Region Country

Australia and Oceania Tuvalu

Central America and the Caribbean Grenada
Europe Russia
Sub-Saharan Africa Sao Tome and Principe
Sub-Saharan Africa Rwanda
Australia and Oceania Solomon Islands
Sub-Saharan Africa Angola
Sub-Saharan Africa Burkina Faso
Sub-Saharan Africa Republic of the Congo
Sub-Saharan Africa Senegal
Asia Kyrgyzstan
Sub-Saharan Africa Cape Verde
Asia Bangladesh
Central America and the Caribbean Honduras
Asia Mongolia
Europe Bulgaria
Asia Sri Lanka
Sub-Saharan Africa Cameroon
Asia Turkmenistan
Australia and Oceania East Timor
Europe Norway
Europe Portugal
Central America and the Caribbean Honduras
Australia and Oceania New Zealand
Europe Moldova
Europe France
Australia and Oceania Kiribati
Sub-Saharan Africa Mali
Europe Norway
Sub-Saharan Africa The Gambia
Europe Switzerland
Sub-Saharan Africa South Sudan
Australia and Oceania Australia
Asia Myanmar
Sub-Saharan Africa Djibouti
Central America and the Caribbean Costa Rica
Middle East and North Africa Syria
Sub-Saharan Africa The Gambia
Asia Brunei
Europe Bulgaria
Sub-Saharan Africa Niger
Middle East and North Africa Azerbaijan
Sub-Saharan Africa The Gambia
Europe Slovakia
Asia Myanmar
Sub-Saharan Africa Comoros
Europe Iceland
Europe Switzerland
Europe Macedonia
Sub-Saharan Africa Mauritania
Europe Albania
Sub-Saharan Africa Lesotho
Middle East and North Africa Saudi Arabia
Sub-Saharan Africa Sierra Leone
Sub-Saharan Africa Sao Tome and Principe
Sub-Saharan Africa Cote d'Ivoire
Australia and Oceania Fiji
Europe Austria
Europe United Kingdom
Sub-Saharan Africa Djibouti
Australia and Oceania Australia
Europe San Marino
Sub-Saharan Africa Cameroon
Middle East and North Africa Libya
Central America and the Caribbean Haiti
Sub-Saharan Africa Rwanda
Sub-Saharan Africa Gabon
Central America and the Caribbean Belize
Europe Lithuania
Sub-Saharan Africa Madagascar
Asia Turkmenistan
Middle East and North Africa Libya
Sub-Saharan Africa Democratic Republic of th
Sub-Saharan Africa Djibouti
Middle East and North Africa Pakistan
North America Mexico
Australia and Oceania Federated States of Micron
Asia Laos
Europe Monaco
Australia and Oceania Samoa
Europe Spain
Middle East and North Africa Lebanon
Middle East and North Africa Iran
Sub-Saharan Africa Zambia
Sub-Saharan Africa Kenya
North America Mexico
Sub-Saharan Africa Sao Tome and Principe
Sub-Saharan Africa The Gambia
Middle East and North Africa Kuwait
Europe Slovenia
Sub-Saharan Africa Sierra Leone
Australia and Oceania Australia
Middle East and North Africa Azerbaijan
Europe Romania
Central America and the Caribbean Nicaragua
Sub-Saharan Africa Mali
Asia Malaysia
Sub-Saharan Africa Sierra Leone
North America Mexico
Sub-Saharan Africa Mozambique

Excel-only hypothesis test on mean of Unit Sold (1-tailed)

Ho: The mean of Unit Sold variable < or =
Ha: Alternative type >
Sample size
Sample mean
Sample Std Dev
t-value test statistic
Degrees of freedom (n-1)
Significant at 5% level according to t-value t 0.05, 99
Significant at 10% level according to t-value t 0.1, 99
p-value of test
Fidings
Ho testing at 5% level of significant according to t-value
Ha testing at 10% level of significant according to t-value

Ho testing at 5% level of significant according to p-value

Ha testing at 10% level of significant according to p-value

Mean
Standard deviation

Probability calculation
 Range Probability
Less than 1100 16%
More than 1100 84%
Between 700 and 1100 16%
Less than 300 0%
More than 300 100%

