The National Safety Council of the U.S. released the following data on the incidence rates for fatal or lost-worktime injuries per 100 employees for several industries in three recent years. Compute r...



The National Safety Council of the U.S. released the following data on the incidence rates for fatal or lost-worktime injuries per 100 employees for several industries in three recent years.  Compute r for each pair of years and determine which years are most highly correlated. Calculate r using 1.

the formula and 2. function.



























































IndustryYear 1Year 2Year 3
Textile0.460.480.69
Chemical0.520.620.63
Communication0.90.720.81
Machinery1.51.742.1
Services2.892.032.46
Nonferrous metals1.81.922
Food3.293.183.17
Government5.734.434

By formula By Function



























By formulaBy Function
r1
r2
r3

Please provide a step by step of calculation in excelto give me an understaning on how to calculate in future



Thank you in advance



Jun 02, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here