AutoSave (. Off) Linear Regression original - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Add-ins Help Power Pivot Team...

Situation: The state governor has offered an additional funding incentive for police departments that are able to meet the standard of having a minimum of 2.5 officers onsite per incident. The police department has asked you to analyze their data to determine if the department will be eligible for additional funding, using the attached linear regression.

Question: Describe the fit of the linear regression line to the data, providing graphical representations or tables as evidence to support your description.

• Yellow filled cells are outliers it seems. As I cannot attach an excel file, I am attaching a jpg file for the data given.