Hints: to complete, you may have to apply the following techniques

Hypothesis test for the difference between means

Hypothesis test for proportions

ANOVA

Transaction ID Sale Amount Gender Payment Type Promotion Type Weeks After Advertisement

1 50.8 Female Non-Credit None 2

2 93.5 Male Non-Credit BOGO 2

3 70.2 Female Non-Credit BOGO 1

4 36.3 Female Non-Credit None 0

5 71.5 Female Non-Credit BOGO 1

6 79.7 Male Credit BOGO 0

7 60.3 Female Credit Coupon 1

8 74.5 Male Credit None 0

9 86.4 Female Credit BOGO 0

10 20.6 Male Credit None 2

11 39.8 Male Credit None 2

12 67.4 Male Non-Credit Coupon 1

13 52.2 Female Non-Credit Coupon 2

14 99.9 Female Credit None 0

15 68.9 Male Non-Credit Coupon 1

16 74.5 Male Non-Credit BOGO 0

17 88.5 Female Non-Credit None 1

18 88 Female Non-Credit BOGO 1

19 64.6 Female Credit Coupon 1

20 55.8 Female Non-Credit None 2

21 73 Male Non-Credit BOGO 1

22 64 Female Credit Coupon 1

23 73.7 Female Credit BOGO 1

24 58.7 Female Credit Coupon 2

25 70.1 Female Non-Credit Coupon 2

26 78.7 Female Credit Coupon 0

27 85.1 Female Credit BOGO 0

28 66.3 Male Credit Coupon 1

29 62.8 Male Credit BOGO 1

30 75.4 Female Non-Credit Coupon 0

31 53.3 Female Non-Credit BOGO 2

32 65.2 Female Credit Coupon 1

33 59.2 Male Non-Credit Coupon 1

34 104.6 Female Non-Credit Coupon 2

35 67.3 Female Non-Credit None 1

36 51.5 Male Non-Credit Coupon 2

37 81.4 Male Non-Credit Coupon 0

38 49.6 Female Non-Credit None 1

39 62.3 Female Credit Coupon 1

40 54.8 Male Credit Coupon 2

41 63.4 Male Non-Credit Coupon 1

42 47.4 Male Credit None 1

43 65.9 Male Credit Coupon 1

44 42.2 Female Credit None 2

45 36.8 Male Non-Credit None 0

46 88.1 Female Non-Credit BOGO 1

47 57.8 Male Non-Credit Coupon 2

48 96.7 Female Credit BOGO 0

49 77 Female Non-Credit Coupon 0

50 93 Female Credit BOGO 0

51 70.5 Female Non-Credit BOGO 1

52 66.5 Female Non-Credit Coupon 1

53 84.4 Male Non-Credit None 0

54 27.6 Male Non-Credit BOGO 2

55 59 Male Non-Credit Coupon 2

56 49.1 Male Non-Credit None 1

57 54.4 Female Non-Credit Coupon 2

58 63.4 Female Credit Coupon 1

59 95.1 Female Non-Credit BOGO 0

60 69.3 Female Non-Credit Coupon 2

61 72.2 Female Credit BOGO 1

62 39.1 Male Credit None 0

63 69.4 Female Non-Credit Coupon 2

64 60.7 Male Non-Credit Coupon 1

65 65.2 Female Non-Credit Coupon 1

66 74.5 Female Credit BOGO 0

67 44.1 Male Non-Credit BOGO 2

68 83.1 Female Non-Credit BOGO 0

69 30.3 Male Credit None 2

70 49.8 Male Credit None 1

71 39.5 Male Non-Credit None 0

72 48.9 Female Credit None 1

73 70.8 Male Credit BOGO 1

74 78.5 Male Non-Credit Coupon 0

75 107.9 Female Non-Credit BOGO 0

76 101 Female Non-Credit BOGO 2

77 47.3 Female Non-Credit None 2

78 82 Female Non-Credit BOGO 0

79 110.6 Female Credit BOGO 0

