Scribd Logo
Upload

Welcome to Scribd!

  • 573 views

    Fruit Sales Dataset

    Uploaded by

    sqlserver200800
    This document contains monthly sales data for various fruits from 2008-2009. It lists the fruit name, year, month, quantity sold (in number of boxes), revenue, and salesperson for each transaction. There are over 500 rows of data with 25 different fruits and 14 salespeople represented (8 female, 6 male). The salespeople are Jane, Henry, Tom, Susan, and others. The highest volume fruits sold were apples, bananas, oranges, and cherries.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    Fruit Sales Dataset

    Uploaded by

    sqlserver200800
    573 views10 pages
    This document contains monthly sales data for various fruits from 2008-2009. It lists the fruit name, year, month, quantity sold (in number of boxes), revenue, and salesperson for each transaction. There are over 500 rows of data with 25 different fruits and 14 salespeople represented (8 female, 6 male). The salespeople are Jane, Henry, Tom, Susan, and others. The highest volume fruits sold were apples, bananas, oranges, and cherries.

    Original Description:

    Fruit Sales Dataset

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains monthly sales data for various fruits from 2008-2009. It lists the fruit name, year, month, quantity sold (in number of boxes), revenue, and salesperson for each transaction. There are over 500 rows of data with 25 different fruits and 14 salespeople represented (8 female, 6 male). The salespeople are Jane, Henry, Tom, Susan, and others. The highest volume fruits sold were apples, bananas, oranges, and cherries.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    573 views10 pages

    Fruit Sales Dataset

    Uploaded by

    sqlserver200800
    This document contains monthly sales data for various fruits from 2008-2009. It lists the fruit name, year, month, quantity sold (in number of boxes), revenue, and salesperson for each transaction. There are over 500 rows of data with 25 different fruits and 14 salespeople represented (8 female, 6 male). The salespeople are Jane, Henry, Tom, Susan, and others. The highest volume fruits sold were apples, bananas, oranges, and cherries.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 10

    Fruit

    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apple
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots
    Apricots

    Year

    Month

    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009

    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    January
    February
    March
    April
    May
    June
    July
    August
    September

    Quantity
    (number of boxes)
    566
    888
    135
    419
    757
    869
    304
    420
    459
    620
    712
    970
    610
    411
    606
    425
    676
    868
    888
    152
    371
    294
    608
    965
    518
    599
    344
    831
    453
    984
    689
    171
    902
    716
    852
    523
    847
    279
    721
    929
    810
    311
    832
    592
    263

    Revenue
    $33,904
    $8,319
    $24,125
    $33,859
    $31,315
    $43,094
    $41,042
    $33,404
    $15,101
    $15,934
    $8,810
    $49,714
    $5,569
    $29,208
    $6,214
    $34,948
    $17,549
    $16,035
    $46,398
    $30,657
    $32,176
    $22,245
    $38,545
    $11,874
    $48,717
    $33,600
    $5,984
    $43,878
    $10,752
    $23,147
    $42,107
    $46,772
    $32,313
    $41,560
    $5,142
    $11,303
    $14,089
    $39,017
    $22,144
    $16,986
    $9,945
    $25,253
    $29,841
    $15,489
    $38,459

    SalesPerson
    Jane
    Henry
    Tom
    Susan
    Jane
    Henry
    Tom
    Tom
    Henry
    Jane
    Tom
    Henry
    Jane
    Henry
    Susan
    Jane
    Susan
    Henry
    Jane
    Henry
    Henry
    Jane
    Tom
    Jane
    Jane
    Susan
    Jane
    Jane
    Henry
    Susan
    Tom
    Tom
    Susan
    Tom
    Henry
    Susan
    Tom
    Jane
    Henry
    Tom
    Jane
    Henry
    Susan
    Henry
    Henry

    Apricots
    Apricots
    Apricots
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Bananas
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Cherries

    2009
    2009
    2009
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2009
    2009
    2009
    2009
    2009
    2009
    2009

    October
    November
    December
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    December
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    January
    February
    March
    April
    May
    June
    July

    886
    290
    358
    876
    365
    681
    403
    369
    362
    847
    543
    890
    515
    557
    191
    792
    838
    594
    970
    579
    541
    754
    315
    968
    1000
    830
    816
    816
    103
    189
    977
    735
    834
    680
    324
    634
    616
    999
    803
    134
    650
    880
    438
    702
    367
    914
    829

    $40,303
    $28,480
    $21,871
    $33,655
    $6,954
    $38,864
    $39,177
    $45,649
    $13,405
    $28,084
    $41,339
    $44,670
    $15,198
    $46,162
    $35,625
    $48,407
    $10,639
    $24,905
    $13,798
    $27,350
    $45,970
    $39,640
    $35,226
    $33,068
    $17,830
    $48,146
    $22,452
    $22,452
    $6,842
    $35,847
    $7,208
    $13,834
    $41,294
    $41,737
    $37,614
    $38,151
    $23,623
    $36,571
    $12,792
    $11,620
    $23,143
    $27,441
    $33,978
    $34,991
    $32,903
    $5,686
    $41,864

    Jane
    Susan
    Tom
    Henry
    Henry
    Henry
    Susan
    Henry
    Jane
    Tom
    Susan
    Susan
    Jane
    Susan
    Henry
    Tom
    Henry
    Tom
    Susan
    Susan
    Jane
    Henry
    Tom
    Henry
    Jane
    Henry
    Jane
    Jane
    Susan
    Henry
    Henry
    Tom
    Jane
    Tom
    Henry
    Henry
    Jane
    Jane
    Jane
    Jane
    Henry
    Jane
    Jane
    Susan
    Susan
    Jane
    Jane

    Cherries
    Cherries
    Cherries
    Cherries
    Cherries
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Figs
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit

    2009
    2009
    2009
    2009
    2009
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2009
    2009
    2009
    2009
    2009
    2009

    August
    September
    October
    November
    December
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    January
    February
    March
    April
    May
    June

    894
    558
    919
    234
    803
    187
    461
    706
    595
    965
    634
    997
    973
    464
    973
    171
    392
    604
    850
    863
    117
    498
    141
    227
    479
    267
    649
    754
    668
    746
    958
    243
    780
    274
    279
    724
    759
    189
    508
    560
    312
    344
    873
    258
    392
    249
    982

    $25,873
    $30,714
    $22,997
    $41,361
    $47,894
    $7,229
    $23,255
    $46,101
    $26,879
    $47,384
    $10,067
    $15,842
    $31,703
    $22,100
    $47,573
    $49,875
    $8,426
    $40,769
    $17,273
    $7,741
    $17,066
    $20,637
    $34,938
    $5,494
    $9,093
    $24,658
    $36,637
    $48,612
    $17,045
    $11,351
    $47,114
    $40,890
    $20,158
    $36,370
    $14,219
    $6,176
    $42,883
    $49,959
    $24,649
    $48,816
    $8,833
    $36,428
    $16,609
    $40,469
    $8,882
    $30,922
    $6,759

    Tom
    Jane
    Tom
    Susan
    Jane
    Susan
    Tom
    Henry
    Henry
    Susan
    Tom
    Susan
    Tom
    Henry
    Tom
    Henry
    Susan
    Jane
    Henry
    Henry
    Jane
    Susan
    Susan
    Tom
    Tom
    Susan
    Henry
    Susan
    Tom
    Susan
    Susan
    Jane
    Susan
    Henry
    Susan
    Tom
    Henry
    Jane
    Tom
    Jane
    Henry
    Tom
    Susan
    Henry
    Tom
    Susan
    Henry

    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Grapefruit
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Kiwi
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons

    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2008
    2009
    2009

    July
    August
    September
    October
    November
    December
    December
    January
    January
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    January
    February
    March
    April
    May
    June
    July
    August
    September
    October
    November
    December
    January
    February

    678
    225
    708
    130
    677
    856
    856
    344
    344
    952
    604
    218
    157
    206
    291
    643
    382
    467
    846
    445
    512
    258
    968
    497
    287
    316
    797
    350
    631
    932
    100
    227
    370
    900
    235
    835
    153
    153
    807
    526
    994
    873
    124
    490
    111
    375
    261

    $14,762
    $6,691
    $38,243
    $8,746
    $25,434
    $24,896
    $24,896
    $36,428
    $36,428
    $18,248
    $21,154
    $37,585
    $37,805
    $11,716
    $19,614
    $10,299
    $14,385
    $24,306
    $11,887
    $28,815
    $32,894
    $36,242
    $5,756
    $45,676
    $27,253
    $35,356
    $21,662
    $14,319
    $43,390
    $29,604
    $44,529
    $15,381
    $34,237
    $12,666
    $44,150
    $20,465
    $36,606
    $22,770
    $17,904
    $14,157
    $27,177
    $24,680
    $41,987
    $25,837
    $32,610
    $39,350
    $28,309

    Henry
    Tom
    Henry
    Henry
    Henry
    Henry
    Henry
    Tom
    Tom
    Jane
    Susan
    Tom
    Henry
    Tom
    Jane
    Jane
    Susan
    Susan
    Tom
    Jane
    Jane
    Susan
    Henry
    Jane
    Susan
    Susan
    Tom
    Jane
    Tom
    Susan
    Susan
    Jane
    Susan
    Susan
    Henry
    Jane
    Henry
    Henry
    Jane
    Henry
    Susan
    Susan
    Jane
    Jane
    Tom
    Tom
    Henry

    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons
    Lemons

    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009
    2009

    March
    April
    May
    June
    July
    August
    September
    October
    November
    December

    471
    190
    620
    787
    740
    802
    808
    688
    804
    591

    $5,588
    $28,360
    $45,627
    $39,776
    $18,995
    $23,948
    $27,936
    $5,836
    $26,591
    $41,360

    Henry
    Tom
    Jane
    Susan
    Susan
    Susan
    Jane
    Henry
    Jane
    Tom

    SalesPerson
    Gender
    F
    M
    M
    F
    F
    M
    M
    M
    M
    F
    M
    M
    F
    M
    F
    F
    F
    M
    F
    M
    M
    F
    M
    F
    F
    F
    F
    F
    M
    F
    M
    M
    F
    M
    M
    F
    M
    F
    M
    M
    F
    M
    F
    M
    M

    F
    F
    M
    M
    M
    M
    F
    M
    F
    M
    F
    F
    F
    F
    M
    M
    M
    M
    F
    F
    F
    M
    M
    M
    F
    M
    F
    F
    F
    M
    M
    M
    F
    M
    M
    M
    F
    F
    F
    F
    M
    F
    F
    F
    F
    F
    F

    M
    F
    M
    F
    F
    F
    M
    M
    M
    F
    M
    F
    M
    M
    M
    M
    F
    F
    M
    M
    F
    F
    F
    M
    M
    F
    M
    F
    M
    F
    F
    F
    F
    M
    F
    M
    M
    F
    M
    F
    M
    M
    F
    M
    M
    F
    M

    M
    M
    M
    M
    M
    M
    M
    M
    M
    F
    F
    M
    M
    M
    F
    F
    F
    F
    M
    F
    F
    F
    M
    F
    F
    F
    M
    F
    M
    F
    F
    F
    F
    F
    M
    F
    M
    M
    F
    M
    F
    F
    F
    F
    M
    M
    M

    M
    M
    F
    F
    F
    F
    F
    M
    F
    M

    You might also like