The Helicopter Division of Aerospatiale is analyzing assembly costs of its Marseilles plant. The provided data table showcases the number of labor hours per helicopter. The trend indicates a "learning curve" phenomenon where labor hours decrease over time.**Data Table for Number of Hours per Helicopter:**- Helicopter 1: 2000 hours- Helicopter 2: 1500 hours- Helicopter 3: 1328 hours- Helicopter 4: 1114 hours- Helicopter 5: 1074 hours- Helicopter 6: 1029 hours- Helicopter 7: 950 hours- Helicopter 8: 950 hoursThe scatter plot of this data reveals a nonlinear shape, indicating that it may not be adequately modeled with a linear model. Therefore, it is crucial to determine the best curvilinear trendline to maximize the R² value. The options for trendline models include:A. **Power Trendline:** y = [Coefficient] * x^[Exponent] - R² value needed - Round coefficient to one decimal placeB. **Polynomial Trendline (2nd Order):** y = [Coefficient1] * x² + [Coefficient2] * x + [Constant] - R² value needed - Round to three decimal placesC. **Exponential Trendline:** y = [Coefficient] * e^([Rate] * x) - R² value needed - Round coefficient to one decimal placeD. **Logarithmic Trendline:** y = ([Coefficient]) + [Rate] * ln(x) - R² value needed - Round the coefficient of logarithm to one decimal placeSelect the appropriate model and calculate the coefficients as needed to determine which trendline provides the best fit for the data.

The data shows the number of labor hours per helicopters.For Power: The scatterplot is obtained by using EXCEL using procedure as follows: In first column enter data values of x (Helicopter Number). In second column enter data values of y (Labor Hours). Select Insert > Scatter under Charts. Right click on any data point choose Add Trendline. Select Power under Trendline options. Mark Display Equation on chart, and Display R-square value on chart. Click Enter. The output is, From the output, the value of R2 is 0.988, and equation is y=1927.8x0.356. For Polynomial: The scatterplot is obtained by using EXCEL using procedure as follows: In first column enter data values of x (Helicopter Number). In second column enter data values of y (Labor Hours). Select Insert > Scatter under Charts. Right click on any data point choose Add Trendline. Select Polynomial under Trendline options. Mark Display Equation on chart, and Display R-square value on chart. Click Enter. The output is, From the output, the value of R2 is 0.954, and equation is y=31.185x2-407.41x+2277.5. For Exponential: The scatterplot is obtained by using EXCEL using procedure as follows: In first column enter data values of x (Helicopter Number). In second column enter data values of y (Labor Hours). Select Insert > Scatter under Charts. Right click on any data point choose Add Trendline. Select Exponential under Trendline options. Mark Display Equation on chart, and Display R-square value on chart. Click Enter. The output is, From the output, the value of R2 is 0.836, and equation is y=1841.7e-0.095x. For Logarithmic: The scatterplot is obtained by using EXCEL using procedure as follows: In first column enter data values of x (Helicopter Number). In second column enter data values of y (Labor Hours). Select Insert > Scatter under Charts. Right click on any data point choose Add Trendline. Select Logarithmic under Trendline options. Mark Display Equation on chart, and Display R-square value on chart. Click Enter. The output is, From the output, the value of R2 is 0.953, and equation is y=-491.6lnx+1891. The value of R2 is larger for Power indicating that the best trendline is Power. Correct Answer: Option A. The best trendline is Power with an R2 value of 0.988. The equation is y=1927.8x0.356.