Please show step for step on how to do it in excel. Thanks

h

Here is the data for question 4

https://college.cengage.comextbook/shared/business/camm_9780357715857/morningstar.xlsx

4. E=DATAfile momingstar Morningstar Stock Data. Morningstar publishes ratings data on 1,208 company stocks. A sample of 40 of these stocks is contained in the file morningstar. Use the Morningstar data set to answer the following questions. LO 3 a. Develop a point estimate of the proportion of the stocks that receive Morningstar's highest rating of 5 Stars. b. Develop a point estimate of the proportion of the Morningstar stocks that are rated Above Average with respect to business risk. c. Develop a point estimate of the proportion of the Morningstar stocks that are rated 2 Stars or less. Point Estimates for EAI Employees. In this chapter we showed how a simple random sample of 30 EAI employees can be used to develop point estimates of the population mean annual salary, the population standard deviation for annual salary, and the population proportion having completed the management training program. L0 1,2, 3,4 a. Use Excel to select a simple random sample of 50 EAI employees. b. Develop a point estimate of the mean annual salary. c. Develop a point estimate of the population standard deviation for annual salary. d. Develop a point estimate of the population proportion having completed the management training program. 7. SAT Scores. The College Board reported the following mean scores for the three parts of the SAT: Assume that the population standard deviation on each part of the test is o =100.LOS5 Critical Reading 502 Mathematics 515 Writing 494 a. For a random sample of 30 test takers, what is the sampling distribution of x for scores on the Critical Reading part of the test? b. For a random sample of 60 test takers, what is the sampling distribution of x for scores on the Mathematics part of the test? c. For a random sample of 90 test takers, what is the sampling distribution of x for scores on the Writing part of the test