Embedded Files
COMPUTATION OF P VALUE USING t TEST
t testIt is a bivariate. It is also known as Student’s T Test. It is used to find the significant difference between two sets of data.= T.TEST(array1, array2,tails,type)
- Array1 refers to the first set of data (A1:A11).
- Array2 is the second set of data (B1:B11).
- Tails refers to whether you want to run a one- or two tailed test (in the example at left the number 2 is entered, indicating a two-tailed test; it would be 1 for a one-tailed test).
- Type refers to: 1 = paired test; 2 = two sample equal variance test; 3 = two sample unequal variance test The value returned from this formula is your p-value.
- Select Data Menu and click Data Analysis.
- Select T Test : Two Sample Assuming Unequal Variances or Equal Variance or Paired Test
- Give input with variable 1 and Variable 2 Ranges.
- Type ‘0’ in the Hypothesized Mean Difference
- Tick the labels Check box
- Select Output Range
- Finally, Click Ok
Page updated
Report abuse