Need it done in 4 hours correctly solved

profiletv
hw.xlsx
Home>Business & Finance homework help>Economics homework help>Need it done in 4 hours correctly solved

Instructions

Instructions Though this take-home portion of Test 1 is "open book, open notes", neither give nor receive assistance to/from another person on it. After performing the tasks on sheets #1 through #6, copy and paste (as pictures) your results/answers to a Word document. As needed, adjust the size of the pictures so that your Word document is only 2 pages long. The printout of your Word document is due at the beginning of class on Friday, June 13. This take-home portion is worth 28 points (with each task worth 4 or 5 points). Friendly reminders: Any bar chart, histogram, or line graph calls for an appropriate label/title for each of the horizontal and vertical axes. Also, any break in a histogram's x-axis or y-axis scale should be indicated (e.g., by parallel hashmarks).

#1

Below, from the Bureau of Economic Analysis, are the personal consumption expenditures on clothing and footwear (in $ billions)
in the U.S. for the years 1990 through 2013.
Display the annual expenditures in the form of a line graph,
using as the chart title U.S. Personal Consumption Expenditures on Clothing and Footwear (in $ billions), 1990-2013 (source: Bureau of Economic Analysis).
Year Expenditures (in $ billions)
1990 195.2
1991 199.1
1992 211.2
1993 219.1
1994 227.4
1995 231.2
1996 239.5
1997 247.5
1998 257.8
1999 271.1
2000 280.8
2001 277.9
2002 278.8
2003 285.3
2004 297.5
2005 310.7
2006 320.2
2007 323.7
2008 319.5
2009 306.5
2010 320.6
2011 338.3
2012 354.6
2013 362.7

#2

Below is the frequency distribution of the service quality ratings given Sally's Café by a sample of 50 customers.
Service quality rating # of customers
Poor 6
Good 15
Very good 17
Excellent 12
Display the frequency distribution in the form of a bar chart.
using as the Chart Title Service quality ratings of Sally's Café by 50 customers

#3

