# See attached excel for data cholesterol dataxlsx 8 kb

• 71
• 99% (68) 67 out of 68 people found this document helpful

This preview shows page 56 - 69 out of 71 pages.

See Attached Excel for Data
cholesterol data.xlsx8 KBA. 248.3245B. 253.9286 C. 235.2953D. 268E. 236Answer Key: DFeedback: Use =MEDIAN function in Excel.Question 11 of 200.0/ 1.0 PointsThe following data are the distances between 20 retail stores and a large distribution center. The
distances are in miles. Which of the following is the mode?See Attached Excel for Data.distance miles data.xlsx8 KBA. 96 B. 86C. 84D. 34.5E. 89
Answer Key: AFeedback: The mode is the value that appears the most, which is 96.Part 5 of 8 - Measures of the Location of Data Knowledge Check Homework Practice1.0/ 3.0 PointsQuestion 12 of 200.0/ 1.0 PointsA sample of 8 cats found the following weights in kg. Use Excel to find the weight for the 75th percentile.See Attached Excel for Data.Hint: Use =PERCENTILE.INC function in Excel or use textbook formula (n+1)p/100cat weight data.xlsx8 KBA. 3.65 kgB. 3.7 kgC. 3.6875 kg
D. 3.85 kgAnswer Key: DFeedback: use =PERCENTILE.INC( , .75) in Excel.Question 13 of 201.0/ 1.0 PointsThe difference between the first and third quartile is called the A. mid range B. interquartile range C. interdependent range D. unimodal range Answer Key: BFeedback: IQR is the InterQuartile RangeQuestion 14 of 200.0/ 1.0 Points
age data.xlsx8 KBListed are 29 ages for Academy Award-winning best actors in order from smallest to largest.See Attached Excel for Data.Find the 78th percentile. Round one decimal place.yearsHint: Use =PERCENTILE.INC function in Excel or use textbook formula (n+1)p/100.Answer Key: 68.7Feedback: use =PERCENTILE.INC( , .78) in Excel.Part 6 of 8 - Ogives, Pareto and Pie Chart Knowledge Check Homework2.0/ 2.0 PointsQuestion 15 of 201.0/ 1.0 PointsThe following graph represents a random sample of car models driven by college students. Whatpercent of college students drove a Nissan?
A. 24%B. 40%C. 10%D. 12%E. 20% Answer Key: EQuestion 16 of 201.0/ 1.0 Points
The following table summarizes the distribution of students by academic class.Academic ClassFrequencyFreshman22Sophomore13Junior10Senior5Select the correct bar graph for the distribution of students by academic class.A.
B.
C.
Answer Key: CPart 7 of 8 - Scatter Plots Knowledge Check Homework2.0/ 2.0 PointsQuestion 17 of 201.0/ 1.0 PointsA scatter plot for a random sample of 24 countries shows the average life expectancy and the average number of births per woman (fertility rate). What is the approximate fertility rate for a country that has a life expectancy of 76 years? (2013, October 14).
• • • 