Question

The Helicopter Division of Aerospatiale is studying assembly costs at its Marselles 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 dafa, apply simple linear regrescion 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 curvlinear trendine (but not going beyond a second-order polynomial) that maximizes R EE Cick the icon to view the Helicopter Data fr number of hours per hecopte b oded Therefoe, hio data ca The residuals plot has a nonlinear shapeTherefore, this data cannot be modolod Determine the best curvilinear trendine that maximizes R Helicopter Nurmber Labor Hours 2000 1350 1235 1143 1071 1029 987 953 (Type integers or decimals rounded to three decimal places as needed) The best trendline is Exponential with an R2 value ofThe equation ов. The best trendline is Power with an R2 value of The equation is y( Ос. The best trendline is Logarithmic with an R2 value of The equation sy Din o The equation is y-UDx2-Ex. The best trendine is Polynomial with an R2 value of[ OD Print Done Click to select and enter your answer(s) and then click Check Answer Clear Al

Answer 1

x	y	ln x	ln y		x	x^2
1	2000	0	7.600902		1	1
2	1350	0.693147	7.20786		2	4
3	1235	1.098612	7.118826		3	9
4	1143	1.386294	7.041412		4	16
5	1071	1.609438	6.976348		5	25
6	1029	1.791759	6.936343		6	36
7	987	1.94591	6.89467		7	49
8	953	2.079442	6.859615		8	64

option B) is correct

R^2 = 0.959

ln y = 7.5235 -0.3349 ln x
ln (y * x^0.3349) = 7.5235
y*x^0.3349 = e^(7.5235)

y = 1851.007 x^(-0.335)

Please rate