Project #5789 - Data Analysis

I am redoing an assignment... I know that much of this is correct, as I have spent about an hour discussion with my professor today... Would you be willing to review and fix the errors?

Practical Application Scenario 1

You are the manager of the Gander Mountain store in Frogtown, Illinois. Recently, a customer mentioned that they believed your prices for ammunition were lower than the prices of Gander's primary competitor in the hunting equipment market, Cabela's. You would like to be able to include that statement in a forthcoming print advertisement, so you need statistical evidence to support this assertion.

1) Identify the null and alternative hypotheses needed to test the contention.

 

A.  To be able to compare prices between companies, hypothesis' could be determined by how much detail you expect to gather and want to gather. 

 

   H0 = The price of ammunition at Gander Mountain is less than the price of ammunition at Cabelas, Inc.

 

H1= The price of ammunition at Gander Mountain is not less than the price of ammunition at Cabela's, Inc.

 

2) Identify the most appropriate sample selection technique to gather data for testing the hypotheses.

 

A. Using the Statistical Technique Scenarios provided for Unit 4, "Test a hypothesis about the means of two populations using a paired samples t test."

      

 

3) What statistical test should you use to test this hypothesis using the data you will collect?

 

A. You could use ANOVA for this statistical test.  The reason you could use ANOVA is that you are able to measure the prices between two or more retail stores, ammo (in general), specific ammunition, brand of ammunition, and caliber of ammunition. 

 

 

Your love of golf has brought you back to the range as the new product manager for UniDun's "Straight Flight" (SF) line of golf balls. The company's research and development group has been experimenting with dimple patterns that promote straight flight and have achieved some degree of success. You, however, are worried about the effect that the new pattern might have on driving distance.

 

The Golf Ball Distance Test document in the Resources contains test results that compare the driving distances for the two different kinds of balls: 40 balls of the new SF type, and 40 of the old UniDun type. Your job is to determine if the old UniDun balls can be driven further than the new SF balls. To resolve this question, you need appropriate answers to the following four questions.

 

Remember to use your MBA6018 – Data Analysis for Business Decisions textbook and any additional resources you may have located to help you answer each question:

 

1) Identify the null and alternative hypotheses you should form for this test. State each as an explanation and as a math equation.

 

A. H0= Old UniDun golf balls can be driven an equal distance to that of the new SF type.

 

H1- Old UniDun golf balls can be driven a greater distance than that of the SF type

 

H2- Old UniDun golf balls can be driven a lesser distance than that of the SF type.

      

2) Identify the appropriate statistical test to accept or reject the null hypothesis.

 

Using the Statistical Technique Scenarios provided for Unit 4, "Test a hypothesis about the means of more than two populations using one-way ANOVA."

 

3) Calculate the p-value.

 

= DF ( 1.76454, 1, 78)

 

P-Value = .1879323

      

4) What should you tell the vice president of marketing about the golf balls product?

 

 

Summary

 

 

 

 

 

 

Groups

Sample size

Sum

Mean

Variance

 

 

Current

40

10,811.

270.275

76.61474

 

 

New

40

10,700.

267.5

97.94872

 

 

 

 

 

 

 

 

 

ANOVA

 

 

 

 

 

 

Source of Variation

SS

df

MS

F

p-level

F crit

Between Groups

154.0125

1

154.0125

1.76454

0.18793

5.64115

Within Groups

6,807.975

78

87.28173

 

 

 

 

 

 

 

 

 

 

Total

6,961.9875

79

 

 

 

 

 

 

Considering the data given, it would be important to tell the vice president of marketing to stress the ability of the golf ball in the sense of straightness.  It would be difficult to suggest that the new golf ball is not only a straighter, but also a longer ball.  Statistics don't support the new ball outperforming as far as distance. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

As the food court manager at the Mall of Elbonia, you want to determine how much time customers spend at the mall related to different times of the week (for example: midweek, day; midweek evening; weekend, day; weekend, evening) . Last week the mall survey staff administered a random survey to mall visitors by selecting customers as they were leaving the mall. One of the questions asked was how much time the customer had spent in the mall on that day.

The findings from this study are provided in the Mall Time Interview Results document provided in the Resources. Columns A through D show the time spent by the customers interviewed, according to the weekday and time of day when the interviews occurred. Is there any statistically significant difference (at alpha = .05) in the average amount of time people spend in the mall based on the weekday and time? To determine the answer to that question, you need appropriate answers to the following four questions. Remember to use your MBA6018 – Data Analysis for Business Decisions textbook and any additional resources you have used in this course to help you answer each question:

 

1) Identify the null and alternative hypotheses you should form for this test. State each as an explanation and as a math equation.

 

A.  H0= Customers spend equal time at the mall throughout the entire week.

 

H1= Customers spend more time at the mall earlier in the week

 

H2 = Customers spend more time at the mall during middle of the week

 

H3= Customers spend more time at the mall later in the week

 

H4= Customers spend more time at the mall over the weekend

 

 

2) Identify the appropriate statistical test to accept or reject the null hypothesis.

 

A. Using the Statistical Technique Scenarios provided for Unit 4, "Test a hypothesis about the means of more than two populations using one-way ANOVA."

 

 

3) Calculate the appropriate ANOVA values to accept or reject your null and alternative hypotheses.

 

A. 

 

Analysis of Variance (One-Way)

 

 

 

 

 

 

 

Summary

 

 

 

 

 

 

Groups

Sample size

Sum

Mean

Variance

 

 

Midweek, Day

25

2,087.89898

83.51596

1,300.16709

 

 

Midweek, Evening

25

2,384.

95.36

1,479.65667

 

 

Weekend, Day

25

2,528.

101.12

2,434.61

 

 

Weekend, Evening

25

3,074.

122.96

2,608.45667

 

 

 

 

 

 

 

 

 

ANOVA

 

 

 

 

 

 

Source of Variation

SS

df

MS

F

p-level

F crit

Between Groups

20,487.11927

3

6,829.03976

3.49182

0.01862

3.43446

Within Groups

187,749.37009

96

1,955.72261

 

 

 

 

 

 

 

 

 

 

Total

208,236.48936

99

 

 

 

 

 

 

I would reject the null hypothesis and accept my H4 alternative hypothesis that more individuals visit the mall on the weekend, specifically evening and day.

 

 

4) What should you tell the Mall of Elbonia's food court stores managers (in terms of the mall's high traffic times and customer tendencies)?

 

A.  I would explain to the managers that they should concentrate on promotions, marketing, tactical sales strategies around customer traffic levels, which tend to be highest during weekend evening and day, weakest being midweek during the day.

 

Subject Mathematics
Due By (Pacific Time) 05/07/2013 10:30 pm
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