Using Excel and linear regression analyze the data and determine how to do forecasting using website hits.

You are consultant for the Excellent Consulting Group. Your client wants to be able to forecast sales on a monthly basis and believes that there is a valid relationship between sales and the number of hits on their website during the previous month. To test this theory, the client has collected data on sales of one of its products, a lottery app for smart phones and hits on its website.
Case Assignment

Using Excel and linear regression analyze the data and determine how to do forecasting using website hits.