Question: Please help me understand how to use the excel for this Of TELCEL 9:29 PM @ 53% HW11 Questions final Q . . . fx
Please help me understand how to use the excel for this

Of TELCEL 9:29 PM @ 53% HW11 Questions final Q . . . fx V A B D F G H 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 another brand. Specifically, she is interested in three different types of bison yarn. As an experiment, she randomly selected 21 different days and recorded the sales of each brand. At the . 10 significance level, can she conclude that there is a difference in preference between the brands? 8 Misa's Bison Yak-et-ty-Yaks 9 Buffalo Yarns 799 776 799 10 784 640 11 931 807 822 794 12 675 856 920 13 795 616 14 731 375 893 15 Total 837 16 4,735.00 4,603.00 5,012.00 17 5 ) 18 What is the null hypothesis? 19 What is the alternative hypothesis? 20 What is the level of significance? 21 22 6 Use Tools - Data Analysis - ANOVA: Single Factor 23 to find the F statistic: 24 25 26 27 28 29 30 31 32 33 34 35 7 ) 36 From the ANOVA ooutput: What is the F value? 37 8 ) What is the F critical value? 38 39 9 What is your decision? 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
