Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: Michael Sullivan, Kathleen Miranda

7th Edition

ISBN: 1464144397, 9781464144394

More Books

Students also viewed these Mathematics questions