• 23
• 100% (39) 39 out of 39 people found this document helpful

This preview shows page 11 - 15 out of 23 pages.

Retrieved from . Fill in each of the values below: 68th percentile 280
Feedback: Use Excel Functions =PERCENTILE.INC( ,.68) 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 25th percentile. Round your answer to one decimal place. See Attached Excel for Data.
Hint: Use =PERCENTILE.INC function in Excel or use textbook formula (n+1)p/100 Retrieved from .
Feedback: Use =PERCENTILE.INC( , .25) in Excel.
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.
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 graph represents a random sample of car models driven by college students. What was the most common car model?
A. Both Honda and Nissan B. Other C. Both Nissan and Toyota D. Nissan E. Chevy F. Both Chevy and Toyota G.