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:
(in thousands of units)
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
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.
SPSS computation will give you the same result.
Note: Using the ...
The solution computes and forecasts using a simple linear regression model.
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.