Percentiles Score
65th (result no more than) 1169.27
Item Type
Baby Food
Cereal
Office Supplies
Fruits
Office Supplies
Baby Food
Household
Vegetables
Personal Care
Cereal
Vegetables
Clothes
Clothes
Household
Personal Care
Clothes
Cosmetics
Beverages
Household
Meat
Baby Food
Baby Food
Snacks
Fruits
Personal Care
Cosmetics
Fruits
Fruits
Beverages
Household
Cosmetics
Personal Care
Office Supplies
Household
Snacks
Personal Care
Fruits
Meat
Office Supplies
Office Supplies
Personal Care
Cosmetics
Cereal
Vegetables
Clothes
Cereal
Cosmetics
Personal Care
Clothes
Office Supplies
Clothes
Fruits
Cereal
Office Supplies
Fruits
Clothes
Clothes
Cosmetics
Household
Cosmetics
Cereal
Baby Food
Office Supplies
Clothes
Cosmetics
Cosmetics
Personal Care
Clothes
Office Supplies
Clothes
Office Supplies
Fruits
Beverages
Cereal
Cosmetics
Household
Beverages
Vegetables
Baby Food
Cosmetics
Household
Clothes
Cosmetics
Snacks
Vegetables
Personal Care
Beverages
Baby Food
Fruits
Beverages
Office Supplies
Beverages
Office Supplies
Cosmetics
Beverages
Clothes
Fruits
Vegetables
Personal Care
Household

5000
5000
100
5128.71
2794.48
0.46
99
-1.66
-1.29
0.68

Accept
Accept

Accpet
Accpet

1150
50
 How to calculate?
*=[Link](1100,C126,C127,TRUE)
*=[Link](1100,C126,C127,TRUE)
*=[Link](1100,C126,C127,TRUE)-[Link](700,C126,C127,TRUE)
*=[Link](300,C126,C127,TRUE)
*=[Link](300,C126,C127,TRUE)

*=[Link](0.65,C126,C127)
Sales Channel Order Priority Order Date Order ID
Offline H 5/28/2010 669165933
Online C 8/22/2012 963881480
Offline L 5/2/2014 341417157
Online C 6/20/2014 514321792
Offline L 2/1/2013 115456712
Online C 2/4/2015 547995746
Offline M 4/23/2011 135425221
Online H 7/17/2012 871543967
Offline M 7/14/2015 770463311
Online H 4/18/2014 616607081
Online H 6/24/2011 814711606
Offline H 8/2/2014 939825713
Online L 1/13/2017 187310731
Offline H 2/8/2017 522840487
Offline C 2/19/2014 832401311
Online M 4/23/2012 972292029
Offline M 11/19/2016 419123971
Offline C 4/1/2015 519820964
Offline L 12/30/2010 441619336
Online L 7/31/2012 322067916
Online L 5/14/2014 819028031
Online H 7/31/2015 860673511
Online L 6/30/2016 795490682
Online H 9/8/2014 142278373
Online L 5/7/2016 740147912
Online H 5/22/2017 898523128
Online M 10/13/2014 347140347
Online L 5/7/2010 686048400
Offline C 7/18/2014 435608613
Offline L 5/26/2012 886494815
Offline M 9/17/2012 249693334
Offline C 12/29/2013 406502997
Online C 10/27/2015 158535134
Offline H 1/16/2015 177713572
Online M 2/25/2017 756274640
Offline L 5/8/2017 456767165
Online L 11/22/2011 162052476
Online M 1/14/2017 825304400
Online L 4/1/2012 320009267
Online M 2/16/2012 189965903
Online H 3/11/2017 699285638
Online M 2/6/2010 382392299
Offline H 6/7/2012 994022214
Online H 10/6/2012 759224212
Online H 11/14/2015 223359620
Offline H 3/29/2016 902102267
Online C 12/31/2016 331438481
Online M 12/23/2010 617667090
Offline C 10/14/2014 787399423
Offline C 1/11/2012 837559306
Online C 2/2/2010 385383069
Online L 8/18/2013 918419539
Online M 3/25/2013 844530045
Offline M 11/26/2011 441888415
Offline H 9/17/2013 508980977
Online C 6/8/2012 114606559
Offline C 6/30/2010 647876489
Offline H 2/23/2015 868214595
Online L 1/5/2012 955357205
Offline H 4/7/2014 259353148
Offline H 6/9/2013 450563752
Online L 6/26/2013 569662845
Online M 11/7/2011 177636754
Offline H 10/30/2010 705784308
Offline H 10/13/2013 505716836
Offline H 10/11/2013 699358165
Offline L 7/8/2012 228944623
Offline M 7/25/2016 807025039
Offline H 10/24/2010 166460740
Offline L 4/25/2015 610425555
Online M 4/23/2013 462405812
Online L 8/14/2015 816200339
Online C 5/26/2011 585920464
Online H 5/20/2017 555990016
Offline L 7/5/2013 231145322
Offline C 11/6/2014 986435210
Online C 10/28/2014 217221009
Offline C 9/15/2011 789176547
Offline H 5/29/2012 688288152
Online H 7/20/2013 670854651
Offline L 10/21/2012 213487374
Online L 9/18/2012 663110148
Online H 11/15/2016 286959302
Online L 1/4/2011 122583663
Online L 3/18/2012 827844560
Offline L 2/17/2012 430915820
Offline C 1/16/2011 180283772
Offline M 2/3/2014 494747245
Online M 4/30/2012 513417565
Offline C 10/23/2016 345718562
Offline H 12/6/2016 621386563
Offline H 7/7/2014 240470397
Online M 6/13/2012 423331391
Online H 11/26/2010 660643374
Offline C 2/8/2011 963392674
Online M 7/26/2011 512878119
Offline L 11/11/2011 810711038
Offline C 6/1/2016 728815257
Offline M 7/30/2015 559427106
Offline L 2/10/2012 665095412

