# Use the data in the World Health.xls to analyze worldwide life expectancy. Answer the following… 1 answer below »

Use the data in the World Health.xls to analyze worldwide lifeexpectancy. Answer the following questions.a. Discuss the validity of the data.b. Construct a histogram, stem plot, dot plot, and normal probabilityplot of CIA life expectancy at birth (years), total for 2006. What dothese graphs indicate? Is this random variable normally distributed?c. Construct box plots of CIA life expectancy—total, male, and female.What do these graphs show?d. Determine the mean, median, mode, range, variance, and standarddeviation for CIA life expectancy—total, male, and female. What dothese numbers show?e. What is the 95 percent CI for mean life expectancy of males andfemales? The 99 percent CI?f. What is the 99 percent CI for the difference in the two means?g. Set up and perform a hypothesis test to determine if life expectancyfor males and females differs at a 95 percent confidence level.h. Perform an ANOVA to determine if life expectancies for males,females, and all are different.i. Construct scatter plots of CIA gross domestic product, telephones,televisions, physicians, nurses, pharmacists, hospital beds, and percapita health expenditures versus CIA life expectancy total. What dothese graphs indicate?j. Construct a correlation matrix for all the data. What does this indicate?k. Construct histogram and normal probability plots for CIA grossdomestic product, televisions, and hospital beds. (Bonus: Use Best-Fit to determine the best-fitting probability distribution for each ofthese and total life expectancy.) Are these random variables normallydistributed?l. Perform three separate simple linear regression analyses for CIAgross domestic product, televisions, and hospital beds with CIAlife expectancy total. Interpret your results. (Note: Excel will notperform a regression analysis when data are missing. The work-book “World Health Regression” has eliminated countries forwhich there are no data on life expectancy. You may need to sortthe data and run the analysis only on complete data.)223224Performance Improvement Tools, Techniques, and Programsm. Discuss the following statement: “World life expectancy could beincreased if everyone in the world owned a television.”n. Look at x-y scatter plots for each pair of variables in l. Do the rela-tionships appear to be linear? Would a transformation of the x vari-able improve the regression?o. Bonus: Build a multiple regression model with the available data topredict life expectancy in countries throughout the world. Be sureto eliminate any ou