The Excel workbook ALY$6050\_$Module$3$Project$\_$Data.xlsx Download ALY$6050$Module$3$Project Data. xlsxcontains the historical stock prices for Apple Inc $($AAPL$)$ and Honeywell International Inc $($HON$)$ for a total time period of one year, consisting of $252$ market days. Perform exponential smoothing to forecast AAPL prices for period $253.$ 

 

Use successive values of $0\mathrm{.}15,0,35,0\mathrm{.}55,$ and $0\mathrm{.}75$ for the smoothing parameter alpha $.$

Next, calculate the MAPE $($Mean Absolute Percentage Error$)$ of each forecast.

Based on the MAPEs, which value of alpha that has yielded the most accurate forecast?

What is the MAPE using this value of alpha $?$