Question

As part of a study designed to compare hybrid and similarly equipped conventional vehicles, a variety of classes of hybrid and all-gas model cars and sport utility vehicles (SUVs) were tested. The data showing the miles-per-gallon rating study obtained for two hybrid small cars, two hybrid midsize cars, two hybrid small SUVs, two hybrid midsize SUVs, and eight similarly equipped conventional models are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.

**a.** At the a=0.05 level of significance, test
for significant effects due to class, type, and interaction.

Sourceof Variation |
Sum of Squares(to 2 decimals) |
Degreesof Freedom |
Mean Square(to 2 decimals) |
(to 2 decimals) |

Class | ||||

Type | ||||

Interaction | ||||

Error | ||||

Total |

**b.** The p-value for the class of vehicle is
.

(___)

**c.** The p-value for the type of vehicle is .

(___)

**d.** The p-value for the interaction between
class and type of vehicle is .

(___)

Make/Model | Class | Type | MPG |

Honda Civic | Small Car | Hybrid | 37 |

Honda Civic | Small Car | Conventional | 27 |

Toyota Prius | Small Car | Hybrid | 43 |

Toyota Corolla | Small Car | Conventional | 31 |

Chevrolet Malibu | Midsize Car | Hybrid | 27 |

Chevrolet Malibu | Midsize Car | Conventional | 23 |

Nissan Altima | Midsize Car | Hybrid | 32 |

Nissan Altima | Midsize Car | Conventional | 25 |

Ford Escape | Small SUV | Hybrid | 26 |

Ford Escape | Small SUV | Conventional | 21 |

Saturn Vue | Small SUV | Hybrid | 28 |

Saturn Vue | Small SUV | Conventional | 23 |

Lexus RX | Midsize SUV | Hybrid | 22 |

Lexus RX | Midsize SUV | Conventional | 19 |

Toyota Highlander | Midsize SUV | Hybrid | 23 |

Toyota Highlander | Midsize SUV | Conventional | 17 |

Answer #1

put above data in below format in excel:

Hybrid | Conventional | |

Small Car | 37 | 27 |

Small Car | 43 | 31 |

Midsize Car | 27 | 23 |

Midsize Car | 32 | 25 |

Small SUV | 26 | 21 |

Small SUV | 28 | 23 |

Midsize SUV | 22 | 19 |

Midsize SUV | 23 | 17 |

from excel :data-data analysis: ANOVA: 2 factor with replication:

below is output:

Source of Variation |
SS |
df |
MS |
F |
P-value |

class |
428.5 |
3 |
142.83 |
24.31 |
0.0002 |

type |
169 |
1 |
169.00 |
28.77 |
0.0007 |

Interaction |
27.5 |
3 |
9.17 |
1.56 |
0.2730 |

Within |
47 |
8 |
5.88 |
||

Total |
672 |
15 |

b)\

p value for class =0.0002

c)

p value for type =0.0007

d)

p value for interaction =0.2730

As part of a study designed to compare hybrid and similarly
equipped conventional vehicles, Consumer Reports tested a
variety of classes of hybrid and all-gas model cars and sport
utility vehicles (SUVs). The following data show the
miles-per-gallon rating Consumer Reports obtained for two
hybrid small cars, two hybrid midsize cars, two hybrid small SUVs,
and two hybrid midsize SUVs; also shown are the miles per gallon
obtained for eight similarly equipped conventional models.
Make/Model
Class
Type
MPG
Honda Civic...

As part of a study designed to compare hybrid and similarly
equipped conventional vehicles, Consumer Reports tested a
variety of classes of hybrid and all-gas model cars and sport
utility vehicles (SUVs) were tested. The following data show the
miles-per-gallon rating Consumer Reports obtained for two
hybrid small cars, two hybrid midsize cars, two hybrid small SUVs,
and two hybrid midsize SUVs; also shown are the miles per gallon
obtained for eight similarly equipped conventional models.
Make/Model
Class
Type
MPG...

You may need to use the appropriate technology to answer this
question.
As part of a study designed to compare hybrid and similarly
equipped conventional vehicles, Consumer Reports tested a
variety of classes of hybrid and all-gas model cars and sport
utility vehicles (SUVs). The following data show the
miles-per-gallon rating Consumer Reports obtained for two
hybrid small cars, two hybrid midsize cars, two hybrid small SUVs,
and two hybrid midsize SUVs; also shown are the miles per gallon
obtained...

You may need to use the appropriate technology to answer this
question.
As part of a study designed to compare hybrid and similarly
equipped conventional vehicles, Consumer Reports tested a
variety of classes of hybrid and all-gas model cars and sport
utility vehicles (SUVs). The following data show the
miles-per-gallon rating Consumer Reports obtained for two
hybrid small cars, two hybrid midsize cars, two hybrid small SUVs,
and two hybrid midsize SUVs; also shown are the miles per gallon
obtained...

As part of a study designed to compare hybrid and similarly
equipped conventional vehicles, a group tested a variety of classes
of hybrid and all-gas model cars and sport utility vehicles (SUVs).
Suppose the following data show the miles-per-gallon rating
obtained for two hybrid small cars, two hybrid midsize cars, two
hybrid small SUVs, and two hybrid midsize SUVs; also shown are the
miles per gallon obtained for eight similarly equipped conventional
models.
Class
Type
MPG
Small Car
Hybrid
37...

As part of a study designed to compare hybrid and similarly
equipped conventional vehicles, a group tested a variety of classes
of hybrid and all-gas model cars and sport utility vehicles (SUVs).
Suppose the following data show the miles-per-gallon rating
obtained for two hybrid small cars, two hybrid midsize cars, two
hybrid small SUVs, and two hybrid midsize SUVs; also shown are the
miles per gallon obtained for eight similarly equipped conventional
models.
Class
Type
MPG
Small Car
Hybrid
37...

As part of a study designed to compare hybrid and similarly
equipped conventional vehicles, a group tested a variety of classes
of hybrid and all-gas model cars and sport utility vehicles (SUVs).
Suppose the following data show the miles-per-gallon rating
obtained for two hybrid small cars, two hybrid midsize cars, two
hybrid small SUVs, and two hybrid midsize SUVs; also shown are the
miles per gallon obtained for eight similarly equipped conventional
models.
Class
Type
MPG
Small Car
Hybrid
38...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 13 minutes ago

asked 22 minutes ago

asked 24 minutes ago

asked 35 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago