Expert answer:GBA327 St Leo University Science and Engineering J

  

Solved by verified expert:1.The Excel file Science and Engineering Jobs shows the number of jobs in thousands in the year 2000 and projections for 2010 from a government study. Use the Excel file to compute the projected increase from the 2000 baseline and also the percentage increase for each occupational category.2.The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year. Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions. 3.The Excel file President’s Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn during one month.6 Room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. Guests staying for seven days or more receive a 10% discount. Modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay4.A manager needs to identify some information from the Purchase Orders Excel file but has only the order number. Modify the Excel file to use the VLOOKUP function to find the item description and cost per order for the following order numbers: B3041, C8989, and A2367.
science_and_engineering_jobs.xlsx

store_and_regional_sales_database.xlsx

Don't use plagiarized sources. Get Your Custom Essay on
Expert answer:GBA327 St Leo University Science and Engineering J
Just from $10/Page
Order Essay

president_s_inn_guest_database.xlsx

purchase_orders.xlsx

Unformatted Attachment Preview

Total science and engineering jobs in thousands: 2000 and projected 2010
Occupation
Scientists
Life scientists
Mathematical/computer scientists
Computer specialists
Mathematical scientists
Physical scientists
Social scientists
Engineers
All occupations
2000
3.241
184
2.408
2.318
89
239
410
1.465
145.571
2010
5.301
218
4.308
4.213
95
283
492
1.603
167.754
Store and Regional Sales Database
ID Store No.
1
1
2
1
3
1
4
1
5
1
6
1
7
1
8
1
9
1
10
1
11
1
12
1
13
2
14
2
15
2
16
2
17
2
18
2
19
2
20
2
21
2
22
2
23
2
24
2
25
3
26
3
27
3
28
3
29
3
30
3
31
3
32
3
33
3
34
3
35
3
36
3
37
4
38
4
39
4
40
4
41
4
42
4
43
4
44
4
45
4
46
4
47
4
48
4
49
5
50
5
51
5
52
5
Sales Region
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
North
North
North
North
North
North
North
North
North
North
North
North
North
North
North
North
Item No.
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
Item Description
24″ Monitor
24″ Monitor
24″ Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24″ Monitor
24″ Monitor
24″ Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24″ Monitor
24″ Monitor
24″ Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24″ Monitor
24″ Monitor
24″ Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24″ Monitor
24″ Monitor
24″ Monitor
Wireless Keyboard
Unit Price Units Sold
$229.00
28
$229.00
30
$229.00
9
$19.95
30
$19.95
35
$19.95
39
$8.95
28
$8.95
3
$8.95
38
$849.95
25
$849.95
27
$849.95
33
$229.00
8
$229.00
8
$229.00
10
$19.95
8
$19.95
8
$19.95
8
$8.95
9
$8.95
9
$8.95
8
$849.95
18
$849.95
18
$849.95
20
$229.00
38
$229.00
30
$229.00
3
$19.95
30
$19.95
32
$19.95
33
$8.95
25
$8.95
5
$8.95
26
$849.95
28
$849.95
27
$849.95
29
$229.00
18
$229.00
20
$229.00
4
$19.95
12
$19.95
24
$19.95
36
$8.95
29
$8.95
11
$8.95
38
$849.95
21
$849.95
24
$849.95
30
$229.00
27
$229.00
25
$229.00
23
$19.95
80
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
5
5
5
5
5
5
5
5
6
6
6
6
6
6
6
6
6
6
6
6
7
7
7
7
7
7
7
7
7
7
7
7
8
8
8
8
8
8
8
8
8
8
8
8
North
North
North
North
North
North
North
North
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24″ Monitor
24″ Monitor
24″ Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24″ Monitor
24″ Monitor
24″ Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24″ Monitor
24″ Monitor
24″ Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
$19.95
$19.95
$8.95
$8.95
$8.95
$849.95
$849.95
$849.95
$229.00
$229.00
$229.00
$19.95
$19.95
$19.95
$8.95
$8.95
$8.95
$849.95
$849.95
$849.95
$229.00
$229.00
$229.00
$19.95
$19.95
$19.95
$8.95
$8.95
$8.95
$849.95
$849.95
$849.95
$229.00
$229.00
$229.00
$19.95
$19.95
$19.95
$8.95
$8.95
$8.95
$849.95
$849.95
$849.95
82
75
65
24
55
55
57
47
24
85
56
52
58
69
35
39
44
78
88
99
34
36
35
49
47
48
45
42
45
55
57
55
18
17
23
22
18
22
14
16
17
32
28
30
Week Ending
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
President’s Inn Guest Database
ID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Guest First Name
Barry
Michael
Kim
Edward
Thomas
Paul
Randall
Calvin
Homer
David
Buster
Julia
Samuel
Arthur
Darlene
Carlyle
Albert
Charlene
Everett
Gerald
Jamal
Louis
Nigel
Peter
Ronald
Trista
Valerie
Walter
Xavier
Zachary
Guest Last Name
Lloyd
Lunsford
Kyuong
Holt
Collins
Bodkin
Battenburg
Nowotney
Gonzalez
Sanchez
Whisler
Martines
Kim
Gottfried
Shore
Charleston
Goldstone
Tilson
Chad
Pittsfield
Smith
Paris
Stratford
Willington
Cartier
Leven
Snell
Acton
Trezza
Miller
Room
Hayes
Cleveland
Coolidge
Washington
Lincoln
Coolidge
Washington
Lincoln
Lincoln
Jefferson
Jackson
Reagan
Truman
Garfield
Arthur
Quincy Adams
Johnson
Van Buren
Madison
Roosevelt
Tyler
Jackson
Eisenhower
Grant
Jefferson
Eisenhower
Adams
Polk
McKinley
Washington
Room Type
Bay-window
Ocean
Bay-window
Ocean
Ocean
Bay-window
Ocean
Ocean
Ocean
Bay-window
Ocean
Bay-window
Side
Side
Ocean
Bay-window
Ocean
Bay-window
Ocean
Ocean
Bay-window
Ocean
Ocean
Ocean
Bay-window
Ocean
Bay-window
Side
Side
Ocean
Arrival Date Departure Date
12/1/2014
12/4/2014
12/1/2014
12/9/2014
12/4/2014
12/7/2014
12/1/2014
12/3/2014
12/9/2014
12/13/2014
12/1/2014
12/3/2014
12/4/2014
12/12/2014
12/2/2014
12/4/2014
12/5/2014
12/7/2014
12/5/2014
12/7/2014
12/5/2014
12/8/2014
12/10/2014
12/15/2014
12/20/2014
12/30/2014
12/13/2014
12/15/2014
12/24/2014
12/31/2014
12/3/2014
12/6/2014
12/5/2014
12/7/2014
12/5/2014
12/7/2014
12/10/2014
12/14/2014
12/5/2014
12/7/2014
12/20/2014
12/23/2014
12/10/2014
12/14/2014
12/14/2014
12/16/2014
12/19/2014
12/21/2014
12/24/2014
12/28/2014
12/17/2014
12/20/2014
12/3/2014
12/6/2014
12/24/2014
12/31/2014
12/14/2014
12/17/2014
12/13/2014
12/16/2014
No of Guests Daily Rate
2
$150.00
3
$112.50
1
$150.00
4
$325.00
2
$300.00
2
$150.00
2
$292.50
1
$300.00
5
$320.00
2
$175.00
2
$250.00
1
$150.00
3
$112.50
2
$125.00
5
$198.00
2
$150.00
3
$250.00
1
$150.00
2
$275.00
2
$275.00
2
$150.00
1
$250.00
2
$200.00
1
$200.00
4
$175.00
1
$200.00
1
$150.00
6
$148.50
2
$125.00
2
$325.00
Purchase Orders
Supplier
Hulkey Fasteners
Alum Sheeting
Fast-Tie Aerospace
Fast-Tie Aerospace
Steelpin Inc.
Fast-Tie Aerospace
Steelpin Inc.
Durrable Products
Fast-Tie Aerospace
Fast-Tie Aerospace
Steelpin Inc.
Hulkey Fasteners
Hulkey Fasteners
Steelpin Inc.
Steelpin Inc.
Alum Sheeting
Hulkey Fasteners
Steelpin Inc.
Steelpin Inc.
Hulkey Fasteners
Spacetime Technologies
Alum Sheeting
Durrable Products
Steelpin Inc.
Hulkey Fasteners
Hulkey Fasteners
Hulkey Fasteners
Hulkey Fasteners
Spacetime Technologies
Hulkey Fasteners
Fast-Tie Aerospace
Steelpin Inc.
Spacetime Technologies
Hulkey Fasteners
Spacetime Technologies
Spacetime Technologies
Pylon Accessories
Pylon Accessories
Spacetime Technologies
Spacetime Technologies
Durrable Products
Manley Valve
Fast-Tie Aerospace
Pylon Accessories
Durrable Products
Hulkey Fasteners
Pylon Accessories
Durrable Products
Spacetime Technologies
Order No.
Aug11001
Aug11002
Aug11003
Aug11004
Aug11005
Aug11006
Aug11007
Aug11008
Aug11009
Aug11010
Aug11011
Aug11012
Aug11013
Aug11014
Sep11001
Sep11002
Sep11003
Sep11004
Sep11005
Sep11006
Sep11007
Sep11008
Sep11009
Sep11010
Sep11011
Sep11012
Sep11013
Sep11014
Sep11015
Sep11016
Sep11017
Sep11018
Sep11019
Sep11020
Sep11021
Sep11022
Sep11023
Sep11024
Sep11025
Sep11026
Sep11027
Sep11028
Sep11029
Sep11030
Sep11031
Sep11032
Sep11033
Sep11034
Oct11001
Item No.
1122
1243
5462
5462
5319
5462
4312
7258
6321
5462
5319
3166
9966
5234
4312
5417
3166
5234
4312
1122
4111
1243
7258
5234
1122
5066
3166
1122
4111
3166
6321
5319
4111
5066
9752
4111
9764
9764
9752
4111
1369
6431
6321
9764
1369
1122
9764
1369
5125
Item Description
Airframe fasteners
Airframe fasteners
Shielded Cable/ft.
Shielded Cable/ft.
Shielded Cable/ft.
Shielded Cable/ft.
Bolt-nut package
Pressure Gauge
O-Ring
Shielded Cable/ft.
Shielded Cable/ft.
Electrical Connector
Hatch Decal
Electrical Connector
Bolt-nut package
Control Panel
Electrical Connector
Electrical Connector
Bolt-nut package
Airframe fasteners
Bolt-nut package
Airframe fasteners
Pressure Gauge
Electrical Connector
Airframe fasteners
Shielded Cable/ft.
Electrical Connector
Airframe fasteners
Bolt-nut package
Electrical Connector
O-Ring
Shielded Cable/ft.
Bolt-nut package
Shielded Cable/ft.
Gasket
Bolt-nut package
Gasket
Gasket
Gasket
Bolt-nut package
Airframe fasteners
O-Ring
O-Ring
Gasket
Airframe fasteners
Airframe fasteners
Gasket
Airframe fasteners
Shielded Cable/ft.
Item Cost Quantity
$
4.25
19,500
$
4.25
10,000
$
1.05
23,000
$
1.05
21,500
$
1.10
17,500
$
1.05
22,500
$
3.75
4,250
$ 90.00
100
$
2.45
1,300
$
1.05
22,500
$
1.10
18,100
$
1.25
5,600
$
0.75
500
$
1.65
4,500
$
3.75
4,200
$ 255.00
406
$
1.25
5,500
$
1.65
4,850
$
3.75
4,150
$
4.25
15,500
$
3.55
4,800
$
4.25
9,000
$ 90.00
120
$
1.65
4,750
$
4.25
12,500
$
0.95
25,000
$
1.25
5,650
$
4.25
15,000
$
3.55
4,585
$
1.25
5,425
$
2.45
1,200
$
1.10
16,500
$
3.55
4,200
$
0.95
17,500
$
4.05
1,500
$
3.55
4,250
$
3.75
1,980
$
3.75
1,750
$
4.05
1,550
$
3.55
4,200
$
4.20
15,000
$
2.85
1,300
$
2.45
2,500
$
3.75
1,850
$
4.20
14,000
$
4.25
14,500
$
3.75
1,800
$
4.20
10,000
$
1.15
15,000
Durrable Products
Manley Valve
Pylon Accessories
Fast-Tie Aerospace
Hulkey Fasteners
Durrable Products
Spacetime Technologies
Durrable Products
Spacetime Technologies
Durrable Products
Manley Valve
Durrable Products
Durrable Products
Spacetime Technologies
Alum Sheeting
Steelpin Inc.
Manley Valve
Manley Valve
Hulkey Fasteners
Fast-Tie Aerospace
Alum Sheeting
Durrable Products
Manley Valve
Steelpin Inc.
Alum Sheeting
Manley Valve
Alum Sheeting
Durrable Products
Fast-Tie Aerospace
Fast-Tie Aerospace
Hulkey Fasteners
Steelpin Inc.
Steelpin Inc.
Spacetime Technologies
Alum Sheeting
Manley Valve
Manley Valve
Fast-Tie Aerospace
Fast-Tie Aerospace
Steelpin Inc.
Manley Valve
Fast-Tie Aerospace
Fast-Tie Aerospace
Steelpin Inc.
Manley Valve
Oct11002
Oct11003
Oct11004
Oct11005
Oct11006
Oct11007
Oct11008
Oct11009
Oct11010
Oct11011
Oct11012
Oct11013
Oct11014
Oct11015
Oct11016
Oct11017
Oct11018
Oct11019
Oct11020
Oct11021
Oct11022
Oct11023
Oct11024
Oct11025
Oct11026
Oct11027
Oct11028
Oct11029
Oct11030
Oct11031
Oct11032
Oct11033
Oct11034
Oct11035
Oct11036
Nov11001
Nov11002
Nov11003
Nov11004
Nov11005
Nov11006
Nov11007
Nov11008
Nov11009
Nov11010
9399
6431
6433
5166
1122
9399
6489
9399
4111
4569
6431
9399
5454
6489
1243
8008
7258
8148
1122
6321
4224
5454
7258
8008
5417
7258
5634
5275
6321
5689
1122
5677
8008
6489
5634
9977
9955
5689
7268
5677
9967
7268
5689
5677
9955
Gasket
O-Ring
O-Ring
Electrical Connector
Airframe fasteners
Gasket
O-Ring
Gasket
Bolt-nut package
Bolt-nut package
O-Ring
Gasket
Control Panel
O-Ring
Airframe fasteners
Machined Valve
Pressure Gauge
Machined Valve
Airframe fasteners
O-Ring
Bolt-nut package
Control Panel
Pressure Gauge
Machined Valve
Control Panel
Pressure Gauge
Side Panel
Shielded Cable/ft.
O-Ring
Side Panel
Airframe fasteners
Side Panel
Machined Valve
O-Ring
Side Panel
Panel Decal
Door Decal
Side Panel
Pressure Gauge
Side Panel
Hatch Decal
Pressure Gauge
Side Panel
Side Panel
Door Decal
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
3.65
2.85
2.95
1.25
4.25
3.65
3.00
3.65
3.55
3.50
2.85
3.65
220.00
3.00
4.25
645.00
100.50
655.50
4.25
2.45
3.95
220.00
100.50
645.00
255.00
100.50
185.00
1.00
2.45
175.00
4.25
195.00
645.00
3.00
185.00
1.00
0.55
175.00
95.00
195.00
0.85
95.00
175.00
195.00
0.55
1,250
1,350
1,500
5,650
18,000
1,450
1,100
1,985
4,600
3,900
1,250
1,470
550
900
10,500
100
90
125
17,000
1,250
4,500
500
100
150
500
95
150
25,000
1,500
155
17,500
130
120
1,050
140
525
150
150
110
120
550
105
175
110
125
Cost per order A/P Terms (Months)
$
82,875.00
30
$
42,500.00
30
$
24,150.00
30
$
22,575.00
30
$
19,250.00
30
$
23,625.00
30
$
15,937.50
30
$
9,000.00
45
$
3,185.00
30
$
23,625.00
30
$
19,910.00
30
$
7,000.00
30
$
375.00
30
$
7,425.00
30
$
15,750.00
30
$ 103,530.00
30
$
6,875.00
30
$
8,002.50
30
$
15,562.50
30
$
65,875.00
30
$
17,040.00
25
$
38,250.00
30
$
10,800.00
45
$
7,837.50
30
$
53,125.00
30
$
23,750.00
30
$
7,062.50
30
$
63,750.00
30
$
16,276.75
25
$
6,781.25
30
$
2,940.00
30
$
18,150.00
30
$
14,910.00
25
$
16,625.00
30
$
6,075.00
25
$
15,087.50
25
$
7,425.00
15
$
6,562.50
15
$
6,277.50
25
$
14,910.00
25
$
63,000.00
45
$
3,705.00
30
$
6,125.00
30
$
6,937.50
15
$
58,800.00
45
$
61,625.00
30
$
6,750.00
15
$
42,000.00
45
$
17,250.00
25
Order Date
08/05/11
08/08/11
08/10/11
08/15/11
08/20/11
08/20/11
08/25/11
08/25/11
08/25/11
08/25/11
08/25/11
08/25/11
08/25/11
08/28/11
09/01/11
09/01/11
09/01/11
09/02/11
09/03/11
09/04/11
09/05/11
09/05/11
09/05/11
09/05/11
09/05/11
09/05/11
09/05/11
09/08/11
09/10/11
09/10/11
09/12/11
09/15/11
09/15/11
09/15/11
09/20/11
09/20/11
09/20/11
09/20/11
09/25/11
09/25/11
09/25/11
09/25/11
09/25/11
09/25/11
09/27/11
09/28/11
09/28/11
09/29/11
10/01/11
Arrival Date
08/13/11
08/14/11
08/15/11
08/22/11
08/31/11
08/26/11
09/01/11
08/28/11
09/04/11
09/02/11
09/05/11
08/29/11
08/31/11
09/05/11
09/10/11
09/10/11
09/06/11
09/11/11
09/11/11
09/12/11
09/20/11
09/12/11
09/09/11
09/13/11
09/11/11
09/12/11
09/10/11
09/15/11
09/30/11
09/15/11
09/23/11
10/05/11
10/15/11
09/22/11
09/25/11
10/10/11
09/29/11
09/25/11
10/05/11
10/25/11
09/30/11
10/01/11
10/04/11
10/05/11
10/03/11
10/03/11
10/05/11
10/04/11
10/15/11
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
4,562.50
3,847.50
4,425.00
7,062.50
76,500.00
5,292.50
3,300.00
7,245.25
16,330.00
13,650.00
3,562.50
5,365.50
121,000.00
2,700.00
44,625.00
64,500.00
9,045.00
81,937.50
72,250.00
3,062.50
17,775.00
110,000.00
10,050.00
96,750.00
127,500.00
9,547.50
27,750.00
25,000.00
3,675.00
27,125.00
74,375.00
25,350.00
77,400.00
3,150.00
25,900.00
525.00
82.50
26,250.00
10,450.00
23,400.00
467.50
9,975.00
30,625.00
21,450.00
68.75
45
30
15
30
30
45
25
45
25
45
30
45
45
25
30
30
30
30
30
30
30
45
30
30
30
30
30
45
30
30
30
30
30
25
30
30
30
30
30
30
30
30
30
30
30
10/01/11
10/01/11
10/01/11
10/01/11
10/01/11
10/03/11
10/05/11
10/05/11
10/05/11
10/05/11
10/05/11
10/07/11
10/09/11
10/10/11
10/10/11
10/10/11
10/10/11
10/10/11
10/11/11
10/12/11
10/15/11
10/15/11
10/15/11
10/15/11
10/20/11
10/20/11
10/25/11
10/25/11
10/25/11
10/25/11
10/25/11
10/28/11
10/28/11
10/29/11
10/29/11
11/01/11
11/01/11
11/01/11
11/01/11
11/02/11
11/05/11
11/05/11
11/05/11
11/05/11
11/05/11
10/06/11
10/07/11
10/10/11
10/06/11
10/08/11
10/08/11
10/10/11
10/11/11
10/19/11
10/10/11
10/10/11
10/12/11
10/14/11
10/18/11
10/17/11
10/21/11
10/17/11
10/17/11
10/19/11
10/21/11
10/20/11
10/20/11
10/24/11
10/26/11
10/27/11
10/29/11
11/03/11
10/30/11
11/02/11
11/03/11
11/03/11
11/07/11
11/04/11
11/10/11
11/04/11
11/07/11
11/06/11
11/09/11
11/12/11
11/13/11
11/11/11
11/16/11
11/15/11
11/17/11
11/10/11
Observation
x1
x2
x3
x4
x5
x6
x7
x8
x9
x10
x11
x12
x13
x14
x15
x16
x17
x18
x19
x20
x21
x22
x23
x24
x25
x26
x27
x28
x29
x30
x31
x32
x33
x34
x35
x36
x37
x38
x39
x40
x41
x42
x43
x44
x45
x46
x47
x48
x49
x50
x51
x52
x53
x54
Cost per order
$2,700.00
$19,250.00
$15,937.50
$18,150.00
$23,400.00
$15,750.00
$17,775.00
$127,500.00
$42,500.00
$103,530.00
$6,075.00
$3,300.00
$6,277.50
$17,250.00
$3,150.00
$14,910.00
$4,562.50
$5,292.50
$121,000.00
$5,365.50
$7,245.25
$15,087.50
$14,910.00
$16,330.00
$110,000.00
$13,650.00
$63,000.00
$3,562.50
$9,547.50
$525.00
$3,847.50
$17,040.00
$16,276.75
$3,705.00
$10,050.00
$467.50
$82.50
$4,425.00
$38,250.00
$15,562.50
$27,750.00
$25,900.00
$44,625.00
$7,425.00
$9,000.00
$10,800.00
$58,800.00
$25,000.00
$42,000.00
$3,185.00
$2,940.00
$6,125.00
$3,062.50
$3,675.00
x55
x56
x57
x58
x59
x60
x61
x62
x63
x64
x65
x66
x67
x68
x69
x70
x71
x72
x73
x74
x75
x76
x77
x78
x79
x80
x81
x82
x83
x84
x85
x86
x87
x88
x89
x90
x91
x92
x93
x94
Sum of cost/order
Number of observations
$26,250.00
$10,450.00
$9,975.00
$23,625.00
$30,625.00
$22,575.00
$24,150.00
$21,450.00
$7,425.00
$7,837.50
$8,002.50
$96,750.00
$64,500.00
$7,062.50
$27,125.00
$23,625.00
$25,350.00
$77,400.00
$19,910.00
$68.75
$82,875.00
$7,000.00
$6,937.50
$9,045.00
$65,875.00
$6,875.00
$76,500.00
$81,937.50
$53,125.00
$63,750.00
$61,625.00
$23,750.00
$7,062.50
$6,781.25
$375.00
$6,750.00
$16,625.00
$74,375.00
$72,250.00
$6,562.50
$2,471,760.00
94
Mean cost/order
$26,295.32
Excel AVERAGE function
$26,295.32
Rank
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
Cost per order
$68.75
$82.50
$375.00
$467.50
$525.00
$2,700.00
$2,940.00
$3,062.50
$3,150.00
$3,185.00
$3,300.00
$3,562.50
$3,675.00
$3,705.00
$3,847.50
$4,425.00
$4,562.50
$5,292.50
$5,365.50
$6,075.00
$6,125.00
$6,277.50
$6,562.50
$6,750.00
$6,781.25
$6,875.00
$6,937.50
$7,000.00
$7,062.50
$7,062.50
$7,245.25
$7,425.00
$7,425.00
$7,837.50
$8,002.50
$9,000.00
$9,045.00
$9,547.50
$9,975.00
$10,050.00
$10,450.00
$10,800.00
$13,650.00
$14,910.00
$14,910.00
$15,087.50
$15,562.50
$15,562.50
$15,750.00
$15,750.00
$15,937.50 Average $15,656.25
$16,276.75
$16,330.00
$16,625.00
$17,040.00
$17,250.00
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
$17,775.00
$18,150.00
$19,250.00
$19,910.00
$21,450.00
$22,575.00
$23,400.00
$23,625.00
$23,625.00
$23,750.00
$24,150.00
$25,000.00
$25,350.00
$25,900.00
$26,250.00
$27,125.00
$27,750.00
$30,625.00
$38,250.00
$42,000.00
$42,500.00
$44,625.00
$53,125.00
$58,800.00
$61,625.00
$63,000.00
$63,750.00
$64,500.00
$65,875.00
$72,250.00
$74,375.00
$76,500.00
$77,400.00
$81,937.50
$82,875.00
$96,750.00
$103,530.00
$110,000.00
$121,000.00
$127,500.00
Observation
x1
x2
x3
x4
x5
x6
x7
x8
x9
x10
x11
x12
x13
x14
x15
x16
x17
x18
x19
x20
x21
x22
x23
x24
x25
x26
x27
x28
x29
x30
x31
x32
x33
x34
x35
x36
x37
x38
x39
x40
x41
x42
x43
x44
x45
x46
x47
x48
x49
x50
x51
x52
x53
x54
Cost per order
$2,700.00
$19,250.00
$15,937.50
$18,150.00
$23,400.00
$15,750.00
$17,775.00
$127,500.00
$42,500.00
$103,530.00
$6,075.00
$3,300.00
$6,277.50
$17,250.00
$3,150.00
$14,910.00
$4,562.50
$5,292.50
$121,000.00
$5,365.50
$7,245.25
$15,087.50
$14,910.00
$16,330.00
$110,000.00
$13,650.00
$63,000.00
$3,562.50
$9,547.50
$525.00
$3,847.50
$17,040.00
$16,276.75
$3,705.00
$10,050.00
$467.50
$82.50
$4,425.00
$38,250.00
$15,562.50
$27,750.00
$25,900.00
$44,625.00
$7,425.00
$9,000.00
$10,800.00
$58,800.00
$25,000.00
$42,000.00
$3,185.00
$2,940.00
$6,125.00
$3,062.50
$3,675.00
(xi – mean)
-$23,595.32
-$7,045.32
-$10,357.82
-$8,145.32
-$2,895.32
-$10,545.32
-$8,520.32
$101,204.68
$16,204.68
$77,234.68
-$20,220.32
-$22,995.32
-$20,017.82
-$9,045.32
-$23,145.32
-$11,385.32
-$21,732.82
-$21,002.82
$94,704.68
-$20,929.82
-$19,050.07
-$11,207.82
-$11,385.32
-$9,965.32
$83,704.68
-$12,645.32
$36,704.68
-$22,732.82
-$16,747.82
-$25,770.32
-$22,447.82
-$9,255.32
-$10,018.57
-$22,590.32
-$16,245.32
-$25,827.82
-$26,212.82
-$21,870.32
$11,954.68
-$10,732.82
$1,454.68
-$395.32
$18,329.68
-$18,870.32
-$17,295.32
-$15,495.32
$32,504.68
-$1,295.32
$15,704.68
-$23,110.32
-$23,355.32
-$20,170.32
-$23,232.82
-$22,620.32
(xi – mean)^2
$556,739,085.7 …
Purchase answer to see full
attachment

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYSHELP