I need to modify the data set to show If the time of month has any correlation to the amount of days people are absent. You can skew the numbers one way or another but I need a completed data set. The data set will be used for:
- Calculate coefficient of correlation and coefficient of determination.
- Develop a single linear regression equation.
- Predict the value of Y' for a given value of X using a single linear regression equation.
- Calculate standard error of estimate, confidence intervals, and prediction intervals.
- Interpret standard error of estimate, confidence intervals, and prediction intervals.
Whether the number of absentees in a period of time (say a month) is correlated to ...
A complete, neat and step-by-step solution is provided in the attached Excel file.