Share
Explore BrainMass

# Regression Analysis and Using Megastat in Excel

Can you please show step-by-step how to use Megastat in Excel to solve this problem? (I need to see what options should be selected to run the regression analysis, interpret the results of those options and the analysis outcome). Thank you.

Analyze the effect of sack yardage has on quarterback rating.
a) Does the sack yardage predict the QB rating?
b) What is the regression equation and is this a significant equation?
c) What is your prediction for the QB rating of a quarterback that has
300 sack yards?

Player sack yardage quarterback rating
1 0 131.9
2 0 122.2
3 22 118.1
4 45 101.4
5 108 100.4
6 0 100
7 107 99
8 8 98.6
9 54 96.6
10 196 96.4
11 130 92.6
12 73 91.2
13 48 90.6
14 137 90.4
15 0 90.3
16 46 89.7
17 246 88.8
18 195 88.8
19 3 88.2
20 249 87.4
21 219 85.9
22 15 84.8
23 57 84.3
24 160 82.9
25 27 82.8
26 111 81.5
27 288 81.4
28 168 80.6
29 104 80.1
30 25 79.7
31 253 79.6
32 0 78.8
33 116 77.6
34 206 75.8
35 242 75.3
36 41 74.8
37 166 74.6
38 90 73.5
39 371 73
40 90 73
41 38 72.9
42 126 72.4
43 125 72.3
44 185 71.4
45 164 70.7
46 174 70.3
47 132 69.6
48 90 69.5
49 83 69.2
50 64 69

#### Solution Summary

The solution examines regression analysis using Megastat in Excel. The analysis is on the effect of sack yardage has on quarterback rating.

\$2.19