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-CreditCoupon1Please showhow you would compute answers in excel spreedsheet. The excel prodecure The 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 ofpromotional policies. You intend to analyze past sales data to gain insight into the businessoperations.On BB, under the folder Term Project, you are going to find PROJDATA.XLSX file. The datain this file corresponds to a random sample of 100 sales transactions that took place over theprevious 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 cyclicaleffects are absent from the data.The Analysis:Based on this sample, you seek to answer the following questions: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 fornon-credit sales? (a=.05)

Given Information: Consider the given data: Credit sales Non-credit sales 79.7 50.8 60.3…

Answered: The Scenario: Congratulations. You have…

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

100%

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