Note: use excel only please (regression). thank you!1 $ 50.80FemaleNon-CreditNone22 $ 93.50MaleNon-CreditBOGO23 $ 70.20FemaleNon-CreditBOGO14 $ 36.30FemaleNon-CreditNone05 $ 71.50FemaleNon-CreditBOGO16 $ 79.70MaleCreditBOGO07 $ 60.30FemaleCreditCoupon18 $ 74.50MaleCreditNone09 $ 86.40FemaleCreditBOGO010 $ 20.60MaleCreditNone211 $ 39.80MaleCreditNone212 $ 67.40MaleNon-CreditCoupon113 $ 52.20FemaleNon-CreditCoupon214 $ 99.90FemaleCreditNone015 $ 68.90MaleNon-CreditCoupon116 $ 74.50MaleNon-CreditBOGO017 $ 88.50FemaleNon-CreditNone118 $ 88.00FemaleNon-CreditBOGO119 $ 64.60FemaleCreditCoupon120 $ 55.80FemaleNon-CreditNone221 $ 73.00MaleNon-CreditBOGO122 $ 64.00FemaleCreditCoupon123 $ 73.70FemaleCreditBOGO124 $ 58.70FemaleCreditCoupon225 $ 70.10FemaleNon-CreditCoupon226 $ 78.70FemaleCreditCoupon027 $ 85.10FemaleCreditBOGO028 $ 66.30MaleCreditCoupon129 $ 62.80MaleCreditBOGO130 $ 75.40FemaleNon-CreditCoupon031 $ 53.30FemaleNon-CreditBOGO232 $ 65.20FemaleCreditCoupon133 $ 59.20MaleNon-CreditCoupon134 $ 104.60FemaleNon-CreditCoupon235 $ 67.30FemaleNon-CreditNone136 $ 51.50MaleNon-CreditCoupon237 $ 81.40MaleNon-CreditCoupon038 $ 49.60FemaleNon-CreditNone139 $ 62.30FemaleCreditCoupon140 $ 54.80MaleCreditCoupon241 $ 63.40MaleNon-CreditCoupon142 $ 47.40MaleCreditNone143 $ 65.90MaleCreditCoupon144 $ 42.20FemaleCreditNone245 $ 36.80MaleNon-CreditNone046 $ 88.10FemaleNon-CreditBOGO147 $ 57.80MaleNon-CreditCoupon248 $ 96.70FemaleCreditBOGO049 $ 77.00FemaleNon-CreditCoupon050 $ 93.00FemaleCreditBOGO051 $ 70.50FemaleNon-CreditBOGO152 $ 66.50FemaleNon-CreditCoupon153 $ 84.40MaleNon-CreditNone054 $ 27.60MaleNon-CreditBOGO255 $ 59.00MaleNon-CreditCoupon256 $ 49.10MaleNon-CreditNone157 $ 54.40FemaleNon-CreditCoupon258 $ 63.40FemaleCreditCoupon159 $ 95.10FemaleNon-CreditBOGO060 $ 69.30FemaleNon-CreditCoupon261 $ 72.20FemaleCreditBOGO162 $ 39.10MaleCreditNone063 $ 69.40FemaleNon-CreditCoupon264 $ 60.70MaleNon-CreditCoupon165 $ 65.20FemaleNon-CreditCoupon166 $ 74.50FemaleCreditBOGO067 $ 44.10MaleNon-CreditBOGO268 $ 83.10FemaleNon-CreditBOGO069 $ 30.30MaleCreditNone270 $ 49.80MaleCreditNone171 $ 39.50MaleNon-CreditNone072 $ 48.90FemaleCreditNone173 $ 70.80MaleCreditBOGO174 $ 78.50MaleNon-CreditCoupon075 $ 107.90FemaleNon-CreditBOGO076 $ 101.00FemaleNon-CreditBOGO277 $ 47.30FemaleNon-CreditNone278 $ 82.00FemaleNon-CreditBOGO079 $ 110.60FemaleCreditBOGO080 $ 73.70FemaleNon-CreditBOGO181 $ 27.00MaleCreditNone282 $ 68.90FemaleNon-CreditCoupon183 $ 43.20FemaleCreditNone284 $ 61.50MaleCreditCoupon185 $ 59.50MaleNon-CreditCoupon186 $ 28.20MaleNon-CreditNone287 $ 83.90FemaleNon-CreditBOGO088 $ 50.00MaleCreditNone189 $ 91.40FemaleNon-CreditBOGO090 $ 55.80FemaleNon-CreditCoupon291 $ 45.40MaleNon-CreditNone292 $ 103.80FemaleCreditBOGO293 $ 69.50FemaleCreditCoupon294 $ 69.60FemaleNon-CreditCoupon295 $ 72.90MaleNon-CreditBOGO196 $ 67.10FemaleCreditNone197 $ 53.80MaleNon-CreditCoupon298 $ 94.10FemaleCreditCoupon099 $ 58.30FemaleNon-CreditCoupon2100 $ 86.40FemaleNon-CreditCoupon1 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.The Analysis:Based on this sample, you seek to answer the following question:1. 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 ofa sale?a) To answer this question, conduct a regression analysis.

