Purchase Solution

# ABC Furniture Company Linear Regression

Not what you're looking for?

See Attached

Background:
Linear Regression Forecasting and Decision Trees
Why is Forecasting important? How can we use Linear Regression as a forecasting method?
Read this introductory resource: Forecasting for Business and Using Linear Regression (attached)
Read Chapter 6, Regression Analysis pp. 159-166, in this resource:
Chase, C. W. (2013). Demand-driven forecasting: A structured approach to forecasting. John Wiley & Sons: Somerset, NJ. Retrieved from the Ebrary. Could not retrieve chapter 6 from Ebrary but found Chapter 6 on google (https://books.google.com/books?id=oe1CYQ5TxW0C&pg=PT62&source=gbs_selected_pages&cad=2#v=onepage&q&f=false)
The topics discussed here include:
1. Definition of regression
2. Correlation and regression
3. How to calculate the regression equation of X on Y.
OPTIONAL: Two videos on Khan Academy showing how to calculate regression coefficients.
PRACTICE: Download the Excel file Linear Regression Practice Examples (attached) which provides an examples and practice problems to learn how to do regression analysis in Excel.

##### Solution Summary

The Word file contains the report, written in 514 words. The report includes explanations as well as equations, tables and charts. The Excel file contains all computations used.

##### Solution Preview

INTRODUCTION
I am a consultant from the Excellent Consulting Group. My client, the ABC Furniture Company, believes that the number of customers who visit the store during any particular month is related to the total sales for the month in question, i.e. the client believes that there is a relationship between higher customer traffic and higher total sales. The client has provided me with the number of customers who visited the store over the most recent 12-month period from January to December, with the sales corresponding to each of those months. This data will be used to test the client's theory.

ANALYSIS
Linear Regression was used to analyze the number of customers and sales data provided. Note that in this analysis, we are investigating the possibility of a linear relationship ...

Solution provided by:
###### Education
• MSc, California State Polytechnic University, Pomona
• MBA, University of California, Riverside
• BSc, California State Polytechnic University, Pomona
• BSc, California State Polytechnic University, Pomona
###### Recent Feedback
• "Excellent work. Well explained."
• "Can you kindly take a look at 647530 and 647531. Thanks"
• "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
• "GREAT JOB!!!"
• "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "

##### Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.