Share
Explore BrainMass

Regression analysis in Megastat

Instructions for Exercises 12.25-12.27: (a) Use Excel's Tools > Data Analysis > Regression (or MegaStat
or MINITAB) to obtain regression estimates. (b) Interpret the 95 percent confidence interval for the
slope. Does it contain zero? (c) Interpret the t test for the slope and its p-value. (d) Interpret the F
statistic. (e) Verify that the p-value for F is the same as for the slope's t statistic, and show that t 2 = F.
(f) Describe the fit of the regression.

12.25 Portfolio Returns (%) on Selected Mutual Funds (n = 17 funds) Portfolio
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

12.27 Moviegoer Spending on Snacks (n = 10 purchases) Movies
Age (X) $ Spent (Y)
30 2.85
50 6.50
34 1.50
12 6.35
37 6.20
33 6.75
36 3.60
26 6.10
18 8.35
46 4.35

Solution Summary

The solution provides step by step method for the calculation of regression model in Megastat . Formula for the calculation and Interpretations of the results are also included.

$2.19