Question: Please help me explain this using Excel. AutoSave . OFF MGMT650 HW11 Summer21_Questions Q Home Insert Draw Page Layout Formulas Data Review View Developer Tell

Please help me explain this using Excel.

Please help me explain this using Excel. AutoSave . OFF MGMT650 HW11

AutoSave . OFF MGMT650 HW11 Summer21_Questions Q Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments Calibri (Body) * 11 AA ag Wrap Text v General Ex AY- O. Paste BIU~ OvAv Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates K23 fx A E G H J K L M N O P Q R S T Saeko owns a yam 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 yam. 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? Misa's Bison Yak-et-ly-Yaks Buffalo Yams 799 776 799 784 640 931 807 822 794 675 856 920 795 616 731 14 875 893 837 15 Total 4,735.00 4,603.00 5,012.00 16 17 6 What is the null hypothesis? 18 What is the alternative hypothesis? 19 20 What is the level of significance? 21 22 7) Use Tools - Data Analysis - ANOVA: Single Factor 23 to find the F statistic: 24 25 26 27 28 29 30 31 32 8) From the ANOVA output: What is the F value? 33 34 What is the F critical value? 35 36 9) What is your decision? 37 Explain in statistical terms 38 39 40 41 42 43 44 HW11 Chi Square ANOVA Regression Cleaning Data with Outlier + IT - + 100%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!