Return to
Quick Notes
Statistics
Updated 3/27/18
Please link to, use
to educate and
 
Answer the following questions concerning the relationship between average sick days taken over the past 5 years by senior managers and their performance rating using the this data. Be sure to show all mathematics calculations.  
 
ID Number  AA1  AB2  AC3  AD4  AE5 
Sick days taken  4  8  3  7  1 
Performance Rating  8  2  7  4  9 
1. Draw a scatter diagram of this data and calculate the coefficient of correlation to
determine if average sick days taken over the last 5 years has an affect on a
senior manager's most recent performance rating.
2. Calculate the coefficient of determination and the coefficient of
nondetermination.
4. Could rho be zero at the .01 level of significance? Franklin Pierce college
students may skip this question.
6. Calculate the expected performance rating for a senior manager who averaged 5
absences per year over the 
1.  .952 
Please visit Our Sponsors. Our Statistics Tutors can help with difficult questions.
Statistics Specialty Store Online Six Sigma Certification [Green Belt]will improve your resume.
Please support this site by
shopping at
amazon.com and

2.  90.6% and 9.4%  
3.  High negative, 90.7% of the variability in rating is accounted for by variability in absences and 9.3% of the variability in rating is not accounted for by variability in absences.  
4.  No  
5.  Y._{x} = 10.4  .964x (Hint: when calculating b, you have a double negative so 4.43 is added to 6.)  
6.  5.58  
Quick Statistics Using Microsoft
(TM) Excel 