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.