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).

C. 5.5D. 7.5Answer Key: BFeedback: 76 along the x-axis matched up with approximately 1.5 along the y-axis.Question 18 of 201.0/ 1.0 PointsA survey by the Pew Research Center, conducted in 16 countries among 20,132 respondents from April 4 to May 29, 2016, before the United Kingdom's so-called Brexit referendum to exit the EU. The following is a time series graph for the proportion of survey respondents by countrythat responded that the current economic situation is their country was good. Which country had the least