Question: Please help me this case. thank you so much! The following data are number of proceeded loans in a week and the years of experience
Please help me this case. thank you so much!

The following data are number of proceeded loans in a week and the years of experience of 10 randomly selected loan managers in ANB bank. Loan Manager 1 2 3 4 6 7 8 10 Years of Experience 0 2 10 3 5 12 20 15 Number of loans processed 7 9 20 15 18 14 20 17 30 25 You may use the following Excel summary output to answer the questions below. Variable Mean Variance Sum Sum of Squares Years of Experience 3.2 38.6 32 1020 Number of Loans 17.5 47.4 175 3489 Experience * Loans 181.1 34711.0 1811 640371 Regression Statistics Multiple R 0.976536 R Square 0.953623 Adjusted R Square 0.947826 Standard Error 1.572404 Observations 10 Standard Coefficients Error t Stat P-value Lower 95% Upper 95% Intercept 0.851774 10.13184 0.000 6.66584 10.59423 years of experience 0.084338 12.82578 0.000 0.887219 1.276187 Determine the least squares regression line. Interpret the value of the slope of the regression line. Determine the coefficient of determination, and discuss what its value tells you about the two variables. d) Use your regression equation from part (a) to predict the number of loans processed for a loan manager with 21 years of experience. How confident are you in this prediction? Explain Test if the regression line in part (a) is significant at a = 5% Find the correlation coefficient of the two variables
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
