Question 1

A airline company has run a campaign to increase the number of customers to purchase extra baggage to avoid being compound with surcharge for overweight baggage. Before the campaign, only half of the total customers purchased the extra baggage. The campaign manager believes that the campaign has increased the percentage of customers purchasing an extra baggage to more than 55 percent. A data on 80 customers who purchased the computer in the previous month is provided in the file Data1. Is there statistical support that the campaign has successfully increased the proportion of customers purchasing an extra baggage to more than 55%? Use alpha = 0.05.

*please help to use excel to show the working.

File Data1

Unit	Extra Baggage
1	No
2	No
3	No
4	Yes
5	Yes
6	No
7	No
8	Yes
9	No
10	Yes
11	No
12	No
13	Yes
14	Yes
15	No
16	No
17	No
18	Yes
19	No
20	No
21	Yes
22	Yes
23	No
24	Yes
25	No
26	Yes
27	Yes
28	Yes
29	Yes
30	Yes
31	Yes
32	No
33	No
34	No
35	No
36	Yes
37	No
38	Yes
39	No
40	Yes
41	No
42	No
43	Yes
44	No
45	Yes
46	No
47	No
48	Yes
49	Yes
50	Yes
51	Yes
52	No
53	No
54	No
55	No
56	No
57	No
58	No
59	Yes
60	No
61	No
62	Yes
63	No
64	No
65	No
66	No
67	No
68	Yes
69	Yes
70	No
71	Yes
72	yes
73	no
74	no
75	yes
76	yes
77	no
78	no
79	yes
80	yes