run a bivariate correlation using Mary's volunteer profile data.

• Examine if there is a statistically significant correlation between the age of the volunteers and the number of hours they are willing to volunteer.
• Write a research question as well as a null and alternative hypothesis.
• Create a scatterplot.
• Run a Pearson's r correlation.
• Determine if the correlation is statistically significant.
• Show your
  • scatterplot
  • correlation, and
  • p-value.
• Interpret the results and report your findings. What do you know about Mary's volunteers from your analysis?

use Mary's volunteer profile data to run chi-square analysis.

• Mary first wants to know if there is a relationship between gender and region.
• Also, she wants to know if there is a relationship between gender and income.
• Write a research question and write hypotheses that you can test to answer Mary's questions.
• Determine if there is a relationship between dummy gender (0=male, 1=female) and region (E_W; where 1=East, 2=West) by running Chi-square. Be sure you're selecting the correct variable (E_W).
• Determine if there is a relationship between dummy gender and income (where <11 is low and>=11 is high) by running Chi-square.
• For each question, convert values to labels
  • create a contingency table,
  • calculate the expected frequencies,
  • p-value, and
  • chi-square statistic.
• Interpret the results and report your findings.

Submit one Excel workbook with both parts included in separate workbooks (tabs). If your output shows values with a letter E, you may need to change the format of the cell from general to number.

Please create excel sheet

volunter_id	age	hours_week	gender	region	income	filter_$	E_W	dummy_gender
1	37	9	2	3	8	1	1	0
2	40	15	2	1	14	1	2	0
3	31	9	2	3	7	1	2	0
4	38	6	1	4	6	1	1	1
5	68	5	1	4	8	1	2	1
6	29	6	1	2	9	1	2	1
7	61	12	1	1	8	1	2	1
8	47	9	1	3	10	1	2	1
9	58	6	2	1	8	1	1	0
10	28	4	1	4	5	1	1	1
11	53	6	1	4	10	1	2	1
12	77	10	1	2	12	1	2	1
13	29	6	1	4	9	1	2	1
14	31	14	1	3	10	1	2	1
15	57	15	1	4	16	0	2	1
16	28	8	1	2	11	0	1	1
17	64	17	1	4	18	1	1	1
18	19	10	1	3	13	1	1	1
19	32	10	1	4	8	0	2	1
20	51	18	2	4	15	1	2	0
21	62	18	1	2	19	1	1	1
22	43	12	1	3	10	0	2	1
23	66	8	1	4	12	1	2	1
24	57	13	1	4	9	1	2	1
25	68	14	1	4	10	1	2	1
26	48	7	1	4	10	0	2	1
27	50	10	1	2	12	1	1	1
28	22	13	1	3	10	1	2	1
29	29	14	2	2	16	1	1	0
30	50	6	1	1	11	0	1	1
31	42	8	1	1	11	1	1	1
32	64	5	2	2	7	1	2	0
33	65	22	1	1	18	1	1	1
34	77	20	2	2	20	1	2	0
35	30	6	1	4	6	0	2	1
36	20	4	1	1	8	0	1	1
37	32	5	1	3	4	0	2	1
38	63	14	2	1	15	1	1	0
39	45	15	1	1	15	1	1	1
40	31	9	1	3	9	1	2	1
41	28	3	2	1	2	1	2	0
42	29	3	2	3	3	0	2	0
43	30	14	1	3	9	1	2	1
44	41	5	1	4	9	1	2	1
45	21	15	2	3	17	1	2	0
46	22	14	2	3	9	0	2	0
47	32	5	2	3	4	1	2	0
48	62	8	2	2	11	1	1	0
49	43	12	1	3	8	0	2	1
50	41	4	1	4	6	1	2	1
51	66	17	2	3	19	1	2	0
52	60	6	1	3	8	0	2	1
53	41	8	2	1	9	1	1	0
54	42	12	1	3	9	1	2	1
55	53	14	1	4	8	1	2	1
56	76	14	2	2	10	1	2	0
57	64	15	1	2	18	1	1	1
58	51	15	2	4	11	0	2	0
59	43	8	2	2	9	1	1	0
60	63	12	2	1	9	0	2	0