Hypothesis, ANOVA

Please see attached excel files for additional data.

*** Use the Hypothesis excel file for questions 1-3***

1. According to a survey conducted in October '01, consumers were trying to reduce their credit card debt. Based on a sample of 1,000 consumers in October '01 and in October '00, the mean credit card debt was $2,411 in October 2001 as compared to $2,814 in October '00. Suppose that the standard deviation was $847.43 in October '01 and $976.93 in October '00.
a) Assuming that the population variances from both years are equal, is there evidence that the mean credit card debt was lower in October 2001 than in October 2000?
(use the α = 0.05 level of significance)

2. A newspaper article discussed the opening of a Whole Foods Market in the Time-Warner building in New York City. The data below compared the prices of some kitchen staples at the new Whole Foods Market and at the Fairway supermarket located about 15 blocks from the Time-Warner building:

Item Whole Foods Fairway
Half-gallon milk 2.19 1.35
Dozen eggs 2.39 1.69
Tropicana orange juice 2.00 2.49
Head of Boston lettuce 1.98 1.29
Ground round, 1lb. 4.99 3.69
Bumble Bee tuna, 6 oz. can 1.79 1.33
Granny smith apples 1.69 1.49
Box DeCecco linguini 1.99 1.59
Salmon steak, 1 lb. 7.99 5.99
Whole chicken, per pound 2.19 1.49

a) At the 0.01 level of significance, is there evidence that the mean price is higher at Whole Foods Market than at the Fairway supermarket?

3. 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? Of 240 males, 136 answered yes. Of 260 females, 224 answered yes.
a) Is there evidence of a significant difference between males and females in the proportion who enjoy shopping for clothing at the 0.01 level of significance?
*** Use the ANOVA file for the following question***

4. The retailing manager of a supermarket chain wants to determine whether product location has any effect on the sale of pet toys. Three different aisle locations are considered: front, middle, and rear. A random sample of 18 stores is selected, with 6 stores randomly assigned to each aisle location. The size of the display area and price of the product are constant for all stores. At the end of a one-month trial period, the sales volumes of the product in each store were as follows:

Aisle Location
Front Middle Rear
8.6 3.2 4.6
7.2 2.4 6.0
5.4 2.0 4.0
6.2 1.4 2.8
5.0 1.8 2.2
4.0 1.6 2.8

a) At the 0.05 level of significance, is there evidence of a significant difference in mean sales among the various aisle locations?
b) If appropriate, which aisle locations appear to differ significantly in mean sales?
c) What should the retailing manager conclude? Fully describe the retailing manager's options with respect to aisle locations.

5. Suppose you heard a rumor that there was a difference in the salaries for men and women at your company. You decide to take a sample of employees and test the claim. Assume the "Cumba" database file represents a random sample of 100 employees. Using the "Hypothesis" file and a .05 significance level, test whether there is a difference in the mean salary for men versus women. Note: Use salary and gender data.