Scribd Logo
Upload

Welcome to Scribd!

  • 76 views

    Pelican Stores

    Uploaded by

    Hernan Foen
    The document contains sales data from 100 customers including type of customer, items purchased, net sales, payment method, gender, marital status and age. Most customers were married females between 31-50 years old who purchased 1-3 promotional items with a net sales between $30-$89.99 and paid with a proprietary card.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Pelican Stores

    Uploaded by

    Hernan Foen
    76 views7 pages
    The document contains sales data from 100 customers including type of customer, items purchased, net sales, payment method, gender, marital status and age. Most customers were married females between 31-50 years old who purchased 1-3 promotional items with a net sales between $30-$89.99 and paid with a proprietary card.

    Original Title

    PelicanStores.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains sales data from 100 customers including type of customer, items purchased, net sales, payment method, gender, marital status and age. Most customers were married females between 31-50 years old who purchased 1-3 promotional items with a net sales between $30-$89.99 and paid with a proprietary card.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    76 views7 pages

    Pelican Stores

    Uploaded by

    Hernan Foen
    The document contains sales data from 100 customers including type of customer, items purchased, net sales, payment method, gender, marital status and age. Most customers were married females between 31-50 years old who purchased 1-3 promotional items with a net sales between $30-$89.99 and paid with a proprietary card.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 7

    Type of Method of Marital

    Customer Customer Items Net Sales Payment Gender Status Age


    1 Regular 1 39.50 Discover Male Married 32
    2 Promotional 1 102.40 Proprietary Card Female Married 36
    3 Regular 1 22.50 Proprietary Card Female Married 32
    4 Promotional 5 100.40 Proprietary Card Female Married 28
    5 Regular 2 54.00 MasterCard Female Married 34
    6 Regular 1 44.50 MasterCard Female Married 44
    7 Promotional 2 78.00 Proprietary Card Female Married 30
    8 Regular 1 22.50 Visa Female Married 40
    9 Promotional 2 56.52 Proprietary Card Female Married 46
    10 Regular 1 44.50 Proprietary Card Female Married 36
    11 Regular 1 29.50 Proprietary Card Female Married 48
    12 Promotional 1 31.60 Proprietary Card Female Married 40
    13 Promotional 9 160.40 Visa Female Married 40
    14 Promotional 2 64.50 Visa Female Married 46
    15 Regular 1 49.50 Visa Male Single 24
    16 Promotional 2 71.40 Proprietary Card Male Single 36
    17 Promotional 3 94.00 Proprietary Card Female Single 22
    18 Regular 3 54.50 Discover Female Married 40
    19 Promotional 2 38.50 MasterCard Female Married 32
    20 Promotional 6 44.80 Proprietary Card Female Married 56
    21 Promotional 1 31.60 Proprietary Card Female Single 28
    22 Promotional 4 70.82 Proprietary Card Female Married 38
    23 Promotional 7 266.00 American ExpressFemale Married 50
    24 Regular 2 74.00 Proprietary Card Female Married 42
    25 Promotional 2 39.50 Visa Male Married 48
    26 Promotional 1 30.02 Proprietary Card Female Married 60
    27 Regular 1 44.50 Proprietary Card Female Married 54
    28 Promotional 5 192.80 Proprietary Card Female Single 42
    29 Promotional 3 71.20 Proprietary Card Female Married 32
    30 Promotional 1 18.00 Proprietary Card Female Married 70
    31 Promotional 2 63.20 MasterCard Female Married 28
    32 Regular 1 75.00 Proprietary Card Female Married 52
    33 Promotional 3 63.20 Proprietary Card Female Married 44
    34 Regular 1 40.00 Proprietary Card Female Married 34
    35 Promotional 5 105.50 MasterCard Female Married 56
    36 Regular 1 29.50 MasterCard Male Single 36
    37 Regular 2 102.50 Visa Female Single 42
    38 Promotional 6 117.50 Proprietary Card Female Married 50
    39 Promotional 5 13.23 Proprietary Card Female Married 44
    40 Regular 2 52.50 Proprietary Card Female Married 58
    41 Promotional 13 198.80 Proprietary Card Female Married 42
    42 Promotional 4 19.50 Visa Female Married 46
    43 Regular 2 123.50 Proprietary Card Female Married 48
    44 Promotional 1 62.40 Proprietary Card Female Married 54
    45 Promotional 2 23.80 Proprietary Card Female Married 38
    46 Promotional 2 39.60 Proprietary Card Female Married 60
    47 Regular 1 25.00 MasterCard Female Married 46
    48 Promotional 3 63.64 Proprietary Card Female Married 30
    49 Promotional 1 14.82 Proprietary Card Female Married 32
    50 Promotional 9 145.20 MasterCard Female Married 46
    51 Promotional 6 176.62 Proprietary Card Female Married 38
    52 Promotional 5 118.80 Proprietary Card Male Married 68
    53 Regular 1 58.00 Discover Female Single 78
    54 Regular 2 74.00 Visa Female Single 20
    55 Regular 2 49.50 MasterCard Female Married 32
    56 Promotional 3 141.60 Proprietary Card Female Married 38
    57 Promotional 6 123.10 Proprietary Card Female Married 54
    58 Promotional 2 80.40 Proprietary Card Female Married 48
    59 Promotional 4 65.20 MasterCard Female Married 46
    60 Promotional 4 113.00 Proprietary Card Female Single 50
    61 Promotional 1 108.80 Proprietary Card Female Married 46
    62 Promotional 3 59.91 Proprietary Card Female Single 30
    63 Promotional 5 53.60 Proprietary Card Female Married 54
    64 Promotional 1 31.60 Proprietary Card Female Single 42
    65 Promotional 2 49.50 Proprietary Card Female Married 48
    66 Promotional 1 39.60 Proprietary Card Female Married 62
    67 Promotional 2 59.50 Proprietary Card Female Married 34
    68 Promotional 5 146.80 Proprietary Card Female Married 28
    69 Promotional 2 47.20 Proprietary Card Male Married 46
    70 Promotional 8 95.05 Proprietary Card Female Married 54
    71 Promotional 5 155.32 Proprietary Card Female Married 30
    72 Promotional 4 58.00 MasterCard Female Married 32
    73 Regular 1 69.00 Proprietary Card Female Single 22
    74 Promotional 2 46.50 Proprietary Card Female Married 32
    75 Promotional 2 45.22 Proprietary Card Female Married 74
    76 Promotional 4 84.74 Proprietary Card Female Married 62
    77 Regular 2 39.00 Proprietary Card Female Married 42
    78 Promotional 4 111.14 Proprietary Card Female Married 28
    79 Promotional 3 86.80 Proprietary Card Female Married 38
    80 Regular 2 89.00 Discover Female Married 54
    81 Promotional 2 78.00 MasterCard Female Married 68
    82 Promotional 6 53.20 Proprietary Card Female Single 30
    83 Promotional 4 58.50 Visa Female Married 36
    84 Promotional 3 46.00 Proprietary Card Female Married 44
    85 Regular 2 37.50 Visa Female Married 44
    86 Promotional 1 20.80 Proprietary Card Female Married 62
    87 Regular 6 144.00 MasterCard Female Single 48
    88 Regular 4 107.00 Proprietary Card Female Married 36
    89 Promotional 1 31.60 Proprietary Card Female Single 20
    90 Promotional 6 57.60 Proprietary Card Female Married 42
    91 Promotional 4 95.20 Proprietary Card Female Married 54
    92 Promotional 1 22.42 Proprietary Card Female Married 54
    93 Regular 5 159.75 Proprietary Card Female Married 72
    94 Promotional 17 229.50 Proprietary Card Female Married 30
    95 Regular 3 66.00 American ExpressFemale Married 46
    96 Regular 1 39.50 MasterCard Female Married 44
    97 Promotional 9 253.00 Proprietary Card Female Married 30
    98 Promotional 10 287.59 Proprietary Card Female Married 52
    99 Promotional 2 47.60 Proprietary Card Female Married 30
    100 Promotional 1 28.44 Proprietary Card Female Married 44
    Ventas Netas Frecuencia Frecuencia Porcentual Frecuencia Relativa
    [0-29,99] 13 13% 0.3
    [30-59,99] 38 38% 0.34
    [60-89,99] 20 20% 0.34
    [90-119,99] 13 13% 0.02
    [120-149,99] 6 6% 1
    [150-179,99] 4 4%
    [180-209,99] 2 2%
    [210-239,99] 1 1% Estado Civil
    [240-269,99] 2 2% Married
    [270-299,99] 1 1% Single
    total 100 100% total

    Age Frecuencia Frecuencia Porcentual


    [1-10] 0 0% Genero
    [11-20] 2 2% Female
    [21-30] 16 16% Male
    [31-40] 26 26% total
    [41-50] 32 32%
    [51-60] 15 15% Tipo de Cliente
    [61-70] 6 6% Promotional
    [71-80] 3 3% Regular
    total 100 100% total

    Items Frecuencia Frecuencia Porcentual Tipo de Cliente


    [1-3] 66 66% Promotional
    [4-6] 26 26% Regular
    [7-9] 5 5% total
    [10-12] 1 1%
    [13-15] 1 1%
    [16-18] 1 1%
    total 100 100%

    Items Frecuencia Frecuencia Porcentual


    American Express 2 2%
    Discover 4 4%
    MasterCard 14 14%
    Proprietary Card 70 70%
    Visa 10 10%
    total 100 100%
    cia Relativa
    Contar

    Method of Payme
    American Expres
    Filas: Type of Customer   Columnas: Method of Payment Discover
    MasterCard
    Proprietary Card
    Frecuencia Frecuencia Porcentual Frecuencia Relativa Visa
    84 84% 0.84 N=
    16 16% 0.16
    100 100% 1

    Frecuencia Frecuencia Porcentual Frecuencia Relativa


    93 93% 0.93
    7 7% 0.07
    100 100% 1

    Frecuencia Frecuencia Porcentual Frecuencia Relativa


    70 70% 0.7
    30 30% 0.3
    100 100% 1

    Frecuencia Frecuencia Porcentual Frecuencia Relativa


    70 70% 0.7
    30 30% 0.3
    100 100% 1
    Conteo Porcentaje
    2 2
    4 4
    14 14
    70 70
    10 10
    100

    You might also like