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?Write your Review or question?

Related Questions in Statistics and Probability

Please let me know what are the steps involved in computing

Please let me know what are the steps involved in computing the future value when you have multiple cash flows.

Your supervisor comes to you and says she would like a

Your supervisor comes to you and says she would like a marketing research study. She says there is a budget of $30,000. She would like to conduct a simple random sample of consumers interested in using the services of th ...

For the given cash flows below assume the cash flow is the

For the given cash flows below, assume the cash flow is the same in the next 2 years. Compute the NPV for each project, and compute the incremental IRR. Compare and explain why NPV always gives the correct decision. ...

Lets do some r suppose you have the following situation you

Let's do some R.... Suppose you have the following situation: You have a large jar of beans, 43% black, 57% white. You take a sample of 14 beans. a) Use R to figure out the probability for every single possible outcome. ...

The company financial officer was interested in the average

The company financial officer was interested in the average cost of PCs that had been purchased in the past six months. A random sample of the price of 10 computers was taken with the following results (mean = $3,213): $ ...

A cupcake stand has 40 chocolate 30 coconut and 20 banana

A cupcake stand has 40 chocolate, 30 coconut and 20 banana cupcakes. Alice chooses 20 cupcakes at random to make a box as a present for her friend. What is the probability that she chose a. Eight banana and 6 coconut cup ...

A machine has four components a b c and d set up in such a

A machine has four? components, A? B, C, and? D, set up in such a manner that all four parts must work for the machine to work properly. Assume the probability of one part working does not depend on the functionality of ...

Consider the probability distribution shown belowx 0 1 2 px

Consider the probability distribution shown below. x 0 1 2 P(x) 0.65 0.30 0.05 Compute the expected value of the distribution. Compute the standard deviation of the distribution. (Round your answer to four decimal places ...

1 prince georges county publicnbspschools wants to access

1) Prince George's County Public Schools wants to access the effectiveness of its new 1st grade reading program. Ten 1st grade classrooms are randomly selected from across the county. What kind of sampling method is bein ...

Your company is considering a new project that will require

Your Company is considering a new project that will require $18,000 of new equipment at the start of the project. The equipment will have a depreciable life of 5 years and will be depreciated to a book value of $3,000 us ...

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