Share
Explore BrainMass

A problem on Multiple regression

Baseball

Mark Havana has just bought a major league baseball team. He has been receiving a lot of advice concerning what he should do to create a winning baseball club. Mark asks you to study this problem and write him a report. You decide to use regression analysis to determine which statistics are important in developing a winning team (measured by the number of games won in the 1991 season). You gather the following statistics from sporting news 1992 baseball yearbook (data in Excel data file) and run regressions.

Assignment:
a) Discuss the importance of each variable.
b) What equation should Cindy use to forecast wins?
c) Write a report for Cindy.

Team Wins ERA SO BA Runs HR SB
Giants 75 4.03 905 0.246 649 141 95
Mets 77 3.56 1028 0.244 640 117 153
Cubs 77 4.03 927 0.253 695 159 123
Reds 74 3.83 997 0.258 689 164 124
Pirates 98 3.44 919 0.263 768 126 124
Cardinals 84 3.69 822 0.255 651 68 202
Phillies 78 3.86 988 0.241 629 111 92
Astros 65 4 1033 0.244 605 79 125
Dodgers 93 3.06 1028 0.253 665 108 126
Expos 71 3.64 909 0.246 579 95 221
Braves 94 3.49 969 0.258 749 141 165
Padres 84 3.57 921 0.244 636 121 101
Red Sox 84 4.01 999 0.269 731 126 59
White Sox 87 3.79 923 0.262 758 139 134
Yankees 71 4.42 936 0.256 674 147 109
Tigers 84 4.51 739 0.247 817 209 109
Orioles 67 4.59 868 0.254 686 170 50
Brewers 83 4.14 859 0.271 799 116 106
Indians 57 4.23 862 0.254 576 79 84
Blue Jays 91 3.5 971 0.257 684 133 148
Mariners 83 3.79 1003 0.255 702 126 97
Rangers 85 4.47 1022 0.27 829 177 102
Athletics 84 4.57 892 0.248 760 159 151
Royals 82 3.92 1004 0.264 727 117 119
Angels 81 3.69 990 0.255 653 115 94
Twins 95 3.69 876 0.28 776 140 107

Solution Summary

This posting contains solution to following problem on Multiple regression

$2.19