Question

Note: use excel only please (regression). thank you!1 $              50.80FemaleNon-CreditNone22 $              93.50MaleNon-CreditBOGO23 $              70.20FemaleNon-CreditBOGO14 $              36.30FemaleNon-CreditNone05 $              71.50FemaleNon-CreditBOGO16 $              79.70MaleCreditBOGO07 $              60.30FemaleCreditCoupon18 $              74.50MaleCreditNone09 $              86.40FemaleCreditBOGO010 $              20.60MaleCreditNone211 $              39.80MaleCreditNone212 $              67.40MaleNon-CreditCoupon113 $              52.20FemaleNon-CreditCoupon214 $              99.90FemaleCreditNone015 $              68.90MaleNon-CreditCoupon116 $              74.50MaleNon-CreditBOGO017 $              88.50FemaleNon-CreditNone118 $              88.00FemaleNon-CreditBOGO119 $              64.60FemaleCreditCoupon120 $              55.80FemaleNon-CreditNone221 $              73.00MaleNon-CreditBOGO122 $              64.00FemaleCreditCoupon123 $              73.70FemaleCreditBOGO124 $              58.70FemaleCreditCoupon225 $              70.10FemaleNon-CreditCoupon226 $              78.70FemaleCreditCoupon027 $              85.10FemaleCreditBOGO028 $              66.30MaleCreditCoupon129 $              62.80MaleCreditBOGO130 $              75.40FemaleNon-CreditCoupon031 $              53.30FemaleNon-CreditBOGO232 $              65.20FemaleCreditCoupon133 $              59.20MaleNon-CreditCoupon134 $            104.60FemaleNon-CreditCoupon235 $              67.30FemaleNon-CreditNone136 $              51.50MaleNon-CreditCoupon237 $              81.40MaleNon-CreditCoupon038 $              49.60FemaleNon-CreditNone139 $              62.30FemaleCreditCoupon140 $              54.80MaleCreditCoupon241 $              63.40MaleNon-CreditCoupon142 $              47.40MaleCreditNone143 $              65.90MaleCreditCoupon144 $              42.20FemaleCreditNone245 $              36.80MaleNon-CreditNone046 $              88.10FemaleNon-CreditBOGO147 $              57.80MaleNon-CreditCoupon248 $              96.70FemaleCreditBOGO049 $              77.00FemaleNon-CreditCoupon050 $              93.00FemaleCreditBOGO051 $              70.50FemaleNon-CreditBOGO152 $              66.50FemaleNon-CreditCoupon153 $              84.40MaleNon-CreditNone054 $              27.60MaleNon-CreditBOGO255 $              59.00MaleNon-CreditCoupon256 $              49.10MaleNon-CreditNone157 $              54.40FemaleNon-CreditCoupon258 $              63.40FemaleCreditCoupon159 $              95.10FemaleNon-CreditBOGO060 $              69.30FemaleNon-CreditCoupon261 $              72.20FemaleCreditBOGO162 $              39.10MaleCreditNone063 $              69.40FemaleNon-CreditCoupon264 $              60.70MaleNon-CreditCoupon165 $              65.20FemaleNon-CreditCoupon166 $              74.50FemaleCreditBOGO067 $              44.10MaleNon-CreditBOGO268 $              83.10FemaleNon-CreditBOGO069 $              30.30MaleCreditNone270 $              49.80MaleCreditNone171 $              39.50MaleNon-CreditNone072 $              48.90FemaleCreditNone173 $              70.80MaleCreditBOGO174 $              78.50MaleNon-CreditCoupon075 $            107.90FemaleNon-CreditBOGO076 $            101.00FemaleNon-CreditBOGO277 $              47.30FemaleNon-CreditNone278 $              82.00FemaleNon-CreditBOGO079 $            110.60FemaleCreditBOGO080 $              73.70FemaleNon-CreditBOGO181 $              27.00MaleCreditNone282 $              68.90FemaleNon-CreditCoupon183 $              43.20FemaleCreditNone284 $              61.50MaleCreditCoupon185 $              59.50MaleNon-CreditCoupon186 $              28.20MaleNon-CreditNone287 $              83.90FemaleNon-CreditBOGO088 $              50.00MaleCreditNone189 $              91.40FemaleNon-CreditBOGO090 $              55.80FemaleNon-CreditCoupon291 $              45.40MaleNon-CreditNone292 $            103.80FemaleCreditBOGO293 $              69.50FemaleCreditCoupon294 $              69.60FemaleNon-CreditCoupon295 $              72.90MaleNon-CreditBOGO196 $              67.10FemaleCreditNone197 $              53.80MaleNon-CreditCoupon298 $              94.10FemaleCreditCoupon099 $              58.30FemaleNon-CreditCoupon2100 $              86.40FemaleNon-CreditCoupon1 Case Scenario:Congratulations. You have just inherited your uncle's business, which is a clothing store. Although thebusiness was successful, your uncle was a &#34;seat of the pants&#34; 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.The Analysis:Based on this sample, you seek to answer the following question:1. Can multiple regression be used to &#34;profile&#34; 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 ofa sale?a) To answer this question, conduct a regression analysis.

