Module 3 – Case Instructions
Scenario: 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.
Using Excel and linear regression analyze the data and determine how to do forecasting using website hits.
Then forecast the next three months using the monthly hits data. Compare the forecast to the actual sales and determine the forecasting error. Ask your Instructor for the data for the actual sales when you are ready.
Then write a report to your boss and the client that briefly describes the results that you obtained. Make a recommendation on how this might be used for forecasting purposes.
Data: Download the Word file Case 3 Data.docx with the data. Use this data in Excel for your analysis.
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.