Conduct a correlation analysis of net sales and age. Use the results to answer the question for Parts A, B, and C.

A. State the null and alternate hypothesisfor the above test.

1. Ho: 1=0; H1: 10

2. Ho: 1=0; H1: 1>0

3. Ho: r=0; H1: r>0

4. Ho: r=0; H1: r0

B. What is the value of the correlation coefficient?

_____________________________________________________

C. Based on the results, what conclusion should be drawn? Test at a level of significance of 0.05.

1. Accept the null hypothesis

2. Do not reject the null hypothesis

3. Reject the null hypothesis

4. Insufficient information to draw a conclusion

Data Set listed below:

Customer	Store location	Type of Customer	Items	Net Sales	Method of Payment	Gender	Marital Status	Age
1	A	Regular	1	$39.50	Discover	Male	Married	32
2	B	Promotional	1	$102.40	Proprietary Card	Female	Married	36
3	B	Regular	1	$22.50	Proprietary Card	Female	Married	32
4	A	Promotional	5	$100.40	Proprietary Card	Female	Married	28
5	C	Regular	2	$54.00	MasterCard	Female	Married	34
6	A	Regular	1	$44.50	MasterCard	Female	Married	44
7	A	Promotional	2	$78.00	Proprietary Card	Female	Married	30
8	A	Regular	1	$22.50	Visa	Female	Married	40
9	B	Promotional	2	$56.52	Proprietary Card	Female	Married	46
10	A	Regular	1	$44.50	Proprietary Card	Female	Married	36
11	C	Regular	1	$29.50	Proprietary Card	Female	Married	48
12	C	Promotional	1	$31.60	Proprietary Card	Female	Married	40
13	B	Promotional	9	$160.40	Visa	Female	Married	40
14	B	Promotional	2	$64.50	Visa	Female	Married	46
15	B	Regular	1	$49.50	Visa	Male	Single	24
16	A	Promotional	2	$71.40	Proprietary Card	Male	Single	36
17	A	Promotional	3	$94.00	Proprietary Card	Female	Single	22
18	C	Regular	3	$54.50	Discover	Female	Married	40
19	B	Promotional	2	$38.50	MasterCard	Female	Married	32
20	A	Promotional	6	$44.80	Proprietary Card	Female	Married	56
21	C	Promotional	1	$31.60	Proprietary Card	Female	Single	28
22	A	Promotional	4	$70.82	Proprietary Card	Female	Married	38
23	B	Promotional	7	$266.00	American Express	Female	Married	50
24	C	Regular	2	$74.00	Proprietary Card	Female	Married	42
25	C	Promotional	2	$39.50	Visa	Male	Married	48
26	B	Promotional	1	$30.02	Proprietary Card	Female	Married	60
27	A	Regular	1	$44.50	Proprietary Card	Female	Married	54
28	B	Promotional	5	$192.80	Proprietary Card	Female	Single	42
29	B	Promotional	3	$71.20	Proprietary Card	Female	Married	32
30	C	Promotional	1	$18.00	Proprietary Card	Female	Married	70
31	C	Promotional	2	$63.20	MasterCard	Female	Married	28
32	A	Regular	1	$75.00	Proprietary Card	Female	Married	52
33	B	Promotional	3	$63.20	Proprietary Card	Female	Married	44
34	C	Regular	1	$40.00	Proprietary Card	Female	Married	34
35	A	Promotional	5	$105.50	MasterCard	Female	Married	56
36	C	Regular	1	$29.50	MasterCard	Male	Single	36
37	C	Regular	2	$102.50	Visa	Female	Single	42
38	B	Promotional	6	$117.50	Proprietary Card	Female	Married	50
39	A	Promotional	5	$13.23	Proprietary Card	Female	Married	44
40	B	Regular	2	$52.50	Proprietary Card	Female	Married	58
41	A	Promotional	13	$198.80	Proprietary Card	Female	Married	42
42	B	Promotional	4	$19.50	Visa	Female	Married	46
43	A	Regular	2	$123.50	Proprietary Card	Female	Married	48
44	A	Promotional	1	$62.40	Proprietary Card	Female	Married	54
45	C	Promotional	2	$23.80	Proprietary Card	Female	Married	38
46	C	Promotional	2	$39.60	Proprietary Card	Female	Married	60
47	A	Regular	1	$25.00	MasterCard	Female	Married	46
48	A	Promotional	3	$63.64	Proprietary Card	Female	Married	30
49	A	Promotional	1	$14.82	Proprietary Card	Female	Married	32
50	B	Promotional	9	$145.20	MasterCard	Female	Married	46
51	A	Promotional	6	$176.62	Proprietary Card	Female	Married	38
52	C	Promotional	5	$118.80	Proprietary Card	Male	Married	68
53	A	Regular	1	$58.00	Discover	Female	Single	78
54	C	Regular	2	$74.00	Visa	Female	Single	20
55	B	Regular	2	$49.50	MasterCard	Female	Married	32
56	B	Promotional	3	$141.60	Proprietary Card	Female	Married	38
57	B	Promotional	6	$123.10	Proprietary Card	Female	Married	54
58	C	Promotional	2	$80.40	Proprietary Card	Female	Married	48
59	B	Promotional	4	$65.20	MasterCard	Female	Married	46
60	A	Promotional	4	$113.00	Proprietary Card	Female	Single	50
61	A	Promotional	1	$108.80	Proprietary Card	Female	Married	46
62	A	Promotional	3	$59.91	Proprietary Card	Female	Single	30
63	B	Promotional	5	$53.60	Proprietary Card	Female	Married	54
64	A	Promotional	1	$31.60	Proprietary Card	Female	Single	42
65	A	Promotional	2	$49.50	Proprietary Card	Female	Married	48
66	B	Promotional	1	$39.60	Proprietary Card	Female	Married	62
67	C	Promotional	2	$59.50	Proprietary Card	Female	Married	34
68	A	Promotional	5	$146.80	Proprietary Card	Female	Married	28
69	A	Promotional	2	$47.20	Proprietary Card	Male	Married	46
70	B	Promotional	8	$95.05	Proprietary Card	Female	Married	54
71	C	Promotional	5	$155.32	Proprietary Card	Female	Married	30
72	A	Promotional	4	$58.00	MasterCard	Female	Married	32
73	C	Regular	1	$69.00	Proprietary Card	Female	Single	22
74	A	Promotional	2	$46.50	Proprietary Card	Female	Married	32
75	B	Promotional	2	$45.22	Proprietary Card	Female	Married	74
76	B	Promotional	4	$84.74	Proprietary Card	Female	Married	62
77	B	Regular	2	$39.00	Proprietary Card	Female	Married	42
78	A	Promotional	4	$111.14	Proprietary Card	Female	Married	28
79	A	Promotional	3	$86.80	Proprietary Card	Female	Married	38
80	B	Regular	2	$89.00	Discover	Female	Married	54
81	C	Promotional	2	$78.00	MasterCard	Female	Married	68
82	B	Promotional	6	$53.20	Proprietary Card	Female	Single	30
83	A	Promotional	4	$58.50	Visa	Female	Married	36
84	C	Promotional	3	$46.00	Proprietary Card	Female	Married	44
85	B	Regular	2	$37.50	Visa	Female	Married	44
86	B	Promotional	1	$20.80	Proprietary Card	Female	Married	62
87	C	Regular	6	$144.00	MasterCard	Female	Single	48
88	C	Regular	4	$107.00	Proprietary Card	Female	Married	36
89	C	Promotional	1	$31.60	Proprietary Card	Female	Single	20
90	C	Promotional	6	$57.60	Proprietary Card	Female	Married	42
91	B	Promotional	4	$95.20	Proprietary Card	Female	Married	54
92	A	Promotional	1	$22.42	Proprietary Card	Female	Married	54
93	B	Regular	5	$159.75	Proprietary Card	Female	Married	72
94	A	Promotional	17	$229.50	Proprietary Card	Female	Married	30
95	A	Regular	3	$66.00	American Express	Female	Married	46
96	C	Regular	1	$39.50	MasterCard	Female	Married	44
97	C	Promotional	9	$253.00	Proprietary Card	Female	Married	30
98	C	Promotional	10	$287.59	Proprietary Card	Female	Married	52
99	A	Promotional	2	$47.60	Proprietary Card	Female	Married	30
100	B	Promotional	1	$28.44	Proprietary Card	Female	Married	44