Using excel data analysis compute distribution and, Ask an Expert

Statistics

Using Excel data analysis compute distribution and interpret the result.

The fuel efficiencies for a sample of 27 compact, midsize and large cars are entered into a statistical software package. Examination of variance is used to investigate if there is a difference in the mean mileage of the three cars. Describe what do you conclude? Use the .01 significance level.

Summary
Groups	count	Sum	Average	Variance
Compact	12	268.3	22.35833	9.388106
Midsize	9	172.4	19.15556	7.315278
Large	6	100.5	16.75	7.303
			Anova
Source of Variation			SS	df	MS	F	p-value
Between groups			136.4803	2	68.24014	8.258752	0.001866
Within groups			198.3064	24	8.262766
Total			334.7867	26

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M923463

Have any Question?

Related Questions in Statistics and Probability

Thirty percent of the time a sale at food shoppe is paid

Thirty percent of the time, a sale at Food Shoppe is paid using a store-issued credit card. A sample of 18 Food Shoppe sales is obtained. Let X represent the number of sales paid for using the store-issued credit card. W ...

In pre election a candidate receives 330 out of 650 votes

In pre election , a candidate receives 330 out of 650 votes. Assuming that the people polled represents a random sample of voting population, test the claim that a majority of voters supports the candidate. Use a signifi ...

Assignment- inferences and linear regression1a left-tail

Assignment- Inferences and Linear Regression 1. A left-tail area in the chi-square distribution equals 0.95. For df = 10, the table value equals A. 18.307. B. 20.483. C. 3.940. D. 15.987. 2. Which of the following statem ...

Prove that if player i believes at the state of the world

Prove that if player i believes at the state of the world ω that the state of the world is consistent, then he believes that every player believes that the state of the world is consistent. Deduce that in this case playe ...

Consider the following belief space where the set of

Consider the following belief space, where the set of players is N = {I, II}, and the set of states of nature is S = {s 1 , s 2 }: Write out the belief hierarchies of orders 1, 2, and 3 of Player I, at each state of the ...

What is a critical value how is the critical value

"What is a critical value? How is the critical value determined? Are there differences between the standard normal table and the student t table when trying to determine the critical value? Explain."

Entertainment software association would like to test if

Entertainment Software Association would like to test if the average age of "gamers" (those that routinely play video games) is more than 30 years old. A random sample of 33 gamers was selected and their ages were record ...

Explain how you would conduct the study you designed in

Explain how you would conduct the study you designed in Question as a matched-subjects design. Question:- Design a randomized groups experiment to test the hypothesis that children who watch an hour-long violent televisi ...

Romeo composes a letter to juliet and gives it to tybalt to

Romeo composes a letter to Juliet, and gives it to Tybalt to deliver to Juliet. While on the way, Tybalt peeks at the letter's contents. Tybalt gives Juliet the letter, and Juliet reads it immediately, in Tybalt's presen ...

1 what is the relationship between confounding and internal

1. What is the relationship between confounding and internal validity? 2. What are experimenter expectancy effects, and how do researchers minimize them? 3. Should demand characteristics be eliminated or strengthened in ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert