Topic: BUS520 M3C-LINEAR REGRESSION FORECASTING AND DECISION TREES

Order Description
LINEAR REGRESSION FORECASTING AND DECISION TREES
Assignment Overview
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.
Assignment
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. Actual data will be attached in separate attachment
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: ATTACHED
Assignment Expectations
Analysis
• Accurate and complete Linear Regression analysis in Excel.
Written Report
• Length requirements = 4– pages minimum (not including Cover and Reference pages)
• Provide a brief introduction/ background of the problem.
• Complete and accurate Excel analysis.
PLEASE include the EXCEL document showing anaylsis as well.
• Written analysis that supports Excel analysis, and provides thorough discussion of assumptions, rationale, and logic used.
• Complete, meaningful, and accurate recommendation(s).

Background –
https://www.khanacademy.org/math/probability/regression/regression-correlation/v/regression-line-example?topic=statistics

https://www.khanacademy.org/video/second-regression-example?topic=statistics