80 73.7 Female Non-Credit BOGO 1

81 27 Male Credit None 2

82 68.9 Female Non-Credit Coupon 1

83 43.2 Female Credit None 2

84 61.5 Male Credit Coupon 1

85 59.5 Male Non-Credit Coupon 1

86 28.2 Male Non-Credit None 2

87 83.9 Female Non-Credit BOGO 0

88 50 Male Credit None 1

89 91.4 Female Non-Credit BOGO 0

90 55.8 Female Non-Credit Coupon 2

91 45.4 Male Non-Credit None 2

92 103.8 Female Credit BOGO 2

93 69.5 Female Credit Coupon 2

94 69.6 Female Non-Credit Coupon 2

95 72.9 Male Non-Credit BOGO 1

96 67.1 Female Credit None 1

97 53.8 Male Non-Credit Coupon 2

98 94.1 Female Credit Coupon 0

99 58.3 Female Non-Credit Coupon 2

100 86.4 Female Non-Credit Coupon 1

Question

Hints: to complete, you may have to apply the following techniques

Hypothesis test for the difference between means

Hypothesis test for proportions

ANOVA

Transaction ID	Sale Amount	Gender	Payment Type	Promotion Type	Weeks After Advertisement
1	50.8	Female	Non-Credit	None	2
2	93.5	Male	Non-Credit	BOGO	2
3	70.2	Female	Non-Credit	BOGO	1
4	36.3	Female	Non-Credit	None	0
5	71.5	Female	Non-Credit	BOGO	1
6	79.7	Male	Credit	BOGO	0
7	60.3	Female	Credit	Coupon	1
8	74.5	Male	Credit	None	0
9	86.4	Female	Credit	BOGO	0
10	20.6	Male	Credit	None	2
11	39.8	Male	Credit	None	2
12	67.4	Male	Non-Credit	Coupon	1
13	52.2	Female	Non-Credit	Coupon	2
14	99.9	Female	Credit	None	0
15	68.9	Male	Non-Credit	Coupon	1
16	74.5	Male	Non-Credit	BOGO	0
17	88.5	Female	Non-Credit	None	1
18	88	Female	Non-Credit	BOGO	1
19	64.6	Female	Credit	Coupon	1
20	55.8	Female	Non-Credit	None	2
21	73	Male	Non-Credit	BOGO	1
22	64	Female	Credit	Coupon	1
23	73.7	Female	Credit	BOGO	1
24	58.7	Female	Credit	Coupon	2
25	70.1	Female	Non-Credit	Coupon	2
26	78.7	Female	Credit	Coupon	0
27	85.1	Female	Credit	BOGO	0
28	66.3	Male	Credit	Coupon	1
29	62.8	Male	Credit	BOGO	1
30	75.4	Female	Non-Credit	Coupon	0
31	53.3	Female	Non-Credit	BOGO	2
32	65.2	Female	Credit	Coupon	1
33	59.2	Male	Non-Credit	Coupon	1
34	104.6	Female	Non-Credit	Coupon	2
35	67.3	Female	Non-Credit	None	1
36	51.5	Male	Non-Credit	Coupon	2
37	81.4	Male	Non-Credit	Coupon	0
38	49.6	Female	Non-Credit	None	1
39	62.3	Female	Credit	Coupon	1
40	54.8	Male	Credit	Coupon	2
41	63.4	Male	Non-Credit	Coupon	1
42	47.4	Male	Credit	None	1
43	65.9	Male	Credit	Coupon	1
44	42.2	Female	Credit	None	2
45	36.8	Male	Non-Credit	None	0
46	88.1	Female	Non-Credit	BOGO	1
47	57.8	Male	Non-Credit	Coupon	2
48	96.7	Female	Credit	BOGO	0
49	77	Female	Non-Credit	Coupon	0
50	93	Female	Credit	BOGO	0
51	70.5	Female	Non-Credit	BOGO	1
52	66.5	Female	Non-Credit	Coupon	1
53	84.4	Male	Non-Credit	None	0
54	27.6	Male	Non-Credit	BOGO	2
55	59	Male	Non-Credit	Coupon	2
56	49.1	Male	Non-Credit	None	1
57	54.4	Female	Non-Credit	Coupon	2
58	63.4	Female	Credit	Coupon	1
59	95.1	Female	Non-Credit	BOGO	0
60	69.3	Female	Non-Credit	Coupon	2
61	72.2	Female	Credit	BOGO	1
62	39.1	Male	Credit	None	0
63	69.4	Female	Non-Credit	Coupon	2
64	60.7	Male	Non-Credit	Coupon	1
65	65.2	Female	Non-Credit	Coupon	1
66	74.5	Female	Credit	BOGO	0
67	44.1	Male	Non-Credit	BOGO	2
68	83.1	Female	Non-Credit	BOGO	0
69	30.3	Male	Credit	None	2
70	49.8	Male	Credit	None	1
71	39.5	Male	Non-Credit	None	0
72	48.9	Female	Credit	None	1
73	70.8	Male	Credit	BOGO	1
74	78.5	Male	Non-Credit	Coupon	0
75	107.9	Female	Non-Credit	BOGO	0
76	101	Female	Non-Credit	BOGO	2
77	47.3	Female	Non-Credit	None	2
78	82	Female	Non-Credit	BOGO	0
79	110.6	Female	Credit	BOGO	0
80	73.7	Female	Non-Credit	BOGO	1
81	27	Male	Credit	None	2
82	68.9	Female	Non-Credit	Coupon	1
83	43.2	Female	Credit	None	2
84	61.5	Male	Credit	Coupon	1
85	59.5	Male	Non-Credit	Coupon	1
86	28.2	Male	Non-Credit	None	2
87	83.9	Female	Non-Credit	BOGO	0
88	50	Male	Credit	None	1
89	91.4	Female	Non-Credit	BOGO	0
90	55.8	Female	Non-Credit	Coupon	2
91	45.4	Male	Non-Credit	None	2
92	103.8	Female	Credit	BOGO	2
93	69.5	Female	Credit	Coupon	2
94	69.6	Female	Non-Credit	Coupon	2
95	72.9	Male	Non-Credit	BOGO	1
96	67.1	Female	Credit	None	1
97	53.8	Male	Non-Credit	Coupon	2
98	94.1	Female	Credit	Coupon	0
99	58.3	Female	Non-Credit	Coupon	2
100	86.4	Female	Non-Credit	Coupon	1

