Obs	Dist_1	Dist_2	Dist_3	Dist_4
1	74.53	38.57	15.83	49.81
2	70.95	37.85	29.12	76.43
3	119.31	41.62	21.99	73.50
4	106.25	37.80	25.54	82.79
5	155.19	38.96	20.16	77.43
6	84.45	41.12	23.33	86.43
7	98.30	36.33	31.51	97.95
8	162.43	41.20	24.96	113.45
9	149.95	38.00	22.64	111.06
10	167.06	38.76	19.22	126.49
11	95.33	37.66	24.20	127.16
12	78.90	39.41	30.85	151.23
13	63.27	39.96	20.19	146.22
14	113.73	36.60	16.82	146.29
15	87.14	36.56	26.07	156.42
16	138.69	39.47	25.66	157.40
17	86.50	38.84	29.06	152.91
18	103.02	37.41	35.42	162.46
19	104.17	37.91	26.37	157.75
20	90.15	38.43	34.66	161.21
21	63.51	38.92	24.70	177.07
22	59.28	39.10	25.31	161.93
23	110.34	37.00	23.40	203.29
24	125.00	35.65	28.38	207.50
25	119.69	35.95	16.85	207.42
26	117.57	36.03	25.18	192.86
27	142.65	38.58	28.39	211.47
28	127.64	42.69	27.27	214.92
29	73.40	37.05	22.00	190.08
30	147.62	39.44	130.54	208.96
31	31.97	38.38	67.32	212.53
32	64.13	37.35	67.58	225.91
33	53.83	36.73	73.81	193.18
34	28.06	40.08	66.69	191.22
35	64.73	40.41	73.50	148.00
36	75.08	38.06	68.12	90.57
37	106.85	36.52	68.14	62.30
38	132.97	35.31	66.09	76.95
39	133.66	40.43	66.56	71.96
40	98.76	35.25	70.02	84.03
41	131.44	40.98	24.32	80.62
42	73.26	38.58	26.71	86.08
43	128.51	38.49	13.16	112.64
44	119.32	35.91	20.63	112.60
45	179.28	37.70	32.24	115.00
46	86.12	36.38	32.95	129.62
47	101.25	39.08	23.52	120.78
48	111.90	37.17	22.94	139.48
49	118.59	39.91	26.30	146.65
50	159.37	40.54	28.63	132.29
51	109.95	36.52	20.55	144.33
52	159.29	37.63	84.41	137.58
53	126.80	34.60	87.94	150.78
54	113.95	40.57	88.35	172.71
55	138.94	36.21	92.23	170.52
56	72.52	35.99	86.93	154.71
57	106.50	38.62	189.00	165.88
58	120.53	36.25	84.94	181.45
59	113.82	40.49	87.65	200.73
60	116.50	39.23	87.43	206.42
61	150.51	43.53	85.93	206.46
62	129.67	37.70	88.33	205.15
63	143.76	36.84	119.13	214.66
64	122.69	37.67	24.66	205.09
65	95.54	36.25	188.82	198.74
66	75.39	38.82	133.25	210.59
67	386.03	39.45	87.08	223.17
68	146.27	38.07	151.18	234.27
69	89.49	37.41	20.84	194.89
70	0.87	35.81	25.44	188.05
71	18.25	36.51	29.99	171.13
72	42.06	36.91	18.11	94.94
73	121.74	476.57	18.54	63.04
74	85.39	37.76	31.94	74.33
75	97.83	40.13	28.14	88.09
76	216.22	37.44	30.53	95.58
77	140.57	35.37	22.04	93.19
78	135.66	36.95	230.04	85.52
79	116.27	37.62	23.98	103.03
80	98.93	36.51	121.87	94.41
81	106.52	36.22	19.06	105.77
82	106.45	39.41	88.04	121.29
83	81.65	39.40	121.55	118.36
84	120.18	38.22	32.61	129.64
85	90.05	40.63	19.62	135.77
86	159.19	37.35	31.11	135.35
87	139.02	38.42	27.11	148.66
88	155.63	34.74	23.39	150.30
89	107.42	41.42	161.15	160.38
90	176.71	37.58	33.64	163.22
91	99.24	38.18	14.17	165.62
92	129.21	38.77	131.35	153.59
93	87.01	39.12	125.38	177.61
94	133.84	34.90	37.61	165.32
95	112.46	41.18	36.33	194.41
96	126.31	40.47	75.89	213.75
97	146.29	38.02	27.95	202.86
98	191.28	33.61	31.49	225.12
99	358.51	39.99	23.95	241.08
100	198.04	37.59	28.55	273.86

6. (24 pts) Continuing in the Excel file named Exam 1 Data, use it to answer the following questions: a) (18 pts) Create a nicely formatted summary table that displays the mean, median, mode, and standard deviation for all 4 distributions. Make sure that all values in this table are rounded to 2 decimal places and centered. When complete, copy and paste the chart into this word document (you can copy and paste by highlighting the cells and copying and pasting it into here; you can also use screenshot/snipping tool features) b) (6 pts) Calculate Z-scores for Dist_3 and make sure they display 3 decimal places. Explain the process you went through to calculate this. What is the value of the highest Z-score