Question

In: Statistics and Probability

You are gearing up to open a new wine shop. In an effort to optimize wine...

You are gearing up to open a new wine shop. In an effort to optimize wine sales, you collect data by observing your competition and noting what people are ordering during happy hour. Below is data collected during a 2 week period.

Cabernet Sauvignon Merlot Chardonnay
9 3 1
8 9 6
5 5 2
8 8 5
4 6 3
8 7 2
6 12 5
1 9 4
0 8 6
3 3 4
4 11 2
5 8 0
7 9 3
2 7 2

Explain why we need to do a one-way ANOVA test with this data. Perform a one-way ANOVA test at a 5% level of significance with F*= 4.08 Explain the decision we make and Build 95% confidence interval for each type of wine. Explain what this means.

Solutions

Expert Solution


Individual 95% CIs For Mean Based on
                         Pooled StDev
Level   N   Mean StDev   -+---------+---------+---------+--------
C1     14 5.000 2.828            (------*------)
C2     14 7.500 2.624                         (-----*------)
C3     14 3.214 1.847   (------*------)
                          -+---------+---------+---------+--------
                         2.0       4.0       6.0       8.0

Pooled StDev = 2.470


One-way ANOVA: C1, C2, C3

Source DF      SS     MS      F      P
Factor   2 129.76 64.88 10.64 0.000
Error   39 237.86   6.10
Total   41 367.62

S = 2.470   R-Sq = 35.30%   R-Sq(adj) = 31.98%


                         Individual 95% CIs For Mean Based on
                         Pooled StDev
Level   N   Mean StDev   -+---------+---------+---------+--------
C1     14 5.000 2.828            (------*------)
C2     14 7.500 2.624                         (-----*------)
C3     14 3.214 1.847   (------*------)
                          -+---------+---------+---------+--------
                         2.0       4.0       6.0       8.0

Pooled StDev = 2.470


Grouping Information Using Tukey Method

     N   Mean Grouping
C2 14 7.500 A
C1 14 5.000    B
C3 14 3.214    B

Means that do not share a letter are significantly different.


Tukey 95% Simultaneous Confidence Intervals
All Pairwise Comparisons

Individual confidence level = 98.06%


C1 subtracted from:

     Lower Center Upper ---------+---------+---------+---------+
C2   0.223   2.500 4.777                      (-----*------)
C3 -4.063 -1.786 0.491         (------*-----)
                           ---------+---------+---------+---------+
                                 -3.5       0.0       3.5       7.0


C2 subtracted from:

     Lower Center   Upper ---------+---------+---------+---------+
C3 -6.563 -4.286 -2.009 (------*-----)
                            ---------+---------+---------+---------+
                                  -3.5       0.0       3.5       7.0


Related Solutions

You are a wine importer for Singapore and are seeking new sources of wine to offer...
You are a wine importer for Singapore and are seeking new sources of wine to offer more diversity to the local wine market. You are considering Greece because its Assyrtiko grape, grown mainly on the island of Santorini, is the current darling among informed Western wine consumers. You are considering between two suppliers of wine from Greece (Supplier A and Supplier B). You conducted a taste test of wine from the two suppliers in Singapore. Respondents had to taste the...
A wine shop wants to serve its white wine at a mean temperature of 50 degrees....
A wine shop wants to serve its white wine at a mean temperature of 50 degrees. In a sample of 36 glasses of wine, the mean was found to be 53 with a standard deviation of 3. The wine shop is interested to see if the evidence indicates that the wine shop is not meeting its temperature standard. (a) Using a significance level of α=0.05, perform a two-tailed hypothesis test to determine if the wine shop is not meeting its...
3.       ‘Myrto’ Cosmetics Ltd has decided to open a new shop in Leeds. A new bank...
3.       ‘Myrto’ Cosmetics Ltd has decided to open a new shop in Leeds. A new bank account will be opened on 1 April 2012. The following is a summary of the expected transactions for the first three months: ‘Myrto’ transferred £55,000 capital in April into the new shop bank account. The shop expects to sell items worth £8,000 in April, £9,000 in May and £10,000 in June. In each month 80% of the sales will be in cash and 20%...
Sandhill Bottle Shop has two divisions, Wine and Beer. The sales mix is 70% Wine and...
Sandhill Bottle Shop has two divisions, Wine and Beer. The sales mix is 70% Wine and 30% Beer. Sandhill’s annual fixed costs are estimated at $342000. The average selling price in the Wine division is $45 with a variable cost of $18. The average selling price in the Beer division is $18 with a variable cost of $9. What is Sandhill’s sales revenue at the break-even point? a. $194940 b. $600000 c. $942000 d. $342000
Jack and Mari decided to open a new bakery and pastry shop in Encino. On 10...
Jack and Mari decided to open a new bakery and pastry shop in Encino. On 10 January 2000 they entered into a written agreement providing that each of them would contribute $50,000 to the capital of the business. Jack and Mari agreed to work full-time for the partnership. It was agreed that both Jack and Mari would have authority to buy and sell property on behalf of the business; they would also have the authority to borrow money for the...
If you were going to open up a new US company that produces vaccines, which country...
If you were going to open up a new US company that produces vaccines, which country would you base your international headquarters in, and why? Think through logistics and geopolitical conflicts. Please write at least 250 words
Mary Magnolia wants to open a flower shop, the Petal Pusher, in a new mall. She...
Mary Magnolia wants to open a flower shop, the Petal Pusher, in a new mall. She has her choice of three different floor sizes, 200 square feet, 500 square feet, or 1,000 square feet. The monthly rent will be $1 a square foot. Mary estimates that if she has F square feet of floor space and sells y bouquets a month, her variable costs will be cv(y) = y^ 3/ 4F per month. (1) If she has 200 square feet...
research practice questions word limit (400- 600) 1) You are planning to open up a new...
research practice questions word limit (400- 600) 1) You are planning to open up a new restaurant business, what kind of external environment will affect you. 2) Write the job description for a sales representative at best buy. What will be the selection criteria and process, explain in detail.
Fermento sells a wine it purchases from a local brewer. Fermento stocked up on the wine...
Fermento sells a wine it purchases from a local brewer. Fermento stocked up on the wine throughout the year, preparing for a special millenium sales event in late December. On January 1, Fermento had 30 bottles on hand that cost $31 each. They also made the following purchases: 50 bottles for $28 each on Mar. 28 20 bottles for $27 each on Sep. 14 15 bottles for $30 each on Nov. 5 Fermento’s sales were as follows: 10 from the...
Here is a typical situation for an entrepreneur: You are planning to open a coffee shop...
Here is a typical situation for an entrepreneur: You are planning to open a coffee shop in one of two areas in your local community. Conduct a secondary data search on key variables that would allow you to make a logical decision on what area is best suited for your proposed coffee shop. What external sources of information would you use to find this information? Identify 2 key variables and 2 external sources.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT