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