cliente cgategoria hotel tipo de habitacion ¿desayuno incluido?

1 6 2 NO
2 2 4 SI
3 3 4 SI
4 6 4 SI
5 6 4 SI
6 3 1 SI
7 6 1 NO
8 5 2 SI
9 5 3 NO
10 2 3 NO
11 4 4 NO
12 2 3 SI
13 5 2 SI
14 5 4 SI
15 3 2 NO
16 5 4 SI
17 6 4 SI
18 3 2 SI
19 5 2 NO
20 6 3 NO
21 4 3 NO
22 3 3 NO
23 3 3 NO
24 4 1 NO
25 1 4 SI
26 6 4 NO
27 6 1 SI
28 5 3 NO
29 5 1 NO
30 5 4 SI
31 4 1 NO
32 5 3 SI
33 3 3 SI
34 5 1 NO
35 1 1 SI
36 4 4 SI
37 4 3 SI
38 6 4 NO
39 1 2 SI
40 4 4 SI
41 6 2 SI
42 6 2 SI
43 3 3 NO
44 1 3 NO
45 1 2 NO
46 6 4 NO
47 4 2 NO
48 4 4 SI
49 5 3 NO
50 6 2 SI
51 2 4 NO
52 3 4 NO
53 6 1 SI
54 6 1 SI
55 6 3 SI
56 4 4 SI
57 2 3 NO
58 4 1 NO
59 1 1 SI
60 2 4 SI
 61 1 4 SI
62 4 3 NO
63 2 1 NO
64 2 2 SI
65 3 1 NO
66 5 1 NO
67 1 2 SI
68 4 1 SI
69 4 2 SI
70 4 1 SI
71 3 3 SI
72 2 4 SI
73 6 3 NO
74 4 4 SI
75 5 3 SI
76 3 3 SI
77 5 1 SI
78 2 1 NO
79 2 4 NO
80 1 4 SI
81 4 4 NO
82 3 1 NO
83 2 1 NO
84 2 4 SI
85 1 3 SI
86 4 1 NO
87 5 3 SI
88 3 3 NO
89 5 2 SI
90 3 1 SI
91 1 2 SI
92 3 1 SI
93 2 4 NO
94 1 1 SI
95 4 1 NO
96 2 4 NO
97 5 4 NO
98 3 4 SI
99 3 3 SI
100 6 4 NO
pago total por desayunos precio por noche numero de noches total a pagar
$0.00 $1,660.25 3 $4,980.75
$400.00 $1,240.62 5 $8,203.10
$500.00 $1,648.54 4 $8,594.16
$1,200.00 $3,860.08 8 $40,480.64
$1,200.00 $3,860.08 4 $20,240.32
$125.00 $489.00 4 $2,456.00
$0.00 $1,145.00 1 $1,145.00
$440.00 $1,157.10 6 $9,582.60
$0.00 $1,793.51 1 $1,793.51
$0.00 $827.08 9 $7,443.72
$0.00 $2,309.31 4 $9,237.24
$300.00 $827.08 6 $6,762.48
$440.00 $1,157.10 10 $15,971.00
$880.00 $2,690.26 4 $14,281.04
$0.00 $709.05 1 $709.05
 $880.00 $2,690.26 3 $10,710.78
