Purchase Solution

ABC Furniture Company Linear Regression

Not what you're looking for?

Ask Custom Question

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.
Regression Line Example: http://www.khanacademy.org/video/regression-line-example?topic=statistics
Second Regression Example: http://www.khanacademy.org/video/second-regression-example?topic=statistics
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.

Attachments
Purchase this Solution
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:
J Pye, MSc
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. "
Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

View More Free Quizzes
Related BrainMass Solutions

  • Simple Exponential Smoothing

    I had previously completed the initial project for my client, the ABC Furniture Company, which was comprised of developing and testing a forecasting method that used Linear Regression techniques.

  • Economics Case Study Regress

    Are there any significant differences between the linear and log-linear regression analyses that would suggest the advantage of either approach?

  • Regression and Correlation

    Do you think that there is a relationship between the number of stations that a company owns and the revenues generated by radio? b) Find the linear regression line for the data.

  • Linear Regression, Trends and Forecasting

    233660 Linear Regression, Trends and Forecasting Great news! ABC Advertising has called you in for an interview to join their advertising team. During the interview process, you are expected to solve a linear regression problem.

  • Regression analysis problem

    ABC Advertising has called you in for an interview to join their advertising team. During the interview process, you are expected to solve a linear regression problem.

  • Linear Programming

    84466 Linear programming for Hickory Cabinet and Furniture Company Using Excel, please solve the following: The Hickory Cabinet and Furniture Company produces sofas, tables, and chairs at its plant in Greensboro, N.C..

  • Fomulate Linear Programming Model and Solve using Computer

    The Hickory Cabinet and Furniture Company produces sofas, tables, and chairs at its plant in Greensboro, North Carolina. The plant uses three main resources to make furniture- wood, upholstery, and labor.

  • define the decision variables.

    The company wishes to get the maximum profit possible, and a linear program is to be developed for this purpose. a) Carefully define the decision variables. b) Set up the linear program.

  • Maximising Profits for the Hickory Cabinet and Furniture Company

    215966 Maximizing Profits for the Hickory Cabinet and Furniture Company The Hickory Cabinet and furniture company produces sofas, tables, and chairs at its plant in Greensboro, North Carolina.

View More Related Solutions