In: Statistics and Probability
income (Y in $1,000s), GPA (X1), age (X2), and the gender of the individual (X3; zero representing female and one representing male) was performed on a sample of 10 people.
Coefficients | Standard Error | |
Intercept | 4.0928 | 1.4400 |
X1 | 10.0230 | 1.6512 |
X2 | 0.1020 | 0.1225 |
X3 | -4.4811 | 1.4400 |
ANOVA | |||
DF | SS | MS | |
Regression | 360.59 | ||
Error | 23.91 |
a. use Excel/XLSTAT to calculate p-value for the coefficient of X1. Is it significant? α = 0.05. Next, the T table and interpolate the p-value
b. use Excel/XLSTAT to calculate p-value for the coefficient of X2. Is it significant? α = 0.05. Next, the T table and interpolate the p-value
c. use Excel/XLSTAT to calculate p-value for the coefficient of X1. Is it significant? α = 0.05. Next, the T table and interpolate the p-value
d. perform an F test