Explore BrainMass

Data Forecasting Using Simple Linear Regression Model

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 25, 2018, 7:04 am ad1c9bdddf

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

Solution Summary

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

See Also This Related BrainMass Solution

Linear regression

Sales date for two years are as follows. Data are aggregated with two months of sales in each period.

(see chart in attached file)

a. Plot the data
b. Fit a simple linear regression model to the sales data.
c. Using the results from parts a and b, prepare a forecast for the next year.

View Full Posting Details