Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please please show me the steps on getting the R square answers and the other answers. Link to excel spreadsheet : https://docs.google.com/spreadsheets/d/16-YTDDk6LGbXNSe0o6OkoCQRq28R6SC-CPk-TzDZerE/edit?usp=sharing The data are

Please please show me the steps on getting the R square answers and the other answers.

Link to excel spreadsheet: https://docs.google.com/spreadsheets/d/16-YTDDk6LGbXNSe0o6OkoCQRq28R6SC-CPk-TzDZerE/edit?usp=sharing

image text in transcribed
The data are from a small moving company that moves people from urban apartment buildings to other urban apartment building in the same or different cities. The companyr needs assistance in predicting the labor hours for jobs so they can provide more accurate price quotes. Run two separate regressions using the data in the sections of the spreadsheet titled Regression Model 1 and Regression Model 2. Use a 95% condence level. Fill in all the blanks below. Do not round any numbers except for when entering them in the blanks for this quiz, round these numbers to exacdy 2 decimal places even if the number has only one or no decimal places. Use commas to separate thousands (e.g.. 1225 should be entered as 1.22300). Regression Liodel l R Square expressed as a percentage rounded and carried out to two decimal places is l:% 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 0. We. The overall regression model (was I was not) \\:j signicant. Using square footage of 1,500 and mileage of 92, the model estimates that :j hours oflabor would be required, with a margin of error of :m Regression Model 2 1 Square expressed as a percentage rounded and carried out to two decimal places is :|% and Adjusted R Square expressed as a percentage rounded and carried out to two decimal places is :\"Aa. 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 0. ['Va. The overall regression model (was i was not} \\:j signicant. Using square footage of 1,500= mileage of 92, and floors of T1, the model estimates that \\:j hours of labor would be required, with a margin of error of :m Diodel 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 I: and the margin of error of the estimated labor hours is (smaller! larger) \\:| in regression model 1 than in regression model 2 , we would characterize regression model (1 or 2) \\:j as being the better model

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Mathematics questions

Question

What is the difference between product and period costs?

Answered: 1 week ago