Question
1) make a histogram for column FinalMark using Excel Data Analysis Function with the following bin in data range C2: C11. Output range is E1.
1) make a histogram for column "FinalMark" using Excel Data Analysis Function with the following bin in data range C2: C11. Output range is E1. Adjust the chart so that the lower right corner is in cell M12. Edit the chart title so that it is read as "Chart Created by Pauline Fu" . Rename the bin in column E so that it includes both the lower limit and upper limit (for example, 0 to 5, 5 to 10, 11 to 15 etc). Add data labels - outside end. Remove gap among bars (set gap width to 0%).
Final Mark 37 24 39 28 20 33 35 14 35 22 26 23 28 27 31 25 37 33 12 20 29 19 17 17 22 9 21 24 32 19 16 13 27 20 27 17 22 15 39 16 25 13 29 29 16 24 22 20 27 22 22 16 17 28 23 21 35 19 21 19 19 16 12 24 30 33 20 24 37 20 32 20 29 11 22 10 36 31 14 26 19 13 24 36 15 17 11 25 24 24 26 26 23 23 21 14 27 28 17 14 30 28 31 29 40 16 18 15 31 11 23 34 19 37 12 13 21 14 20 20 28 21 19 22 17 16 21 22 16 20 11 15 25 34 14 24 30 18 21 21 18 24 42 13 16 40 12 18 34 20 21 19 35 36 27 18 22 12 18 21 38 18 11 19 19 34 13 13 38 28 23 34 36 23 12 26 14 23 43 16 34 29 15 18 17 36 20 36 26 17 23 28 45 14 16 13 24 18 22 17 28 18 24 35 19 22 34 23 19 20 26 29 11 18 17 20 16 19 36 21 29 19 42 22 30 19 11 30 29 15 30 26 14 27 35 12 15 16 12 14 14 22 23 41 11 16 13 20 21 13 29 17 31 17 16 30 18 24 19 33 34 34 38 14 18 This data is used for all questions when needed.
2) Describe the natures of the histograms (uniform, normal, skewed left, skewed right).
3) Using Excel or by hand, construct a frequency distribution table, relative frequency distribution, and cumulative relative frequency distribution of the data using the following class limit(zero decimal with %).
4) Using Excel to calculate the descriptive statistic: mean, median, standard deviation (for sample), first quartile (Q1), third quartile (Q3), and interquartile range (IQR). Use QUARTILE.INC for quartile. Keep 3 decimals where applicable.
5)Construct a box-plot for the data. Use your name as the chart title. Identify 5-number summary on the box-plot. Calculate 1.5*IQR. How do you determine the outliers? Keep whole numbers.
6) Suppose a student has a final mark of 35. calculate the z-score for this student. Keep 3 decimals. Explain to someone about this z-score who does not have statistics knowledge.
7) Based on the design of the study and data collection method, a. Identify the sample and the population from this data set. b. The mean you calculated in question 4 is a parameter. True or False? c. How would you name the data based on the measurement scale (nominal, ordinal, interval, and ratio) d. If you want to conduct a study about this data, is the study observational study or design of experiment?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started