# Question 12 of 20 10 10 points final grade dataxlsx 8

• 22
• 78% (9) 7 out of 9 people found this document helpful

This preview shows page 10 - 18 out of 22 pages.

Question 12 of 20 1.0/ 1.0 Points final grade data.xlsx 8 KB An instructor wants to compare the final grades of students in her online class and face-to-face class. The instructor selects 10 students randomly from each class and the following table shows the final grades of those students. See Attached Excel for Data. Hint: Use =PERCENTILE.INC function in Excel or use textbook formula (n+1)p/100 Compute the following percentiles and interpret them. (round to two decimal places) The 62nd percentile of final grades for the online class is 83.16 The 62nd percentile of final grades for the face-to-face class is 88.16 . .
Feedback:Use PERCENTILE.INC( , .62) in Excel.
Question 13 of 20 1.0/ 1.0 Points cholesterol data.xlsx 8 KB Cholesterol levels were collected from patients two days after they had a heart attack (Ryan, Joiner & Ryan, Jr , 1985). Use Excel to find the 68th percentile. Do Not include any decimals. See Attached Excel for Data. Retrieved from . Fill in each of the values below: 68th percentile 280
Question 14 of 20 1.0/ 1.0 Points age data.xlsx 8 KB Listed are 29 ages for Academy Award-winning best actors in order from smallest to largest. See Attached Excel for Data. Find the 40th percentile. Round one decimal place. 37.8 years Hint: Use =PERCENTILE.INC function in Excel or use textbook formula (n+1)p/100.
Feedback:use =PERCENTILE.INC( , .40) in Excel. Part 6 of 8 - Ogives, Pareto and Pie Chart Questions 2.0/ 2.0 Points Question 15 of 20 1.0/ 1.0 Points The following table summarizes the proportion of people who prefer different food for lunch. Lunch Choices Proportion Mac ‘n Cheese 0.24 Sandwich 0.36 Soup 0.28 Hamburger 0.08 Chicken Nuggets 0.04 Select the correct bar graph for the distribution of people by their lunch choice. A.
B.
C.