Transaction IDSale AmountGenderPayment TypePromotion TypeWeeks After Advertisement150.8FemaleNon-CreditNone2293.5MaleNon-CreditBOGO2370.2FemaleNon-CreditBOGO1436.3FemaleNon-CreditNone0571.5FemaleNon-CreditBOGO1679.7MaleCreditBOGO0760.3FemaleCreditCoupon1874.5MaleCreditNone0986.4FemaleCreditBOGO01020.6MaleCreditNone21139.8MaleCreditNone21267.4MaleNon-CreditCoupon11352.2FemaleNon-CreditCoupon21499.9FemaleCreditNone01568.9MaleNon-CreditCoupon11674.5MaleNon-CreditBOGO01788.5FemaleNon-CreditNone11888FemaleNon-CreditBOGO11964.6FemaleCreditCoupon12055.8FemaleNon-CreditNone22173MaleNon-CreditBOGO12264FemaleCreditCoupon12373.7FemaleCreditBOGO12458.7FemaleCreditCoupon22570.1FemaleNon-CreditCoupon22678.7FemaleCreditCoupon02785.1FemaleCreditBOGO02866.3MaleCreditCoupon12962.8MaleCreditBOGO13075.4FemaleNon-CreditCoupon03153.3FemaleNon-CreditBOGO23265.2FemaleCreditCoupon13359.2MaleNon-CreditCoupon134104.6FemaleNon-CreditCoupon23567.3FemaleNon-CreditNone13651.5MaleNon-CreditCoupon23781.4MaleNon-CreditCoupon03849.6FemaleNon-CreditNone13962.3FemaleCreditCoupon14054.8MaleCreditCoupon24163.4MaleNon-CreditCoupon14247.4MaleCreditNone14365.9MaleCreditCoupon14442.2FemaleCreditNone24536.8MaleNon-CreditNone04688.1FemaleNon-CreditBOGO14757.8MaleNon-CreditCoupon24896.7FemaleCreditBOGO04977FemaleNon-CreditCoupon05093FemaleCreditBOGO05170.5FemaleNon-CreditBOGO15266.5FemaleNon-CreditCoupon15384.4MaleNon-CreditNone05427.6MaleNon-CreditBOGO25559MaleNon-CreditCoupon25649.1MaleNon-CreditNone15754.4FemaleNon-CreditCoupon25863.4FemaleCreditCoupon15995.1FemaleNon-CreditBOGO06069.3FemaleNon-CreditCoupon26172.2FemaleCreditBOGO16239.1MaleCreditNone06369.4FemaleNon-CreditCoupon26460.7MaleNon-CreditCoupon16565.2FemaleNon-CreditCoupon16674.5FemaleCreditBOGO06744.1MaleNon-CreditBOGO26883.1FemaleNon-CreditBOGO06930.3MaleCreditNone27049.8MaleCreditNone17139.5MaleNon-CreditNone07248.9FemaleCreditNone17370.8MaleCreditBOGO17478.5MaleNon-CreditCoupon075107.9FemaleNon-CreditBOGO076101FemaleNon-CreditBOGO27747.3FemaleNon-CreditNone27882FemaleNon-CreditBOGO079110.6FemaleCreditBOGO08073.7FemaleNon-CreditBOGO18127MaleCreditNone28268.9FemaleNon-CreditCoupon18343.2FemaleCreditNone28461.5MaleCreditCoupon18559.5MaleNon-CreditCoupon18628.2MaleNon-CreditNone28783.9FemaleNon-CreditBOGO08850MaleCreditNone18991.4FemaleNon-CreditBOGO09055.8FemaleNon-CreditCoupon29145.4MaleNon-CreditNone292103.8FemaleCreditBOGO29369.5FemaleCreditCoupon29469.6FemaleNon-CreditCoupon29572.9MaleNon-CreditBOGO19667.1FemaleCreditNone19753.8MaleNon-CreditCoupon29894.1FemaleCreditCoupon09958.3FemaleNon-CreditCoupon210086.4FemaleNon-CreditCoupon1 3. What is the lag effectiveness of the current advertising policy? In answering this question, considerthe 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 thanthe average amount of sales 2 weeks after an advertisement. (a=.05)4. Can multiple regression be used to "profile" a sale and determine whether a customer is spendingmore or less than anticipated, i.e. to predict the amount of a sale given the profile of a sale?a) To answer this question, conduct a regression analysis.b) How does the regression analysis support (or not support) your answers to part 1-4 above?Hints:1. To completel you may have to apply the following techniques:Hypothesis test for the difference between means.Hypothesis test for proportionsANOVARegression Analysis Case Scenario:Congratulations. You have just inherited your uncle's business, which is a clothing store. Although thebusiness was successful, your uncle was a "seat of the pants" type of businessman. There was never anysales analysis conducted concerning, e.g. determining the effectiveness of promotional policies. Youintend 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 placeover the previous year. Because all transactions took place during the previous year and all transactionstook place on Saturdays, on non-holiday weekends, you are confident that seasonal and cyclical effectsare absent from the data.Case Analysis:Based on this sample, you seek to answer the following questions (excel please! Thank you!):1. Should you consider targeting males or females in your promotional policy? In answering thisquestion, consider the following:a) Is the proportion of male and female shoppers significantly different? (a=.05)b) Is the average sale amount for males different than the average sales amount for females? (a=.05)2. Should you be encouraging or discouraging credit card sales? In answering this question, considerthe following:a) Is the proportion of credit and non-credit sales significantly different? (a=.05)b) Is the average sale amount for credit sales different than the average sales amount for non-creditsales? (a=.05)

Hello! As you have posted more than 3 sub parts, we are answering the first 3 sub-parts. In case…

Answered: Based on this sample, you seek to…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

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

Transcribed Image Text:3. 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) 4. Can multiple regression be used to "profile" a sale and determine whether a customer is spending more or less than anticipated, i.e. to predict the amount of a sale given the profile of a sale? a) To answer this question, conduct a regression analysis. b) How does the regression analysis support (or not support) your answers to part 1-4 above? Hints: 1. To completel you may have to apply the following techniques: Hypothesis test for the difference between means. Hypothesis test for proportions ANOVA Regression Analysis

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, e.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:
Based on this sample, you seek to answer the following questions (excel please! Thank you!):
1. Should you consider targeting males or females in your promotional policy? In answering this
question, consider the following:
a) Is the proportion of male and female shoppers significantly different? (a=.05)
b) Is the average sale amount for males different than the average sales amount for females? (a=.05)
2. Should you be encouraging or discouraging credit card sales? In answering this question, consider
the following:
a) Is the proportion of credit and non-credit sales significantly different? (a=.05)
b) Is the average sale amount for credit sales different than the average sales amount for non-credit
sales? (a=.05)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here