Compute the Forecast for the data provided using REGRESSION ANALYSIS for a Linear Trend Projection and derive the required measures of Forecast Accuracy

MEASURES OF FORECAST ACCURACY ean Forecast Err zan Absolute Errean Squared Erriosolute Percentage Error

$\{\begin{array}{ccc}\text{:}& \text{M}\text{F}\text{E}\text{M}\text{A}\text{E}\text{M}\text{S}\text{E}\text{M}\text{A}\text{P}\text{E}& \end{array}$

Use Excel Data Analysis to develop a REGRESSION model for forecasting Sales $(Y)$ based on Year$(x)$