Managerial Report

profileMrs.JackAlec
MTH410_Module5_CT_Option1_Cars_v6.xlsx
Home>Mathematics homework help>Statistics homework help>Managerial Report

Data

Domestic Cars Foreign Cars
Car List Price in K Sale Price in K Days to Sell List Price in K Sale Price in K Days to Sell
1 29 26.3 66 41.7 39.1 65
2 29.6 24.8 47 21 16.5 62
3 43.6 41 10 5 4 60
4 43.1 39.2 15 31.6 29.4 11
5 5.6 1 10 13.9 10.6 57
6 43.1 42.1 47 6.4 4.4 61
7 5.9 2.4 58 82.9 78.2 32
8 53.2 52.2 25 3.5 3.5 10
9 34.4 30 25 35.6 33.2 4
10 4.6 1.6 51 14.6 11.2 33
11 13.1 9.1 13 43.7 39 79
12 34.8 32.5 63 19.8 18.7 88
13 44.9 44 18 22.8 21.4 11
14 54.3 51.6 59 59.2 55.1 19
15 48.4 45.6 47 29.7 28.7 68
16 52.2 51.7 70 72.5 70.2 57
17 9.6 5.4 56 6.9 3.9 17
18 13.2 10.2 26 17.6 15.6 40
19 22.6 20.8 22 35.3 33.5 57
20 38 37.6 32 12.3 10.6 85
21 6.6 3.8 29 29.9 26.2 6
22 60 57.9 28 61.2 60.5 4
23 47.2 45.3 26 53.4 52.4 39
24 45.7 44.8 66 51.2 46.8 50
25 19.1 15.1 48 14.4 9.9 33
26 12.7 10.9 67 38 37.5 52
27 20.2 16.8 67 65.5 61.4 78
28 49.2 46 36 70.4 67 14
29 38 33.2 58 80.9 79.1 37
30 21.7 17.3 12 63.8 60.6 21
31 59.4 56.8 31 74.7 72.4 70
32 38.3 36.4 70 61.5 59.5 21
33 50.2 48.6 50 75.8 74.7 64
34 7.4 7.1 20 44.1 40 32
35 20.7 19.6 65 67 64.5 84
36 59.4 59 43 55 55 40
37 25.9 21.6 48 21.7 17.3 21
38 39.8 37.2 29 3.9 2.1 49
39 20.7 16.3 58 82.2 79.2 18
40 34.6 33 5 61.8 58.7 4
41 37 32.1 15 6.9 4.6 50
42 50.7 49.1 38 7.2 6.4 15
43 9.2 7 7 12 10.6 29
44 25.5 22.6 45 42 38.7 75
45 13.8 12.5 59 25.1 22.8 40
46 22 21.1 29 39.7 36.4 34
47 35 30.6 43 40.6 37.3 50
48 43.1 38.9 66 14.1 10.7 46
49 27.3 25.2 55 56.4 53.6 41
50 26 23.2 2 72.6 71.2 9
51 8 6.5 61 43.9 41.1 74
52 42.8 38.3 65 44.6 42.3 87
53 19 17.6 27 9.5 9.5 3
54 58.7 53.8 63 35.8 31.2 66
55 20.2 17.6 63 5.9 4.9 35
56 9.4 7.9 29 11.7 8.6 39
57 33.6 29.1 46 67 66.2 52
58 49.7 46.2 23 5.1 0.1 28
59 47 45.8 63 49.4 46.9 46
60 8.3 6 17 19 17 49
61 60 58 47 16 14.1 80
62 20 19.3 67 27.4 26 55
63 51.1 46.2 50 23.6 21.4 54
64 52.3 48.3 20 37.1 32.4 53
65 4.8 4.6 27 66.6 62.1 86
66 21.1 20.7 50 36.6 35.6 5
67 50.7 45.7 8 81.3 77.1 38
68 14.5 9.7 8 75.3 71.5 86
69 13.4 8.9 41 42.8 38.6 37
70 33.7 29.7 60 27 23.5 83
71 45 40.3 21 47.7 47.2 22
72 39 34.4 51 52.1 48.1 83
73 11.5 8.6 15 84 82.1 37
74 15 11.4 47 59.8 56.9 23
75 57.6 54.5 17 43.1 38.4 16
76 50.9 47.2 43 81.2 79.2 78
77 30.2 26.6 56 19.2 18.8 50
78 52.2 51.2 23 46.4 42.8 85
79 42 41 23 20 15.8 72
80 20.4 19 59 55.2 51.3 69
81 38 36.9 32 42 41.7 31
82 16 11.4 50 63.1 60.9 46
83 41.8 41.2 32 17.3 13.7 63
84 13.8 10.6 11 70 66.4 68
85 8.5 7.3 58 47.6 43.9 12
86 13.6 10.6 18 11.9 10.8 9
87 53 48 65 25.9 25.1 11
88 31.6 26.8 69 66.4 66.3 20
89 33.8 33.8 63 48.5 46 56
90 57.3 54.6 59 69.3 68.7 44
91 8 7 49 13.9 9.1 15
92 46 46 57 26.9 23.9 82
93 55.8 53 62 13.2 8.3 25
94 22 21.8 40 65.3 63.2 10
95 5 3 65 27.2 24.4 37
96 28.7 26.8 42 28 24.1 54
97 29.8 26.9 20 66 62.9 70
98 60.9 57.5 3 54.5 52.8 13
99 4.6 3.6 4 6 5 42
100 18.9 15.4 55 70.4 69.3 2
101 60.6 60.5 58 32 27.9 38
102 49.6 46.6 41 35.1 30.1 83
103 18.9 16.5 69 51.4 48.4 84
104 22.5 18.9 20 75.2 73.4 65
105 38.7 36.8 18 65.6 62.4 79
106 41 38.8 3 78.3 74.8 5
107 56.6 55.7 3 31 27.3 63
108 57.1 53.8 10 21.9 20.9 71
109 15.2 12.3 24 14.3 9.8 70
110 59.2 57.4 22 4.3 4 12
111 17.7 16.3 7 49 46.3 59
112 45.9 44.5 65 47.9 47.5 56
113 50.6 50.6 29 82.6 78.1 52
114 52 48 68 14.1 10.4 58
115 14 11.8 44 58.3 55.4 16
116 58.8 58 70 47.6 43 89
117 34.7 32.8 2 20 16.9 44
118 45.1 44.6 40 37.1 35.5 52
119 57.9 53.1 67 44.3 41.6 38
120 32 30.6 49 72.9 71.3 77
121 55.2 51.2 52 85.9 84.9 48
122 58.2 57.2 34 56 54.9 16
123 10.9 9.2 26 6.3 5 28
124 44.6 43.7 70 47 46.4 79
125 30 29.1 6 62.4 58.2 88
126 44.4 44 24 5.1 0.6 35
127 43.9 39.8 47 59.8 55 15
128 18.2 16.2 68 64.4 63.2 11
129 57.5 56.3 41 53.6 50.6 2
130 49.4 45.4 18 26.3 23.3 40
131 14.4 13.5 59 23.1 21.3 39
132 44.9 41.2 20 64.9 62.8 79
133 24.5 22.6 43 7 5.1 24
134 14 10.8 34 9.5 8.6 75
135 49.2 47.2 45 58 57.1 73
136 37.5 34 10 42 40.1 42
137 47 46.4 35 69.7 67.8 62
138 57.4 52.4 7 53.7 50 62
139 22.8 22.3 24 29.1 28.5 57
140 40.3 36.3 25 82.2 79.2 89
141 52.4 50.4 68 3.3 2 7
142 39.2 35.7 9 72.6 68.4 56
143 54 49 19 6.8 2.8 67
144 15 13 15 64.1 63.3 12
145 60.9 59.9 19 78.1 73.8 31
146 8.4 7.2 50 67.5 67 50
147 39.6 36.2 58 34.4 33.5 44
148 12.7 11.5 48 82 81.2 24
149 19.7 17.6 32 43.1 42 41
150 40.2 37.7 55 50.8 49.1 67
151 35.6 33.8 34 53.2 52.5 55
152 41.3 40.4 26 58.5 57.6 53
153 11.8 8.1 61 20.1 18.1 83
154 37.1 32.4 50 35.9 34.9 23
155 55.9 54.1 29 63.3 61.5 29
156 6.1 4.7 67 53.7 53 72
157 39 36.1 42 6 4.1 44
158 5.9 0.9 39 50.7 46.7 68
159 19.1 15.6 35 18.3 15 33
160 52 50.6 21 48.7 46.3 52
161 56.2 53.6 37 55 54.7 1
162 49.5 44.8 25 58 54 42
163 8.9 6.6 29 9.6 5.3 26
164 4.8 5 34 68.9 66.4 21
165 9.5 7.9 4 32.4 27.7 87
166 17 12.9 50 29.7 26.4 64
167 28.5 26.1 20 58 57.4 87
168 38.7 34.4 33 3.8 -0.8 9
169 30.4 27.3 25 55 52.4 14
170 31.4 28.5 35 36 34.4 78
171 50.4 49.6 44 81.2 79.3 63
172 42.9 40.6 7 19.3 17.8 51
173 11.2 28 34 3.7 -1.2 41
174 40.6 40.1 63 17.5 15.9 8
175 29.2 27.4 67 22.7 20.8 53
176 20.6 16.2 2 85.3 83.5 88
177 53.5 51.1 64 14 11.1 39
178 50.7 47.6 10 73.9 73.8 58
179 25.9 21.6 25 54.7 50.4 84
180 6.3 5 53 44.2 43.7 79
181 49.9 46.7 26 50.8 48.7 14
182 27.3 22.5 39 31.8 28.1 86
183 40.4 37.4 51 28.9 27.6 51
184 8 7.7 29 39.2 35.7 22
185 41 40.4 37 41 37.6 12
186 23.5 19.1 42 26.2 21.8 1
187 24.2 21.9 47 79.8 75.1 58
188 19.8 17 59 3.4 2 57
189 47 44.1 64 75.8 75.1 41
190 6.4 3.3 61 34.2 30.2 66
191 4.6 2.6 7 44.1 40.1 2
192 28.8 27.8 55 37.9 34.5 68
193 56.4 51.5 69 61.7 57.3 27
194 32.6 30.8 23 84.9 82 21
195 16.9 12.6 58 66 62.9 17
196 29.4 28.8 31 34.7 30.7 37
197 25.6 25.5 37 46 45.1 32
198 60.8 59.2 5 4 3 89
199 52.2 47.2 68 42.7 42.3 50
200 35.2 32.8 26 25.5 22.6 18

Work

3-202
Domestic Cars Foreign Cars
List Price in K Sale Price in K Days to Sell List Price in K Sale Price in K Days to Sell
Mean 33.1665 30.7445 38.44 42.091 39.5845 45.455
Median 34.65 32.25 39 42.95 40.05 46
Range
STD 17.100087506 17.0287834881 20.0465889528 23.7603744916 23.8140790617 25.5076690606
Coefficient
Variation
Comparision