Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The regression analysis from Excel, for the linear regression forecast of police car maintenance costs is as follows: ANOVA Significance df SS MS F F

image text in transcribed
The regression analysis from Excel, for the linear regression forecast of police car maintenance costs is as follows: ANOVA Significance df SS MS F F Regression 783926.0339 391963 11.59854 0.013241 JUN Residual 168970.8411 33794.17 Total 952896.875 Coefficients Standard Error t Stat P-value Intercept 117.602 277.8340873 0.421578 0.690844 Miles Driven 0.561 0.04534026 1.587538 0.173254 Car Age (yrs) 19.138 70.18474335 0.272829 0.795894 The forecast for the maintenance cost for a police car that is 6 years old and will be driven 10,000 miles in 1 year is: (Round your answer to the nearest whole number.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Single Variable

Authors: Deborah Hughes Hallett, Deborah Hughes Hallet, Andrew M Gleason, William G McCallum, Daniel E Flath, Patti Frazer Lock, David O Lomen, David Lovelock,

6th Edition

1118748611, 9781118748619

More Books

Students also viewed these Mathematics questions

Question

Find in the network shown using nodal analysis. 10 k 4000 I

Answered: 1 week ago