Assignment

Follow these instructions to produce a correlation

1. Open the attached worksheet called Inferential Statistics Student Worksheet.
2. Use the Analysis Toolpak to select Correlation.
3. Input Highlight the data in columns B and C or type $B$1:$C$59
4. Output Highlight the data in cells H2 to J5 or type $H$2:$J$5
5. Click OK
6. Answer the question related to the findings by checking whether the findings show a positive, negative, or no correlation. Note a strong correlation is determined by how close the r statistic is to 1.0.

Patient Identifier	Age	Medication Compliance Rating	Number of Appointments	% of Missed Appointments	Number Appointments Missed		Correlation Findings
1	35	1	24	50%	12
2	42	2	24	30%	7
3	49	2	24	33%	8
4	56	3	24	5%	1
5	63	3	24	5%	1
6	70	4	24	10%	2		Age and medication compliance are	Put an X for the correct answer
7	67	4	24	7%	2		Strongly positively correlated with medication Compliance
8	64	4	24	5%	1		Weakly positively correlated with medication Compliance
9	61	4	24	3%	1		Strongly negatively correlated with medication Compliance
10	58	4	24	15%	4		Weakly negatively correlated with medication Compliance
11	55	3	24	5%	1		Not correlated
12	52	3	24	18%	4
13	49	2	24	30%	7
14	46	2	24	33%	8
15	43	2	24	30%	7
16	40	2	24	33%	8
17	37	1	24	50%	12
18	34	1	24	55%	13
19	31	1	24	50%	12
20	28	1	24	55%	13
21	25	1	24	55%	13
22	22	1	24	55%	13
23	29	1	24	55%	13
24	36	2	24	55%	13
25	43	2	24	30%	7
26	50	3	24	33%	8
27	47	3	24	30%	7
28	44	3	24	33%	8
29	41	3	24	28%	7
30	38	3	24	55%	13
31	35	3	24	55%	13
32	32	2	24	55%	13
33	29	1	24	55%	13
34	26	2	24	55%	13
35	33	3	24	55%	13
36	40	3	24	30%	7
37	47	3	24	33%	8
38	54	4	24	25%	6
39	51	5	24	25%	6
40	48	3	24	32%	8
41	45	3	24	37%	9
42	42	3	24	33%	8
43	39	3	24	55%	13
44	36	2	24	55%	13
45	33	2	24	55%	13
46	30	2	24	55%	13
47	37	3	24	55%	13
48	44	4	24	32%	8
49	51	4	24	37%	9
50	58	4	24	33%	8
51	55	5	24	12%	3
52	52	4	24	10%	2
53	49	3	24	32%	8
54	46	5	24	37%	9
55	43	4	24	33%	8
56	40	4	24	32%	8
57	37	3	24	37%	9
58	34	2	24	43%	10