Note that in EXCEL you must first click on the variable

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 clarity for ANOVA single factor α=0.1 for all exercises related to Diamonds