[SOLVED] Alternative Hypothesis

Homeworkweek61(11.9pg.409)ThefollowingdatarepresentsthepriceofregulargasolineatselfservicestationsinfourcountiesinNewYorkCityMay17,2014ManhattenBronxQueensBrooklynnassauSuffolk2.3392.1992.2392.1592.0992.1792.2992.1392.2392.1992.1992.1592.2392.2392.1792.3592.2592.1192.1992.1592.2992.1592.2392.1592.1992.1792.2791.9992.2392.219At the .05 level of significance, is there evidence of a difference in the mean price of gasoline in the six countiesa. State the null hypothesis, state the alternative hypothesisb. using excel, analyze the gas data using the ANOVA:single factorc. explain your results comparing the F results to Fcritical and how this determines whether we can accept or reject Ho. What is your conclusion from this analysis.2. (12.5 pg. 452) A sample of 500 shoppers was selected in a large metropolitan area to determine various information concerning consumer behavior. Among the questions asked was “Do you enjoy shopping for clothing?” the results are summarized in the following contingency tableGENDEREnjoy Shopping for ClothingMaleFemaleTotalyes136224360no10436140Total24260500a. Is there evidence of a significant difference between the proportion of males and females who enjoy shopping for clothing at the .01 level of significance? Watch the video provided to do this problem in Excel.c. What is your answer to a) if 206 males enjoyed shopping for clothingClass Work week 6 problem.xlsx Class Work week 6 problem.xlsxFebruary 21 2020, 3:33 PM