Develop a forecast for the next month using the naïve last-value method.

Construct a time series plot. What type of pattern exists?Develop a forecast for the next month using the averaging method.Develop a forecast for the next month using the naïve last-value method. *Develop a forecast for the next month using a four-month moving average method.*Use the Excel Functions SLOPE and INTERCEPT to write the linear regression prediction equation with Months as the independent variable and sales as the dependent variable.*Use the prediction equation to estimate the number of sales in month 9.