1 / 16

T-Test

T-Test. Label and list one set of scores in one column List the second set in the second column. Choose Formulas tab>more functions>statistical> T.test. A box will pop up. Click on Array 1>Highlight the first column. You will notice that Array 1 now says A1:A11.

Download Presentation

T-Test

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. T-Test • Label and list one set of scores in one column • List the second set in the second column

  2. Choose Formulas tab>more functions>statistical>T.test

  3. A box will pop up

  4. Click on Array 1>Highlight the first column You will notice that Array 1 now says A1:A11

  5. Click on Array 2>Highlight the second column The numbers from each column are on the right of the table.

  6. The next box asks for the number of tails. • Click on that box for an explanation. • We will choose 2

  7. Choose the type of T-Test you want to run. • If you put your cursor in the Type box, it will give you an explanation of your choices

  8. We will type 1 in the box • Then put your cursor on the spreadsheet Your answer will appear at the bottom of the right hand column.

  9. If you place your cursor on the spreadsheet, the answer will appear there when you hit OK

  10. Standard Deviation • Choose Formulas tab>more functions>statistical>STDEV.S for standard deviation of a sample (STDEV.P for standard deviation of population) Every time you click in a box and highlight a row of numbers it will add a new box.

  11. Creating Charts • If you want to create a column chart, go to Insert • Highlight the columns you want to include, • Click on Column • Click on the style you want If you include the Column labels, a Legend will appear on The right

  12. Correlation • Put your numbers in corresponding columns • Choose Formulas tab>more functions>statistical> • Choose CORREL or PEARSON

  13. Click on Array 1>Highlight the first column

  14. Click on Array 2>Highlight the second column

  15. Your answer is in the right hand column and on the designated block on your spreadsheet

  16. Scatter Plot • Go to Insert • Highlight your columns • Click on Scatter

More Related