Layout Reset A - - Shape Fill Section B I U abe X2 X2 AY Aa A. Convert to Picture Shapes Text SmartArt Arrange Quick Box Shape Outline Styles empire learning Part 1: Empire Learning is a developer of educational software. CEO Bill Hartborne is making a bid to create an e-learning module for a new client. He needs to estimate the number of developer labor hours needed to create the module. From prior experience he knows that developer labor hours are driven by the length of the module and the complexity of the animations. He has a database of prior e-learning modules he has created, showing development labor hours, number of pages Pages#, and Animation (runtimes in seconds). He chooses to run three regressions, using number of Pages# and Animation as independent variables that predict Labor hours. The results of three regressions appear below. The number of observations (10) are sufficient in this case to conduct a Regression Analysis. Answer the five questions on the next page pertaining to this Part. Regression Report #1 Regression Report #2 Regression Report #3 Regression Statistics A H 2 Multiple R 0.9128 Regression Statistics Regression Statistics 2 Multiple R 0.8313 0.9662 3 R Multiple R 0.8332 3 R' 0.6911 R 0.9335 Adjusted R' .8123 4 Adjusted R 0.6524 4 Adjusted R .9145 5 Standard Error 79 5 Standard Error 108 5 Standard Error 54 6 Observations 10 6 Observations 10 6 Observations 7 B ANOVA 8 ANOVA 8 ANOVA df SS MS Signif. F 9 SS MS F Signif. F 9 df SS MS Signif. F N N 10 Regression 251,257 140,759 251,257 40.0 0.0002 10 Regression 281,518 49.2 0.0001 10 Regression 1 208,396 208,396 17.9 0.0029 11 Residual 20.042 2.863 1 Residual 8 50,303 6,288 11 Residual 8 93, 16 11,646 12 Total 301,560 12 Total 301,560 12 Total o 301,56 Coefficients Std. Error t-stat P-value Lower 95% Upper 95% Coefficients Std. Error t-stat P-value Lower 95% Upper 95% 14 Coefficients Std. Error t-stat P-value Lower 95% Upper 95% 15 Intercept 548 43 12.65 0.0000 446 650 15 Intercept 580 63 9.27 0.0000 436 724 15 Intercept 665 74 9.01 0.0000 495 835 16 Animation 1.29 0.40 3.25 0.0140 0.35 2.22 6 Pages (#) 1.19 0.19 6.32 0.0002 0.76 1.63 16 Animation 2.58 0.61 4.23 0.0029 1.17 3.98 17 Pages (#) 0.84 0.17 5.05 0.0015 045 1.24 2 Notes Comments + 129% lish (United States)Reset A A R FEE Shape Fill Section B I U abe X2 X2 AV . Ad A.= = = 14.F Convert to Picture Shapes Text Arrange SmartArt Quick Shape Outline Box Styles 1. Write the equation for the simple linear regression line in Regression Report #1 Identify the y intercept and the slope of that equation 2. Comparing the two simple regressions in Reports 1 and 2, which of the two independent variables ("Pages#" or "Animation") explains/accounts for the most variation in the dependent variable of labor hours? Justify your answer citing the statistic you use to make the comparison. 3. Using Regression Report #2, how many labor hours are needed to create an e-learning module with 50 seconds of Animation? 4. In Regression Report #3, is there a significant linear relationship between the independent variable "Animation" and the dependent variable "Labor hours" in the true population? Justify your answer based on both tests (p value and confidence interval) 5. In Regression Report #3, Is the effect of Pages# on labor hours gross or net with respect to Animation? What is the value of this effect? + 129% 63 Notes Comments lish (United States)