Instructions for Running a t-Test in Excel.doc
《Instructions for Running a t-Test in Excel.doc》由会员分享,可在线阅读,更多相关《Instructions for Running a t-Test in Excel.doc(2页珍藏版)》请在三一文库上搜索。
1、Running a t-Test in EXCELTM 2003Heres an example: You measure iron concentration in 3 separate water samples from a stream and 3 separate water samples from a lake. Youre null hypothesis is that the stream and the lake will have the same iron concentration. Your results from the stream are 1.0, 0.5
2、and 0.8 ppm. Your results from the lake are 0.7, 0.2 and 0.3. To determine if your results are significant you need to perform a statistical test. Your null hypothesis is usually the hypothesis that states there is no difference. . . Scientists always try to disprove the null hypothesis. So you will
3、 probably be comparing two treatments or a treatment versus a control. In statistics you usually compare the average or mean values.In this example we will be comparing the mean stream value with the mean lake value. The number of replicates in this example is three, because thats how many samples w
4、e have from each treatment. The means in this case will be different. But is that difference due to randomness or is it due to the fact that they come from different water sources? We will use a statistical test to tell us the answer.The test we will be using is called Students t-test (named after t
5、he statistician Student). It is used for experiments where you are comparing two treatments or a treatment vs. control. For experiments with more than two treatments a different statistical test would be used.When you run the t-test, EXCEL will provide a printout that contains the mean values and ot
6、her information. The most important part of these results is the p-value. The p-value tells you in an unbiased manner whether you must accept or reject the null hypothesis.Procedure1. Open a blank spreadsheet in EXCEL.2. Go to the cell in the upper left corner (cell A1). Type in the name of one of y
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Instructions for Running t-Test in Excel Test
链接地址:https://www.31doc.com/p-8845203.html