Question
In: Math
A business consultant believes consumers equally prefer four brands of coffee (A, B, C, D). He...
- 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:
milcah answered 2 years agoRelated 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
Latest Questions
- Why does a particular codon represent only one specific amino acid?
- Write a function template sort that takes two references to generic objects and switches them if...
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
ADVERTISEMENT