One-sample t-test

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

    3. Paste

    4. Type “]”

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

  3. Run the ttest function in MATLAB:

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

See MATLAB’s help on ttest.