Solve the following problem using Microsoft Excel. Copy your answers from Excel into the Table

provided on the next page. Upload only this Word file; do not upload Excel file on Blackboard. This

assignment does not require providing snapshots. For more details on how to solve this problem and

enter values in the table, please watch this video.

Problem: Sarah Anderson, the Marketing Manager at Exeter Township's Cultural Center, is conducting

research on the attendance history for cultural events in the area over the past ten years. The following

data has been collected on the number of attendees who registered for events at the cultural center.

Year Number of Attendees

$1700$

$2248$

$3633$

$4458$

$51410$

$61588$

$71629$

$81301$

$91455$

$101989$

You have been hired as a consultant to assist in implementing a forecasting system that utilizes various

forecasting techniques to predict attendance for Year $11.($Each of the following questions is for $2$

points; one for correct answer and the other for correct process $($justification in case of question $10).$

Total points: $20)$

$1.$ Calculate the Three$-$Period Simple Moving Average

$2.$ Calculate the Three$-$Period Weighted Moving Average $($weights: $50\%,30\%,$ and $20\%$; use $50\%$ for

the most recent period, $30\%$ for the next most recent, and $20\%$ for the oldest$)$

$3.$ Apply Exponential Smoothing with the smoothing constant alpha $=0\mathrm{.}2.$

$4.$ Perform a Simple Linear Regression analysis and provide the adjusted R$-$square value.

$5.$ Calculate the Mean Absolute Deviation $($MAD$)$ for the Moving Average

$6.$ Calculate the Mean Absolute Deviation $($MAD$)$ for the Weighted Moving Average

$7.$ Calculate the Mean Absolute Deviation $($MAD$)$ for Exponential Smoothing.

$8.$ Calculate the Mean Squared Error $($MSE$)$ for the Moving Average

$9.$ Calculate the Mean Squared Error $($MSE$)$ for the Weighted Moving Average

$10.$ Which forecasting techniques $($Moving Average, Weighted Moving Average, or Exponential

Smoothing$)$ would you choose based on MAD or MSE scores?