PLEASE HELP ME! I will upvote and suggest to ither students too as well! PLEASE HELP ME! I will upvote and suggest to it

[answerhappygod]

PLEASE HELP ME! I will upvote and suggest to ither students too as well!
PLEASE HELP ME! I will upvote and suggest to ither students too as well!

Please Help Me I Will Upvote And Suggest To Ither Students Too As Well Please Help Me I Will Upvote And Suggest To It 1 (95.02 KiB) Viewed 19 times

Please Help Me I Will Upvote And Suggest To Ither Students Too As Well Please Help Me I Will Upvote And Suggest To It 2 (87.77 KiB) Viewed 19 times

Please Help Me I Will Upvote And Suggest To Ither Students Too As Well Please Help Me I Will Upvote And Suggest To It 3 (84.67 KiB) Viewed 19 times

Please Help Me I Will Upvote And Suggest To Ither Students Too As Well Please Help Me I Will Upvote And Suggest To It 4 (69.04 KiB) Viewed 19 times

Please Help Me I Will Upvote And Suggest To Ither Students Too As Well Please Help Me I Will Upvote And Suggest To It 5 (84.95 KiB) Viewed 19 times

Please Help Me I Will Upvote And Suggest To Ither Students Too As Well Please Help Me I Will Upvote And Suggest To It 6 (86.8 KiB) Viewed 19 times

