a$.$ Use regression, moving averages, and summary$/$descriptive statistics $($located in Excel Data Analysis$)$ to forecast gas prices for the next period. Be sure to include your chart$($s$)$ effectively organized, labeled, and titled.

Note: To insert dates for Moving Average, once chart it is created:

Right double click x Axis and select $$Number$.$

Under category select $$Date$.$

At bottom select $$Link to Source$$

Right click on date axis Click $$Select Data$.$Edit$.$

Highlight dates in column A$.$

Click OK

b$.$ Present two paragraphs discussing your forecast and findings $($please use Excel and present this discussion in a text box$).$