Use the following cash flow data to estimate cash forecast using various techniques. a. Compare a 3-day moving average forecast to a 5-day moving average forecast. Which is better? b. Graph a scatter plot of the data. Does it appear to have a linear relation? c. Use regression analysis to develop the linear trend equation. Statistically speaking, would this be a good forecast equation? Why or why not? (output the regression results to a separate tab in the current file) d. "Back" Test the equation from part c. by using to estimating forecast for periods 1.30. Is it better than either of the methods in part a. e. Produce the Descriptive statistics for Net Cash Flow. Use the following cash flow data to estimate cash forecast using various techniques. a. Compare a 3-day moving average forecast to a 5-day moving average forecast. Which is better? b. Graph a scatter plot of the data. Does it appear to have a linear relation? c. Use regression analysis to develop the linear trend equation. Statistically speaking, would this be a good forecast equation? Why or why not? (output the regression results to a separate tab in the current file) d. "Back" Test the equation from part c. by using to estimating forecast for periods 1.30. Is it better than either of the methods in part a. e. Produce the Descriptive statistics for Net Cash Flow