How to calculate?

*=AVERAGE(I2:I101)
*=STDEV.S(I2:I101)
*=(C108-C105)*SQRT(C107)/C109
*=C107-1
*=[Link](0.05,C111)
*=[Link](0.1, C111)
*=[Link](ABS(C110),C111,1)

*=IF(ABS(C110)>=ABS(C112),"Reject","Accept")
*=IF(ABS(C110)>=ABS(C113),"Reject","Accept")

*=IF($C$114<=0.05,"Reject","Accpet")
*=IF($C$114<=0.1,"Reject","Accpet")
Ship Date Units Sold Unit Price Unit Cost Total Revenue Total Cost
6/27/2010 $ 9,925.00 $ 255.28 $ 159.42 $ 2,533,654.00 $ 1,582,243.50
9/15/2012 $ 2,804.00 $ 205.70 $ 117.11 $ 576,782.80 $ 328,376.44
5/8/2014 $ 1,779.00 $ 651.21 $ 524.96 $ 1,158,502.59 $ 933,903.84
7/5/2014 $ 8,102.00 $ 9.33 $ 6.92 $ 75,591.66 $ 56,065.84
2/6/2013 $ 5,062.00 $ 651.21 $ 524.96 $ 3,296,425.02 $ 2,657,347.52
2/21/2015 $ 2,974.00 $ 255.28 $ 159.42 $ 759,202.72 $ 474,115.08
4/27/2011 $ 4,187.00 $ 668.27 $ 502.54 $ 2,798,046.49 $ 2,104,134.98
7/27/2012 $ 8,082.00 $ 154.06 $ 90.93 $ 1,245,112.92 $ 734,896.26
8/25/2015 $ 6,070.00 $ 81.73 $ 56.67 $ 496,101.10 $ 343,986.90
5/30/2014 $ 6,593.00 $ 205.70 $ 117.11 $ 1,356,180.10 $ 772,106.23
7/12/2011 $ 124.00 $ 154.06 $ 90.93 $ 19,103.44 $ 11,275.32
8/19/2014 $ 4,168.00 $ 109.28 $ 35.84 $ 455,479.04 $ 149,381.12
3/1/2017 $ 8,263.00 $ 109.28 $ 35.84 $ 902,980.64 $ 296,145.92
2/13/2017 $ 8,974.00 $ 668.27 $ 502.54 $ 5,997,054.98 $ 4,509,793.96
2/23/2014 $ 4,901.00 $ 81.73 $ 56.67 $ 400,558.73 $ 277,739.67
6/3/2012 $ 1,673.00 $ 109.28 $ 35.84 $ 182,825.44 $ 59,960.32
12/18/2016 $ 6,952.00 $ 437.20 $ 263.33 $ 3,039,414.40 $ 1,830,670.16
4/18/2015 $ 5,430.00 $ 47.45 $ 31.79 $ 257,653.50 $ 172,619.70
1/20/2011 $ 3,830.00 $ 668.27 $ 502.54 $ 2,559,474.10 $ 1,924,728.20
9/11/2012 $ 5,908.00 $ 421.89 $ 364.69 $ 2,492,526.12 $ 2,154,588.52
6/28/2014 $ 7,450.00 $ 255.28 $ 159.42 $ 1,901,836.00 $ 1,187,679.00
9/3/2015 $ 1,273.00 $ 255.28 $ 159.42 $ 324,971.44 $ 202,941.66
7/26/2016 $ 2,225.00 $ 152.58 $ 97.44 $ 339,490.50 $ 216,804.00
10/4/2014 $ 2,187.00 $ 9.33 $ 6.92 $ 20,404.71 $ 15,134.04
5/10/2016 $ 5,070.00 $ 81.73 $ 56.67 $ 414,371.10 $ 287,316.90
6/5/2017 $ 1,815.00 $ 437.20 $ 263.33 $ 793,518.00 $ 477,943.95
11/10/2014 $ 5,398.00 $ 9.33 $ 6.92 $ 50,363.34 $ 37,354.16
5/10/2010 $ 5,822.00 $ 9.33 $ 6.92 $ 54,319.26 $ 40,288.24
7/30/2014 $ 5,124.00 $ 47.45 $ 31.79 $ 243,133.80 $ 162,891.96
6/9/2012 $ 2,370.00 $ 668.27 $ 502.54 $ 1,583,799.90 $ 1,191,019.80
10/20/2012 $ 8,661.00 $ 437.20 $ 263.33 $ 3,786,589.20 $ 2,280,701.13
1/28/2014 $ 2,125.00 $ 81.73 $ 56.67 $ 173,676.25 $ 120,423.75
11/25/2015 $ 2,924.00 $ 651.21 $ 524.96 $ 1,904,138.04 $ 1,534,983.04
3/1/2015 $ 8,250.00 $ 668.27 $ 502.54 $ 5,513,227.50 $ 4,145,955.00
2/25/2017 $ 7,327.00 $ 152.58 $ 97.44 $ 1,117,953.66 $ 713,942.88
5/21/2017 $ 6,409.00 $ 81.73 $ 56.67 $ 523,807.57 $ 363,198.03
12/3/2011 $ 3,784.00 $ 9.33 $ 6.92 $ 35,304.72 $ 26,185.28
1/23/2017 $ 4,767.00 $ 421.89 $ 364.69 $ 2,011,149.63 $ 1,738,477.23
5/8/2012 $ 6,708.00 $ 651.21 $ 524.96 $ 4,368,316.68 $ 3,521,431.68
2/28/2012 $ 3,987.00 $ 651.21 $ 524.96 $ 2,596,374.27 $ 2,093,015.52
3/28/2017 $ 3,015.00 $ 81.73 $ 56.67 $ 246,415.95 $ 170,860.05
2/25/2010 $ 7,234.00 $ 437.20 $ 263.33 $ 3,162,704.80 $ 1,904,929.22
 6/8/2012 $ 2,117.00 $ 205.70 $ 117.11 $ 435,466.90 $ 247,921.87
