The Helicopter Division of Aerospatiale is studying assembly costs at its Marseilles plant. Past data indicates the accompanying data of number of labor hours per helicopter. Reduction in labor hours...

10 see pictures

Extracted text: The Helicopter Division of Aerospatiale is studying assembly costs at its Marseilles plant. Past data indicates the accompanying data of number of labor hours per helicopter. Reduction in labor hours over time is often called a "learning curve" phenomenon. Using these data, apply simple linear regression and examine the residual plot. What do you conclude? Construct a scatter chart and use the Excel Trendline feature to identify the best type of curvilinear trendline (but not going beyond a second-order polynomial) that maximizes R2. Click the icon to view the Helicopter Data. The residuals plot has a nonlinear shape. Therefore, this data cannot be modeled with a linear model. Determine the best curvilinear trendline that maximizes R2. The equation is y = ()x² + O A. The best trendline is Polynomial with an R2 value of (Round to three decimal places as needed.) O B. The best trendline is Exponential with an R2 value of The equation is y = (Round the coefficient to one decimal place as needed. Round all other values to three decimal places as needed.) OC. The best trendline is Logarithmic with an R2 value of The equation is y = In (x) (Round the coefficient of the logarithm to one decimal place as needed. Round all other values to three decimal places as needed.) O D. The best trendline is Power with an R2 value of The equation is y = ( )x (Round the coefficient to one decimal place as needed. Round all other values to three decimal places as needed.)


Extracted text: Helicopter Number Labor Hours 1 2000 2. 1450 3. 1240 4 1144 1074 6. 1025 981 8. 959