Use the data in the file labeled WorldHealth.xls to analyze worldwide life ex: pectancy. Answer the following questions:

a. Construct a histogram, dot plot, and normal probability plot of the Central Intelligence Agency’s (CIA) totals for life expectancy at birth (years) for 2006. What do these graphs indicate? Is this random variable normally distributed?

b. Construct a graph of the CIA life expectancy data—total, male, and female. What do these graphs show?

c. Determine the mean, median, mode, range, variance, and standard deviation for the CIA life expectancy data—total, male, and female. What do these numbers show?

d. What is the 95 percent Cl for mean life expectancy of males and females as reflected in the CIA data? The 99 percent Cl?

e. What is the 99 percent Cl for the difference in the two means?

f’ Set up and perform a hypothesis test to determine if life expectancy for males and females differs at a 95 percent confidence level.

g. Construct histogram and normal probability plots for the CIA gross domestic product, television, and hospital bed data. Do these random vari ables appear normally distributed?

h. Perform three separate simple linear regression analyses for the CIA gross domestic product, television, and hospital bed data with the CIA life expectancy total. Interpret your results. (Note: Excel will not perform a regression analysis when data are missing. The Excel workbook titled ‘World Health Regression” has eliminated countries for which no data are available on life expectancy. You may need to sort the data and run the analysis only on complete data.)

i. Discuss the following statement: “World life expectancy could be increased if everyone in the world owned a television.”

j. Look at x-y scatter plots for each pair of variables in exercise 3h. Do the rela, tionships appear to be linear? Would a transformation of the x variable improve the regression?