Final Project ECN304 The Scenario: Congratulations. You have just inherited your imcle'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 litend to analyze past sales data to gain insight into the business operations. On BB, under the folder Term Project, you are going to find PROJDATA.XLSX file. The 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. The Analysis: Based on this sample, you seek to answer the following questions: 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) 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? (q=05) b) Test the hypothesis that the average amount of sales o 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? I What to do? Apply the statistical tools that you have learned in class, to the above question using Microsoft Excel or Minitab as a tool. What to hand in: (Do not include the Data Set) Submit a report with your work for parts 1-4 above. For each part above, you should include: a) A description of the statistical technique(s) used to analyze the question and why the technique is appropriate for the desired analysis. b) A narrative descriptions of how the data was (re)organized so as to make the data amenable to a spreadsheet solution c) The numeric output of the spreadsheet, embedded as a number exhibit in your report d) A narrative analysis of your findings, with reference to numbers appearing in each exhibit. c) A management conclusion specifying a course of action to take based on your findings. In essence, you need to describe what you did and why (parts a and b), what you found (parts c and d) and what you conclude (parte). In order to prepare your report, you can use Excel or Minitab and copy and paste your work to MS Word. You can upload an electronic version of your report on BB.
Grading: Your grade will be based on the following: selection of correct technique, proper application of technique, proper interpretation of output, reasonableness of conclusion reached, organization and labeling of spreadsheet, organization and logical flow of report, effectiveness of report, and the technical accuracy of your report (spelling and grammar). The grading template below will be used. Question 2b 3a la 1b 2a 3b Sa Sb Selection of technique - including justification (10 pts) Application of technique (10 points) Interpretation of output (10 points) Organization and labeling of spreadsheet (10 points) Organization and logical flow of report (5 points) Effectiveness of report (5 points) Technical Accuracy of Report (10 points) Question Total Project Total Scaled Project Score 7100 Hints: 1. To complete this project, you may have to apply the following techniques: • Hypothesis test for the difference between means, • Hypothesis test for proportions • ANOVA • Regression Analysis
Canbr AA General ste BTU- O A. 三三三中三 $ - % 69 Conditional Formatting Format as Table Cell Styles Styles board Font Alignment Number > Ix 1 G ORDONNHN с Transaction ID Sale Amount Gender 1 50.8 Female 2 93.5 Male 3 70.2 Female 4 36.3 Female 5 71.5 Female 6 79.7 Male 7 60.3 Female 8 74.5 Male 9 86.4 Female 10 20.6 Male 11 39.8 Male 12 67.4 Male 13 52.2 Female 14 99.9 Female 15 68.9 Male 16 74.5 Male 17 88.5 Female 18 88 Female 19 64.6 Female 20 55.8 Female 21 73 Male 22 64 Female 23 73.7 Female 24 58.7 Female 25 70.1 Female 26 78.7 Female 27 85.1 Female 28 66.3 Male 29 62.8 Male 30 75.4 Female 31 53.3 Female 32 65.2 Female 33 59.2 Male 34 104.6 Female 35 67.3 Female 36 51.5 Male 37 81.4 Male armala Sheet1 Q1 D Payment Type Non-Credit Non-Credit Non-Credit Non-Credit Non-Credit Credit Credit Credit Credit Credit Credit Non-Credit Non-Credit Credit Non-Credit Non-Credit Non-Credit Non-Credit Credit Non-Credit Non-Credit Credit Credit Credit Non-Credit Credit Credit Credit Credit Non-Credit Non-Credit Credit Non-Credit Non-Credit Non-Credit Non-Credit Non-Credit Man Candi Promotion Type Weeks After Advertisement None 2 BOGO 2 BOGO 1 None 0 BOGO 1 BOGO Coupon 1 None BOGO None 2 None 2 Coupon 1 Coupon 2 None 0 Coupon 1 BOGO 0 None 1 BOGO 1 Coupon 1 None 2 BOGO 1 Coupon 1 BOGO 1 Coupon 2 Coupon 2 Coupon 0 BOGO 0 Coupon 1 BOGO 1 Coupon 0 BOGO 2 Coupon 1 Coupon 1 Coupon 2 None 1 Coupon 2 Coupon 0
Clipboard Font Alignment Number F6 fo 1 A B. E Coupon Coupon None Coupon Coupon Coupon None Coupon None None BOGO Coupon 37 38 39 40 41 42 n 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 51.5 Male 81.4 Male 49.6 Female 62.3 Female 54.8 Male 63.4 Male 47.4 Male 65.9 Male 42.2 Female 36.8 Male 88.1 Female 57.8 Male 96.7 Female 77 Female 93 Female 70.5 Female 66.5 Female 84.4 Male 27.6 Male 59 Male 49.1 Male 54.4 Female 63.4 Female 95.1 Female 69.3 Female 72.2 Female 39.1 Male 69.4 Female 60.7 Male 65.2 Female 74.5 Female 44.1 Male 83.1 Female 30.3 Male 49.8 Male 39.5 Male 48.9 Female 70.8 Male D Non-Credit Non-Credit Non-Credit Credit Credit Non-Credit Credit Credit Credit Non-Credit Non-Credit Non-Credit Credit Non-Credit Credit Non-Credit Non-Credit Non-Credit Non-Credit Non-Credit Non-Credit Non-Credit Credit Non-Credit Non-Credit Credit Credit Non-Credit Non-Credit Non-Credit Credit Non-Credit Non-Credit Credit Credit Non-Credit Credit Credit MARCH BOGO Coupon BOGO BOGO Coupon None BOGO Coupon None Coupon Coupon BOGO Coupon BOGO None Coupon Coupon Coupon BOGO BOGO BOGO None None None None BOGO 64 65 66 67 68 69 70 71 72 73 CURA Sheet1 20 All Q1
Alignment Number F6 X 1 A B E 69 70 71 atulati 72 73 74 erite 75 usin 76 None None None None BOGO Coupon BOGO BOGO None BOGO BOGO BOGO None the any 77 78 79 80 81 82 83 84 85 86 87 88 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 30.3 Male 49.8 Male 39.5 Male 48.9 Female 70.8 Male 78.5 Male 107.9 Female 101 Female 47.3 Female 82 Female 110.6 Female 73.7 Female 27 Male 68.9 Female 43.2 Female 61.5 Male 59.5 Male 28.2 Male 83.9 Female 50 Male 91.4 Female 55.8 Female 45.4 Male 103.8 Female 69.5 Female 69.6 Female 72.9 Male 67.1 Female 53.8 Male 94.1 Female 58.3 Female 86.4 Female D Credit Credit Non-Credit Credit Credit Non-Credit Non-Credit Non-Credit Non-Credit Non-Credit Credit Non-Credit Credit Non-Credit Credit Credit Non-Credit Non-Credit Non-Credit Credit Non-Credit Non-Credit Non-Credit Credit Credit Non-Credit Non-Credit Credit Non-Credit Credit Non-Credit Non-Credit is file cause on- 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 Coupon None Coupon Coupon None BOGO None BOGO Coupon None BOGO Coupon Coupon BOGO None Coupon Coupon Coupon Coupon 05) 99 100 104 105 106 107 Sheet1 Q1