Question
The most obese countries in the world have obesity rates that range from 11.4% to 74.6%. This data is summarized in Table 2.75. Use Excel
The most obese countries in the world have obesity rates that range from 11.4% to 74.6%. This data is summarized in Table 2.75.
Use Excel to create Descriptive Statistics table for the data below. Please include image of excel file for reference and clarification.
Table 2.75
Percent of Population Obese | Number of Countries |
11.4-20.45 | 29 |
20.45-29.45 | 13 |
29.45-38.45 | 4 |
38.45-47.45 | 0 |
47.45-56.45 | 2 |
56.45-65.45 | 1 |
65.45-74.45 | 0 |
74.45-83.45 | 1 |
Use the Descriptive Statistics table created in Excel to answer the next three questions.
What is the best estimate of the average obesity percentage for these countries?
What is the standard deviation for the listed obesity rates?
The United States has an average obesity rate of 33.9%. Is this rate above average or below? How "unusual" is the United States' obesity rate compared to the average rate? Explain.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started