Explore BrainMass
Share

Regression analysis in Megastat

Homework help from our online tutors - BrainMass.com

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

© BrainMass Inc. brainmass.com September 18, 2018, 1:46 pm ad1c9bdddf

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