Question number 5: Assume that the average length ofjail in pretrial in the state of Florida is 90 days. Use the data to perform a hypothesis test to determine if the average length of jail in pretrial in your sample is significantly different from the average length of jail in pretrial in Florida. The variable that measures the average length of jail in pretrial is JAILCREDIT. Use a .05 level of statistical significance. Run the one-sample t-test inExcel. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.

person	sex	race	ageadmit	offense	sentence	jailcredit
2	0	White	29	4	251	637
5	0	White	36	8	3	1043
6	0	White	71	1	131	735
8	0	White	74	4	82	1868
12	0	White	62	8	337	617
16	0	White	59	2	184	707
18	0	White	47	2	89	1123
23	0	White	62	2	153	494
25	0	White	60	9	131	1608
26	0	White	66	3	5	1965
30	0	White	40	3	137	793
31	0	White	59	5	239	1943
35	0	White	43	6	81	1655
37	0	White	75	9	226	506
38	0	White	29	2	270	1194
44	0	White	43	1	102	1248
45	0	White	39	7	85	1998
50	0	White	64	8	237	1674
52	0	White	44	9	348	243
54	0	White	57	3	136	10
56	0	White	71	6	278	1608
57	0	White	70	2	73	1862
58	0	White	21	6	119	811
62	0	White	27	6	304	1457
65	0	White	36	8	288	1945
66	0	White	36	9	104	1631
67	0	White	63	6	67	583
69	0	White	58	2	143	322
71	0	White	37	3	268	828
73	0	White	57	7	281	1039
74	0	White	72	1	316	804
77	0	White	72	8	257	450
81	0	White	53	7	149	2096
82	0	White	42	7	63	34
86	0	White	67	4	302	116
92	0	White	40	8	231	2392
96	0	White	23	5	302	592
100	0	White	33	8	163	1524
1	0	Black	21	7	213	1461
4	0	Black	73	2	115	1147
11	0	Black	62	3	342	1750
15	0	Black	59	4	76	51
17	0	Black	39	3	304	67
21	0	Black	31	9	253	365
27	0	Black	45	1	327	6
28	0	Black	50	6	114	1051
32	0	Black	53	5	50	314
34	0	Black	75	1	244	1576
40	0	Black	74	3	335	406
47	0	Black	72	5	7	599
49	0	Black	70	7	155	1287
53	0	Black	21	7	230	1878
59	0	Black	50	4	28	40
61	0	Black	39	3	308	541
68	0	Black	62	3	157	427
70	0	Black	30	6	181	1580
72	0	Black	56	2	212	2383
75	0	Black	51	4	37	1062
76	0	Black	60	2	271	1677
80	0	Black	47	5	76	784
83	0	Black	77	6	284	402
84	0	Black	66	7	102	1438
87	0	Black	23	4	252	1478
88	0	Black	66	7	261	158
89	0	Black	43	5	175	2263
90	0	Black	69	8	10	2231
94	0	Black	27	9	353	1245
7	1	White	60	3	289	1684
9	1	White	55	6	330	2040
13	1	White	31	3	190	1142
19	1	White	41	2	340	915
29	1	White	48	7	121	1028
33	1	White	56	5	16	2092
36	1	White	38	6	73	1986
41	1	White	68	8	194	1221
42	1	White	21	7	82	935
43	1	White	27	1	187	1306
48	1	White	55	7	339	1414
51	1	White	47	2	128	2045
55	1	White	53	9	297	806
78	1	White	24	1	354	1780
79	1	White	68	1	242	1960
85	1	White	75	5	95	1173
93	1	White	62	8	351	95
95	1	White	80	6	312	816
98	1	White	71	8	323	1093
99	1	White	30	2	123	451
3	1	Black	26	7	284	621
10	1	Black	75	2	214	1172
14	1	Black	36	3	137	211
20	1	Black	38	3	76	2128
22	1	Black	61	5	58	235
24	1	Black	78	7	230	1708
39	1	Black	51	5	145	1038
46	1	Black	69	8	202	1474
60	1	Black	71	2	254	245
63	1	Black	28	8	79	1660
64	1	Black	66	2	327	1512
91	1	Black	71	5	41	1864
97	1	Black	59	6	176	1516

Assume that the average age of offenders at prison admissions in the state of Florida is 30. Use the data to perform a hypothesis test to determine if the average age of offenders at prison admissions in your sample is significantly different from the average age in the offender population in Florida. The variable that measures the average age of offenders at prison admission is AGEADMIT. Use a .05 level of statistical significance. Run the one-sample t- test in Excel. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result. Assume that the average length of jail in pretrial in the state of Florida is 90 days. Use the data to perform a hypothesis test to determine if the average length of jail in pretrial in your sample is significantly different from the average length of jail in pretrial in Florida. The variable that measures the average length of jail in pretrial is JAILCREDIT. Use a .05 level of statistical significance. Run the one-sample t-test in Excel. In your summary, please discuss the null hypothesis, altemative hypothesis, the result of this hypothesis test, and interpret the result. Conduct an independent sample t-test (alpha= .05) in Excel to determine whether there is a significant difference in the length of jail in pretrial between White and Black offenders. For this t-test, assume that the variances of the two groups are unequal. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result. Conduct an independent sample t-test (alpha=.05) in Excel to determine whether there is a significant difference in the age of offenders at prison admissions between White and Black offenders. For this t-test, assume that the variances of the two groups are equal. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result