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

The Answer is in the image, click to view ...

Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

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...

Question ONE OF ACME CO.S PLANTS IS STILL OPERATING ITS OWN POWER GENERATING PLANT DUE TO ITS LOCATION. THIS PLANT CONSUMES THREE TYPES OF THINGAMABOBS, AS DETAILED IN THE TABLE BELOW, TO PRODUCE...

Hours/Unit needed Model A Model B Hours Available Production 0.2 0.4 10,000 Assembly 0.3 0.5 15,000 Packaging 0.1 0.1 5,000 ACME CO, has a contract to provide a retailer with two models of DOODADS:...

Write a cpp program to make a class of English Distance with data members feet and inches, and member function getdata(), showdata(), adddata() and operator+() to get data for two distances, to...

Example Code: The example below demonstrates the aspects of constructor overloading, defining member functions outside the class, and most importantly objects as function arguments. This program...

After listening to the Baldwin Park Police audio file on YouTube, what Do you believe the risk to public safety outweighed the need to apprehend this suspect? If yes or no, why? when you answer apply...

12. Although we typically speak of "the" shortest path between two nodes, single graph could contain several minimum-length paths with the same endpoints. Even for weighted graphs, it is often...

CODE LANGUAGE (IF USED) : PYTHON (3) Consider the following problem. Given a positive number N, find all combinations of 2N elements with the following conditions: Every element from 1 to N appears...

A large national survey conducted in 1995 indicated that 18% of American adults had ever been tested for HIV at some point in their life. Suppose that in 2016 we take a simple random sample of 100...

During the coming year, Bauba Ltd is forecast to have total sales of R250m, earnings before interest and tax (EBIT) of R100m, depreciation and amortization of R18m, capital expenditure of R40m, and a...

Express the number in terms of i. a. -3 b. -21 c. -25 d. -100 e. --33

(a) Identify two production systems not mentioned in the chapter in which queueing is an important aspect of the system. (b) What can be done to improve the operation of these two systems? Explain.

The force constant of a massless spring is 2 5 . 0 N / m . A mass of 0 . 4 5 kg is oscillating in simple harmonic motion at the end of the spring

During the year ended 31 March 1998 a companys profit as per financial accounts was Rs 16,624. Prepare a reconciliation statement and arrive at the profit as per cost accounts using the additional...

A company maintains separate cost and financial accounts, and the costing profit for the year 1998 differed to that revealed in the financial accounts, which was shown as Rs 50,000. The following...

In the reconciliation between cost and financial accounts, one of the areas of differences is different methods of stock valuation used. State with reasons, in each of the following circumstances...