Question
In: Statistics and Probability
Month Chevy Cruze Ford Focus Hyundai Elantra Honda Civic Toyota Corolla VW Jetta January 21,711 21,303...
|
Month |
Chevy Cruze |
Ford Focus |
Hyundai Elantra |
Honda Civic |
Toyota Corolla |
VW Jetta |
|
January |
21,711 |
21,303 |
21,006 |
19,341 |
20,985 |
19,671 |
|
February |
18,274 |
19,385 |
19,992 |
20,872 |
19,785 |
19,105 |
|
March |
17,934 |
16,557 |
15,713 |
17,181 |
16,889 |
16,006 |
|
April |
19,387 |
17,420 |
15,054 |
14,500 |
14,093 |
14,083 |
|
May |
17,097 |
16,147 |
15,023 |
15,800 |
15,727 |
16,875 |
|
June |
16,244 |
16,173 |
14,295 |
15,058 |
15,236 |
16,893 |
a. run the data using ANOVA on Excel. You may choose which ANOVA is most appropriate.
b. Show the Excel ANOVA output and describe what the output means.
Solutions
Expert Solution
| Anova: Two-Factor Without Replication | ||||||
| SUMMARY | Count | Sum | Average | Variance | ||
| January | 6 | 124017 | 20669.5 | 892146.3 | ||
| February | 6 | 117413 | 19568.83 | 769914.2 | ||
| March | 6 | 100280 | 16713.33 | 653005.1 | ||
| April | 6 | 94537 | 15756.17 | 4717579 | ||
| May | 6 | 96669 | 16111.5 | 597021.5 | ||
| June | 6 | 93899 | 15649.83 | 905859.8 | ||
| Chevy Cruze | 6 | 110647 | 18441.17 | 3701180 | ||
| Ford Focus | 6 | 106985 | 17830.83 | 4369303 | ||
| Hyundai Elantra | 6 | 101083 | 16847.17 | 8305758 | ||
| Honda Civic | 6 | 102752 | 17125.33 | 6374508 | ||
| Toyota Corolla | 6 | 102715 | 17119.17 | 7349288 | ||
| VW Jetta | 6 | 102633 | 17105.5 | 4204497 | ||
| ANOVA | ||||||
| Source of Variation | SS | df | MS | F | P-value | F crit |
| month | 1.4E+08 | 5 | 27947623 | 21.98208 | 2.04E-08 | 2.602987 |
| Columns | 10893073 | 5 | 2178615 | 1.71358 | 0.168264 | 2.602987 |
| Error | 31784556 | 25 | 1271382 | |||
| Total | 1.82E+08 | 35 |
p value for month = 0.0000 , so significant
there is an effect of month
.............
p value for column for 0.168
p value > 0.05
so not significant
.........................
THANKS
revert back for doubt
please upvote
orchestra answered 2 years agoRelated Solutions
Data Month Chevy Cruze Ford Focus Hyundai Elantra Honda Civic Toyota Corolla VW Jetta January 21,711...
Data
Month
Chevy Cruze
Ford Focus
Hyundai Elantra
Honda Civic
Toyota Corolla
VW Jetta
January
21,711
21,303
21,006
19,341
20,985
19,671
February
18,274
19,385
19,992
20,872
19,785
19,105
March
17,934
16,557
15,713
17,181
16,889
16,006
April
19,387
17,420
15,054
14,500
14,093
14,083
May
17,097
16,147
15,023
15,800
15,727
16,875
June
16,244
16,173
14,295
15,058
15,236
16,893
Phase 1 report must include the preliminary findings:
What are the means, medians, modes, range and standard
deviation for each of the six car...
Based on 2017 sales, the six top-selling compact cars are the Honda Civic, Toyota Corolla, Nissan...
Based on 2017 sales, the six top-selling compact cars are the
Honda Civic, Toyota Corolla, Nissan Sentra, Hyundai Elantra,
Chevrolet Cruze, and Ford Focus.† The 2017 market shares are: Honda
Civic 20%, Toyota Corolla 17%, Nissan Sentra 12%, Hyundai Elantra
10%, Chevrolet Cruze 10%, and Ford Focus 8%, with other small car
models making up the remaining 23%. Suppose a sample of 400 compact
car sales in a certain large city showed the following number of
vehicles sold.
Honda Civic...
Based on sales over a six-month period, the five top-selling compact cars are Chevy Cruze, Ford...
Based on sales over a six-month period, the five top-selling
compact cars are Chevy Cruze, Ford Focus, Hyundai Elantra, Honda
Civic, and Toyota Corolla (Motor trend, November 2, 2011). Based on
total, the market shares for these five compact cars were Chevy
Cruze 24%, Ford Focus 21%, Hyundai Elantra 19%, Honda Civic 18%,
and Toyota Corolla 17%. A sample of 400 compact car sales in
Chicago showed the following of vehicles sold:
Chevy Cruze
108
Ford Focus
92
Hyundai Elantra...
Based on sales over a six-month period, the five top-selling compact cars are Chevy Cruze, Ford...
Based on sales over a six-month period, the five top-selling
compact cars are Chevy Cruze, Ford Focus, Hyundai Elantra, Honda
Civic, and Toyota Corolla.† Based on total sales, the market shares
for these five compact cars were Chevy Cruze 24%, Ford Focus 21%,
Hyundai Elantra 20%, Honda Civic 18%, and Toyota Corolla 17%.
Suppose a sample of 400 compact car sales in one city showed the
following number of vehicles sold.
Chevy Cruze
107
Ford Focus
92
Hyundai Elantra
65...
Based on sales over a six-month period, the five top-selling compact cars are Chevy Cruze, Ford...
Based on sales over a six-month period, the five top-selling
compact cars are Chevy Cruze, Ford Focus, Hyundai Elantra, Honda
Civic, and Toyota Corolla.† Based on total sales, the market shares
for these five compact cars were Chevy Cruze 24%, Ford Focus 21%,
Hyundai Elantra 20%, Honda Civic 18%, and Toyota Corolla 17%.
Suppose a sample of 400 compact car sales in one city showed the
following number of vehicles sold.
Chevy Cruze
109
Ford Focus
92
Hyundai Elantra
64...
Based on sales over a six-month period, the five top-selling compact cars are Chevy Cruze, Ford...
Based on sales over a six-month period, the five top-selling
compact cars are Chevy Cruze, Ford Focus, Hyundai Elantra, Honda
Civic, and Toyota Corolla.† Based on total sales, the market shares
for these five compact cars were Chevy Cruze 24%, Ford Focus 21%,
Hyundai Elantra 20%, Honda Civic 18%, and Toyota Corolla 17%.
Suppose a sample of 400 compact car sales in one city showed the
following number of vehicles sold.
Chevy Cruze
109
Ford Focus
91
Hyundai Elantra
63...
Based on sales over a six-month period, the five top-selling compact cars are Chevy Cruze, Ford...
Based on sales over a six-month period, the five top-selling
compact cars are Chevy Cruze, Ford Focus, Hyundai Elantra, Honda
Civic, and Toyota Corolla.† Based on total sales, the market shares
for these five compact cars were Chevy Cruze 24%, Ford Focus 21%,
Hyundai Elantra 20%, Honda Civic 18%, and Toyota Corolla 17%.
Suppose a sample of 400 compact car sales in one city showed the
following number of vehicles sold.
Chevy Cruze
107
Ford Focus
93
Hyundai Elantra
64...
Based on sales over a six-month period, the five top-selling compact cars are Chevy Cruze, Ford...
Based on sales over a six-month period, the five top-selling
compact cars are Chevy Cruze, Ford Focus, Hyundai Elantra, Honda
Civic, and Toyota Corolla.† Based on total sales, the market shares
for these five compact cars were Chevy Cruze 24%, Ford Focus 21%,
Hyundai Elantra 20%, Honda Civic 18%, and Toyota Corolla 17%.
Suppose a sample of 400 compact car sales in one city showed the
following number of vehicles sold.
Chevy Cruze
109
Ford Focus
93
Hyundai Elantra
64...
Based on sales over a six‐month period, the five top‐selling compact cars are Chevy Cruze, Ford...
Based on sales over a six‐month period, the five top‐selling
compact cars are Chevy Cruze, Ford Focus, Hyundai Elantra, Honda
Civic, and Toyota Corolla (Motor Trend, November 2, 2011). A sample
of compact car sales in Chicago showed the following number of
vehicles sold:
Type
Number Sold
Chevy Cruze
108
Ford Focus
92
Hyundai Elantra
64
Honda Civic
84
Toyota Corolla
52
a. State your null and alternative hypotheses. Use a goodness of
fit test to determine if the sample...
Based on sales over a six-month period, the five top-selling compact cars are Chevy Cruze, Ford...
Based on sales over a six-month period, the five top-selling
compact cars are Chevy Cruze, Ford Focus, Hyundai Elantra, Honda
Civic, and Toyota Corolla.† Based on total sales, the market shares
for these five compact cars were Chevy Cruze 24%, Ford Focus 21%,
Hyundai Elantra 20%, Honda Civic 18%, and Toyota Corolla 17%.
Suppose a sample of 400 compact car sales in one city showed the
following number of vehicles sold.
Chevy Cruze
109
Ford Focus
92
Hyundai Elantra
63...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What is the difference among the principles of modularization, abstraction, encapsulation, and separation of interface and...
- An investment project costs $20,100 and has annual cash flows of $4,400 for six years. ...
- PUT IN JAVA PROGRAMMING The StockB class: Design a class named StockB that contains the following...
- Draw a DFA for the following ( ∑ = {0,1}): Set of all strings with.
- In the article from Forbes notes that the goal of a leader is not to clone...
- Many people keep time using a 24 hour clock (11 is 11am and 23 is 11pm,...
- UNIX ONLY -- DIFFICULT LAB ASSIGNMENT This is an extremely difficult subject for me. Could you...
ADVERTISEMENT