Question

In: Math

A business consultant believes consumers equally prefer four brands of coffee (A, B, C, D). He...

  1. A business consultant believes consumers equally prefer four brands of coffee (A, B, C, D). He collects a random sample of 400 consumers with the following results on preferences:

   Observed

   Frequency

Brand              of Preferences

               A                          102

               B                         121

               C                          120

               D                            57

Use an Excel spreadsheet to test this hypothesis at the 0.05 level. Submit the Excel spreadsheet you create along with an explanation of results

Solutions

Expert Solution

ho:   all categories are equally likely.
h1:   at least one of the category differs significantly

Oi pi = 1/4 Ei = pi*N (Oi-ei)^2/Ei
102 0.2500 100 0.04
121 0.2500 100 4.41
120 0.2500 100 4.00
57 0.2500 100 18.49
SUM 400 1.0000 400 26.94

chisq=   26.940   = sum(Oi-Ei)^2/Ei
      
alpha=   0.05  
k=   4.00  
critival value=   CHISQ.INV.RT(0.05,4-1)=   7.815
      
p-value=   6.06036E-06 = CHISQ.TEST(B2:B4,D2:D4)   

With chisq(4) = 26.94, p<5%, i reject ho and conclude that at least one of the category differs significantly.

Excel sheet:

Excel Formula Sheet:


Related Solutions

A department store, A, has four competitors: B,C,D, and E. Store A hires a consultant to...
A department store, A, has four competitors: B,C,D, and E. Store A hires a consultant to determine if the percentage of shoppers who prefer each of the five stores is the same. A survey of 1100 randomly selected shoppers is conducted, and the results about which one of the stores shoppers prefer are below. Is there enough evidence using a significance level α = 0.05 to conclude that the proportions are really the same? Store A B C D E...
Q4. There are four consumers A, B, C and D who can potentially buy three goods—1,...
Q4. There are four consumers A, B, C and D who can potentially buy three goods—1, 2, and 3. All three goods are made by a monopolist who incurs a production cost of $40, $40 and $80, respectively, for these goods. Consumers’ reservation prices for these goods are as shown in the following table: 1 2 3 A 150 90 60 B 90 90 90 C 60 80 100 D 80 60 120 (a) [3] What are the optimal prices...
Five people, A, B, C, D, and E are equally qualified runners. They run a one...
Five people, A, B, C, D, and E are equally qualified runners. They run a one - km sprint, and the order of finish is recorded. Number of orders of finish is? Probability that runners come in order E, D C, B, A is ? Probability that runners come in order E, D C, B, A is ?
Jason believes that the sales of coffee at his coffee shop depend upon the weather. He...
Jason believes that the sales of coffee at his coffee shop depend upon the weather. He has taken a sample of 6 days varying in degrees of temperature. Below you are given the results of the sample. Cups of Coffee Sold Temperature (in ⁰F) 350   50 200   60 220   70 110   80   65   90   40 100 ​ a. In this scenario, the dependent variable is . b. The least squares estimated regression equation is . c. The correlation coefficient (to...
Jason believes that the sales of coffee at his coffee shop depend upon the weather. He...
Jason believes that the sales of coffee at his coffee shop depend upon the weather. He has taken a sample of 6 days. Below you are given the results of the sample. Cups of Coffee Sold Temperature (in ⁰F) 350 50 200 60 210 70 100 80 60 90 40 100 a. Compute the least squares estimated regression equation. b. Is there a significant relationship between the sales of coffee and temperature? Use a t test and a .05 level...
Jason believes that the sales of coffee at his coffee shop depend upon the weather. He...
Jason believes that the sales of coffee at his coffee shop depend upon the weather. He has taken a sample of 5 days. Below you are given the results of the sample. Cups of Coffee Sold Temperature 700 50 500 60 400 70 200 80 100 90 Now we are going to conduct a hypothesis test to see if there is a significant relationship between sales of coffee and temperature. The hypotheses are: H 0 ; β 1 = 0...
Consider the cross: A/a; b/b; C/c; D/d; E/e x A/a; B/b; c/c; D/d; e/e a) what...
Consider the cross: A/a; b/b; C/c; D/d; E/e x A/a; B/b; c/c; D/d; e/e a) what proportion of the progeny will phenotypically resemble the first parent? b) what proportion of the progeny will genotypically resemble neither parent?
An experiment consists of four outcomes (A, B, C, D) with P(A) = 0.2, P(B) =...
An experiment consists of four outcomes (A, B, C, D) with P(A) = 0.2, P(B) = 0.3, and P(C) = 0.4.  The P(D) is 0.500 0.024 0.100 0.900 Given that event E has a probability of 0.3, the probability of the complement of event E cannot be determined with the above information can have any value between zero and one must be 0.7 is 0.3 If P(A) = 0.38, P(B) = 0.83, and P(A Ç B) = 0.57; then P(A È...
There is a chess team with four players {A, B, C, D} training for a competition....
There is a chess team with four players {A, B, C, D} training for a competition. The coach wants all players to play each other. Ignore which player is chosen to take the first move. 1. Do we use a counting rule for combinations or for permutations to calculate the total number of possible games if all players must play each other once? (Only one is correct.) 2. Calculate by hand (you can use a calculator but show some work),...
There are four urns, which we label A, B, C, and D, and each of these...
There are four urns, which we label A, B, C, and D, and each of these urns contains some white balls and some black balls, as specified below.•UrnAhas3white balls and2black balls•UrnBhas2white balls and6black balls•UrnChas3white balls and6black balls•UrnDhas5white balls and7black balls one of the urns is chosen at random, and then one of the balls is selected from the chosen urn. (a) What is the probability that urnAis chosen, and then a white ball is chosen from thaturn? (b) What is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT