Question

DATAnle: Repair A statistical program is recommended. samples 10 W e eported the table Sesw.ved to type of repair problem mechanical order , and the pairperson who performed the service. Bata rör Repair Time Months Since in Hours Type of Repair Repairperson Last Service 2.9 Electrical Dave Newton 6 Mechanical Dave Newton 4.8 Electrical Bab Jones 3.0 Mechanical Dave Newton Electrical Dave Newton Electrical 4.2 9 Mechanical Mechanical Bab Jones Bab Jones Bab Jones Electrical Bob Jones Flectrical Dave Newton - if the type of repair (a Develop the estimated regression equation to predict the repair time(), in hours, given the number of months since the last maintenance service (x), the type of repair (X), and the repairperson who performed the service (x2). (Use X mechanical and xy = 1 if the type of repair is electrical. Use x = Dif Bob Jones performed the service and x3 = 1 if Dave Newton performed the service. Round your numerical answers to three decimal places.) (bAt the 0.05 level of significance, test whether the estimated regression equation developed in part (a) represents a significant relationship between the independent variables and the dependent variable. State null and alternative hypotheses. Hoi, = B =0 H One or more of the parameters is not equal to zero. Hoi -M -B -0 H. At the parameters are not equal to zero. H: One or more of the parameters is not equal to zero. H = ,= B = 0 H #: 200 + 0 Find the value of the test statistic (Round your answer to two decimal places.) Find the p-value. (Round your answer to three decimal places.) p-value - State your conclusion. - Reject Ho. There is sutricient evidence to conclude that there is a significant relationship. Do not reject Ho. There is sufficient evidence to conclude that there is a significant relationship. Do not reject Ho. There is insufficient evidence to conclude that there is a significant relationship. Reject Ho. There is insufficient evidence to condude that there is a significant relationship. (cIs the independent variable xg, the repairperson who performed the service, statistically significant? Use a -0.05. State the null and alternative hypotheses. 0:4320 Ho: - Ho - H.: B = 0 - F3 :3 250 Find the value of the test statistic. (Round your answer to two decimal places.) Find the p-value. (Round your answer to three decimal places.) p-value -

Answer 1

Answer Date: 01/05/2020 The regression equation of hours (y) on service, type of repair and Repair person (x's) is, 1) By using Excel software, find regression equation with help of following steps: Import the data. Select Data Analysis from Data menu. 3) Select Regression and click Ok. Input Y Range and Input X range. 5) Click Ok. 4) Coefficients Standard Error Stat P-value Intercept 1.860160428 0.728633984 2.552942 0.043319 Service 0.29144385 0.083598385 3.486238 0.013043 Type of repair 1.102406417 0.303344279 3.634176 0.010911 Repair person -0.609090909 0.387930137 -1.5701 0.167444 From the Excel output, the regression equation of hours (v) on service, type of repair and Repair person (X's) is,

y = Be + B, Xı + B2 x2 + B; xz = 1.860 +0.291x2 +1.102x2 -0.609xz b) The F-test statistics is, By using Excel software, find F-test statistics with the help of following steps: 1) Import the data. Select Data Analysis from Data menu. Select Regression and click OK. 4) Input Y Range and Input X range. 5) Click Ok. ANOVA df Significance F 0.002091348 Regression Residual Total 3 6 SS M SF 9.430491979 3.143497 18.04002 1.045508021 0.174251 10.476 9 From the Excel output, the F-test statistics is 18.04.

The p-value for this test is, From the Excel output, the p value for this test is 0.002). To test the hypothesis is that the repair person who performed service is different from 0 at 5% significance level. The null and alternative hypothesis is, Ho:B2 = 0 H2:B; 0 The t-test statistics is, From Excel output in part (a), the t-test statistics is -1.57. The p-value for this test is, From Excel output in part (a), the p value for this test is (0.167).