# Using Excel and Megastat to find the regression equation

12.33 Use Excel's Add Trend-line feature to fit a linear regression to the scatter plot. Is a linear model credible?

12.35 Use Megastat to fit the regression model, including residuals and standardized residuals.

12.37 ( a) based on the R2 and ANOVA table for your model, how would you assess the fit? (b) Interpret the p-value for the F statistic. (c) would you say that your model's fit is good enough to be of practical value?

12.42 Use Megastat to generate 95 percent confidence and prediction intervals for various x-values.

Portfolio Returns (%) on Selected

Mutual Funds

Last Year (X) This Year (Y)

11.9 15.4

19.5 26.7

11.2 18.2

14.1 16.7

14.2 13.2

5.2 16.4

20.7 21.1

11.3 12.0

รข?'1.1 12.1

3.9 7.4

12.9 11.5

12.4 23.0

12.5 12.7

2.7 15.1

8.8 18.7

7.2 9.9

5.9 18.9

--------------------------------------------------------------------------------

#### Solution Summary

Compute regression equation using two softwares, excel and megastat. Then interpret and compare the results. Also develop plots