Question 12 of 20 10 10 points final grade dataxlsx 8

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.
Answer Key:C
Question 16 of 20 1.0/ 1.0 Points The following graph represents a random sample of car models driven by college students. What was the most common car model?
A. Nissan B. Chevy C. Toyota D. Both Nissan and Toyota
Part 7 of 8 - Scatter Plots Questions 2.0/ 2.0 Points

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture