Question

Saeko owns a yarn shop and want to expands her color selection. Before she expands her colors, she wants to find out if her customers prefer one brand over the other brand. Specifically, she is interested in three different types of bison yarn. As an experiment, she randomly selected 15 different days and recorded the sales of each brand. At a .05 significance level can she conclude that there are differences in preference between the brands?

1. What is the null hypothesis?

2. What is the alternate hypothesis?

3. What is the level of significance?

Use Tools-Data Analysis-Anova Single Factor Anova: Single Factor to find the F statistic;

4. from the ANOVA output; What is the F value?

5. What is the F critical value?

6. What is your decision?

Use the "Pivot Table Data" tab to crate a pivot table that shows Seako the number of yards and meters that were sold in the various yarn types during the busiest weekend of her shop last year.

PLEASE SHOW HOW TO DO ALL EXCEL FUNCTIONS. THANK YOU!

Misa's Bison	Yak-et-ty-Yaks	Buffalo Yarns
98	79	65
85	86	83
91	72	78
87	82	66
98	91	193

Answer 1