Scribd Logo
Upload

Welcome to Scribd!

  • 24 views

    PelicanStores Ejercicios

    Uploaded by

    johana velandia
    This document contains data on 100 customers including their customer type (regular or promotional), number of articles purchased, net sales, payment method, and gender. Some key details are: - There are 30 regular customers and 70 promotional customers. - Net sales range from $13.23 to $287.59. - The most common payment methods are proprietary cards and most customers are female.

    Copyright:

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

    PelicanStores Ejercicios

    Uploaded by

    johana velandia
    24 views20 pages
    This document contains data on 100 customers including their customer type (regular or promotional), number of articles purchased, net sales, payment method, and gender. Some key details are: - There are 30 regular customers and 70 promotional customers. - Net sales range from $13.23 to $287.59. - The most common payment methods are proprietary cards and most customers are female.

    Original Title

    PelicanStores ejercicios

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains data on 100 customers including their customer type (regular or promotional), number of articles purchased, net sales, payment method, and gender. Some key details are: - There are 30 regular customers and 70 promotional customers. - Net sales range from $13.23 to $287.59. - The most common payment methods are proprietary cards and most customers are female.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    24 views20 pages

    PelicanStores Ejercicios

    Uploaded by

    johana velandia
    This document contains data on 100 customers including their customer type (regular or promotional), number of articles purchased, net sales, payment method, and gender. Some key details are: - There are 30 regular customers and 70 promotional customers. - Net sales range from $13.23 to $287.59. - The most common payment methods are proprietary cards and most customers are female.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 20

    Clase Frecuencia % acumulado

    Frecuencia
    13 1 1%
    44 25 26% Histograma
    74 37 64% 40 1
    30
    105 13 77% 8
    20
    135 9 86% 10 4
    166 7 93% 0 0
    196 2 95%
    227 1 96%
    257 2 98%
    Clase
    y mayor... 2 100%
    Histograma
    120%
    80%
    40%
    Frecuencia
    0% %
    acumulado

    Clase
    Clase Frecuencia % acumulado

    Frecuencia
    20 2 2%
    26 3 5% Histograma de Edad
    32 13 18% 25 1
    20
    37 17 35% 15 8
    43 16 51% 10 4
    5
    49 22 73% 0 0
    55 13 86%
    61 5 91%
    66 3 94%
    Clase
    72 4 98%
    y mayor... 2 100%
    Histograma de Edad
    120%
    80%
    40%
    Frecuencia
    0% %
    acumulado

    Clase
    Clase Frecuencia % acumulado

    Frecuencia
    1 29 29%
    3 27 56% Histograma
    4 20 76% 30
    6 9 85% 20
    7 8 93% 10
    9 4 97% 0
    11 1 98%
    12 0 98%
    14 1 99%
    Clase
    15 0 99%
    y mayor... 1 100%
    Histograma
    120%
    80%
    40%
    Frecuencia
    0% %
    acumulado

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

    tipo de cliente genero


    regular 30 mujer 93
    Promocional 70 hombre 7
    total 100 total 100

    GENERO ESTADO CIVIL


    mujer hombre estado civil Casado
    Soltero

    7%
    16%

    93%

    84%

    CLIENTES
    American express Mastercard discover visa propietary card
    CLIENTES
    American express Mastercard discover visa propietary card

    American express
    Mastercard

    discover

    visa

    propietary card
    Estado Civil Edad
    Married 32
    Married 36
    Married 32
    Married 28
    Married 34
    Married 44
    Married 30
    Married 40
    Married 46
    Married 36
    Married 48
    Married 40
    Married 40
    Married 46
    Single 24
    Single 36
    Single 22
    Married 40
    Married 32
    Married 56
    Single 28
    Married 38
    Married 50
    Married 42
    Married 48
    Married 60
    Married 54
    Single 42
    Married 32
    Married 70
    Married 28
    Married 52
    Married 44
    Married 34
    Married 56
    Single 36
    Single 42
    Married 50
    Married 44
    Married 58
    Married 42
    Married 46
    Married 48
    Married 54
    Married 38
    Married 60
    Married 46
    Married 30
    Married 32
    Married 46
    Married 38
    Married 68
    Single 78
    Single 20
    Married 32
    Married 38
    Married 54
    Married 48
    Married 46
    Single 50
    Married 46
    Single 30
    Married 54
    Single 42
    Married 48
    Married 62
    Married 34
    Married 28
    Married 46
    Married 54
    Married 30
    Married 32
    Single 22
    Married 32
    Married 74
    Married 62
    Married 42
    Married 28
    Married 38
    Married 54
    Married 68
    Single 30
    Married 36
    Married 44
    Married 44
    Married 62
    Single 48
    Married 36
    Single 20
    Married 42
    Married 54
    Married 54
    Married 72
    Married 30
    Married 46
    Married 44
    Married 30
    Married 52
    Married 30
    Married 44

    estado civil forma de pago cantidad Porcentaje


    Casado 84 American express 2 2%
    Soltero 16 Mastercard 14 14%
    total 100 discover 4 4%
    visa 10 10%
    propietary card 70 70%
    Total 100 100%

    ESTADO CIVIL
    estado civil Casado
    TIPO DE CLIENTE
    Soltero
    regular Promocional

    16%

    30%

    84% 70%
    DE CLIENTE
    ar Promocional

    30%
    tipo de ventas
    cliente articulos Forma de pago genero
    cliente netas
    1 Regular 1 39.50 Discover Male
    2 Promotional 1 102.40 Proprietary Card Female
    3 Regular 1 22.50 Proprietary Card Female
    4 Promotional 5 100.40 Proprietary Card Female
    5 Regular 2 54.00 MasterCard Female
    6 Regular 1 44.50 MasterCard Female
    7 Promotional 2 78.00 Proprietary Card Female
    8 Regular 1 22.50 Visa Female
    9 Promotional 2 56.52 Proprietary Card Female
    10 Regular 1 44.50 Proprietary Card Female
    11 Regular 1 29.50 Proprietary Card Female
    12 Promotional 1 31.60 Proprietary Card Female
    13 Promotional 9 160.40 Visa Female
    14 Promotional 2 64.50 Visa Female
    15 Regular 1 49.50 Visa Male
    16 Promotional 2 71.40 Proprietary Card Male
    17 Promotional 3 94.00 Proprietary Card Female
    18 Regular 3 54.50 Discover Female
    19 Promotional 2 38.50 MasterCard Female
    20 Promotional 6 44.80 Proprietary Card Female
    21 Promotional 1 31.60 Proprietary Card Female
    22 Promotional 4 70.82 Proprietary Card Female
    23 Promotional 7 266.00 American ExpressFemale
    24 Regular 2 74.00 Proprietary Card Female
    25 Promotional 2 39.50 Visa Male
    26 Promotional 1 30.02 Proprietary Card Female
    27 Regular 1 44.50 Proprietary Card Female
    28 Promotional 5 192.80 Proprietary Card Female
    29 Promotional 3 71.20 Proprietary Card Female
    30 Promotional 1 18.00 Proprietary Card Female
    31 Promotional 2 63.20 MasterCard Female
    32 Regular 1 75.00 Proprietary Card Female
    33 Promotional 3 63.20 Proprietary Card Female
    34 Regular 1 40.00 Proprietary Card Female
    35 Promotional 5 105.50 MasterCard Female
    36 Regular 1 29.50 MasterCard Male
    37 Regular 2 102.50 Visa Female
    38 Promotional 6 117.50 Proprietary Card Female
    39 Promotional 5 13.23 Proprietary Card Female
    40 Regular 2 52.50 Proprietary Card Female
    41 Promotional 13 198.80 Proprietary Card Female
    42 Promotional 4 19.50 Visa Female
    43 Regular 2 123.50 Proprietary Card Female
    44 Promotional 1 62.40 Proprietary Card Female
    45 Promotional 2 23.80 Proprietary Card Female
    46 Promotional 2 39.60 Proprietary Card Female
    47 Regular 1 25.00 MasterCard Female
    48 Promotional 3 63.64 Proprietary Card Female
    49 Promotional 1 14.82 Proprietary Card Female
    50 Promotional 9 145.20 MasterCard Female
    51 Promotional 6 176.62 Proprietary Card Female
    52 Promotional 5 118.80 Proprietary Card Male
    53 Regular 1 58.00 Discover Female
    54 Regular 2 74.00 Visa Female
    55 Regular 2 49.50 MasterCard Female
    56 Promotional 3 141.60 Proprietary Card Female
    57 Promotional 6 123.10 Proprietary Card Female
    58 Promotional 2 80.40 Proprietary Card Female
    59 Promotional 4 65.20 MasterCard Female
    60 Promotional 4 113.00 Proprietary Card Female
    61 Promotional 1 108.80 Proprietary Card Female
    62 Promotional 3 59.91 Proprietary Card Female
    63 Promotional 5 53.60 Proprietary Card Female
    64 Promotional 1 31.60 Proprietary Card Female
    65 Promotional 2 49.50 Proprietary Card Female
    66 Promotional 1 39.60 Proprietary Card Female
    67 Promotional 2 59.50 Proprietary Card Female
    68 Promotional 5 146.80 Proprietary Card Female
    69 Promotional 2 47.20 Proprietary Card Male
    70 Promotional 8 95.05 Proprietary Card Female
    71 Promotional 5 155.32 Proprietary Card Female
    72 Promotional 4 58.00 MasterCard Female
    73 Regular 1 69.00 Proprietary Card Female
    74 Promotional 2 46.50 Proprietary Card Female
    75 Promotional 2 45.22 Proprietary Card Female
    76 Promotional 4 84.74 Proprietary Card Female
    77 Regular 2 39.00 Proprietary Card Female
    78 Promotional 4 111.14 Proprietary Card Female
    79 Promotional 3 86.80 Proprietary Card Female
    80 Regular 2 89.00 Discover Female
    81 Promotional 2 78.00 MasterCard Female
    82 Promotional 6 53.20 Proprietary Card Female
    83 Promotional 4 58.50 Visa Female
    84 Promotional 3 46.00 Proprietary Card Female
    85 Regular 2 37.50 Visa Female
    86 Promotional 1 20.80 Proprietary Card Female
    87 Regular 6 144.00 MasterCard Female
    88 Regular 4 107.00 Proprietary Card Female
    89 Promotional 1 31.60 Proprietary Card Female
    90 Promotional 6 57.60 Proprietary Card Female
    91 Promotional 4 95.20 Proprietary Card Female
    92 Promotional 1 22.42 Proprietary Card Female
    93 Regular 5 159.75 Proprietary Card Female
    94 Promotional 17 229.50 Proprietary Card Female
    95 Regular 3 66.00 American ExpressFemale
    96 Regular 1 39.50 MasterCard Female
    97 Promotional 9 253.00 Proprietary Card Female
    98 Promotional 10 287.59 Proprietary Card Female
    99 Promotional 2 47.60 Proprietary Card Female
    100 Promotional 1 28.44 Proprietary Card Female
    Estado
    Edad
    Civil
    Married 32
    Married 36
    Married 32 ventas Netas
    Married 28 77.60 media
    Married 34 59.71 mediana
    Married 44 31.6 moda
    Married 30 3098.58537045455 varianza
    Married 40 55.664938430349 desviacion estandar
    Married 46 0.717327058850768 coeficiente de variacion
    Married 36
    Married 48 resumen de los 5 numeros
    Married 40
    Married 40 VALORES ANCHOS
    Married 46 MIN 13.23 13.23
    Single 24 Q1 39.6 26.37
    Single 36 Q2 O MEDIANA 59.71 20.11
    Single 22 Q3 100.9 41.20
    Married 40 MAX 287.59 186.69
    Married 32
    Married 56
    Single 28 edades
    Married 38 43.08 media
    Married 50 42.00 mediana
    Married 42 46 moda
    Married 48 153.488484848485 varianza
    Married 60 12.3890469709532 desviacion estandar
    Married 54 0.287582334516091 coeficiente de variacion
    Single 42
    Married 32 VALORES
    Married 70 MIN 20.00
    Married 28 Q1 32
    Married 52 Q2 O MEDIANA
    Married 44 Q3
    Married 34 MAX
    Married 56
    Single 36
    Single 42
    Married 50
    Married 44
    Married 58
    Married 42
    Married 46
    Married 48
    Married 54
    Married 38
    Married 60
    Married 46
    Married 30
    Married 32
    Married 46
    Married 38
    Married 68
    Single 78
    Single 20
    Married 32
    Married 38
    Married 54
    Married 48
    Married 46
    Single 50
    Married 46
    Single 30
    Married 54
    Single 42
    Married 48
    Married 62
    Married 34
    Married 28
    Married 46
    Married 54
    Married 30
    Married 32
    Single 22
    Married 32
    Married 74
    Married 62
    Married 42
    Married 28
    Married 38
    Married 54
    Married 68
    Single 30
    Married 36
    Married 44
    Married 44
    Married 62
    Single 48
    Married 36
    Single 20
    Married 42
    Married 54
    Married 54
    Married 72
    Married 30
    Married 46
    Married 44
    Married 30
    Married 52
    Married 30
    Married 44

    You might also like