Assignment On Regression Equation

Chapter 4 - Problem 30.
The procedure to run simple regression in Excel is as written below:
1. Consider the provided data.
2. Click on Data->Select Data Analysis->Regression->Enter the input ranges and output range as
shown below:
3. Click on OK.
The output from Excel is as shown below:

The regression equation is as written below:
The calculation of total cost with a high median SAT score say 2400 is as follows:
The calculation of total cost with a low median SAT score say 500 is as follows:
To check that private schools are more expensive than public schools when SAT scores are taken
into consideration we will calculate the average SAT scores for both type of schools and put that
average in the regression equation.
The average of median SAT score for Public schools is calculated as shown below:
The calculation of total cost for Public schools with 1838 is as follows:
The average of median SAT score for Public schools is calculated as shown below:
The calculation of total cost for Private schools with 1838 is as follows:
The regression model here is not much accurate as the variability explained in the total cost is
only 16% if we look at the adjusted R-square value.
Chapter 4 - Problem 31

The procedure to run simple regression in Excel is as written below:
1. Consider the provided data.
2. Click on Data->Select Data Analysis->Regression->Enter the input ranges and output range as
shown below:
3. Click on OK
The output from Excel is as shown below:
The regression equation is as written below:

Prediction for a team with payroll of$79 is as shown below
Therefore, the number of victories for a team with a payroll of $79 is 82.
Chapter 4 - Problem32
(a) The procedure to run simple regression in Excel is as written below:
1. Consider the provided data.
2. Click on Data->Select Data Analysis->Regression->Enter the input ranges and output range as
shown below:
3. Click on OK
The output from Excel is as shown below: