Quantitative Business 5

profileWill Wheaton
MTH410_Module5_CT_Option1_Cars_v6.xlsx
Home>Business & Finance homework help>Economics homework help>Quantitative Business 5

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