Homework answers / question archive / 12

12

Accounting

Share With

12. The graduate Santa Clara Broncos football team has compiled the following statlatis:
YEAR ans AVERAGE OFFENSIVE YARDS AVERAGE INTERCEPTIONS
> ” 500 2
3 5 450 4
250 10
4 10 485 4
5 7 399 4
6 11 521 2
7 4 158 15
8 1 525 0
8 8 485 4
10 4 300 9
11 § $60 9
12 7 378 9
13 2 150 16
14 5 $80 5
eee eee eeeee reer reer reer eee erence ence eee ee
inte ception: i z
_— _—

15. Given the following data, use Excel to construct a least squares regression model that develope a relation
between the number of games lost, the rainy days, and the team payroll of the Winterville Indians baseball
team. The model should predict future lost games.

ay: Se eehy RAINY DAYS VA ee CD
1993 25 26 175
1994 20 30 178
1995 10 3 240
1996 15 6 235
1997 22 17 180
1996 12 10 241
1999 25 22 173
2000 8 2 255
2001 a. , 2 267
2000 Bt eee: 38; 160
are a “&  , 4