Question

1.) The most obese countries in the world have obesity rates that range from 11.4% to 74.6%. This data is summarized in the following table.

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

1. What is the best estimate of the average obesity percentage for these countries?
2. The United States has an average obesity rate of 33.9%. Is this rate above average or below?
3. How does the United States compare to other countries?

In excel format, please

2.) Two baseball players, Fredo and Karl, on different teams wanted to find out who had the higher batting average when compared to his team. Which baseball player had the higher batting average when compared to his team?

Baseball Player	Batting Average	Team Batting Average	Team Standard Deviation
Fredo	0.158	0.166	0.012
Karl	0.177	0.189	0.015

In excel format, please

3.)  Find the standard deviation for the following frequency tables using the formula. Check the calculations with the TI 83/84.

1. Grade	Frequency
   49.5–59.5	2
   59.5–69.5	3
   69.5–79.5	8
   79.5–89.5	12
   89.5–99.5	5

2. Daily Low Temperature	Frequency
   49.5–59.5	53
   59.5–69.5	32
   69.5–79.5	15
   79.5–89.5	1
   89.5–99.5	0

3. Points per Game	Frequency
   49.5–59.5	14
   59.5–69.5	32
   69.5–79.5	15
   79.5–89.5	23
   89.5–99.5	2

Use the following information to answer the next nine exercises: The population parameters below describe the full-time equivalent number of students (FTES) each year at Lake Tahoe Community College from 1976–1977 through 2004–2005.

• μ = 1000 FTES
• median = 1,014 FTES
• σ = 474 FTES
• first quartile = 528.5 FTES
• third quartile = 1,447.5 FTES
• n = 29 years

whats the midpoint, formula in excel format, please

Answer 1