In 2009, the New York Yankees won 103 baseball
games during the regular season. The table on the next
page lists the number of victories (W), the earnedrun-
average (ERA), and the batting average (AVG)
of each team in the American League. The ERA is
one measure of the effectiveness of the pitching staff,
and a lower number is better. The batting average
is one measure of effectiveness of the hitters, and a
higher number is better.
(a) Develop a regression model that could be used to
predict the number of victories based on the ERA.
(b) Develop a regression model that could be used to
predict the number of victories based on the batting
(c) Which of the two models is better for predicting
the number of victories?
(d) Develop a multiple regression model that includes
both ERA and batting average. How does
this compare to the previous models?
This posting contains solution to following multiple regression model using excel.