Purchase Solution

Data Forecasting Using Simple Linear Regression Model

Not what you're looking for?

Ask Custom Question

Please state the regression model, the Sy.x, r2, and t*. Tell me if this regression model is reliable (or not) and why you believe that. If the model is reliable, make forecasts for years 11-15 and show me those forecasts.

Setup: We make a control valve whose sales have been growing. The marketing manager believes that this is dependent on the year since the valve's introduction to the market, and has provided you with the following data:

Sales Year
(in thousands of units)

1000 1
1300 2
1800 3
2000 4
2000 5
2000 6
2200 7
2600 8
2900 9
3200 10

Run a formal analysis and report the results to the marketing manager as required in the first paragraph.

Purchase this Solution

Solution Summary

The solution computes and forecasts using a simple linear regression model.

Solution Preview

Using Excel:
The regression model is Y = 215.7x +913.3, where Y is the sales while X is the year.
The computed r-squared is 0.941 (being very close to 1), which means that the regression model is reliable.

Using SPSS:
SPSS computation will give you the same result.

Note: Using the ...

Purchase this Solution

Free BrainMass Quizzes
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.

Measures of Central Tendency

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

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.