$1,200.00 $3,860.08 9 $45,540.72
$250.00 $709.05 1 $959.05
$0.00 $1,157.10 6 $6,942.60
$0.00 $2,573.39 2 $5,146.78
$0.00 $1,539.54 2 $3,079.08
$0.00 $1,099.03 6 $6,594.18
$0.00 $1,099.03 7 $7,693.21
$0.00 $685.00 8 $5,480.00
$340.00 $852.93 5 $5,964.65
$0.00 $3,860.08 9 $34,740.72
$300.00 $1,145.00 9 $13,005.00
$0.00 $1,793.51 10 $17,935.10
$0.00 $798.00 6 $4,788.00
$880.00 $2,690.26 2 $7,140.52
$0.00 $685.00 7 $4,795.00
$660.00 $1,793.51 4 $9,814.04
$375.00 $1,099.03 5 $7,370.15
$0.00 $798.00 10 $7,980.00
$85.00 $253.00 4 $1,352.00
$680.00 $2,309.31 2 $5,978.62
$510.00 $1,539.54 8 $16,396.32
$0.00 $3,860.08 10 $38,600.80
$170.00 $366.85 1 $536.85
$680.00 $2,309.31 8 $23,914.48
$600.00 $1,660.25 5 $11,301.25
$600.00 $1,660.25 6 $13,561.50
$0.00 $1,099.03 8 $8,792.24
$0.00 $568.60 4 $2,274.40
$0.00 $366.85 6 $2,201.10
$0.00 $3,860.08 2 $7,720.16
$0.00 $993.25 7 $6,952.75
$680.00 $2,309.31 1 $2,989.31
$0.00 $1,793.51 9 $16,141.59
$600.00 $1,660.25 7 $15,821.75
$0.00 $1,240.62 6 $7,443.72
$0.00 $1,648.54 2 $3,297.08
$300.00 $1,145.00 3 $4,335.00
$300.00 $1,145.00 6 $8,670.00
$900.00 $2,573.39 1 $3,473.39
$680.00 $2,309.31 7 $20,925.17
$0.00 $827.08 4 $3,308.32
$0.00 $685.00 3 $2,055.00
$85.00 $253.00 1 $338.00
$400.00 $1,240.62 10 $16,406.20
$340.00 $852.93 4 $4,771.72
$0.00 $1,539.54 6 $9,237.24
$0.00 $368.00 5 $1,840.00
$200.00 $533.60 3 $2,200.80
$0.00 $489.00 2 $978.00
$0.00 $798.00 6 $4,788.00
$170.00 $366.85 4 $2,147.40
$170.00 $685.00 7 $5,985.00
$340.00 $993.25 2 $2,666.50
$170.00 $685.00 1 $855.00
$375.00 $1,099.03 7 $10,318.21
$400.00 $1,240.62 9 $14,765.58
$0.00 $2,573.39 6 $15,440.34
$680.00 $2,309.31 8 $23,914.48
$660.00 $1,793.51 10 $24,535.10
$375.00 $1,099.03 6 $8,844.18
$220.00 $798.00 7 $7,126.00
$0.00 $368.00 5 $1,840.00
$0.00 $1,240.62 3 $3,721.86
$340.00 $852.93 8 $9,543.44
$0.00 $2,309.31 7 $16,165.17
$0.00 $489.00 9 $4,401.00
$0.00 $368.00 6 $2,208.00
$400.00 $1,240.62 10 $16,406.20
$255.00 $568.60 7 $5,765.20
$0.00 $685.00 6 $4,110.00
$660.00 $1,793.51 2 $4,907.02
$0.00 $1,099.03 1 $1,099.03
$440.00 $1,157.10 2 $3,194.20
$125.00 $489.00 2 $1,228.00
$170.00 $366.85 4 $2,147.40
$125.00 $489.00 6 $3,684.00
$0.00 $1,240.62 3 $3,721.86
$85.00 $253.00 2 $676.00
$0.00 $685.00 7 $4,795.00
$0.00 $1,240.62 2 $2,481.24
$0.00 $2,690.26 8 $21,522.08
$500.00 $1,648.54 9 $19,336.86
$375.00 $1,099.03 6 $8,844.18
$0.00 $3,860.08 1 $3,860.08
 catalogo de precios
habitacion
categoria sencilla doble triple suite desayuno/ buffete
1 $253.00 $366.85 $568.60 $852.93 $85.00
2 $368.00 $533.60 $827.08 $1,240.62 $100.00
3 $489.00 $709.05 $1,099.03 $1,648.54 $125.00
4 $685.00 $993.25 $1,539.54 $2,309.31 $170.00
5 $798.00 $1,157.10 $1,793.51 $2,690.26 $220.00
6 $1,145.00 $1,660.25 $2,573.39 $3,860.08 $300.00

estadisticas
¿cuantos clinetes reservaron habitacion con desayuno incluido?
55
"En promedio por cuantas noches se reserva una habitacion"
5.21

¿Cuánto dinero ingreso a la mini agencia de viajes por la resertva de las suites?
$ 472,620.00

muestra graficamente la distribucion parental de las reservas por categoria de hotel

TOTAL DE CADA CATEGORIA

1 12 12%
2 15 15%
3 18 18%
4 19 19%
5 18 18%
6 18 18%
100

18% 12%
1
15% 2
3
18% 4
5
18% 6

19%
incluido?
a resertva de las suites?

ervas por categoria de hotel