11/10/2012 $ 171.00 $ 154.06 $ 90.93 $ 26,344.26 $ 15,549.03
11/18/2015 $ 5,930.00 $ 109.28 $ 35.84 $ 648,030.40 $ 212,531.20
4/29/2016 $ 962.00 $ 205.70 $ 117.11 $ 197,883.40 $ 112,659.82
12/31/2016 $ 8,867.00 $ 437.20 $ 263.33 $ 3,876,652.40 $ 2,334,947.11
1/31/2011 $ 273.00 $ 81.73 $ 56.67 $ 22,312.29 $ 15,470.91
11/14/2014 $ 7,842.00 $ 109.28 $ 35.84 $ 856,973.76 $ 281,057.28
1/13/2012 $ 1,266.00 $ 651.21 $ 524.96 $ 824,431.86 $ 664,599.36
3/18/2010 $ 2,269.00 $ 109.28 $ 35.84 $ 247,956.32 $ 81,320.96
9/18/2013 $ 9,606.00 $ 9.33 $ 6.92 $ 89,623.98 $ 66,473.52
3/28/2013 $ 4,063.00 $ 205.70 $ 117.11 $ 835,759.10 $ 475,817.93
1/7/2012 $ 3,457.00 $ 651.21 $ 524.96 $ 2,251,232.97 $ 1,814,786.72
10/24/2013 $ 7,637.00 $ 9.33 $ 6.92 $ 71,253.21 $ 52,848.04
6/27/2012 $ 3,482.00 $ 109.28 $ 35.84 $ 380,512.96 $ 124,794.88
8/1/2010 $ 9,905.00 $ 109.28 $ 35.84 $ 1,082,418.40 $ 354,995.20
3/2/2015 $ 2,847.00 $ 437.20 $ 263.33 $ 1,244,708.40 $ 749,700.51
2/14/2012 $ 282.00 $ 668.27 $ 502.54 $ 188,452.14 $ 141,716.28
4/19/2014 $ 7,215.00 $ 437.20 $ 263.33 $ 3,154,398.00 $ 1,899,925.95
7/2/2013 $ 682.00 $ 205.70 $ 117.11 $ 140,287.40 $ 79,869.02
7/1/2013 $ 4,750.00 $ 255.28 $ 159.42 $ 1,212,580.00 $ 757,245.00
11/15/2011 $ 5,518.00 $ 651.21 $ 524.96 $ 3,593,376.78 $ 2,896,729.28
11/17/2010 $ 6,116.00 $ 109.28 $ 35.84 $ 668,356.48 $ 219,197.44
11/16/2013 $ 1,705.00 $ 437.20 $ 263.33 $ 745,426.00 $ 448,977.65
11/25/2013 $ 4,477.00 $ 437.20 $ 263.33 $ 1,957,344.40 $ 1,178,928.41
7/9/2012 $ 8,656.00 $ 81.73 $ 56.67 $ 707,454.88 $ 490,535.52
9/7/2016 $ 5,498.00 $ 109.28 $ 35.84 $ 600,821.44 $ 197,048.32
11/17/2010 $ 8,287.00 $ 651.21 $ 524.96 $ 5,396,577.27 $ 4,350,343.52
5/28/2015 $ 7,342.00 $ 109.28 $ 35.84 $ 802,333.76 $ 263,137.28
5/20/2013 $ 5,010.00 $ 651.21 $ 524.96 $ 3,262,562.10 $ 2,630,049.60
9/30/2015 $ 673.00 $ 9.33 $ 6.92 $ 6,279.09 $ 4,657.16
7/15/2011 $ 5,741.00 $ 47.45 $ 31.79 $ 272,410.45 $ 182,506.39
6/17/2017 $ 8,656.00 $ 205.70 $ 117.11 $ 1,780,539.20 $ 1,013,704.16
8/16/2013 $ 9,892.00 $ 437.20 $ 263.33 $ 4,324,782.40 $ 2,604,860.36
12/12/2014 $ 6,954.00 $ 668.27 $ 502.54 $ 4,647,149.58 $ 3,494,663.16
11/15/2014 $ 9,379.00 $ 47.45 $ 31.79 $ 445,033.55 $ 298,158.41
10/23/2011 $ 3,732.00 $ 154.06 $ 90.93 $ 574,951.92 $ 339,350.76
6/2/2012 $ 8,614.00 $ 255.28 $ 159.42 $ 2,198,981.92 $ 1,373,243.88
8/7/2013 $ 9,654.00 $ 437.20 $ 263.33 $ 4,220,728.80 $ 2,542,187.82
11/30/2012 $ 4,513.00 $ 668.27 $ 502.54 $ 3,015,902.51 $ 2,267,963.02
10/8/2012 $ 7,884.00 $ 109.28 $ 35.84 $ 861,563.52 $ 282,562.56
12/8/2016 $ 6,489.00 $ 437.20 $ 263.33 $ 2,836,990.80 $ 1,708,748.37
1/5/2011 $ 4,085.00 $ 152.58 $ 97.44 $ 623,289.30 $ 398,042.40
4/7/2012 $ 6,457.00 $ 154.06 $ 90.93 $ 994,765.42 $ 587,135.01
 3/20/2012 $ 6,422.00 $ 81.73 $ 56.67 $ 524,870.06 $ 363,934.74