Below (from the FuelData08 file referenced on page 64 of our text) are data on 311 cars brought to market in the year 2008.
Use Excel's PivotTable module to cross-classify the cars by Fuel Type (premium or regular) and City MPG (using the
intervals 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39). Provide above your table the title
311 cars brought to market in 2008 cross-classified by Fuel Type and City MPG.
Car Size Fuel Type City MPG Hwy MPG
1 Compact premium 15 25
2 Compact premium 17 25
3 Compact premium 17 25
4 Compact premium 16 25
5 Compact premium 17 25
6 Compact premium 17 25
7 Compact premium 20 25
8 Compact premium 22 25
9 Compact premium 17 25
10 Compact premium 18 24
11 Compact premium 15 24
12 Compact premium 17 24
13 Compact premium 17 24
14 Compact premium 18 24
15 Compact regular 19 24
16 Compact premium 16 24
17 Compact premium 15 24
18 Compact regular 17 24
19 Compact regular 17 24
20 Compact regular 17 24
21 Compact regular 17 24
22 Compact regular 17 24
23 Compact regular 17 24
24 Compact regular 17 24
25 Compact premium 16 24
26 Compact premium 16 24
27 Compact premium 15 24
28 Compact premium 17 24
29 Compact premium 16 24
30 Compact premium 17 24
31 Compact premium 16 24
32 Compact premium 16 24
33 Compact premium 17 24
34 Compact premium 16 24
35 Compact premium 16 24
36 Compact premium 16 24
37 Compact regular 15 24
38 Compact regular 21 24
39 Compact regular 15 24
40 Compact regular 17 24
41 Compact premium 18 23
42 Compact premium 16 23
43 Compact premium 15 23
44 Compact premium 15 23
45 Compact premium 16 23
46 Compact regular 15 23
47 Compact regular 15 23
48 Compact regular 15 23
49 Compact regular 15 23
50 Compact regular 15 23
51 Compact regular 15 23
52 Compact premium 16 23
53 Compact premium 16 23
54 Compact premium 15 23
55 Compact premium 17 23
56 Compact premium 15 23
57 Compact premium 15 23
58 Compact premium 16 22
59 Compact regular 15 22
60 Compact premium 16 22
61 Compact premium 15 22
62 Compact premium 15 22
63 Compact regular 15 22
64 Compact regular 15 22
65 Compact regular 15 22
66 Compact regular 15 22
67 Compact regular 15 22
68 Compact regular 15 22
69 Compact premium 15 22
70 Compact premium 16 22
71 Compact premium 15 22
72 Compact premium 20 22
73 Compact premium 16 22
74 Compact premium 15 22
75 Compact premium 14 21
76 Compact premium 14 21
77 Compact premium 14 21
78 Compact premium 16 21
79 Compact premium 14 21
80 Compact premium 14 21
81 Compact premium 13 20
82 Compact premium 13 20
83 Compact premium 13 20
84 Compact premium 14 20
85 Compact premium 14 20
86 Compact premium 13 19
87 Compact premium 13 19
88 Compact premium 14 19
89 Compact premium 13 19
90 Compact premium 13 19
91 Compact premium 12 19
92 Compact premium 11 18
93 Compact premium 12 18
94 Compact premium 13 18
95 Compact premium 13 18
96 Compact regular 13 18
97 Compact regular 13 18
98 Compact premium 13 18
99 Compact premium 11 17
100 Compact premium 11 17
101 Compact premium 11 17
102 Compact premium 11 17
103 Compact premium 11 17
104 Compact premium 11 17
105 Compact premium 11 17
106 Compact premium 10 16
107 Compact premium 10 16
108 Compact premium 10 16
109 Compact premium 10 16
110 Compact premium 9 16
111 Compact premium 10 15
112 Midsize regular 28 37
113 Midsize regular 24 35
114 Midsize regular 25 35
115 Midsize regular 26 35
116 Midsize regular 24 34
117 Midsize regular 33 34
118 Midsize regular 24 33
119 Midsize regular 24 33
120 Midsize regular 25 33
121 Midsize regular 24 33
122 Midsize regular 27 33
123 Midsize regular 35 33
124 Midsize regular 25 33
125 Midsize regular 23 32
126 Midsize regular 27 32
127 Midsize regular 27 32
128 Midsize regular 24 32
129 Midsize regular 24 32
130 Midsize regular 24 32
131 Midsize regular 24 32
132 Midsize regular 23 32
133 Midsize regular 24 32
134 Midsize premium 20 31
135 Midsize regular 22 31
136 Midsize regular 23 31
137 Midsize regular 23 31
138 Midsize regular 22 31
139 Midsize regular 21 31
140 Midsize regular 21 31
141 Midsize regular 22 31
142 Midsize regular 21 31
143 Midsize regular 21 31
144 Midsize regular 21 31
145 Midsize regular 21 31
146 Midsize regular 23 31
147 Midsize regular 26 31
148 Midsize regular 24 31
149 Midsize regular 21 31
150 Midsize regular 21 31
151 Midsize premium 21 30
152 Midsize regular 21 30
153 Midsize regular 22 30
154 Midsize regular 22 30
155 Midsize regular 21 30
156 Midsize regular 22 30
157 Midsize regular 21 30
158 Midsize regular 21 30
159 Midsize regular 23 30
160 Midsize regular 24 30
161 Midsize regular 22 30
162 Midsize premium 19 29
163 Midsize premium 21 29
164 Midsize premium 21 29
165 Midsize premium 22 29
166 Midsize premium 22 29
167 Midsize regular 22 29
168 Midsize regular 22 29
169 Midsize regular 22 29
170 Midsize regular 21 29
171 Midsize regular 18 29
172 Midsize regular 21 29
173 Midsize regular 22 29
174 Midsize regular 21 29
175 Midsize regular 21 29
176 Midsize regular 18 29
177 Midsize regular 18 29
178 Midsize regular 19 29
179 Midsize premium 21 29
180 Midsize premium 21 29
181 Midsize regular 18 29
182 Midsize regular 24 29
183 Midsize regular 23 29
184 Midsize regular 20 29
185 Midsize regular 20 29
186 Midsize regular 21 29
187 Midsize regular 18 29
188 Midsize premium 19 28
189 Midsize premium 20 28
190 Midsize premium 20 28
191 Midsize premium 18 28
192 Midsize premium 19 28
193 Midsize premium 19 28
194 Midsize premium 19 28
195 Midsize premium 20 28
196 Midsize premium 20 28
197 Midsize premium 20 28
198 Midsize premium 20 28
199 Midsize regular 19 28
200 Midsize regular 20 28
201 Midsize regular 19 28
202 Midsize regular 19 28
203 Midsize regular 20 28
204 Midsize regular 18 28
205 Midsize regular 18 28
206 Midsize regular 19 28
207 Midsize regular 18 28
208 Midsize regular 19 28
209 Midsize premium 18 28
210 Midsize premium 18 28
211 Midsize premium 19 28
212 Midsize regular 17 28
213 Midsize regular 18 28
214 Midsize regular 20 28
215 Midsize regular 20 28
216 Midsize regular 20 28
217 Midsize regular 18 28
218 Midsize regular 21 28
219 Midsize regular 18 28
220 Midsize regular 19 28
221 Midsize premium 19 27
222 Midsize premium 18 27
223 Midsize premium 19 27
224 Midsize premium 19 27
225 Midsize premium 19 27
226 Midsize premium 19 27
227 Midsize regular 20 27
228 Midsize regular 20 27
229 Midsize regular 20 27
230 Midsize regular 20 27
231 Midsize regular 18 27
232 Midsize premium 18 27
233 Midsize premium 18 27
234 Midsize premium 18 27
235 Midsize premium 19 27
236 Midsize premium 19 27
237 Midsize premium 19 27
238 Midsize regular 19 27
239 Midsize regular 19 27
240 Midsize regular 19 27
241 Midsize regular 23 27
242 Midsize regular 19 27
243 Midsize regular 20 27
244 Midsize regular 18 26
245 Midsize regular 18 26
246 Midsize regular 17 26
247 Large premium 17 26
248 Large premium 17 26
249 Large premium 18 26
250 Large premium 19 26
251 Large premium 16 26
252 Large premium 18 26
253 Large premium 18 26
254 Large premium 17 26
255 Large premium 18 26
256 Large premium 18 26
257 Large regular 21 26
258 Large regular 17 26
259 Large regular 17 26
260 Large regular 18 26
261 Large regular 18 26
262 Large regular 18 26
263 Large regular 17 26
264 Large regular 18 26
265 Large premium 18 26
266 Large premium 17 26
267 Large premium 17 26
268 Large premium 17 26
269 Large premium 17 26
270 Large premium 18 26
271 Large premium 19 26
272 Large premium 17 26
273 Large premium 17 26
274 Large regular 17 26
275 Large regular 17 26
276 Large regular 18 26
277 Large regular 17 26
278 Large regular 17 26
279 Large regular 17 26
280 Large regular 16 26
281 Large regular 16 26
282 Large premium 18 25
283 Large premium 17 25
284 Large premium 20 25
285 Large premium 19 25
286 Large premium 19 25
287 Large premium 17 25
288 Large regular 17 25
289 Large premium 16 25
290 Large premium 16 25
291 Large premium 16 25
292 Large regular 16 25
293 Large premium 17 25
294 Large premium 17 25
295 Large premium 17 25
296 Large premium 16 25
297 Large premium 17 25
298 Large premium 17 25
299 Large premium 18 25
300 Large premium 17 25
301 Large premium 19 25
302 Large premium 16 25
303 Large regular 17 25
304 Large regular 17 25
305 Large regular 16 25
306 Large regular 16 25
307 Large regular 21 25
308 Large regular 17 25
309 Large regular 17 25
310 Large regular 17 25
311 Large regular 18 25

