# Report to your boss and the client that briefly describes the results that you obtained.

###### James is a community counseling student who is interning with the College Counseling Center at the local university. James is a 25 year-old Caucasian male, who attended a private high school in a small rural town. In terms of being a counselor, James admits that one of his challenges is that he has not experienced much diversity in his relationships.
August 13, 2019
August 13, 2019

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.
Case 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. Ask your Instructor for the data for the actual sales when you are ready (This data is in the Case data file).

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.

Assignment Expectations
Analysis
Accurate and complete Linear Regression analysis in Excel.
Written Report
Length requirements = 45 pages minimum (not including Cover and Reference pages)
Provide a brief introduction/ background of the problem.
Complete and accurate Excel analysis.
Written analysis that supports Excel analysis, and provides thorough discussion of assumptions, rationale, and logic used.
Complete, meaningful, and accurate recommendation(s).
Instruction files

bus520_case_3_data.docx(16,89 KiB)
bus520_mod_3_case.docx(89,96 KiB)

Place your order now for a similar paper and have exceptional work written by our team of experts to guarantee you A Results