Project #72988 - Assn 4 updated 6-4-15

Analysis Assignment (AA) #4 – Due by Sunday (total of 75 points)
 

Note:  please use the Assignments link and follow the instructions for uploading your assignment. I have also included the assignment description below, but it should also be visible under the Assignments link (where you should upload your response). In addition, all Excel files required to complete this assignment are also attached to the Assignment 4 link.

 

Q1: (25 points) Using the data set titled, “Bank Customer Wait Time

Case,” complete the following data analysis:

a.     Using the 6 Step process, 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 eyes of the client?

c.     Finally, do you think the bank president will allow the manager to install the new process?  On what do you base your opinion?  

 

Q2: (25 points) Using the data set titled, “Stain Removal Case,”

complete the following data analysis: 

a.     Using the 6 Step process, 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: (25 points) Using the data set titled, “AA 5 CC Demo 1,” complete the following analysis using correlation: 

a.     Scatter plots are useful in determining patterns between two variables.  The CC Demo data set has a number of variables that may be related to Credit Score (V10).  Use the scatter plot option to display the data patterns for V3 (age) with V10.  Next, compare V4 (Income) with V10.  Discuss your findings. 

a.     Use the correlation option to build a correlation table for V3 and V10 and then comparing V4 with V10.  Discuss your findings.  Are either of the relationships statistically significant?  How do you know this?  

Note 1:  be sure to save all of your work with a title such as “AA # 4 ____ (your last name). 

Note 2:  make sure you attach all files required for grading when you submit your assignment.  This includes: 
1) your Word document with your discussion of each problem.
2) your MegaStat output for Prob. 1,
3) your MegaStat output for Prob. 2, and
4) your MegaStat output for Prob. 3.

File #1

 

Subject Mathematics
Due By (Pacific Time) 06/06/2015 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy