2. Use excel to answer the folowing questions and show work and formulas used

Problem 2 A community bank has recently increased its fees for using its employees as tellers. Management is interested in whether its new fee policy has increased the number of customers now using its automatic teller machines to that point that more machines are required. The following table provides the number of automatic teller transactions by week. a. Plot the data. Do the data appear to have a linear trend? b. Use the linear trend projection to forecast usage for weeks 13 to 16