Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

NUMBER EXPER TIME 1 9 66 1 11 74 3 11 88 4 8 99 6 9 134 6 9 120 7 10 178 8


NUMBEREXPERTIME
1966
11174
31188
4899
69134
69120
710178
89139
98187
1110227
1110225
127270
139265
149301
1510343
1611383
1710383
209515
199474
209495
229628
229636
2310660
2410731
2511752
268800
2710863
289918
299976
30101027

Analyzing Customer Service: A computer repair service is examining the time taken on service calls to repair computers. Data were obtained for 30 service calls. The data are available in the worksheet entitled "COMPREP5". Information obtained includes: x = number of machines to be repaired (NUMBER) x2 = years of experience of service person (EXPER) y = time taken (in minutes) to provide service (TIME) Develop a polynomial regression model to predict average time on the service calls using EXPER and NUMBER as explanatory variables by fitting ALL the models below (Let NUMBERSQR and EXPERSQR represent squared variables.) Hint: Yes, this means that you have to fit ALL six of the models listed below separately. Create a table in EXCEL that organizes the standard error of the regression (Se) and Raj for each model to easily compare models based on these two indicators of model fit. (a) Choose the best fitting model. HINT: You will have to fit each one of these 6 models separately, organize the appropriate model fit statistics, and then, based on these results, make a decision concerning which model is the best fitting model. O TIME = -179 + 33 NUMBER+10.189 EXPER O TIME = 289 + 33 NUMBER - 92 EXPER +5.488 EXPERSQR O TIME = 286 + 16 EXPER O TIME = -84 + 33 NUMBER O TIME = 66 + 3.887 NUMBER + 0.943 NUMBERSQR + 0.371 EXPER O TIME = 69 + 3.865 NUMBER + 0.944 NUMBERSQR (b) Justify your model choice. (Use a 5% significance level.) O This model has significant p values for each coefficient, with a large standard error of the regression and a low R adj This model has the smallest standard error of the regression and the smallest Radj of all the models. This model has significant p values for each coefficient, with a small standard error of the regression and a high Rdj. This model has the largest standard error of the regression and the highest Rady of all the models. O This model has the largest standard error of the regression and the lowest Rdy of all the models. (c) What is the standard error of the regression for the best fitting model that you evaluated above? (Enter your answer to two decimal places.) Se= (d) What is Radj for the best fitting model that you evaluated above? (Enter your answer as a proportion and round to four decimal places.) Radj =

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: Jay Abramson

1st Edition

1938168348, 978-1938168345

More Books

Students also viewed these Mathematics questions

Question

How does selection differ from recruitment ?

Answered: 1 week ago