Carrying out a T-Test in Microsoft Excel

Author: | Posted in software review 32 Comments



On this video I take advantage of Excel for Mac 2011 Model 14.2.3

First state a null speculation – which is at all times that there’s NO vital distinction between your two knowledge units.

Select the cell during which you want to calculate the p-value (the worth that Excel produces in a t-test). Choose the blue enigma signal on the prime of the display, then ‘extra features’ after which seek for t-test. Double click on.

Put the next within the choice containers:
Array 1 – Choose your knowledge set 1
Array 2 – Choose your knowledge set 2
Tails – kind in ‘2’ to characterize 2-tailed take a look at as described within the directions (until your teacher states in any other case)
Sort – kind in ‘2’ to characterize two-sample equal variance as described within the directions

Hit ‘enter’ and a p-value will probably be calculated by Excel.

If the P-value is larger than 0.05, we contemplate it to be excessive and in such a case there’s a excessive likelihood that your noticed outcomes are due merely to probability and never another variable. This might be the case if the calculated worth of t had been lower than the essential worth of t (had you calculated the worth of t your self as a substitute of in Excel). In such a case you’d settle for the null speculation and state that there isn’t a vital distinction between the 2 knowledge units on the 5% or 0.05 significance degree.

If the P-value is decrease than 0.05, we contemplate it to be low and in such a case there’s a low likelihood that your noticed outcomes are due merely to probability and a excessive likelihood that they’re on account of another variable. This might be the case if the calculated worth of t had been greater than the essential worth of t (had you calculated the worth of t your self as a substitute of in Excel). In such a case you may reject the null speculation and state that there’s a vital distinction between the 2 knowledge units on the 5% or 0.05 significance degree.

source

Comments
  1. Posted by John Antinora
  2. Posted by Rachael Roo
  3. Posted by Jade Lee
  4. Posted by Brad Oxler
  5. Posted by Samuel Bruce
  6. Posted by Grand Shanks
  7. Posted by Baker Lee
  8. Posted by Dr Min Thu
  9. Posted by Rich Hogg
  10. Posted by Harsimran Singh Sethi
  11. Posted by Linnah Wang
  12. Posted by skyhybrid
  13. Posted by Sudhir Kudikala
  14. Posted by Mr.Miscellaneous
  15. Posted by 10ohagan
  16. Posted by Mark Minnema
  17. Posted by Jordan Nielson
  18. Posted by Mona Pal
  19. Posted by Tony Vid
  20. Posted by Aragornaz
  21. Posted by Austin Frewert
  22. Posted by Reetobrata Basu
  23. Posted by Peaklist
  24. Posted by Aditya Reddy
  25. Posted by blahblah89750
  26. Posted by intubation8
  27. Posted by NAIF ALHARBY
  28. Posted by mingtipparat
  29. Posted by Stephanie Castle
  30. Posted by Sarah
  31. Posted by Stephanie Castle
  32. Posted by Sarah

Add Your Comment