ASK AN EXPERT
Case Scenario:
Congratulations. You have just inherited your uncle's business, which is a clothing store. Although the
business was successful, your uncle was a "seat of the pants" type of businessman. There was never any
sales analysis conducted concerning, c.g. determining the effectiveness of promotional policies. You
intend to analyze past sales data to gain insight into the business operations.
The following data in this file corresponds to a random sample of 100 sales transactions that took place
over the previous year. Because all transactions took place during the previous year and all transactions
took place on Saturdays, on non-holiday weekends, you are confident that seasonal and cyclical effects
are absent from the data.
Case Analysis: (use excel functions when necessary. Thank yor)
Based on this sample, you seek to answer the following questions:
1. What is the lag effectiveness of the current advertising policy? In answering this question, consider
the following:
a) Does the average amount of sales differ 0, 1, and 2 weeks after an advertisement? (a=.05)
b) Test the hypothesis that the average amount of sales 0 weeks after an advertisement is larger than
the average amount of sales 2 weeks after an advertisement. (a-.05)

Accepted Answer

1.
a)
Null Hypothesis:
H0: There is no difference in the average amount of sales among 0, 1, 2…

Based on this sample, you seek to answer the following questions: 1. What is the lag effectiveness of the current advertising policy? In answering this question, consider the following: Docs the averags amount of sales differ 0, 1. and 2 weeks after an advertisement? (a=05)