1/21/2011 $ 8,829.00 $ 47.45 $ 31.79 $ 418,936.05 $ 280,673.91
3/20/2014 $ 5,559.00 $ 255.28 $ 159.42 $ 1,419,101.52 $ 886,215.78
5/18/2012 $ 522.00 $ 9.33 $ 6.92 $ 4,870.26 $ 3,612.24
11/25/2016 $ 4,660.00 $ 47.45 $ 31.79 $ 221,117.00 $ 148,141.40
12/14/2016 $ 948.00 $ 651.21 $ 524.96 $ 617,347.08 $ 497,662.08
7/11/2014 $ 9,389.00 $ 47.45 $ 31.79 $ 445,508.05 $ 298,476.31
7/24/2012 $ 2,021.00 $ 651.21 $ 524.96 $ 1,316,095.41 $ 1,060,944.16
12/25/2010 $ 7,910.00 $ 437.20 $ 263.33 $ 3,458,252.00 $ 2,082,940.30
3/21/2011 $ 8,156.00 $ 47.45 $ 31.79 $ 387,002.20 $ 259,279.24
9/3/2011 $ 888.00 $ 109.28 $ 35.84 $ 97,040.64 $ 31,825.92
12/28/2011 $ 6,267.00 $ 9.33 $ 6.92 $ 58,471.11 $ 43,367.64
6/29/2016 $ 1,485.00 $ 154.06 $ 90.93 $ 228,779.10 $ 135,031.05
8/8/2015 $ 5,767.00 $ 81.73 $ 56.67 $ 471,336.91 $ 326,815.89
2/15/2012 $ 5,367.00 $ 668.27 $ 502.54 $ 3,586,605.09 $ 2,697,132.18
Total Profit Unit Cost
$ 951,410.50 Variance $ 35,422.32
$ 248,406.36 Standard deviation $ 188.21
$ 224,598.75 Mean $ 191.05
$ 19,525.82
$ 639,077.50
$ 285,087.64
$ 693,911.51 Total Revenue
$ 510,216.66 Mean $ 1,373,487.68
$ 152,114.20
$ 584,073.87
$ 7,828.12
$ 306,097.92
$ 606,834.72
$ 1,487,261.02 Confidence interval for Total Profit
$ 122,819.06 Sample size 100
$ 122,865.12 Sample mean $ 441,681.98
$ 1,208,744.24 Sample Std Dev $ 438,537.91
$ 85,033.80 T-test (t alpha/2, n-1) 0.96
$ 634,745.90 Confidence level 95%
$ 337,937.60 Degrees of freedom (n-1) 99
$ 714,157.00 Std error of mean (Estimation) $ 42,109.42
$ 122,029.78 Lower limit $ 399,572.56
$ 122,686.50 Upper limit $ 483,791.41
$ 5,270.67
$ 127,054.20
$ 315,574.05
$ 13,009.18
$ 14,031.02
$ 80,241.84
$ 392,780.10
$ 1,505,888.07
$ 53,252.50
$ 369,155.00
$ 1,367,272.50
$ 404,010.78
$ 160,609.54
$ 9,119.44
$ 272,672.40
$ 846,885.00
$ 503,358.75
$ 75,555.90
$ 1,257,775.58
$ 187,545.03
$ 10,795.23
$ 435,499.20
$ 85,223.58
$ 1,541,705.29
$ 6,841.38
$ 575,916.48
$ 159,832.50
$ 166,635.36
$ 23,150.46
$ 359,941.17
$ 436,446.25
$ 18,405.17
$ 255,718.08
$ 727,423.20
$ 495,007.89
$ 46,735.86
$ 1,254,472.05
$ 60,418.38
$ 455,335.00
$ 696,647.50
$ 449,159.04
$ 296,448.35
$ 778,415.99
$ 216,919.36
$ 403,773.12
$ 1,046,233.75
$ 539,196.48
$ 632,512.50
$ 1,621.93
$ 89,904.06
$ 766,835.04
$ 1,719,922.04
$ 1,152,486.42
$ 146,875.14
$ 235,601.16
$ 825,738.04
$ 1,678,540.98
$ 747,939.49
$ 579,000.96
$ 1,128,242.43
$ 225,246.90
$ 407,630.41
$ 160,935.32
$ 138,262.14
$ 532,885.74
$ 1,258.02
$ 72,975.60
$ 119,685.00
$ 147,031.74
$ 255,151.25
$ 1,375,311.70
$ 127,722.96
$ 65,214.72
$ 15,103.47
$ 93,748.05
$ 144,521.02
$ 889,472.91
 How to calculate
