Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 3 (Mandatory) (100 paints) Toranksal the attached Excel spreadshet and follow the instructions pronvidal here. Module 14 Quiz Data.xkx The data are from a

image text in transcribed
Question 3 (Mandatory) (100 paints) Toranksal the attached Excel spreadshet and follow the instructions pronvidal here. Module 14 Quiz Data.xkx The data are from a small moving company that names people from urtom apartment buildings in other urban apartment building in the same or different cities. The company mails assistarax in predicting the labour hours for jobs so they can provide more runic pax quite Run two separate regressions using the dads in the sections of the spresabsheel titled Regression Moskal I and Regression Mudd 2. The & 95% confident level Fill in all the blanks below. De rail round ary numbers cuzpl for when entering than in the blanks for this quiz, round these numbers in exactly 1 decimal places even if the number has only one ur mo decimal places. Ilee common In separate thenand tep., 1215 should be enterual as 1,215.00). Regression Model 1 A Square expresed as a percentage nunled and carried out to two devined places is % and Adjusted R Square expressed as a percentage rounded and carried out to two decimal places is Refer to the spreadsheet embedded in your Module 14 Regression document I provided you to see the calculation and format for answering this next question. The gap between R Square and Adjusted R Square expressed as a percentage rounded and carried out to two decimal places is O. *% . The overall regression moskl (win / was mul) significant Using square footage of 1,300 arad mileage of 12, the mauled estimates that hours of labor would be required, with a margin of error of hours. Regression Model 2 R Square: expressed as a percentage nunded and carried out to two chained places is % and Adjusted R Square expressed as a percentage rounded and carried out to two decimal places is *% . Refer to the srialshad cibakkal in your Mesluk 14 Regression document I provided you to sec the couldion and bored for answering hisnest quetion The gap between R Square and Adjusted R Square expressed as a percentage rounded and carried out to two decimal places is 5%. The overall regression mockl (wins / was mul) significant Using sopart footage of 1,500, mileage of 12, and flexes of 71, the masked estimates these hours of labor would be required, with a margin of anror of hours. Model Selection Because the R Square is (higher / lower) in regression model 1 than in regression model 2 and the gap between R Square and Adjusted R Square is (smaller / larger) in regression model 1 than in regression model 2 and the margin of error of the estimated labor hours is (smaller / larger) in regression mold I than in regression mould 1, we would characterize regression model (1 or 2) as being the better model

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

Step: 3

blur-text-image

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

Precalculus

Authors: Michael Sullivan

9th edition

321716835, 321716833, 978-0321716835

More Books

Students also viewed these Mathematics questions

Question

How will the infrastructure of companies change in the future?

Answered: 1 week ago