MAT 101 National Louis University how to Analyzing Real-Life Sales Data Please take a look at the document. There is part One: Excel Data Analysis andPart

MAT 101 National Louis University how to Analyzing Real-Life Sales Data Please take a look at the document. There is part One: Excel Data Analysis andPart Two: Preparing a Powerpoint Presentation Milestone 1: Analyzing Real-Life Sales Data
As working professionals, we are required to record and analyze data in our occupations. Excel
is an indispensable tool to accomplish this requirement in most professional fields. You will be
exposed to real-life data retrieved from a toy company.
Look closely at each column heading. These headings indicate the type of data that is contained
within each column. You can access critical information, such as: customer name (these items
are bought wholesale from companies that are reselling them), sales, quantity ordered, and
location (territory, country, and state). You will use this information to analyze the overall
performance of this company and provide insight on its operations.
For the first part of this project you will analyze various components of the company and
provide visualizations of these performance indicators. For the second part of this project
you will create a PowerPoint to present to key stakeholders of the company.
Part One: Excel Data Analysis
For the first part of the project you will analyze a few key performance characteristics of this
toy company. This toy company does business internationally and it is interesting to look at
where the company does business. It is also interesting to observe the types of products that
are popular amongst each country. Consider how you might further develop the markets that
seem promising in your analysis. You are welcome to make more pivots than suggested below
if you would like to do a deeper analysis.
First click anywhere on the data and click on “Insert PivotTable”. Add a new PivotTable for each
part so you don’t lose your work. In total you will need six tabs—one for the data and five for
each of the five pivots/charts you will create.
Next please create the following PivotTables and insert PivotCharts as requested:
1) Find the total count of orders in each territory. Then add an additional row below the
territory to find the breakdown among each country.
2) Create a pivot that filters the country to only United States. Create a bar graph that
shows the distribution of sales across each state.
3) Create a pie-chart that shoes the percentage of orders for each productline item listed
in the data.
4) Create a line-graph that indicates the total sales per quarter over 2003, 2004, and
2005 (*hint add the orderdate column to your pivot and it will populate years and
quarters automatically).
5) Create a histogram that shows the distribution of sales across all orders.
Part Two: Preparing a Presentation
For the second part of this project please create a PowerPoint presentation that could be
presented to shareholders of this company. You are not required to record audio for this
presentation; however, if you’d like to do so you can use Panopto under the Other Tools tab
on the homepage of D2L.
Be sure to include the charts from Part 1 in your PowerPoint to emphasize your conclusions
and overall analysis of the data. Your presentation should include a written explanation or
summary for every graph.
First think about some of the important metrics that you could share. First look at your overall
customer base. What countries/territories generate the most sales? Which types of products
are most popular in different countries?
Second think about the sales of your products. What types of toys are most popular? Do certain
regions prefer a particular toy? What time of year do sales peak? Why do you think sales peak
at that time of year? Are sales increasing sufficiently by year?
Finally synthesize your findings. Provide an overall outlook of the company. What kinds of
marketing strategies do you think the company could use to increase its profit? Should the
company target any particular demographics? Based on average sales, should the company
provide additional incentives to encourage buying items in bulk?
You do not need to limit yourself to these questions. However, please create a presentation
that addresses the overall business strategy of the company and includes the charts that you
prepared in Part 1.
Attribution:
Originally Written by María Carina Roldán, Pentaho Community Member, BI consultant (Assert
Solutions), Argentina. This work is licensed under the Creative Commons AttributionNoncommercial-Share Alike 3.0 Unported License. Modified by Gus Segura June 2014.
ORDERNUMBER
QUANTITYORDERED
PRICEEACH ORDERLINENUMBER
SALES
10107
30
95.7
2
2871
10121
34
81.35
5
2765.9
10134
41
94.74
2 3884.34
10145
45
83.26
6
3746.7
10159
49
100
14 5205.27
10168
36
96.66
1 3479.76
10180
29
86.13
9 2497.77
10188
48
100
1 5512.32
10201
22
98.57
2 2168.54
10211
41
100
14 4708.44
10223
37
100
1 3965.66
10237
23
100
7 2333.12
10251
28
100
2 3188.64
10263
34
100
2 3676.76
10275
45
92.83
1 4177.35
10285
36
100
6 4099.68
10299
23
100
9 2597.39
10309
41
100
5 4394.38
10318
46
94.74
1 4358.04
10329
42
100
1 4396.14
10341
41
100
9 7737.93
10361
20
72.55
13
1451
10375
21
34.91
12
733.11
10388
42
76.36
4 3207.12
10403
24
100
7 2434.56
10417
66
100
2 7516.08
10103
26
100
11 5404.62
10112
29
100
1 7209.11
10126
38
100
11 7329.06
10140
37
100
11
7374.1
10150
45
100
8 10993.5
10163
21
100
1 4860.24
10174
34
100
4 8014.82
10183
23
100
8 5372.57
10194
42
100
11 7290.36
10206
47
100
6 9064.89
10215
35
100
3
6075.3
10228
29
100
2 6463.23
10245
34
100
9 6120.34
10258
32
100
6 7680.64
10270
21
100
9 4905.39
10280
34
100
2 8014.82
10291
37
100
11 7136.19
10304
47
100
6 10172.7
10312
48
100
3 11623.7
10322
40
100
1
6000.4
ORDERDATESTATUS
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Disputed
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
######## Shipped
QTR_ID
1
2
3
3
4
4
4
4
4
1
1
2
2
2
3
3
3
4
4
4
4
4
1
1
2
2
1
1
2
3
3
4
4
4
4
4
1
1
2
2
3
3
3
4
4
4
MONTH_ID
2
5
7
8
10
10
11
11
12
1
2
4
5
6
7
8
9
10
11
11
11
12
2
3
4
5
1
3
5
7
9
10
11
11
11
12
1
3
5
6
7
8
9
10
10
11
10333
10347
10357
10369
10381
10391
10411
10424
10107
10120
10134
10145
10159
10168
10180
10188
10201
10210
10223
10236
10251
10263
10275
10285
10298
10308
10318
10329
10339
10361
10374
10388
10402
10417
10107
10120
10134
10145
10159
10168
10180
10188
10201
10210
10223
10237
10251
26
30
32
41
36
24
23
50
39
29
27
37
37
27
42
38
24
23
47
22
44
40
22
47
39
34
45
20
40
26
39
50
45
45
27
46
31
33
22
20
41
45
49
34
49
39
43
100
100
100
100
100
100
100
100
99.91
96.34
100
100
100
100
100
96.34
100
100
100
100
100
100
100
100
96.34
100
100
100
68.92
51.15
100
44.51
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
3
1
10
2
3
4
9
6
5
3
5
9
17
4
12
4
5
2
4
1
5
5
4
9
1
2
4
2
4
8
5
5
1
5
4
2
4
8
16
3
11
3
4
1
3
9
4
3003
3944.7
5691.84
4514.92
8254.8
2416.56
4140.23
12001
3896.49
2793.86
3307.77
5192.95
5016.83
3660.93
4695.6
3660.92
3025.92
3009.09
5422.39
2852.08
5756.52
4472
2904.44
6484.59
3757.26
4043.96
5566.5
3176
2756.8
1329.9
5288.01
2225.5
5833.8
5887.35
6065.55
9264.86
7023.98
5176.38
4132.7
4183
8892.9
8714.7
8065.89
6123.4
9774.03
7023.9
7078.23
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
In Process
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Disputed
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
4
4
4
1
1
1
2
2
1
2
3
3
4
4
4
4
4
1
1
2
2
2
3
3
3
4
4
4
4
4
1
1
2
2
1
2
3
3
4
4
4
4
4
1
1
2
2
11
11
12
1
2
3
5
5
2
4
7
8
10
10
11
11
12
1
2
4
5
6
7
8
9
10
11
11
11
12
2
3
4
5
2
4
7
8
10
10
11
11
12
1
2
4
5
10263
10275
10285
10299
10308
10318
10329
10339
10362
10374
10388
10403
10417
10105
10119
10129
10143
10155
10167
10178
10186
10197
10209
10222
10248
10261
10273
10283
10295
10307
10316
10325
10337
10350
10359
10373
10384
10395
10400
10414
10103
10114
10126
10140
10150
10164
10175
41
36
27
29
20
37
26
39
22
22
21
66
56
50
46
33
49
32
44
24
26
45
39
49
20
27
30
25
24
22
33
47
25
26
48
39
34
32
64
19
42
31
22
26
20
21
33
100
100
100
100
100
100
100
76.67
100
100
86.77
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
64.93
48.05
75.47
54.68
100
100
100
100
100
100
100
100
100
100
100
100
4
3
8
11
1
3
3
3
4
1
7
9
4
2
11
2
15
13
9
12
9
6
8
12
3
1
4
6
1
9
17
6
8
5
6
3
4
2
9
3
4
8
4
4
1
2
9
8336.94
6901.92
5438.07
6683.34
4570.4
7667.14
5868.2
2990.13
3664.1
3834.38
1822.17
11886.6
9218.16
7208
5004.8
4398.24
5597.76
4526.08
5924.16
3492.48
3854.24
5324.4
5197.92
5997.6
2910.4
3378.24
3508.8
2992
3427.2
2692.8
4128.96
3051.71
1201.25
1962.22
2624.64
4046.25
4846.7
3370.56
9661.44
2764.88
5398.26
4305.28
3347.74
3188.12
3191.2
3536.82
5362.83
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Disputed
Shipped
Shipped
Shipped
Shipped
Shipped
Cancelled
Shipped
Shipped
Shipped
Shipped
Shipped
Cancelled
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
On Hold
Shipped
Shipped
Shipped
Shipped
Shipped
Resolved
Shipped
2
3
3
3
4
4
4
4
1
1
1
2
2
1
2
2
3
4
4
4
4
4
1
1
2
2
3
3
3
4
4
4
4
4
4
1
1
1
2
2
1
2
2
3
3
4
4
6
7
8
9
10
11
11
11
1
2
3
4
5
2
4
6
8
10
10
11
11
11
1
2
5
6
7
8
9
10
11
11
11
12
12
1
2
3
4
5
1
4
5
7
9
10
11
10183
10194
10207
10217
10229
10245
10259
10270
10281
10291
10305
10313
10322
10334
10347
10357
10370
10381
10391
10411
10425
10108
10122
10135
10147
10159
10169
10181
10191
10203
10211
10225
10238
10253
10266
10276
10287
10300
10310
10320
10329
10341
10363
10375
10389
10419
10105
28
26
31
48
50
28
26
32
44
30
38
40
46
26
27
43
35
37
37
27
38
33
42
42
48
41
30
27
21
20
41
27
28
24
44
50
21
33
33
31
41
45
33
45
26
12
41
100
100
100
100
100
100
100
100
100
100
100
100
61.99
100
100
100
65.63
100
46.9
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
71.47
79.65
85.39
76
99.04
100
100
1
4
15
4
9
2
12
2
9
4
13
7
8
2
2
9
4
6
7
2
12
6
10
7
7
2
2
14
3
8
2
9
3
13
14
3
12
5
10
3
5
2
3
7
4
13
15
3433.36
4263.74
4076.19
7020.48
6426.5
4591.72
4033.38
4302.08
7020.64
3855.9
6680.78
6678
2851.54
3188.12
4428
5780.92
2297.05
6231.54
1735.3
4427.73
5894.94
5265.15
7599.9
8008.56
9245.76
8296.35
5019.9
5411.07
3840.9
3930.4
7498.9
4517.91
5774.72
3922.56
9160.36
9631
3432.24
5521.89
6934.62
6876.11
2930.27
3584.25
2817.87
3420
2575.04
1961.28
8690.36
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
On Hold
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
In Process
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Cancelled
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
4
4
4
1
1
2
2
3
3
3
4
4
4
4
4
4
1
1
1
2
2
1
2
3
3
4
4
4
4
4
1
1
2
2
3
3
3
4
4
4
4
4
1
1
1
2
1
11
11
12
2
3
5
6
7
8
9
10
10
11
11
11
12
1
2
3
5
5
3
5
7
9
10
11
11
11
12
1
2
4
6
7
8
8
10
10
11
11
11
1
2
3
5
2
10117
10127
10142
10153
10165
10176
10185
10196
10208
10220
10231
10247
10272
10282
10293
10306
10314
10325
10336
10348
10359
10371
10382
10395
10413
10103
10113
10126
10140
10150
10164
10174
10183
10194
10206
10216
10229
10245
10258
10270
10281
10291
10304
10313
10322
10333
10347
33
46
33
20
44
33
21
47
46
32
42
44
35
41
46
31
38
42
33
48
42
32
34
33
36
27
21
21
38
30
49
43
41
38
28
43
25
38
41
28
25
41
39
21
27
33
29
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
64
57.22
52.36
100
100
100
69.12
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
99.21
100
9
2
12
11
3
2
13
5
13
2
2
2
2
5
8
13
5
8
10
8
8
6
10
1
2
8
2
8
8
5
6
1
5
8
3
1
13
6
3
6
13
8
3
11
9
6
3
6034.38
11279.2
8023.29
4904
8594.52
7474.5
3883.74
8887.7
8602.92
7181.44
8378.58
10606.2
5818.4
7071.27
8411.56
6570.76
7975.44
2688
1888.26
2513.28
4764.48
3560.64
3823.64
2280.96
8677.8
3394.98
3415.44
2439.57
4829.8
4100.1
6563.06
6817.22
6163.94
4933.92
4056.36
5759.42
3451
5920.4
6668.24
4094.72
2938.5
6387.8
6396
2669.1
4784.13
3273.93
3586.43
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Resolved
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
2
2
3
3
4
4
4
4
1
1
1
2
3
3
3
4
4
4
4
4
4
1
1
1
2
1
1
2
3
3
4
4
4
4
4
1
1
2
2
3
3
3
4
4
4
4
4
4
6
8
9
10
11
11
11
1
2
3
5
7
8
9
10
10
11
11
11
12
1
2
3
5
1
3
5
7
9
10
11
11
11
12
2
3
5
6
7
8
9
10
10
11
11
11
10357
10370
10381
10391
10411
10424
10107
10121
10134
10145
10159
10169
10180
10189
10201
10211
10224
10237
10251
10263
10276
10285
10299
10309
10319
10329
10341
10362
10375
10388
10403
10417
10104
10117
10127
10142
10153
10165
10176
10185
10196
10208
10220
10230
10247
10272
10282
49
49
20
39
40
49
21
50
20
49
38
35
40
28
25
36
43
32
46
48
43
49
24
26
30
24
55
22
49
44
66
21
34
43
46
33
42
34
47
33
24
26
30
43
25
27
27
100
100
100
63.2
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
78.92
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
8
8
1
9
6
3
1
4
1
5
13
13
8
1
1
13
6
6
1
1
14
5
8
4
9
6
8
1
13
6
6
1
1
10
3
13
12
4
3
14
6
14
3
1
3
3
6
5960.36
8470.14
2952
2464.8
6232
7969.36
3036.6
8284
2711.2
8339.8
6238.84
4639.25
6747.6
4512.48
4029
4771.8
6087.94
4193.28
7552.28
6434.4
5181.5
6863.92
4157.04
4660.24
4111.8
3542.64
8118.55
3877.06
3867.08
5951.44
8648.64
3447.78
5958.5
5911.64
7366.44
4985.64
5393.64
4880.02
8378.69
4038.21
3807.12
3142.36
4713.6
7016.31
4381.25
4283.01
4364.82
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
Shipped
Shipped
Shipped
Shipped
Shipped
In Process
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Disputed
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
4
1
1
1
2
2
1
2
3
3
4
4
4
4
4
1
1
2
2
2
3
3
3
4
4
4
4
1
1
1
2
2
1
2
2
3
3
4
4
4
4
1
1
1
2
3
3
12
1
2
3
5
5
2
5
7
8
10
11
11
11
12
1
2
4
5
6
8
8
9
10
11
11
11
1
2
3
4
5
1
4
6
8
9
10
11
11
11
1
2
3
5
7
8
10293
10306
10314
10324
10336
10348
10358
10372
10382
10413
10108
10122
10135
10147
10160
10170
10181
10191
10203
10212
10225
10238
10253
10266
10276
10287
10300
10310
10320
10329
10341
10363
10376
10389
10419
10105
10117
10127
10142
10153
10165
10176
10185
10196
10208
10220
10231
24
34
46
27
33
47
49
40
37
47
45
37
48
31
46
47
28
40
20
39
25
29
22
22
47
45
29
24
35
46
44
34
35
25
10
29
39
42
46
49
27
50
43
38
20
27
49
100
100
100
54.33
100
100
55.34
100
100
100
100
99.82
100
100
100
100
100
100
100
100
99.82
100
100
100
100
100
100
100
100
83.63
95.93
96.73
100
72.38
100
100
100
100
100
100
100
100
100
100
100
100
100
9
14
6
1
11
4
5
4
11
3
4
8
5
5
6
4
12
1
6
16
7
1
11
12
1
10
3
8
1
13
1
4
1
6
11
14
8
1
11
10
2
1
12
4
12
1
1
4242.24
4982.7
6393.54
1466.91
4059.33
4801.52
2711.66
5862
4071.85
8236.75
6130.35
3693.34
6031.68
3494.94
5294.14
5464.69
2860.76
5590
2254.8
4946.76
2495.5
3167.38
2402.84
2454.54
5464.69
4756.5
3984.6
3100.32
4850.3
3846.98
4220.92
3288.82
3987.2
1809.5
1092.2
4566.05
5938.14
8138.76
9470.94
7036.89
5559.03
7872.5
7886.2
7232.16
3114.4
5045.22
6952.12
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Cancelled
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
Shipped
3
4
4
4
4
4
4
1
1
2
1
2
3
3
4
4
4
4
4
1
1
2
2
3
3
3
4
4
4
4
4
1
1
1
2
1
2
2
3
3
4
4
4
4
1
1
1
9
10
10
11
11
11
12
1
2
5
3
5
7
9
10
11
11
11
12
1
2
4
6
7
8
8
10
10
11
11
11
1
2
3
5
2
4
6
8
9
10
11
11
11
1
2
3
10247
10272
10282
10293
10306
10314
10325
10336
10349
10359
10372
10382
10396
10413
10108
10122
10135
10147
10159
10169
10181
10191
10203
10211
10225
10238
10253
10266
10276
10287
10300
10310
10320
10329
10341
10363
10377
10389
10419
10104
10115
10127
10141
10151
10165
10175
10184
27
39
24
45
20
36
24
49
26
49
34
34
33
22
39
32
24
21
24
36
20
30
44
28
37
20
25
35
38
41
22
49
38
33
36
34
24
36
34
41
46
24
21
24
48
26
37
100
100
100
100
100
100
100
63.38
100
62.09
100
95.35
100
100
89.38
63.84
75.01
63.84
73.42
63.84
81.4
64.64
82.99
92.57
77.41
74.21
90.17
76.61
83.79
69.43
76.61
81.4
73.42
100
93.56
81.62
67.83
70.26
90.17
100
100
100
100
100
100
100
100
1
1
4
7
12
4
1
1
10
5
1
12
3
1
7
11
8
8
3
3
15
4
9
3
10
4
14
15
4
13
6
11
4
14
10
5
5
7
14
9
5
11
5
3
12
1
6
4157.73
7962.24
3778.8
8253
3633.4
6913.8
2583.6
3105.62
4408.56
3042.41
5941.5
3241.9
6109.29
3387.78
3485.82…
Purchase answer to see full
attachment