*=VAR.S(K2:K101) This chart isn't available in your version of Excel.
*=STDEV.S(K2:K101)
*=AVERAGE(K2:K101) Editing this shape or saving this workbook into a d

How to calculate
*=AVERAGE(L2:L101)

How to calculate

*=AVERAGE(N1:N101)
*=STDEV.S(N2:N101)
*=[Link].2T(1-Q20,Q21)

*=Q18/SQRT(Q16)*Q19
*=Q17-Q22
*=Q17+Q22
available in your version of Excel.

ape or saving this workbook into a different file format will permanently break the chart.

Mean = $ 1,373,487.68
AFC crackers, Ritz crackers 17%
Scotti sweet bread, Kinh Do fresh bread 14% PIE
Solite sponge cake 10%
Cozy Waffles 5%
Slides Snacks 3%
Kinh Do cake 7%
0.23
Cadbury chocolate, Koko Choco 9%
Wel Yo yogurt 6%
Cozy cookies, and Oreo cookies 6%
Kinh Do moon cake 23%

0.06

0.06

0.09

AFC crackers, Ritz crackers

Cozy Waffles
Cadbury chocolate, Koko Choco
Kinh Do moon cake

0.25

0.2

0.15

0.1

0.05

0
s d
er ea
a ck br e
c
cr sh ng
R itz fre sp
o
s, Do lit
e
ker nh So
ac , Ki
cr ad
C e
AF t br
ee
sw
 0
