Question

Completely work the problems in Excel, conclusions and answers may be typed in Excel or Word. Then submit the assignment via Canvas to upload the file, so I can grade an electronic version of the homework.

#1        Problem 25 [page 583-584].

The price drivers pay for gasoline often varies a great deal across regions throughout the United States.  The following data show the price per gallon for regular gasoline for a random sample of gasoline service stations for three major brands of gasoline (Shell, BP, and Marathon) located in 11 metropolitan areas across the upper Midwest region (OhioGasPrices.com website, March 18, 2012).

Metropolitan Area	Shell	BP	Marathon
Akron, OH	3.77	3.83	3.78
Cincinnati, OH	3.72	3.83	3.87
Cleveland, OH	3.87	3.85	3.89
Columbus, OH	3.76	3.77	3.79
Ft. Wayne, IN	3.83	3.84	3.87
Indianapolis, IN	3.85	3.84	3.87
Lansing, MI	3.93	4.04	3.99
Lexington, KY	3.79	3.78	3.79
Louisville, KY	3.78	3.84	3.79
Muncie, IN	3.81	3.84	3.83
Toledo, OH	3.69	3.83	3.86

Use a= 0.05 to test for any significant difference in the mean price of gasoline for the three brands.

#2        Information regarding the ACT scores of samples of students in four different majors are given below.

Student's Major
Management	Marketing	Finance	Accounting
29	22	29	28
27	22	27	26
21	25	27	25
28	26	28	20
22	27	24	21
28	20	20	19
28	23	20	27
23	25	30	24
28	27	29	21
24	28		23
29			27
31			27
			24

At a 5% level of significance, test to determine whether there is a significant difference in the means of the four populations.

#3        Employees of MNM Corporation are about to undergo a retraining program. Management is trying to determine which of three programs is the best. They believe that the effectiveness of the programs may be influenced by gender. A factorial experiment was designed. You are given the following information.

Program	Gender
	Male	Female
Program 1	320	380
	240	300
Program 2	160	240
	180	210
Program 3	240	360
	290	380

Test to determine whether there is a significant difference in the means due to program type and gender, and whether significant interaction exists. Use 10% level of significance.

Answer 1

Only first problem solved.

#1 Problem 25 [page 583-584].

The price drivers pay for gasoline often varies a great deal across regions throughout the United States. The following data show the price per gallon for regular gasoline for a random sample of gasoline service stations for three major brands of gasoline (Shell, BP, and Marathon) located in 11 metropolitan areas across the upper Midwest region

Step 1 - Input the data in excel as shown below.

Step 2 - We use single factor ANOVA from the data analysis tab as shown below

Step 3 - Update the input as shown.

Step 4 - Anova output is generated.

Hypothesis
H0 : The mean price of gasoline for all the brands is the same.
H1 : The mean price of gasoline for all the brands is not the same.

In the anova output we look at the pvalue highlighted in yellow.
Since the pvalue is greater than 0.05, we fail to reject the null hypothesis and conclude that there is no significant difference in the mean price of gasoline for the three brands.