Statistics

Homework week 6

1. (11.9 pg. 409) The following data represents the price of regular gasoline at self service stations in four counties in New York City May 17, 2014

                Manhatten

               Bronx

            Queens

              Brooklyn

           nassau

                 Suffolk

2.339

2.199

2.239

2.159

2.099

2.179

2.299

2.139

2.239

2.199

2.199

2.159

2.239

2.239

2.179

2.359

2.259

2.119

2.199

2.159

2.299

2.159

2.239

2.159

2.199

2.179

2.279

1.999

2.239

2.219

At the .05 level of significance, is there evidence of a difference in the mean price of gasoline in the six counties

a. State the null hypothesis, state the alternative hypothesis

b. using excel, analyze the gas data using the ANOVA:single factor 

c. 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 table

GENDER

Enjoy Shopping for Clothing

     Male

 Female

     Total 

yes

136

224

360

no

104

36

140

Total

240

260

500

a. 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 clothing 

Class Work week 6 problem.xlsx February 21 2020, 3:33 PM