grupo4_trab_2_pelican
Post on 05-Dec-2014
703 Views
Preview:
DESCRIPTION
TRANSCRIPT
Las tiendas PelicanInforme para los directivos
Por:Sebastián EspinosaGabriela Gutiérrez
Mario Chacón
Información tiendas Pelican
•Tiendas Pelican son una división de National Clothing, que es una cadena de ropa femenina, que tiene sucursales por todo Estados Unidos.
•National Clothing Inc. fue constituido en Washington en el año de 1986.
•Actualmente tiene unos ingresos de $ 500 000 000 Usd.
•Esta tienda ofrece ropa para mujeres, hombres, niños.
Datos estadísticos
•Los artículos, ventas netas, número de artículos comprados entre otros son datos que nos pueden servir mucho para sacar datos estadísticos y así tomar decisiones.
•Se desea emplear estos datos muestrales para obtener información acerca de sus clientes y evaluar la promoción de los cupones de descuento.
Datos de las 100 compras con tarjeta de crédito realizadas en las tiendas Pelican
Customer Type of Customer Items Net Sales Method of Payment Gender Marital Status Age
1 Regular 1 39,50Discover Male Married 32
2 Promotional 1 102,40Proprietary Card Female Married 36
3 Regular 1 22,50Proprietary Card Female Married 32
4 Promotional 5 100,40Proprietary Card Female Married 28
5 Regular 2 54,00MasterCard Female Married 34
6 Regular 1 44,50MasterCard Female Married 44
7 Promotional 2 78,00Proprietary Card Female Married 30
8 Regular 1 22,50Visa Female Married 40
9 Promotional 2 56,52Proprietary Card Female Married 46
10 Regular 1 44,50Proprietary Card Female Married 36
11 Regular 1 29,50Proprietary Card Female Married 48
12 Promotional 1 31,60Proprietary Card Female Married 40
13 Promotional 9 160,40Visa Female Married 40
14 Promotional 2 64,50Visa Female Married 46
15 Regular 1 49,50Visa Male Single 24
16 Promotional 2 71,40Proprietary Card Male Single 36
17 Promotional 3 94,00Proprietary Card Female Single 22
18 Regular 3 54,50Discover Female Married 40
19 Promotional 2 38,50MasterCard Female Married 32
20 Promotional 6 44,80Proprietary Card Female Married 56
21 Promotional 1 31,60Proprietary Card Female Single 28
22 Promotional 4 70,82Proprietary Card Female Married 38
23 Promotional 7 266,00American Express Female Married 50
24 Regular 2 74,00Proprietary Card Female Married 42
25 Promotional 2 39,50Visa Male Married 48
26 Promotional 1 30,02Proprietary Card Female Married 60
27 Regular 1 44,50Proprietary Card Female Married 54
28 Promotional 5 192,80Proprietary Card Female Single 42
29 Promotional 3 71,20Proprietary Card Female Married 32
30 Promotional 1 18,00Proprietary Card Female Married 70
31 Promotional 2 63,20MasterCard Female Married 28
32 Regular 1 75,00Proprietary Card Female Married 52
33 Promotional 3 63,20Proprietary Card Female Married 44
34 Regular 1 40,00Proprietary Card Female Married 34
35 Promotional 5 105,50MasterCard Female Married 56
36 Regular 1 29,50MasterCard Male Single 36
37 Regular 2 102,50Visa Female Single 42
38 Promotional 6 117,50Proprietary Card Female Married 50
39 Promotional 5 13,23Proprietary Card Female Married 44
40 Regular 2 52,50Proprietary Card Female Married 58
41 Promotional 13 198,80Proprietary Card Female Married 42
42 Promotional 4 19,50Visa 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,91Proprietary Card Female Single 30
63 Promotional 5 53,60Proprietary Card Female Married 54
64 Promotional 1 31,60Proprietary Card Female Single 42
65 Promotional 2 49,50Proprietary Card Female Married 48
66 Promotional 1 39,60Proprietary Card Female Married 62
67 Promotional 2 59,50Proprietary Card Female Married 34
68 Promotional 5 146,80 Proprietary Card Female Married 28
69 Promotional 2 47,20Proprietary Card Male Married 46
70 Promotional 8 95,05Proprietary Card Female Married 54
71 Promotional 5 155,32 Proprietary Card Female Married 30
72 Promotional 4 58,00MasterCard Female Married 32
73 Regular 1 69,00Proprietary Card Female Single 22
74 Promotional 2 46,50Proprietary Card Female Married 32
75 Promotional 2 45,22Proprietary Card Female Married 74
76 Promotional 4 84,74Proprietary Card Female Married 62
77 Regular 2 39,00Proprietary Card Female Married 42
78 Promotional 4 111,14 Proprietary Card Female Married 28
79 Promotional 3 86,80Proprietary Card Female Married 38
80 Regular 2 89,00Discover Female Married 54
81 Promotional 2 78,00MasterCard Female Married 68
82 Promotional 6 53,20Proprietary 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 Express Female 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
Estadisticos descriptivos sobre ventas netas y sobre ventas a distintos tipos de
clientesTotal → Media Mediana Moda Cuartiles Varianza
Desviacion estandar
Coeficiente de variacion
77,60 59,71 31,6 25 3098,585 55,66 7173,27%
50
75
Cliente Regular → Media Mediana Moda Cuartiles Varianza Desviacion estandar
Coeficiente de variacion
61,99 51,00 44,5 7,5 1229,761 35,06794411 5656,88%
15
22,5
Cliente promocional → Media Mediana Moda Cuartiles Varianza Desviacion estandar
Coeficiente de variacion
84,29 63,42 31,6 17,5 3777,614 61,46229694 7291,77%
35
52,5
Tabla Cruzada para los distintos tipos de clientes
TIPO CLIENTE VENTAS NETAS
0-28 29-56 57-84 85-112 113-140 141-168 169-196 197-224 225-252 253-280 281-308 TOTAL
REGULAR 3 15 6 3 1 2 0 0 0 0 0 30
PROMOCIONAL 8 19 18 9 4 5 2 1 1 2 1 70
TOTAL 11 34 24 12 5 7 2 1 1 2 1 100
Valores Z para los tipos de clientes
Z Regular
Z Promocional
-0,64129 0,294663196
-1,12603 0,262121705
-0,22783 -0,10234299
-0,49872 -0,45183859
-1,12603 -0,85730556
-0,49872 1,238366417
-0,92643 -0,32199805
-0,35614 -0,20972991
-0,21357 0,157988936
0,342458 -0,74503742
-0,49872 -0,64253173
0,370972 -0,85730556
-0,62703 -0,21916694
-0,92643 2,95655711
1,155118 -0,72876668
-0,2706 -0,88301334
1,753921 1,765538562
-1,05475 -0,21298405
-0,11377 -1,0785877
0,342458 -0,34315002
-0,35614 -0,34315002
0,199886 0,345102506
-0,65555 0,540351448
0,770174 -1,15619915
-0,69832 1,863163033
2,338466 -1,05418158
1,283433 -0,35616661
2,787568 -0,98421738
0,114343 -0,7271396
-0,64129 -0,33599089
-1,13032867
0,99105109
1,502277904
0,561503417
0,932476407
0,631467621
-0,0632932
-0,31060853
0,467133095
0,398795965
-0,39668077
-0,49934917
-0,85730556
-0,56605923
-0,7271396
-0,40335177
1,017084282
-0,60348194
0,175073218
1,155711032
-0,42775789
-0,61487146
-0,63569801
0,007321835
0,436869509
0,04083957
-0,10234299
-0,50585747
-0,41962252
-0,62300683
-1,03302961
-0,85730556
-0,43426619
0,17751383
-1,00667101
2,362674911
2,745037423
3,307842499
-0,59697364
-0,90872112
Estadísticos Descriptivos sobre la edad y ventas netas
ventas netas
Total → Media Mediana Moda Cuartiles Varianza Desviacion estandar
Coeficiente de variacion
80,70 63,20 31,6 25 3355,283 57,92 7177,55%
50
75
Edad
Total → Media Mediana Moda Cuartiles Varianza Desviacion estandar
Coeficiente de variacion
43,08 42,00 46 32 153,4885 12,38904697 28,75823345
42
50
Conclusiones• Como hemos visto a lo largo de la presentación
podemos concluir que las tiendas Pelican recibe alrededor de un 70% de clientes promocionales.
• A la vez automáticamente podemos ver que la media para los clientes promocionales es mucho mayor que la de los clientes regulares, lo que quiere decir que la promoción es de gran beneficio para las tiendas Pelican
• De igual manera concluimos que el 75% de los compradores en general no pasan de los 50 años ya que el 3er cuartil es el numero 50.
top related