Engineering services and aerospace systems

Problem 1The Excel workbook Honeywell.xlsx contains the historical stock prices of the Honeywell International Incorporated an American multinational company that produces a variety of commercial and consumer products engineering services and aerospace systems for a wide variety of customers from private consumers to major corporations and governments from 10/15/2017 to 4/15/2018 (courtesy of Yahoo Finance). A.Perform exponential smoothing forecasts on the Honeywell stock prices to forecast the price for 4/16/2018. Use successive values of 0.15 035 0.55 and 0.75 for the smoothing parameter α. Calculate the MSE of each forecast Use the MSEs of your forecasts to determine the value of α that has provided the most accurate forecast. Describe qualitatively as to why such a value of α has yielded the most accurate forecast. B.Use your exponential smoothing forecast with 𝜶=𝟎.75 and perform adjusted exponential smoothing forecasts on the Honeywell stock prices to forecast the price for 4/16/2018. Use successive values of 0.15 0.25 0.45 and 0.85 for the trend parameter β. Use the MSEs of your forecasts to determine the value of β that has provided the most accurate forecast. Describe qualitatively as to why such a value of β has yielded the most accurate forecast.Problem 2The Helicopter Division of Aerospatiale is studying assembly costs at its Marseilles plant. Past data indicates the following labor hours per helicopter:Helicopter NumberLabor Hours12000214003123841142510756102979858957Using 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 trendline that maximizes R2.

Problem 3Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting sales using the last three years of data in the Excel fileNew Car Sales.Perform regression analysis. Hint: Make sure all your p values are acceptably smallby consecutively removing the months with high p value and repeating the analys

Requirements: Follow by the instruction