Utilizing excel data analysis calculate t distribution

Reference no: EM1316292

Using Excel data analysis calculate't' 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. Analysis of variance is used to investigate if there is a difference in the mean mileage of the three cars. 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

Reference no: EM1316292

Questions Cloud

Find the ebit-eps indifference point : Find the EBIT-EPS indifference point - Morton Industries is considering opening a new subsidiary in Boston, to b operated as a separate company.

Population mean cost : What is the 95% confidence interval estimate of the population mean cost for a prescription of Zocor?

What score should be used for the two cut offs : Robinson & Associates performs employment screening for large companies in southern California. It usually follows two-step process. First potential applicants are given a test that covers basic knowledge and intelligence. If applicants score b..

Find the ebit-eps indifference point : Find the EBIT-EPS Indifference point - What happens to the indifference point if the interest rate on debt increases and the common stock sales price remains constant

Utilizing excel data analysis calculate t distribution : Utilizing Excel data analysis calculate t distribution also deduce the result. Study of variance is used to investigate if there is a difference in the mean mileage of the three cars.

Identify the optimal and discriminating prices : Imagine the opera has a capacity of 3000 seats and that all costs are fixed. If they can discriminate between the two groups, what is optimal price to charge to each group and how many tickets will each group buy?

The marginal cost function : The marginal cost function

Evaluation of ebit-eps indifference point : Evaluation of EBIT-EPS indifference point - One piece of information the company desires for its decision analysis is an EBIT-EPS indifference point.

Computation of projected external capital requirements : Computation of projected external capital requirements and Determine Upton's projected external capital requirement if the increase in sales is expected to be carried out

User Account

All Pages