# 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?

Â© BrainMass Inc. brainmass.com March 4, 2021, 5:52 pm ad1c9bdddfhttps://brainmass.com/statistics/regression-analysis/multiple-regression-15221

#### 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?