Scribd
Upload
3 views

Independent Sample t Test Excel

The document presents statistical data comparing male and female groups, including means, standard deviations, and other descriptive statistics. The male group has a mean of 429.05, while the female group has a mean of 430.52, with a t-test indicating no significant difference between the two. Additional metrics such as variance, kurtosis, and skewness are also provided for both groups.

Uploaded by

Sumit Kumar Jena
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
3 views

Independent Sample t Test Excel

The document presents statistical data comparing male and female groups, including means, standard deviations, and other descriptive statistics. The male group has a mean of 429.05, while the female group has a mean of 430.52, with a t-test indicating no significant difference between the two. Additional metrics such as variance, kurtosis, and skewness are also provided for both groups.

Uploaded by

Sumit Kumar Jena
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Male Female

431 411
432 412
444 413
432 444
411 424
432 456
422 432
435 435
413 444
415 412
436 418
438 421
445 427
411 428
447 435
448 437
411 440
423 441
427 442
428 437
432
Male

Mean 429.05
Standard Error 2.75153067448495
Median 431.5
Mode 432
Standard Deviation 12.3052192606484
Sample Variance 151.418421052632
Kurtosis -1.06496201095226
Skewness -0.119158320058961
Range 37
Minimum 411
Maximum 448
Sum 8581
Count 20
Largest(1) 448
Smallest(1) 411
Confidence Level(95.0%) 5.75901988813931

434.80901988814
424.80641558214
t-Test: Two-Sample Assuming Equal Variances

Male Female
Mean 429.05 430.52380952381
Variance 151.418421052632 157.7619047619
Observations 20 21
Pooled Variance 154.67148962149
Hypothesized Mean Difference 0
df 39
t Stat -0.379287859179183
P(T<=t) one-tail 0.353265741660306
t Critical one-tail 1.68487512171122
P(T<=t) two-tail 0.706531483320612
t Critical two-tail 2.02269092003676
Male Female

Mean 429.05 Mean 430.52380952381


Standard Error 2.75153067448495 Standard Error 2.74088884403013
Median 431.5 Median 432
Mode 432 Mode 412
Standard Deviation 12.3052192606484 Standard Deviation 12.5603305992281
Sample Variance 151.418421052632 Sample Variance 157.761904761905
Kurtosis -1.06496201095226 Kurtosis -0.689363983789448
Skewness -0.119158320058961 Skewness -0.084510537725024
Range 37 Range 45
Minimum 411 Minimum 411
Maximum 448 Maximum 456
Sum 8581 Sum 9041
Count 20 Count 21
Largest(1) 448 Largest(1) 456
Smallest(1) 411 Smallest(1) 411
Confidence Level(95.0%) 5.75901988813931 Confidence Level(95.0%) 5.71739394166563

You might also like