Explore BrainMass
Share

# Regression analysis in Megastat

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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
&#8722;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

https://brainmass.com/statistics/regression-analysis/regression-analysis-in-megastat-224076

#### 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

## Regression analysis in Megastat

Can you predict the number of touchdowns from the following variables: attempts, yards, and yards per game?
a)Develop a correlation matrix for the 3 predictor variables, do you suspect multicolinarity?

b)What is your multiple regression equation, is it significant?

c)Predict the number of touchdowns for a back with 200 attempts, 600 yards, and 57 yards per game. Interpret your data analysis.

Hint - put these into Megastat separated with commas and in the same order (L-R) as the data.
Can you predict the number of touchdowns from the following variables: attempts, yards, and yards per game?
a Develop a correlation matrix for the 3 predictor variables, do you suspect multicolinarity?
b What is your multiple regression equation, is it significant?
c Predict the number of touchdowns for a back with 200 attempts, 600 yards, and 57 yards per game. Interpret your data analysis.
Hint - put these into Megastat separated with commas and in the same order (L-R) as the data.

Player Attempts Yards Yards
per game Touchdowns
1 387 2066 129.1 14
2 290 1591 122.4 14
3 355 1883 117.7 15
4 318 1444 103.1 8
5 313 1645 102.8 13
6 351 1641 102.6 8
7 345 1572 98.2 6
8 310 1259 96.8 11
9 331 1356 90.4 10
10 326 1435 89.7 14
11 320 1420 88.8 27
12 392 1372 85.8 9
13 323 1308 81.8 2
14 142 559 79.9 1
15 244 1024 78.8 6
16 278 1216 76 2
17 209 818 74.4 10
18 215 957 73.6 9
19 238 1031 73.6 8
20 312 1031 64.4 5
21 201 1024 64 6
22 178 768 64 3
23 125 672 61.1 3
24 275 972 60.8 5
25 90 447 55.9 1
26 142 600 54.5 1
27 228 830 51.9 0
28 246 811 50.7 7
29 182 642 49.4 3
30 197 779 48.7 11
31 187 751 46.9 0
32 174 745 46.6 5
33 159 678 45.2 4
34 178 638 42.5 0
35 138 541 41.6 2
36 56 289 41.3 2
37 117 613 40.9 7
38 120 553 39.5 3
39 137 627 39.2 3
40 107 579 38.6 5
41 158 606 37.9 3
42 126 542 36.1 8
43 28 107 35.7 0
44 94 345 34.5 0
45 39 99 33 0
46 102 382 31.8 3
47 93 253 31.6 4
48 113 429 30.6 0
49 9 30 30 0
50 71 298 29.8 1

View Full Posting Details