please explain what to do on excel for each number in detail.

Please complete the following set of exercises. The data set \"Computer_Exereise4.xlsx\" is retrieved from II'B/E/S International Inc. It contains buy-sell-hold recommendations for the stock of the Boeing Co. (Ticker code "BA") from a wide cross section ofindividual professional analyst for the time period between November I993 and December 202 I. 1. By denition, a random variable, Y, needs to have a numerical outcome. Generate a new data series of outcomes, y, corresponding the analysts' recommendations as foIIOWs: 0 yil if recommendation is \"STRONG BUY\" 0 ya: if recommendation is \"BUY\" O 3152 if recommendation is \"HOLD\" 0 315:] if recommendation is \"UNDERPERFORM\" ' 3.15:0 if recommendation is \"SELL\" 2. Assume that the analysts' recommendations in the data set are a random sample drawn from an underlying population of analysts' recommendation, Y. Assume throughout this exercise that Y has a Normal probability distribution with unknown mean, )1, and unknown variance, 02.' Compute an unbiased estimate for p and an unbiased estimate for 62. (lfyou know more than one unbiased estimator for u, take the one with the smaller sampling variance.) 3. Denote the sample-average estimate as :t 7 1 y:;' Ya I ll H What is the standard error of )7, i.e. 59(y)? 4. Taking the assumptions in 2. for granted, compute the following confidence intervals for it: 90%, 95%-, and 99%-condence interval. 5. Interpret the confidence intervals in 4. What can you conclude with respect to the (unknown) true population mean of analysts' recommendation? 6. Compute the 95%condence interval for u, again, this time relying on the rule ofthumb (see lecture slides). Is this interval very different from the 95%-condence interval Computed in 4.? 7. Under the same assumptions as 4., evaluate the null hypothesis that the mean recommendation in the population is \"HOLD\