Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Inorganic phosphorous is a naturally occurring element in all plants and animals

ID: 3153089 • Letter: I

Question

Inorganic phosphorous is a naturally occurring element in all plants and animals, with concentrations increasing progressively up the food chain. Geochemical surveys take soil samples to determine phosphorous content in ppm.Let m1be the mean phosphorous content for region 1, and m2be the mean phosphorous content for region 2.    Based on this sample data, is there evidence that the two means are different? What is the test statistic and p-value?

X1 : phosphorous content for region 1, in ppm:

   540    810    790    790    340    800    890    860    820    640    970    720

X2 : phosphorous content for region 2, in ppm:

  750   870   700   810   965   350   895   850   635   955   710   890   520   650   280   993

Explanation / Answer

Here we have to test the hypothesis that,

H0 : m1 = m2 Vs H1 : m1 m2

where, m1 be the mean phosphorous content for region 1,

and m2 be the mean phosphorous content for region 2.

Assume alpha = level of significance = 5% = 0.05

Here n1 = 12

and n2 = 16

Both the sample sizes are small and population standard deviation is unknown so we use two sample t-test.

But before that we have to test whether variances are equal or not.

FOr variance testing the hypothesis is,

H0 : Variances are equal.

H1 : Variances are not equal.

Both testing we can done using EXCEL.

steps :

Enter all the data in EXCEL sheet --> Data --> Data Analysis --> F-Test Two - Sample for Variances --> ok --> Variable1Range : select X1 range --> Variable2Range : select X2 range --> Alpha : 0.05 --> Output Range : select one empty cell --> ok

Output is :

The test statistic F = 0.6452

P-value = 0.234

P-value > alpha

Accept H0 at 5% level of significance.

Conclusion : Variances are equal.

So we use pooled variances (equal variances).

Now two sample t-test assuming equal variances by using EXCEL is,

steps :

Data --> Data analysis --> t-test : Two-Sample Assuming Equal Variances --> ok --> Variable1Range : select X1 range --> Variable2Range : select X2 range --> Hypothesized Mean Difference : 0 --> Alpha : 0.05 --> Output Range : select one empty cell --> ok

Output :

Test statistic t = 0.1146

P-value = 0.9096

P-value > alpha

Accept H0 at 5% level of significance.

Conclusion : There is not sufficient evidence to say that the two means are different.

F-Test Two-Sample for Variances Variable 1 Variable 2 Mean 747.5 738.9375 Variance 29038.64 45006.06 Observations 12 16 df 11 15 F 0.645216 P(F<=f) one-tail 0.234159 F Critical one-tail 0.367831