0
   

Can a Z-Test of Two Sample means in Excel be used to answer two separate hypotheses.

 
 
XGIS
 
Reply Sat 19 Jan, 2019 01:15 pm
Can a Z-Test of Two Sample means in Excel be used to answer two separate hypotheses.
1) Hypothesized Mean Difference=0 (Two-Tailed) (NULL vs Alternate, ho = ha)
2) Treatment > Control (One-Tailed)
I am currently doing a Z-Test of Two Sample Means (Control vs Treatment) with Null and Alternate Hypotheses. This is used to determine if there is statistical evidence to indicate a difference between the two means using the Two Tail approach.
Question 1
Can I use the same Z-Test of Two Sample Means output from Excel to Answer Hypothesis 2 above ie Treatment > Control OR is a t-Test: Two-Sample Assuming Equal Variances the more valid approach.
Question 2
Does it matter if the sample populations vary e.g. n=100 (Treatment) vs n=50 (Control) with either tested hypothesis
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 108 • Replies: 1
No top replies

 
XGIS
 
  1  
Reply Sat 19 Jan, 2019 05:30 pm
@XGIS,
This is the sample out put from Excel (here goes for formatting)

z-Test: Two Sample for Means

Control Treatment
Mean 2.887822 2.738808
Known Variance 0.060784456 0.032036594
Observations 50 50
Hypothesized Mean Difference 0
z 3.458508413
P(Z<=z) one-tail 0.000271588
z Critical one-tail 1.644853627
P(Z<=z) two-tail 0.000543175
z Critical two-tail 1.959963985
0 Replies
 
 

 
  1. Forums
  2. » Can a Z-Test of Two Sample means in Excel be used to answer two separate hypotheses.
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 04/19/2024 at 05:59:43