Accepted Answer

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

1
50.8…

1	$ 50.80	Female	Non-Credit	None	2
2	$ 93.50	Male	Non-Credit	BOGO	2
3	$ 70.20	Female	Non-Credit	BOGO	1
4	$ 36.30	Female	Non-Credit	None	0
5	$ 71.50	Female	Non-Credit	BOGO	1
6	$ 79.70	Male	Credit	BOGO	0
7	$ 60.30	Female	Credit	Coupon	1
8	$ 74.50	Male	Credit	None	0
9	$ 86.40	Female	Credit	BOGO	0
10	$ 20.60	Male	Credit	None	2
11	$ 39.80	Male	Credit	None	2
12	$ 67.40	Male	Non-Credit	Coupon	1
13	$ 52.20	Female	Non-Credit	Coupon	2
14	$ 99.90	Female	Credit	None	0
15	$ 68.90	Male	Non-Credit	Coupon	1
16	$ 74.50	Male	Non-Credit	BOGO	0
17	$ 88.50	Female	Non-Credit	None	1
18	$ 88.00	Female	Non-Credit	BOGO	1
19	$ 64.60	Female	Credit	Coupon	1
20	$ 55.80	Female	Non-Credit	None	2
21	$ 73.00	Male	Non-Credit	BOGO	1
22	$ 64.00	Female	Credit	Coupon	1
23	$ 73.70	Female	Credit	BOGO	1
24	$ 58.70	Female	Credit	Coupon	2
25	$ 70.10	Female	Non-Credit	Coupon	2
26	$ 78.70	Female	Credit	Coupon	0
27	$ 85.10	Female	Credit	BOGO	0
28	$ 66.30	Male	Credit	Coupon	1
29	$ 62.80	Male	Credit	BOGO	1
30	$ 75.40	Female	Non-Credit	Coupon	0
31	$ 53.30	Female	Non-Credit	BOGO	2
32	$ 65.20	Female	Credit	Coupon	1
33	$ 59.20	Male	Non-Credit	Coupon	1
34	$ 104.60	Female	Non-Credit	Coupon	2
35	$ 67.30	Female	Non-Credit	None	1
36	$ 51.50	Male	Non-Credit	Coupon	2
37	$ 81.40	Male	Non-Credit	Coupon	0
38	$ 49.60	Female	Non-Credit	None	1
39	$ 62.30	Female	Credit	Coupon	1
40	$ 54.80	Male	Credit	Coupon	2
41	$ 63.40	Male	Non-Credit	Coupon	1
42	$ 47.40	Male	Credit	None	1
43	$ 65.90	Male	Credit	Coupon	1
44	$ 42.20	Female	Credit	None	2
45	$ 36.80	Male	Non-Credit	None	0
46	$ 88.10	Female	Non-Credit	BOGO	1
47	$ 57.80	Male	Non-Credit	Coupon	2
48	$ 96.70	Female	Credit	BOGO	0
49	$ 77.00	Female	Non-Credit	Coupon	0
50	$ 93.00	Female	Credit	BOGO	0
51	$ 70.50	Female	Non-Credit	BOGO	1
52	$ 66.50	Female	Non-Credit	Coupon	1
53	$ 84.40	Male	Non-Credit	None	0
54	$ 27.60	Male	Non-Credit	BOGO	2
55	$ 59.00	Male	Non-Credit	Coupon	2
56	$ 49.10	Male	Non-Credit	None	1
57	$ 54.40	Female	Non-Credit	Coupon	2
58	$ 63.40	Female	Credit	Coupon	1
59	$ 95.10	Female	Non-Credit	BOGO	0
60	$ 69.30	Female	Non-Credit	Coupon	2
61	$ 72.20	Female	Credit	BOGO	1
62	$ 39.10	Male	Credit	None	0
63	$ 69.40	Female	Non-Credit	Coupon	2
64	$ 60.70	Male	Non-Credit	Coupon	1
65	$ 65.20	Female	Non-Credit	Coupon	1
66	$ 74.50	Female	Credit	BOGO	0
67	$ 44.10	Male	Non-Credit	BOGO	2
68	$ 83.10	Female	Non-Credit	BOGO	0
69	$ 30.30	Male	Credit	None	2
70	$ 49.80	Male	Credit	None	1
71	$ 39.50	Male	Non-Credit	None	0
72	$ 48.90	Female	Credit	None	1
73	$ 70.80	Male	Credit	BOGO	1
74	$ 78.50	Male	Non-Credit	Coupon	0
75	$ 107.90	Female	Non-Credit	BOGO	0
76	$ 101.00	Female	Non-Credit	BOGO	2
77	$ 47.30	Female	Non-Credit	None	2
78	$ 82.00	Female	Non-Credit	BOGO	0
79	$ 110.60	Female	Credit	BOGO	0
80	$ 73.70	Female	Non-Credit	BOGO	1
81	$ 27.00	Male	Credit	None	2
82	$ 68.90	Female	Non-Credit	Coupon	1
83	$ 43.20	Female	Credit	None	2
84	$ 61.50	Male	Credit	Coupon	1
85	$ 59.50	Male	Non-Credit	Coupon	1
86	$ 28.20	Male	Non-Credit	None	2
87	$ 83.90	Female	Non-Credit	BOGO	0
88	$ 50.00	Male	Credit	None	1
89	$ 91.40	Female	Non-Credit	BOGO	0
90	$ 55.80	Female	Non-Credit	Coupon	2
91	$ 45.40	Male	Non-Credit	None	2
92	$ 103.80	Female	Credit	BOGO	2
93	$ 69.50	Female	Credit	Coupon	2
94	$ 69.60	Female	Non-Credit	Coupon	2
95	$ 72.90	Male	Non-Credit	BOGO	1
96	$ 67.10	Female	Credit	None	1
97	$ 53.80	Male	Non-Credit	Coupon	2
98	$ 94.10	Female	Credit	Coupon	0
99	$ 58.30	Female	Non-Credit	Coupon	2
100	$ 86.40	Female	Non-Credit	Coupon	1

70.20 Female Non-Credit BOGO 1 4 $ 36.30 Female