Predictive Gross sales Report
A retail retailer has not too long ago employed you as a guide to advise on financial circumstances. One necessary indicator that the retail retailer is anxious about is the unemployment charge. The retail retailer has discovered that a rise within the unemployment charge will trigger a scarcity of client spending of their shops. Retail shops use the unemployment charge to estimate how a lot stock to maintain at their shops, which is necessary in sustaining value effectiveness. On this guide function you’ll apply calculations and analysis to create a predictive gross sales report.
You’ll full this mission in two components, however will submit your work as one Phrase doc. Copy and paste your calculations out of your Excel workbook into the Phrase doc.
TIP: For assist copying and pasting info from Excel to Phrase go to http://office.microsoft.com/en-us/word-help/copy-excel-data-or-charts-to-word-HP010198874.aspx or watch the “Excel Ideas – Tip#48: Copy from Excel to Phrase” present in Week One Beneficial Assets.
The Closing Challenge should be eight to 10 pages in size, excluding title web page and reference web page(s) and should embrace not less than three scholarly sources, along with the Job and Labor Statistics web site. Be sure you format your work in accordance with Help write my thesis – APA pointers as outlined within the Ashford Writing Middle.
Half I
Reference the information on this Excel Workbook to finish the next quantitative parts of the predictive gross sales report. You’ll full the calculations beneath in your personal Excel workbook after which copy and paste out of your Excel workbook into the Phrase doc.
- Calculate the imply yearly worth utilizing the common unemployment charge by month discovered within the “Closing Challenge Knowledge Set.”
- Utilizing the years as your x-axis and the annual imply as your y-axis, create a scatter plot and a linear regression line.
- Reply the next questions utilizing your scatter plot and linear regression line:
- Compute the slope of the linear regression line.
- Determine the Y-intercept of the linear regression line.
- Determine the equation of the linear regression line in slope-intercept type.
- Calculate the unemployment charge in 2016, based mostly on the linear regression line.
- Calculate the residuals of every yr.
Discover the most recent unemployment charge in your state. You will have to go to the Bureau of Labor Statistics Web site (www.bls.gov)and hover over “Topic Areas” within the high menu panel then choose “State and Native Unemployment Charges” from the drop down menu underneath “Unemployment Charge”. Decide whether or not the speed in your state is throughout the vary of the linear regression line or whether it is an outlier.
- Interpret your outcomes of the mannequin and clarify how an organization may use the outcomes to drive resolution making.
PART II
Subsequent interpret the evaluation from Half I to finish the next qualitative parts of the predictive gross sales report:
- Introduce the mission and its significance to the retail retailer.
- Reference the statistical evaluation that you simply accomplished in Half I and clarify the place the information got here from, what kind of research was completed, what the findings had been, and whether or not or not you consider the information to be correct.
- Clarify your data-driven conclusions relating to the consequences of the altering unemployment charge on the retail retailer.
- Predict what may happen sooner or later that might change your linear regression line and due to this fact your prediction of gross sales.