s d
er ea
a ck br c
cr s h ge
itz fre pon
R s
s, Do lit
e
er in
h
So
ck
cr
a
d,K
C e a
AF t br
ee
sw
otti
Sc
 PIE CHART OF KINH DO

0.17
0.23

0.14
0.06

0.06

0.096

0.09
0.05
0.07 0.03

C crackers, Ritz crackers Scotti sweet bread, Kinh Do fresh bread Solite sponge cake
y Waffles Slides Snacks Kinh Do cake
bury chocolate, Koko Choco Wel Yo yogurt Cozy cookies, and Oreo cookies
h Do moon cake

BAR CHART OF KINH DO

rs d ke es ks ke o rt s ke
ke ea ca ac ca oc gu ok
ie ca
br affl n Ch yo
sh ng
e W S Do ko Yo
co oo
n
zy es nh eo
fre sp
o
Co id Ki Ko el Or
m
Do e Sl t e , W d Do
nh lit la an nh
Ki So oco s, Ki
ad
, ch kie
re ury coo
db z y
Ca Co
 rs d ke es ck
s ke o rt s ke
ke ea ca ca oc gu ok
ie ca
br affl na Ch yo
sh ge W s S Do ko Yo
co
oo
n
fre on zy e nh Ko eo
s p Co Sl
id Ki , el Or
m
Do e at
e W d Do
h lit l an nh
in So co s, Ki
d,K cho ie
a ry ok
re bu
o
d z yc
Ca Co
 s ke
kie ca
oo n
oo
m
Do
nh
Ki
 s ke
kie ca
oo n
oo
m
Do
nh
Ki