(Solved): I need this done in excel made with charts? Thank you Choose one Quantitative variable from above ...

I need this done in excel made with charts? Thank you

Choose one Quantitative variable from above and use the data in the Excel file for that Part2: Graphing(8points] variable to provide its descriptive statistics. Answer the following questions for Part 2 using Excel Analysis Tool Pack. For the quantitative variable chosen in Part 1 above, use the sample data set for that variable to answer the following questions. a) Construct a frequency distribution, with 5-7bins, for the variable data set you chose. Copy and paste your distribution table here. b) Construct a histogram based on this frequency distribution ahove. Copy and paste your histogram here. Describe the shape of the histogram and justify your answer. (Unimodal, bimodal, skewed, or approximately symmetric) c) Choose one of the qualitative variables from Part 1. Using Excel, insert a Bar Graph for the data for this variable. Make sure the percentages or frequencies show on each bar. Copy and paste your graph here. d) Based on the Bar Graph constructed in part c ahove, give a summary of what the data reveals. c) Use the same quantitative variable that you have chosen in the previous question. Find the 60 th percentile and the 35 th percentile of this data set for that variable. Interpret what the 60 th percentile and 35 th percentile mean. Note: This is sample data.