Explore BrainMass

# Regression

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

A). Create a scatter plot (using excel) of the data.

b). Find the equation of the linear regression line.

c). Plot the regression line on the same plot as the data.

d). How well do you think the line fits the data?

e). Use the regression equation to predict the number of officers hired for each city.

f). Calculate the residuals and the standard error of the estimate.

https://brainmass.com/statistics/regression-analysis/regression-10641

#### Solution Summary

Ex. 15.5

As part of the anti-crime bill passed in 1995, the U.S. government granted money to different cities to hire new beat-patrol officers. Nine cities in New Jersey were give grants and hired officers. In trying to assess the program, government analysts wanted to look at the relationship between the number of officers hired and the amount of the grant. The data are:

Grant (\$) Number of Officers
150,000 2
375,000 5
471,125 6
70,967 1
450,000 6
525,000 7
375,370 7
750,000 10
1,000,000 12

a). Create a scatter plot (using excel) of the data.

b). Find the equation of the linear regression line.

c). Plot the regression line on the same plot as the data.

d). How well do you think the line fits the data?

e). Use the regression equation to predict the number of officers hired for each city.

f). Calculate the residuals and the standard error of the estimate.

\$2.49