Purchase Solution

Regression analysis and forecasting

Not what you're looking for?

Ask Custom Question

6. Finley Heaters Inc. is a mid-sized manufacturer of residential water heaters. Sales have grown during the last several years, and the company's production capacity needs to be increased. The company's management wonders if 'national housing starts' might be a good indicator of the company's sales:

"
National Housing Starts Annual Sales
Year (millions) (millions)
1 6.2 57
2 5.1 59
3 6.5 65
4 7.9 78
5 6.3 72
6 7.4 80
7 7 86

A) Develop a simple linear regression analysis between Finley Heaters' sales and national housing starts. Forecast Finley Heaters' sales for the next two years. The National Home Builders Association estimates that 'National housing starts' will be 7.1 million and 8.0 million for the next two years.

B) What percentage of variation in Finley Heaters' sales is explained by national housing starts?

C) Would you recommend that Finley Heaters management use the forecast from Part a to plan facility expansion? Why or why not? What could be done to improve the forecast?

see attached problem.

Attachments
Purchase this Solution
Solution Summary

Uses regression analysis to forecast Finley Heaters' sales using national housing starts as the independent variable.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • The Purpose of Using Regression Analysis

    How is regression analysis used in forecasting? Provide examples.

  • Seasonal forecasting

    4) Single linear regression 5) Seasonalized time series regression; and nonlinear seasonal forecasting Not sure, but 5 seems likely...I do not know how to approach this....and what assumptions are there to be drawn...can you help?

  • What is the linear regression and 5-month moving average forecast for the sales data?

    Regression analysis is widely used for prediction (including forecasting of time-series data). Use of regression analysis for prediction has substantial overlap with the field of machine learning.

  • ABC Furniture Company Linear Regression

    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).

  • Mean Absolute Deviation

    Main Analysis and results can be found on the sheet "Main Analysis". The result for linear regression can be found on the sheet "Linear Regression Model". All results are obtained by Excel.

  • Simple Regression Analysis

    Evaluate the goodness of this forecasting model. 3a. Perform a multiple regression analysis to forecast the number of apartment units leased, based on university enrollment and average lease price.

  • Forecasting using Regression Analysis

    Regards This solution provides example of Jasper Furnishing in forecasting of turnover ratio using regression analysis given estimated sales.

  • Simple Lear and Multiple Regression

    2.What are examples in which regression analysis is used for forecasting? 3. What is correlation analysis? How can correlation analysis be used in a business decision or examples specifically related to strategy formulation and implementation?

  • Regression analysis - sources and forecasting

    83376 Regression analysis - sources and forecasting What are examples in which regression analysis is used for forecasting? What are some primary and secondary sources of data that may be used in correlation and regression analysis?

  • The Westar Hotel - Beverage Regression Analysis

    Firstly i have re-typed the data and put them in the sheet called "Raw data". I then use the Multiple Regression analysis tool by going to Tools - Data Analysis in Excel and chose Regression.

View More Related Solutions