Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Here are the steps to do a one-sample t-test using data in Excel and MATLAB. Excel does not provide this option.

  1. Copy the data from a row or column in Excel

  2. Paste into a variable in MATLAB:

    1. Go to the Command Window

    2. Type “>> y = [“

      Image Added
    3. Paste

    4. Type “]”

    5. Hit Enter; you’ve now created a variable “y” in MATLAB

  3. RRun Run the ttest function in MATLAB:

>> [h,p] = ttest(y)Image Added

p returns the p-value, and h is 1 (p<0.05) or 0.

See MATLAB’s help on ttest.

Image RemovedImage Added