Tomato Farmer Two Population Means – Spreadsheet Solutions

The spreadsheet below shows the hypothesis tests performed for the two population means of the tomato farmer.

Tomato Farmer Two Population Means Spreadsheet

 New FertilizerOld FertilizerPaired
Sample Size151515
Sample Mean14.2213.940.28
Standard Deviation0.54930.52750.2242
Test 1 - Farmer's Test
H0new fertilizer mean = old fertilizer mean
H1new fertilizer mean ≠ old fertilizer mean
Significance Level0.05
Decision Rule1.645Reject H0 if t-value ≠ 1.645
T-Statistic1.974266262
DecisionReject H0
p-value0.024175738
Test 2 - One Tail Test
H0paired sample mean <= 0
H1paired sample mean > 0
Significance Level0.05
Decision Rule1.645Reject H0 if t-value <= 1.645
T-Statistic4.835944958
DecisionDo NOT Reject H0
p-value0.999999337
 

Your browser is out of date. It has security vulnerabilities and may not display all features on this site and other sites.

Please update your browser using one of modern browsers (Google Chrome, Opera, Firefox, IE 10).

X