Before running the correlation matrix between , identify what you think

HW #4:
Due 10/7
1.
Download the dataset “prisons.xlsx” from
SACCT.
a.
Before
running the correlation matrix between , identify what you think is the
relationship between median income and each of the other 3 variables in the
spreadsheet. Make sure you provide an
explanation as to why you think the relationship is positive, negative or zero.
b.
Use excel to calculate the correlation
coefficient. Are the correlation
coefficients the same as what you predicted?
Identify the variables with correlation coefficients that have a
different sign from what you predicted.

2.
Using the table below, calculate the sample
correlation coefficient between x and y.
Show all steps taken in you calculations. Assignments turned in that show incomplete
steps will get minimal points. Answers
need to be handwritten.

X

Y

19

5

24

11

28

14

29

28

40

40

45

42

46

49

50

55

60

55

63

75

80

88

3.
Using the data above, use the least squares
regression to find the best fitting line for x and y (i.e., calculate α and
β). Show all steps taken in you
calculations. Assignments turned in that
show incomplete steps will get minimal points.
Answers need to be handwritten.

Order your essay today and save 30% with the discount code: KIWI20