Question

Waterfall Heights Is there a significant difference at

=α0.10

in the mean heights in feet of waterfalls in Europe and the ones in Asia? The data are shown. Use the critical value method with tables.

Europe			Asia
487	1246		614	320
470	345		350	964
900			722	830

Send data to Excel

Use

μ1

for the mean height of waterfalls in Europe. Assume the variables are normally distributed and the variances are unequal.

Find the critical value(s). Round the answer(s) to three decimal places. If there is more than one critical value, separate them with commas.

Critical value(s):

Answer 1

i am using excel to solve the problem.

steps:-

copy the data in two columns of excel named Europe and Asiadata data analysist-Test: Two-Sample Assuming Unequal Variancesok in variable 1 range select the entire data set of Europe and in variable 2 range select the entire data set of Asia including labels in hypothesized mean difference type 0tick labels in alpha type 0.1in output options select new worksheet ply ok

the needed excel output be:-

t-Test: Two-Sample Assuming Unequal Variances
	Europe	Asia
Mean	593.6	633.3333
Variance	235171.3	66941.87
Observations	5	6
Hypothesized Mean Difference	0
df	6
t Stat	-0.16471
P(T<=t) one-tail	0.43729
t Critical one-tail	1.439756
P(T<=t) two-tail	0.874579
t Critical two-tail	1.94318

SOLUTION TO PROBLEM:

hypothesis:-

test statistic is:-

[ from the excel output writing the t stat value by rounding off to 3 decimal places]

t critical value for alpha=0.10 is:-

[ as this is a both tailed test. from the excel output write the t Critical two-tail and add + - before it ]

decision:-

so, we fail to reject the null hypothesis and conclude that there is not sufficient evidence to say that there is a significant difference in the mean heights in feet of waterfalls in Europe and the ones in Asia at 0.10 level of significance.

*** if you have any doubt regarding the problem please write it in the comment box.if you are satisfied please give me a LIKE if possible...