SOLUTION: Refer to the CIA data, which report demographic and economic information on 46 countries. a. The mean of the GDP/capita variable is 16.58 with a standard deviation of 9.27. Use

Question 243056: Refer to the CIA data, which report demographic and economic information on 46 countries.
a. The mean of the GDP/capita variable is 16.58 with a standard deviation of 9.27. Use the normal distribution to estimate the percentage of the countries with exports above 24. Compare this estimate with the actual proportion. Does the normal distribution appear accurate in this case? Explain.
b. The mean of the exports is 116.3 with a standard deviation of 157.4. Use the normal distribution to estimate the percentage of countries with exports above 170. Compare this estimate with the actual proportion. Does the normal distribution appear accurate in this case? Explain.
Can someone give me the steps how to set this up in excel? I don't necessarily need the answer to the question as much as I need the steps to create it in excel. The book is "Basic Statistics for Business & Economics" 6th edition. Thank you.

Answer by 66171(1) (Show Source): You can put this solution on YOUR website!

RELATED QUESTIONS
The economic dynamism, which is the index of productive growth in dollars for countries... (answered by CPhill)

Refer to the Real Estate data, which reports information on homes sold in the Goodyear,... (answered by Solver92311)

Require that you access data from the Pulse Rate Dataset. The data is based on the... (answered by ikleyn)

Every year the PSA releases the Current Population Report based on a survey of 50,000... (answered by ikleyn)

6. Following is the GDP data (in USD billion) for different countries. Use Python list to (answered by ikleyn)

The data is based on the following research problem: Ann conducted a study on the things (answered by ikleyn)

How can i find current GDP in amount in current year if i am given previous year GDP... (answered by Theo)

Refer to the economic loss index function below. The economic loss index in terms of x... (answered by Boreal)

Suppose an economy's real GDP is $30,000 in year 1 and 31,200 in year 2. What is the... (answered by Mathtut)