a) 1:21 AM Mon Jun 17 6% E} E blackboard.cpp.edu QUESTION 02 (15 points) - Histogram File "Question02 - Data.xlsx" contains the necessary sample data...

What is the answer to this

a) 1:21 AM Mon Jun 17 6% E} E blackboard.cpp.edu QUESTION 02 (15 points) - Histogram File “Question02 - Data.xlsx” contains the necessary sample data for this question. You need touse Excel to complete the following parts. (a)[5] Based on the sample data, fill values in the following table using 5 decimals: '\J"\J"\J Range MidrangeMean Variance "\J"\J"\J "\J "\J"\J Standard DeviationCoefficient of Variation (%) ?(b)[2] Based on the statistics in part (a), divide data into bins (classes). You should have 14 bins,where the 12 inner bins have the width of 5. Fill the upper limits In the following table: Bin # Upper Limit1 ?2 ? ||13 ? |14 +°° (c)[3] Draw a histogram of the frequency distribution based on your defined bins. Format thehistogram to make it look clear and good. Note that there should be no gaps between columns.(d)[5] Calculate relative frequencies of the bins & draw a histogram of the relative frequencies. QUESTION 03 (15 points) - Questionnaire Design & Sampling in a Mini SurveyIn this question, you would do a mini survey with free online tools. This is just an introduction to