Question

A political scientist wants to establish a link between the approval rating for a certain state governor's office and the state's unemployment rate. Below is data listing both the approval rating and the unemployment rate over 30 years. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
Col1 Unemployment: 3.9 3.1 4 4.7 5.4 5.9 8 6.1 7.6 5.5 7.2 5.5 4.2 5.5 5.1 7.9 7.6 5.6 7.2 5.7 4 7.2 5.5 4.3 5.8 5 8.3 4.9 4.9 5.5
Col2 Approval Rating: 38 32 64 59 73 40 57 45 35 60 54 37 53 54 45 32 51 51 36 58 55 39 54 54 46 31 52 52 38 32

Answer 1

Answer:

The co-relation coefficient "r" between two data sets is 0.08

Step-by-step explanation:

• There are 27 entries in Unemployment column and 31 entries in Approval rating column.
• To find the co-relation coefficient "r" in excel the formula require the same number of entries in both column, so I omitted the the last four entries from the Approval rating column which are 52, 52, 38 and 32.
• After the calculation and rounding the answer to two decimal places, the co-relation coefficient is 0.08.
• Attached is the excel sheet of the calculation.  

Download xlsx