Step 1: Please view the attached excel document and provide what exactly needs to be done in excel to complete the steps listed below.

Step 2: Use the Data Analysis package to run a Regression where you use Years to predict Yield.

Step 3: Use relative cell references to display the coefficients for Intercept and Years from the Regression Report in cells D44:D45 on the Data worksheet.

Step 4: Use the Regression Coefficients you entered in Step 3 to predict the Yield values for each company, based on the Years for that row. Enter the results in range D2:D41. Remember, hard-coding is NOT permitted and will result in zero credit.

Step 5: Calculate the Residuals (aka Regression Errors) for each predicted value from Step 4, and enter the results in range E2:E41.

Step 6: Use the Residuals calculated in Step 5 to compute the Sum of Squares due to Error (SSE) in Cell F42, using Cells F2:41 for the intermediate computation of the Squared Residuals.

Step 7: Follow a similar process from Steps 5 and 6 to compute the Sum of Squares due to Regression (SSR) in Cell H42. To do so, you will need to compute the y-bar in Cell C42, and you should use cells G2:H41 for your other intermediate computations.

Step 8: Now compute the Total Sum of Squares (SST) in Cell J42 by completing the computations in Cells I2:J41.

Step 9: Compare your results for SSE, SSR, and SST to the SS column of the ANOVA table in your Regression Output generated in Step 2. If your computed values do not match the corresponding values from the Regression Output report, review your calculations to identify and correct your mistake.

Step 10: Cell M2 contains a formula that tells Excel to pick a random number each time that formulas are recalculated across the sheet (which by default happens every time that a cell value is changed), so as you are working, you may notice that the value in this cell changes, but don't pay it any mind. Rather, build a formula in cell M3 that predicts the Yield based on the Random Years in cell G2. Note: this step is similar to the process for computing Regression Coefficients in Step 3.

For each step, please specify what exactly needs to be done in excel - including how to get the right answers.... I can't simply fill cells with the numbers.

Company Ticker	Years	Yield
GE	1	0.767									Random Years	0
MS	1	1.816									Predicted Yield
WFC	1.25	0.797
TOTAL	1.75	1.378
TOTAL	3.25	1.748
GS	3.75	3.558
MS	4	4.413
JPM	4.25	2.31
C	4.75	3.332
RABOBK	4.75	2.805
TOTAL	5	2.069
MS	5	4.739
AXP	5	2.181
MTNA	5	4.366
BAC	5	3.699
VOD	5	1.855
SHBASS	5	2.861
AIG	5	3.452
HCN	7	4.184
MS	9.25	5.798
GS	9.25	5.365
GE	9.5	3.778
GS	9.75	5.367
C	9.75	4.414
BAC	9.75	4.949
RABOBK	9.75	4.203
WFC	10	3.682
TOTAL	10	3.27
MTNA	10	6.046
LNC	10	4.163
FCX	10	4.03
NEM	10	3.866
PAA	10.25	3.856
HSBC	12	4.079
GS	25.5	6.913
C	25.75	8.204
GE	26	5.13
GE	26.75	5.138
T	28.5	4.93
BAC	29.75	5.903
	AVERAGE			SSE		SSR		SST
		Intercept
		Years