Added on -2019-09-25

| 16 pages

| 997 words

| 36 views

Trusted by 2+ million users,

1000+ happy students everyday

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 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 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:

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:

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:

** You are reading a preview**

Upload your documents to download

or

Become a Desklib member to get accesss

Paid Plans

Free Plan

Single Unlock

Monthly Plan

Yearly Plan