# A sample of nine public universities and nine private

August 30, 2017

uestion
Problems 30, 31, and 32 using the Data Analysis Add-In for Microsoft Excel
Problems 25 and 31 using either Excelâ€™s Data Analysis Add-In or Excel QM
30. A sample of nine public universities and nine private universities was taken. The total cost
for the year (including room and board) and the median SAT score (maximum total is 2400) at
each school were recorded. It was felt that schools with higher median SAT scores would have a
better reputation and would charge more tuition as a result of that. The data is in the table
below. Use regression to help answer the following questions based on this sample data. Do
schools with higher SAT scores charge more in tuition and fees? Are private schools more
expensive than public schools when SAT scores are taken into consideration? Discuss how
accurate you believe these results are using information related the regression models
Category Total Cost Median SAT
Public 21700 1990
Public 15600 1620
Public 16900 1810
Public 15400 1540
Public 23100 1540
Public 21400 1600
Public 16500 1560
Public 23500 1890
Public 20200 1620
Public 30400 1630
Public 41500 1840
Public 36100 1980
Public 42100 1930
Public 27100 2130
Public 34800 2010
Public 32100 1590
Public 31800 1720
Public 32100 1770
31. In 2008, the total payroll for the New York Yankees was \$209.1 million, while the total
payroll for the Tampa Bay Rays was about \$43.8 million, or about 1/5 that of the Yankees. Many
people have suggested that some teams are able to buy winning season and championships by
spending a lot of money on the most talented players available. The table below lists the
payrolls (in millions of dollars) for all 14 Major League Baseball teams in the American league as
well as the total number of victories for each in the 2008 season:

Team Payroll (millions) number of victories
NY Yankees 209.1 89
Detroit Tigers 138.7 74
Boston Red Sox 133.4 95
Chicago White sox 121.2 89
Cleveland Indians 79 81
Baltimore Orioles 67.2 68
Oakland Athletics 48 75
Los Angeles Angels 119.2 100
Seattle Mariners 118 61
Toronto Blue Jays 98.6 86
Minnesota Twins 62.2 88
Kansas City 58.2 75
Tampa Bay 43.8 97
Texas Rangers 68.2 79
Develop a regression model to predict total number of victories based on payroll of the team. Based on
results discuss how accurate the model is. Use the model to predict the number of victories for a team
with a payroll of \$79million.

32. 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 earnedrunaverage (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.

Get a 30 % discount on an order above \$ 100
Use the following coupon code:
RESEARCH
Positive SSL