This question is from the book Concise Managerial Statistics

#4 (Use a software program) Gilbert's law rm would like to predict the salary for a legal secretary based on years of college education (X1), typing speed in words per minute (X2), and years of experience (X3). The following data were collected: Y X1 X2 X3 Y X1 X2 X3 15,120 2 65 2 12,500 0 45 .5 12,500 1 45 2 15,800 2.5 60 2 26,000 3.5 85 9 19,600 1 70 3 19,000 0 55 11 21,800 3 75 6 16,000 4 85 1 12,400 0 60 .5 15,000 0 65 1 22,500 2 75 7 a. Using a software package, determine the least squares prediction equation b. What is the value of the residual standar|d deviation? c. Do the variables X1, X2. and X3 contribute to predicting salaries at the .10 signicance level? d. Find the 90% confidence interval for B1 e. Test the null hypothesis that B1 = 0 at the 10% significance level f. Interpret the results of the hypothesis test in part e