Can you please advise me on how the breakdown of SSP version 1 and version 2 goes so that I can get an understanding of how to do my assignment. Thanks!

BUS 6073 AA #4 (Week 4)

Description of Case Studies

Case #1: (40 points):

A branch manager of Wonderful Bank devised a new process designed to reduce customer wait times at her branch.The branch manager received permission from the bank president to test her new process against the existing process. The branch manager contacted you to design and conduct the proper test.She would like the analysis to be set up to determine if the wait times using her new process are shorter than under the existing process.

Using Version 1 of the SSP,completethe following:

1. Complete the preliminary Steps of the SSP (Steps 1 through 4).What CL do you recommend for the client?Be sure to discuss the reason for your recommendation.
2. Analyze the data and report your results to the branch manager.
3. Note:wait times are recorded in minutes.As you can see, data were collected on wait times using the old process (labeled WT - 1).Next, the new process was installed, and after a few weeks, a second sample was collected (labeled WT - 2).Both samples used a random collection design.
4. Analyze Wait Times from the old process versus Wait Times from the new process.
5. Discuss your findings and conclusions.Do you think the test was successful in the eyes of your client?What will your client recommend to the Bank President?
6. Finally, do you think the bank president will allow the manager to install the new process?On what rationale do you base your opinion?

Case #2: (60 points):

One of your clients owns a large number of franchise restaurants.The owner wants you to determine if the Yearly Advertising Budget allocated to each store and / or the Number of Competing Stores helps to explain the level of annual sales for each store.

Design:Your client wants you to study the importance of one or both variables (Yearly Ad Budget and Number of Competitor Stores) in understanding why Annual Net Sales vary among his many stores.

Using Version 2 of the SSP, complete the following:

a.Complete all preliminary steps for correlation analysis.

b.Note that 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.

c.Next, use the correlation option to build a correlation table for the 3 variables. Include all 3 variables in one correlation table.

d.Discuss your findings and conclusions.Are allof the relationships (e.g., X1 with Y, X2 with Y) statistically significant?How do you know this?Be sure to show your work.

Using Version 3 of the SSP, complete the following:

a.Complete all preliminary steps for regression analysis.

b.Next, use the regression option to run a bi-variate regression model with the IV that has the strongest correlation with Sales as the dependent variable.

c.Discuss your findings and conclusions.Does the Independent Variable you tested explain a significant amount of variation in the Dependent Variable (Sales)?

d.Finally, what will you tell your client?

Week 4 Analysis Cases

Case #1:Anayzing Bank Customer Wait Times

WT_1 = Waiting Times (old process)

WT_2 = Waiting Times (new process)

WT_1 WT_2

7.1 7.0

9.1 7.1

6.8 6.9

7.8 6.5

6.0 8.6

5.1 6.2

6.4 5.9

6.5 7.7

7.7 8.4

7.1 7.2

4.1 6.9

6.2 5.4

7.2 5.5

6.2 6.1

4.8 5.8

7.7 5.9

8.9 5.9

5.6 6.7

8.2 7.5

5.0 5.7

8.3 7.7

7.7 6.6

6.3 6.7

8.5 7.4

8.5 7.2

5.6 5.5

8.8 6.1

6.9 5.8

8.0 7.6

8.1 6.5

8.2 7.1

8.3 6.3

7.6 6.2

8.4 6.8

7.8 7.0

8.6 7.9

8.7 7.5

8.1 7.3

7.0 5.8

8.5 7.9

7.1 5.1

6.2 7.2

8.8 6.9

7.6 6.1

7.5 7.8

7.7 6.2

7.7 5.3

7.8 7.4

7.0 6.2

7.2 5.1

7.3 6.8

9.2 8.3

9.4 7.5

9.5 7.5

8.3 6.8

8.4 8.7

8.6 6.2

9.1 8.2

9.2 8.3

9.5 8.7

Week 4 Analysis Assignment (con't)

Case #3: Store Performance

X1= Yearly Advertising Budget (in $1,000s)

X2= Number of Competitor Stores

Y= Annual Net Sales ($1,000s)

X1 X2 Y

$8.2 11 $131

$6.9 12 $86

$2.1 15 $90

$5.8 1 $319

$14.8 5 $243

$11.8 4 $387

$8.1 10 $139

$7.7 12 $65

$3.3 15 $84

$11.3 13 $68

$17.4 3 $275

$10.5 7 $428

$11.3 3 $464

$2.5 14 $132

$4.7 8 $298

$12.9 10 $180

$5.5 4 $398

$4.9 13 $98

$10.4 7 $397

$14.5 6 $207

$16.2 3 $328

$2.8 14 $54

$2.4 7 $295

$9.6 8 $147

$9.8 5 $341

$14.9 3 $267

$7.0 8 $400

$2.4 7 $295

$4.9 13 $98