Question

4.3 Analysis Assignment #4 Note 1: all assignments moving forward must adhere to the appropriate Six Step Process (SSP). As our study materials have specified, the SSP has 3 versions. Version 1 is to be used for all t-tests; for all correlation analyses and Version 3 is be used for all regression analyses. Note 2: The data sets for Q1, Q2 and Q3 below can be downloaded here. Week 4 Analysis Assignments.xlsx Q1: (30 points) Complete the following data analysis: a. Analyze the Wait Times based on the old process versus the new process. What CL do you recommend for the client? Be sure to discuss the reason for your recommendation. b. What are your findings? Do you think the test was successful in the c. Finally, do you think the bank president will allow the manager to install the new process? On what do you base your opinion? of the client? Q2: (30 points) Complete the following data analysis: a. Analyze the difference in the stain removal capability of the two brands of detergent. What CL do you recommend for the test? Be sure to discuss the reason for your recommendation. b. What are your findings? Based on your findings, do you think one brand is clearly better than the other? c. Finally, what do you tell the marketing managers for each brand? Can either brand manager advertise that his/her brand is the best at removing stains? Q3: (35 points) Complete the following analysis as directed a. Scatter plots are useful in determining patterns between two variables. Use the scatter plot option to display the data patterns for each IV with the DV (Sales). The name (definition) of each IV is shown right above the data. Discuss your findings. Note: include the trend line would be helpful. b. Use the correlation option to build a correlation table for the 3 variables. Include all 3 variables in one correlation table. Discuss your findings. Are all of the relationships (e.g., X1 with Y, X2 with Y) statistically significant? How do you know this? Be sure to show your work. c. Run a bi-variate regression model with the IV that has the strongest correlation with Sales as the dependent variable. Note 1: Submit all calculations / statistical output in one Excel file. Title each worksheet with the output "Q1 Results," Q3 regression, etc. Title the file, Name) AA # 4a. (Your Last Note 2: Save your discussion of each problem in one Word file. Title the file," (Your Last Name) AA # 4b." Open the assignment link and select Browse My Computer to upload all files required for grading and Submit on or before the due date to avoid late penalties. 1:02 PM 6/3/2019 Q1: Bank Customer Walting Time Case WT 1 Walting Times (old process) WT 2 Waiting Times (new process) A branch manager of Wonderful Bank devised a new process designed to reduce customer wait times. The branch manager received permission from the bank president to test her new process against the old (existina) process. WT 2 WT 1 70 7.6 69 65 9 1 6.8 The branch manager contacted you to conduct the proper test ess are shorter. She would like 78 6.0 the test to be set up to see if the wait fimes usina the 86 5.1 Once Steps 1 through 5 of the SSP were completed, two samples were taken. 83 9 4 65 In one sample, data were coflected on wait times using the old process. Next, the new process was installed. After a few weeks collected. The second sample contained data collected on wait times using the new process. 7.7 second sample was 7.2 69 5.4 7.1 4.1 6.2 7.2 As always, use the 6 step process. 5.8 5.9 4.8 Provide details on what must be accomplished in each of the 6 steps. 7.7 8.9 5.9 6.7 7.5 5.7 Notes: Observations for each of the two samples have been collected (data on the left). Let me assure you that the sampling design is completely valid. 5.6 8.2 3.0 8.3 7.7 7.7 The data collected is based on the total wait time once a customer enters the cue 6.6 6.3 The Wait time is recorded in minutes. 8.5 5.6 8.8 6.9 8.0 8.1 8.2 8.3 7.6 8.2 Be sure to support each decision you make with appropriate rationale. 5.5 6.1 5.8 Make sure you put your name on all submissions 7.6 6.5 Final Note: Even if the average wait time for the new process is less than the average wait time for the old process, do you think that the difference large enough to make a difference to the bank president? Keep in mind that installing the new process would cause disruption, require additional training, and perhaps an upgrade in equipment. 7.1 6.3 6.2 6.8 7.0 7.9 8.4 7.8 8.6 8.7 7.5 7.3 5.8 7.9 5.1 7.2 6.9 6.1 8.8 6.2 5.3 7.4 8.1 7.0 8.5 7.1 6.2 8.8 7.6 7.5 7.7 7.7 7.8 70 6.2 5.1 6.8 9.3 8.5 7.2 73 9.2 9.4 9.5 7.5 6.8 8.3 9.7 6.2 8.4 8.6 8.2 9.1 8.3 8.7 9.2 9.5 Week 4 Analysis Assignment (con't) Q2: Stain Removal Case SS_1 Stain Score (Brand A) SS 2 Stain Score (Brand B) Two laundry detergent brands (Brands A & B) are both claiming that their brand does the SS A SS B of taking out stains. Unfortunately, they used two different tests 1 0.433 0.233 0.333 to prove their claim, so they agreed to hire an independent lab to test both brands. 2 0.333 The lab technician contacted you to design and ran the appropriate analysis. You decided that a number of different stains should be applied to a variety of different materials (35 separate materials). Each sta and Brand 0.073 0.193 4 area is divided in half 0.363 0.973 0.203 0.583 0.493 5 0.922 o the other half. Both stain After cleaning, the stain was 6 0.363 one half and Brand B was applied 7 0.633 areas of each material were carefully cleaned. Af examined with a scientific instrument and a score was obtained for the area cleaned by Brand A and the for the area cleaned by Brand B The lower the score, the more effect the job of removing the stain. A higher score indicates a less effective job. Keep in mind that these are paired scores since both brands were used on each piece of cothing. The stain scores for each piece of clothing are provided on the left (1 thru 35). 8 0.333 0.133 0.933 0.723 10 0.193 0.673 0.143 11 12 0.033 0.133 0.053 13 0.833 0.463 14 0.563 15 0.633 0.763 Provide details on what must be accomplished in each of the 6 steps of the Six Step Process. 0.173 16 0.533 0.053 17 Notes: 0.293 0.233 18 0.123 19 0.433 Be sure to support each decision you make with appropriate rationale. 0.403 20 0.813 0.213 0.933 21 Make sure you put your name on all submissions 0.473 0.733 22 0.383 23 0.913 Final Note: Is the difference in the Stain Scores between the two brands large enough to actually make a difference? 0.523 0.633 24 0.303 25 0.333 0.513 0.413 26 0.083 27 0.833 How would you put the answer to this question into perspective if you were trying to explain the results of this test to one of the managers from either company? 28 0.233 29 0.963 0.023 0.123 0.063 0.933 30 0.973 0.233 31 0.903 0.263 32 0.353 0.973 33 0.193 0.163 34 0.483 0.053 35 Q3: Store Performance Yearly Advertising Budget (in $1,000s) Number of Competitor Stores Annual Net Sales ($1,000s) X1 X2 Y Y X2 X1 $8.2 $6.9 $2.1 $5.8 $14.8 $11.8 $8.1 $7.7 $3.3 $11.3 $17.4 $10.5 $11.3 $2.5 $4.7 $12.9 $5.5 $4.9 $10.4 $14.5 $131 $86 $90 $319 $243 $387 $139 $65 $84 $68 $275 $428 $464 $132 $298 $180 11 1 12 15 1 5 4 10 7 12 15 13 10 11 7 12 3 13 14 14 15 10 16 $398 $98 $397 $207 $328 4 17 13 18 7 19 20 6 21 $16.2 $2.8 $2.4 3 22 14 $54 23 $295 $147 $341 $267 $400 7 24 $9.6 $9.8 $14.9 $7.0 8 25 26 3 27 234t 56