i need help with the last 2 excel problems on this file. They are problems 5 and 6 and the tabs for the problems are on the bottom of the screen. Can you also double check my work on the first 4 to see if any mistakes were made, and if there are mistakes, please fix themalso when you send me the completed files please use the same file name. Take-home portion of Test 1 take_home_portion_of_test_1_1.xlsxTake-home portion of Test 1
(worth 24 points; comprises six problems)
Independent work on this take-home portion of Test 1 is required, with you neither giving to nor
receiving assistance from another person.
Due by beginning of class on Friday, February 12: The Excel file containing your work, to be submitted
through our D2L account in the Dropbox titled Take-home portion of Test 1.
Due at beginning of class on Friday, February 12: A two-page printout of your work. Specifically, after using
Excel to work the problems on sheets 1 through 6, copy and paste (as pictures) the results/answers to a
Word document, in order by problem number. As needed, adjust the size of the pictures so that your Word
document is only 2 pages long. Turn in a printout of the Word document.
Friendly reminder: All bar charts, histograms, and line graphs call for axis labels/titles. In addition, any break
in a histogram’s x-axis or y-axis scale should be indicated (e.g., by parallel hashmarks).
r giving to nor
to be submitted
pecifically, after using
sults/answers to a
s so that your Word
In addition, any break
Below, from the Bureau of Economic Analysis, are the profits (in $ billions)
of the U.S. financial industry for the years 2000 through 2014.
Year
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
Profits (in
$ billions)
154,9
201,7
280,0
306,3
336,1
367,7
375,3
261,0
64,1
321,7
368,2
355,7
438,2
385,8
383,6
Profits in $ Billions
Display the profits in the form of a line graph, using as the
chart title Profits of U.S. Financial Industry, 2000-2014 (source: Bureau of Economic Analysis)
Profits of U.S. FInancial Industry, 2000-2014 (source:
Bureau of Economic Analysis)
Profits in $ Billions
500,0
400,0
300,0
200,0
100,0
0,0
2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
Years
A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
B
C
D
E
F
G
H
I
J
The manager of a fast-food establishment periodically monitors various aspects of its operations, including service time, i.e
the time (in seconds) between placing and receiving an order. Below are the service times for a sample of 48 recent drive84
121
87
76
79
101
78
99
109
79
111
87
76
104
58
108
72
111
95
95
91
72
76
103
84
74
92
87
75
120
101
87
72
67
86
57
91
84
96
75
68
97
78
96
109
69
74
86
Use Excel statistical functions to determine each of the following measures for the sample of drive-through custo
(a) mean service time
(b) median service time
(c) variance in the service times
(d) standard deviation in the service times
(e) range in the service times
87,4375
86,5
236,89
15,3912
64
K
L
M
N
1
mes for a sample
2 of 48 recent drive-through customers.
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Below is the percentage distribution for the preferred shift of the 820 package handlers
employed by a large package delivery company called WeDeliver.
Preferred Shift
Midnight
Six am
Noon
Six pm
% of package handlers
15%
29%
43%
13%
Portray the percentage distribution in the form of a bar chart,
using as the chart title Preferred shift of WeDeliver’s 820 package handlers
% of package handlers
Preferred shi
50%
45%
40%
35%
30%
25%
20%
15%
10%
5%
0%
Preferred shift of WeDeliver’s 820 package handlers
50%
45%
40%
35%
30%
25%
20%
15%
10%
5%
0%
%…
Midnight
Six am
Noon
Preferred Shift
Six pm
Below (in column A) are the water usage levels (in gallons) on 2/1/2016 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 nume
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
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
21,8
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
Water Usage
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
50 to under 55
Frequency
6,0
23,0
33,0
23,0
9,0
12,0
11,0
3,0
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
W
Below are data on 97 homes sold in a resort community in 2015. [Adapted from Business Statistics by Robert Don
Use Excel’s PivotTable module to cross-classify the homes by Location and Price (in $1000s),
using Price intervals of 150-299, 300-449, 450-599, 600-749, 750-899, 900-1049, and 1050-1199.
Price (in
$1000’s) Bedrooms
741
791
665
765
472
531
650
582
815
402
355
416
580
330
475
1149
189
565
502
915
525
820
1045
644
700
575
572
547
282
425
720
510
579
987
670
1150
796
510
516
570
891
4
4
4
4
3
3
3
4
4
3
3
3
3
2
3
5
1
3
3
4
4
4
5
3
4
3
3
3
2
3
4
3
3
4
4
5
4
2
3
4
4
Bathrooms
Days on
Market
Age
Square
Feet
Location
4
3
2,5
2,5
3
3
2
2,5
4
2,5
2
3
3
2
3
4
1
2
2,5
4
3,5
3
3,5
3,5
2,5
3
3
2,5
2
3,5
3
3
2,5
3,5
3
3,5
3,5
2
3
3
3
7
102
39
44
118
35
145
207
42
48
150
107
183
261
195
118
32
32
53
47
181
200
98
89
158
200
123
11
98
228
195
26
373
105
111
4
42
120
112
106
107
14
10
19
21
32
25
24
22
15
22
30
26
27
34
27
14
20
29
24
17
21
14
4
27
18
29
34
22
33
33
12
28
19
12
22
8
8
30
28
20
12
3.424
2.980
2.790
2.840
1.968
1.933
1.699
2.018
3.217
1.610
1.652
1.750
2.000
1.700
2.484
3.550
520
2.450
1.660
3.267
2.210
2.110
3.277
2.324
2.779
2.534
2.018
2.100
1.210
1.690
2.060
2.910
2.300
2.905
2.337
4.929
3.460
2.248
1.800
2.287
3.030
Golf Course
Wooded
Golf Course
Golf Course
Wooded
Wooded
Golf Course
Wooded
Golf Course
Wooded
Wooded
Wooded
Wooded
Wooded
Wooded
Golf Course
Wooded
Golf Course
Wooded
Golf Course
Wooded
Wooded
Golf Course
Wooded
Wooded
Wooded
Wooded
Wooded
Wooded
Golf Course
Wooded
Golf Course
Golf Course
Golf Course
Golf Course
Golf Course
Wooded
Wooded
Wooded
Golf Course
Wooded
335
574
815
616
518
750
858
410
385
758
887
774
455
800
1013
618
631
896
550
716
430
410
417
471
482
447
544
913
833
435
945
289
674
1049
310
430
733
674
410
517
485
525
625
679
465
450
382
566
841
3
3
4
4
4
4
4
2
3
4
4
4
3
4
5
4
3
4
3
4
2
3
2
2
4
3
3
5
4
3
5
1
4
5
2
3
4
3
2
2
3
3
4
3
3
2
2
3
4
2
3
2
2
3,5
3,5
3
2
2
3
3,5
3,5
2
2,5
4
3,5
3
3,5
2
2
2
3
2
2
2,5
2,5
3,5
4
3
2
3,5
1
3,5
4
2
2
3
3
2
2
2
3,5
3,5
2,5
2
2
2
2,5
4
160
205
129
144
25
7
69
115
217
64
100
25
155
163
17
30
40
47
140
149
266
21
27
156
202
6
84
12
107
165
93
37
20
113
99
139
102
210
104
32
222
233
186
378
27
53
103
59
12
27
24
9
28
25
31
14
28
29
12
10
18
32
20
5
27
27
10
22
30
36
26
23
35
20
20
25
3
24
29
2
22
16
12
33
29
22
26
35
25
31
35
23
21
27
33
35
26
16
1.677
1.650
2.262
2.240
2.320
2.476
3.050
2.198
1.416
3.000
2.855
2.360
1.702
2.829
2.820
2.370
1.983
3.510
1.649
2.290
1.750
2.860
1.365
1.838
1.968
2.050
2.274
2.770
2.610
1.727
3.227
570
2.310
3.500
1.210
1.992
2.560
1.700
1.260
1.415
1.466
1.740
2.260
2.350
2.400
1.896
1.260
1.830
3.474
Wooded
Golf Course
Wooded
Wooded
Golf Course
Golf Course
Golf Course
Wooded
Wooded
Golf Course
Golf Course
Golf Course
Wooded
Wooded
Golf Course
Golf Course
Wooded
Wooded
Golf Course
Wooded
Wooded
Golf Course
Golf Course
Golf Course
Wooded
Wooded
Wooded
Golf Course
Golf Course
Wooded
Golf Course
Wooded
Golf Course
Golf Course
Wooded
Wooded
Golf Course
Golf Course
Wooded
Golf Course
Wooded
Golf Course
Wooded
Golf Course
Golf Course
Wooded
Wooded
Wooded
Golf Course
371
680
350
466
530
650
915
2
3
2
3
3
4
4
2
3
2
2,5
2
3,5
2
151
188
48
54
144
2
134
33
29
31
24
31
29
11
1.788
2.050
1.846
1.780
2.042
2.426
2.312
Golf Course
Wooded
Wooded
Wooded
Wooded
Golf Course
Wooded
iness Statistics by Robert Donnelly, 2012]
Below is the (hypothetical) frequency distribution of the monthly rents of the homes being rented
in the Pope High School district.
Display the frequency distribution in the form of a histogram
using as the chart title Monthly Rents of Homes for Rent in Pope High School District
Monthly
Rent ($) # of homes
1000-1099
3
1100-1199
4
1200-1299
7
1300-1399
9
1400-1499
11
1500-1599
28
1600-1699
35
#
A…
50
0
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.