Question: Please show the which excel formulas to use for the calculations Moto owns a silk shop in Taipei City and want to expands color selection.
Please show the which excel formulas to use for the calculations
| Moto owns a silk shop in Taipei City and want to expands color selection. | |||||||||||
| Before expanding colors, do the customers have a brand preference? | |||||||||||
| As an experiment, sales by brand were recorded on randomly selected days. | |||||||||||
| At the 0.10 significance level, can it be concluded that there is a difference in preference among the brands? | |||||||||||
| Cyan | Pearl | Onyx | |||||||||
| 724 | 776 | 829 | |||||||||
| 709 | 640 | 961 | |||||||||
| 798 | 822 | 824 | |||||||||
| 845 | 812 | 950 | |||||||||
| 720 | 673 | 761 | |||||||||
| 800 | 893 | 867 | |||||||||
| 6 | What is the null hypothesis? | ||||||||||
| What is the alternative hypothesis? | |||||||||||
| 7 | The level of significance depends on the application. What is the level of significance () in this problem? | ||||||||||
| Perform single factor ANOVA using Data Analysis. Include the row 6 labels in the Input Range and check the Labels checkbox. | |||||||||||
| 8 | From the ANOVA output: What is the F test statistic? | ||||||||||
| What is the critical value of the F test statistic? | |||||||||||
| 9 | What is your decision in terms of H0, the significance level, the F test statistic, and the F test statistic critical value. | ||||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
