Answered You can hire a professional tutor to get the answer.
Select one exercise from the list below for Diamonds or Eggs. Do not repeat an exercise until all have been reserved or posted. See Video "ANOVA_8.
Select one exercise from the list below for Diamonds or Eggs. Do not repeat an exercise until all have been reserved or posted. See Video "ANOVA_8.33(Eggs)" in this week's Discussion below before posting exercise. Post only one exercise for this week.
Briefly state the question and conclusions for each test.
α=0.1 for all exercises related to Diamonds
Use the Diamonds file as was done for the Eggs example in the video below.
DIAMOND.xls. Note that in EXCEL you must first click on the variable, such as Color, and then select DATA to sort A to Z in order to have PRICE for each column of color for D E F G H and I. Do this same procedure for Hardness or Certification if one of these is desired as the variable that effects price.
Set up a hypothesis for determining whether the means of the quantitative variable differ for the levels of the qualitative variable.
I. Use the diamonds data file to conduct one of the following the test with ∝=.10.
Use size vs color for ANOVA single factor.
Use price vs color for ANOVA single factor
Use size vs clarity for ANOVA single factor
Use price vs clarity for ANOVA single Factor
II. Use Eggs data in video below and test Overrun vs Housing
Use Eggs data in video below and test Strength vs Housing
Show all data sheets and output results from EXCEL that were used for the ANOVA analysis. See "Content/Data Analysis for EXCEL" in order to add Statistical Analysis in your EXCEL program if not already available.