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 to use 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 Midrange Mean Variance "\\J"\\J"\\J "\\J "\\J"\\J Standard Deviation Coefcient 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 Limit 1 ? 2 ? | | 13 ? | 14 + (c)[3] Draw a histogram of the frequency distribution based on your defined bins. Format the histogram 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 Survey In this question, you would do a mini survey with free online tools. This is just an introduction to