Excel calculates the correlation between two data columns


1. Excel calculates the correlation between two data columns is -0.856. What does this mean?

A. That the two variables move together about 85.6% of the time

B. That the two variables move in opposite directions about 85.6% of the time

C. That we have a strong indication that the two variables tend to move in opposite directions

D. That the analyst collected incorrect data values

2. In a sample of voters, the proportion of female is 2 in 3. What’s the technical term for this ratio?

A. Absolute frequency

B. Relative frequency

C. Ex ante probability

D. Expected value.

Request for Solution File

Ask an Expert for Answer!!
Other Subject: Excel calculates the correlation between two data columns
Reference No:- TGS0627717

Expected delivery within 24 Hours