Share
Explore BrainMass

Multiple Regression

A publishing company in New York is attempting to develop a model that can use to help predict sales for textbooks it is considering for future publication. The marketing department has collected data on several variables from a random sample of 15 books. These data are given in the attached excel file.

Answer these questions for the above question using the attached excel file:
1. Define these variables:

a) dependent variable(s)

b) independent variable(s)

2. Is the correlation coefficient significant? (yes or no)

a) p < .05

b) p < .01

c) p < .001

3. Write the regression equation. (May write independent variables as X1, X2, etc.)

4. Is the regression equation significant?

a) p < .05

b) p < .01

c) p < .001

5. Which, if any, of the independent variables contribute significantly to predicting y?

* What percent of the variation in y is explained by the set of independent variables?

Attachments

Solution Summary

A publishing company in New York is attempting to develop a model that can use to help predict sales for textbooks it is considering for future publication. The marketing department has collected data on several variables from a random sample of 15 books. These data are given in the attached excel file.

Answer these questions for the above question using the attached excel file:
1. Define these variables:

a) dependent variable(s)

b) independent variable(s)

2. Is the correlation coefficient significant? (yes or no)

a) p < .05

b) p < .01

c) p < .001

3. Write the regression equation. (May write independent variables as X1, X2, etc.)

4. Is the regression equation significant?

a) p < .05

b) p < .01

c) p < .001

5. Which, if any, of the independent variables contribute significantly to predicting y?

* What percent of the variation in y is explained by the set of independent variables?

$2.19