# Question 9 of 20 the lengths in kilometers of rivers

• 14
• 100% (5) 5 out of 5 people found this document helpful

This preview shows page 6 - 8 out of 14 pages.

Question 9 of 20 The lengths (in kilometers) of rivers on the South Island of New Zealand that flow to the Tasman Sea are listed below. Find the median. See Attached Excel for Data. river length data.xlsx 9 KB A. 67.68 km B. 64 km C. 66.34 km D. 56 km E. 65.18 km Answer Key: B
Feedback: use =MEDIAN function in Excel Question 10 of 20 height data.xlsx 8 KB The following data show the height (in inches) of a sample of students. See Attached Excel for Data.
Question 11 of 20 The median can also be described as:
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. D. all of the above Answer Key: D Part 5 of 8 - Measures of the Location of Data Questions 3.0/ 3.0 Points Question 12 of 20 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.
1.0/ 1.0 Points Question 13 of 20 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 .
1.0/ 1.0 Points Feedback: Use PERCENTILE.INC( , .62) in Excel.