#4

A car manufacturer is assessing the mileage of its new hybrid car model. Below are the mileages (in mpg) in city driving for a sample of 40 cars of this model.
37.6 36.1 37.0 37.5 37.9 38.1 36.4 35.9
36.8 35.0 37.7 35.7 39.3 37.6 35.0 37.2
38.4 34.3 38.7 38.2 37.9 36.9 39.8 38.5
35.4 37.2 35.2 37.6 37.4 34.9 39.5 39.9
40.3 39.2 36.8 37.0 38.8 38.3 36.2 37.7
Determine--relying on Excel statistical functions--each of the following measures for the sample of cars.
(a) mean mileage
(b) median mileage
(c) variance in the mileages
(d) standard deviation in the mileages

#5

Below (in column A) are the water usage levels (in gallons) on 5/30/2014 of the 120 condos in the Lark Complex.
Summarize the water usage levels in the form of a frequency distribution (in table form), using as the numeric classes the intervals
15 to under 20, 20 to under 25, 25 to under 30, 30 to under 35, 35 to under 40, 40 to under 45, 45 to under 50, and 50 to under 55.
Water usage
22.8
28.0
29.1
46.5
30.5
30.0
31.1
26.2
32.6
27.0
47.3
32.4
45.2
46.8
27.8
28.9
46.4
19.9
28.3
28.0
21.4
28.8
30.2
37.9
22.7
40.6
40.3
23.6
24.1
23.6
41.2
28.6
48.0
25.1
35.5
37.6
28.0
46.3
25.8
30.1
22.5
41.9
23.8
26.0
43.9
33.4
27.3
44.4
33.4
48.9
28.6
42.5
46.6
53.6
28.8
30.1
32.3
36.8
22.4
31.5
31.2
27.8
44.0
22.4
15.1
28.2
23.3
29.0
24.7
21.3
36.4
33.5
22.1
41.0
29.6
32.4
24.4
25.0
24.0
43.1
18.0
45.1
30.3
17.9
33.4
28.4
22.9
28.7
38.4
24.9
30.7
42.9
35.3
32.1
29.4
21.7
26.8
34.6
25.1
48.1
31.8
50.0
29.3
27.8
51.3
23.2
41.6
22.3
32.3
30.6
29.1
25.9
19.7
26.8
37.0
25.8
19.4
21.6
39.2
16.8

#6

A consultant developed an electronic billing system for a trucking company.
The frequency distribution below summarizes the payment times (in days) for 65 invoices using the electronic billing system.
Display the frequency distribution in the form of a histogram
using as the chart title Payment Times (in days) for 65 Invoices Using Electronic Billing System.
Payment time (in days) # of invoices
10-12 3
13-15 14
16-18 23
19-21 12
22-24 8
25-27 4
28-30 1