Regression, Least squares and Correlation Coefficients

The following table shows the number of workdays absent based on the length of employment in years.

Number of workdays absent 2 3 3 5 7 7 8

Length of employment (years) 5 6 9 4 2 2 0

a. What is the independent variable? What is the dependent variable?
b. Using Megastat or Excel derive the least squares equation (LSE).
C. Interpret the two estimate coefficients of the LSE.
d. Calculate the coefficients of correlation and determination and interpret their values.
e. Is there evidence showing a correlation between Number of Workdays Absent and Length of Employment?

Solution Summary

This solution identifies the independent and dependent variable and derives the least squares equation by a graphical representation of the data. It then uses the LSE to interpret two estimate coefficients, calculate the coefficients of correlation and also conducts a regression analysis to determine if a relationship between number of workdays absent and length of employment.

... 2. The least squares method minimizes which of the following ... of the above it minimizes the error sum of squares. ... candy bar sales explained by the regression model ...

... d. Find the equation for the least squares line. Use Excel, we get. SUMMARY OUTPUT. Regression Statistics Multiple R 0.834613 R Square 0.696579 Adjusted ...

Computing the sample correlation coefficient and the coefficients for the least-square regression line. ... y-intercept of the least-squares regression line for ...

... The solution provides a least square regression to look at the correlation coefficients. ... The least-squares regression line for these data has a slope of ...

... The square of correlation between X and Y is ... Mean Y =312.3533. What is the value of the y-intercept of the least-squares regression line for these data? ...

...Regression Statistics. ...coefficient of determination= R Square = 0.914411327. ... 3.) What is the value of the y-intercept of the least squares line? ...

... b) Calculate the coefficient of determination and correlation coefficient for each ... per capita from the number of The Least Squares Regression line is y = 0.0043 ...

... error of the slope of the least-squares regression line was ... value of and that the other regression assumptions are ... statistic is used (Z, t, f, or Chi square)? ...

... of the least squares regression model by hand, which requires only the means and standard deviations of X and Y, and the correlation coefficient (here r ...