Share
Explore BrainMass

Regression Model of Independent Variables

Consider the set of dependent and independent variables that can be found in the attached Excel file Prob 151.xlsx.
a) construct a regression model using both independent variables
b) test the significance of each independent variable using alpha = 0.05
c) interpret the p-value for each independent variable

Data set

y x1 x2
10 2 16
11 3 10
15 3 13
15 9 10
20 7 2
24 11 8
27 16 7
32 20 4

Please be sure to send me your excel file.

Attachments

Solution Summary

The solution provides step by step method for the calculation of regression analysis. Formula for the calculation and Interpretations of the results are also included.

$2.19