Question

# Crescent Oil has developed three new blends of gasoline – Blend X, Blend Y and Blend...

Crescent Oil has developed three new blends of gasoline – Blend X, Blend Y and Blend Z, and must decide which blend or blends to produce and distribute. A study of the miles per gallon ratings of the three blends is being conducted to determine if the mean ratings are the same for the three blends.

Five automobiles- 1, 2 3, 4 and 5, have been tested using each of the three gasoline blends and the miles per gallon ratings are shown on the accompanying Excel spreadsheet.

 Automobile Blend X Blend Y Blend Z 1 31 30 30 2 30 29 29 3 29 29 28 4 33 31 29 5 26 25 26

Based on the sample data we would like to determine whether the different blends of gasoline, produce significant differences in the average mpg. We would like to use the methods we have learnt so far in 361A to see if our result is statically significant. (Statistical significance refers to a result that is not likely to occur randomly but rather is likely to be attributable to a specific cause – in this case the different gasoline blends and different cars.)

Carry out the following tests and make preliminary findings:

1. For the sample data, calculate the means and standard deviations for the mpg for each of the three blends of gasoline – Blend X, Blend Y and Blend Z.
2. Draw three boxplots using Excel for mpg, one for each blend of gasoline.
3. Run three two sample t-tests between the different blends of gasoline i.e. compare the means of Blend X and Blend Y, then Blend X and Blend Z and finally Blend Y and Blend Z. Are they the same or are they different?
4. Armed with this information above determine whether or not your results show that the three different gasoline blends produce the same average mpg or not. Your answers should specifically site the information you re using to make your determination.
5. Re-run parts 1 - 4 above but this time your focus is on the mpg of each car for the 5 cars (car 1 through car 5) not for the three gasoline blends.

Your report should have the following sections, arranged sequentially:

1. Introduction and problem background

3. Initial data exploration – descriptive statistics/graphs

4. Analyses

5. Interpretation of results, deficiencies in methods, final conclusions and recommendations for decision-making

this is what I have calculate from excel on question 1:

 Column1 Blend X Blend Y Blend Z Mean 29.8 28.8 28.4 Standard Deviation 2.6 2.3 1.5

#### Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• ### Three different models of automobiles (A, B, and C) were compared for gasoline consumption. For each...

Three different models of automobiles (A, B, and C) were compared for gasoline consumption. For each model of car, fifteen cars were randomly selected and subjected to standard driving procedures. The average miles/gallon obtained for each model of car and sample standard deviations are shown below. Car A Car B Car C Average Mile Per Gallon 42 49 44 Sample Standard Deviation 4 5 3 Use the above data and test to see if the mean gasoline consumption for all...

• ### Ford has developed a new hybrid car called the Fractal. 31 Fractal cars and 27 competitors...

Ford has developed a new hybrid car called the Fractal. 31 Fractal cars and 27 competitors cars were road tested to compare miles-per-gallon (mpg) performance. The sample statistics are shown in the table below: Sample 1 Sample 2 (competitior) 27 Sample size Sample mean Sample Standard deviation 31 33.0 mpg 31.0 mpg 20 mpg 2.5 mpg Can we conclude, using a 5% level of significan cer that the miles-per-gallon (mpg) performance of Fractal cars is greater than the miles-per gallon...

• ### A research firm tests the miles-per-gallon characteristics of three brands of gasoline. Be- cause of different g...

A research firm tests the miles-per-gallon characteristics of three brands of gasoline. Be- cause of different gasoline performance characteristics in different brands of automobiles five brands of automobiles are selected and treated as blocks in the experiment; that is. each brand of automobile is tested with each type of gasoline. The results of the experiment (in miles per gallon) follow. 40. Gasoline Brands 21 20 24 30 Automobiles 29 25 23 24 24 20 a. At a- 05, is there...

• ### Do heavier cars really use more gasoline? Suppose a car is chosen at random. Let x...

Do heavier cars really use more gasoline? Suppose a car is chosen at random. Let x be the weight of the car (in hundreds of pounds), and let y be the miles per gallon (mpg). x 30 43 31 47 23 40 34 52 y 30 21 22 13 29 17 21 14 Complete parts (a) through (e), given Σx = 300, Σy = 167, Σx2 = 11,908, Σy2 = 3761, Σxy = 5885, and r ≈ −0.888. (a) Draw...

• ### 7. Do heavier cars really use more gasoline? Suppose a car is chosen at random. Let x be the weight of the car (in hundreds of pounds), and let y be the miles per gallon (mpg) At the 5% level of sign...

7. Do heavier cars really use more gasoline? Suppose a car is chosen at random. Let x be the weight of the car (in hundreds of pounds), and let y be the miles per gallon (mpg) At the 5% level of significance, test the claim is that heavier cars use more gasoline. Remember that a claim of correlation would be that X 29 46 29 47 23 40 34 52 Y 30 21 22 14 29 27 22 34 a....

• ### Do heavier cars really use more gasoline? Suppose a car is chosen at random. Let x be the weight of the car (in hundreds of pounds), and let y be the miles per gallon (mpg). x 29 44 33 47 23 40 34 52...

Do heavier cars really use more gasoline? Suppose a car is chosen at random. Let x be the weight of the car (in hundreds of pounds), and let y be the miles per gallon (mpg). x 29 44 33 47 23 40 34 52 y 32 20 26 13 29 17 21 14 Complete parts (a) through (e), given Σx = 302, Σy = 172, Σx2 = 12,064, Σy2 = 4036, Σxy = 6066, and r ≈ −0.902. (a) Draw...

• ### he follo 2. Do heavier cars really use more gasoline? Suppose that a car is chosen...

he follo 2. Do heavier cars really use more gasoline? Suppose that a car is chosen at random. Let x be the weight of the car (in pounds), and let y be the miles per gallon (mpg). The following information is based on data taken from Consumer Reports (vol. 62, no. 4). cystolic 3400 5200 21 14 - Weight of Car (in pounds) 2700 4400 3200 4700 2300 4000 y-Miles per Gallon 30 19 24 13 29 17 . Find...

• ### Gasoline Brands 21 20 24 30 Automobiles 29 25 23 24 24 20 a. At a- 05, is there a significant difference in the...

Gasoline Brands 21 20 24 30 Automobiles 29 25 23 24 24 20 a. At a- 05, is there a significant difference in the mean miles-per-gallon chaacteris- tics of the three brands of gasoline? b. Analyze the experimental data using the ANOVA procedure for completely random- ized designs. Compare your findings with those obtained in part (a). What is the advantage of attempting to remove the block effect? A research firm tests the miles-per-gallon characteristics of three brands of gasoline....

• ### study sing the make of a car in at least three of the five families? Use...

study sing the make of a car in at least three of the five families? Use Binomial Table 2. If Z is a standard normal random variable find the following probabilities (Standard Table is in the Appendix and is also posted under Course Document) a. P(ZS-1.77) b. P(-2.88 SZ S-2.15) 3. Studies show that gasoline use for compact cars sold in the United States is normally distributed, with mean use of 25.5 miles per gallon (mpg) and a standard deviation...

• ### A major oil company has developed a new gasoline additive that is supposed to increase mileage....

A major oil company has developed a new gasoline additive that is supposed to increase mileage. To test this hypothesis, ten cars are randomly selected. The cars are driven both with and without the additive. The results are displayed in the following table. Can it be concluded, from the data, that the gasoline additive does significantly increase mileage? Let d = (gas mileage with additive)-(gas mileage without additive). Use a significance level of a = 0.01 for the test. Assume...