Conducting Statistical Tests on Excell

Chapter 4. Comparing Means

The link below contains the Smart Board notes from a graduate course I taught to high school teachers covering this topic.  I hope these notes are helpful.

http://www.slideshare.net/MarkMcGinley/lecture-statistical-tests

Expected Learning Outcomes

By the end of this course a fully engaged student should be able to

1) determine when you need to use a t-test to help you test your hypothesis

2) determine which type of t-ttest you should use (i.e., one-tailed vs two-tailed test, paired vs unpaired test)

3) use Excel to perform a t-test on the computer

4) use the output of the statistical tests to correctly draw conclusions


Chapter 5. Correlations between quantifiable variables.

Here is a link to the Smart Board Notes from my other class.

http://www.slideshare.net/MarkMcGinley/smart-board-notes-617



Expected Learning Outcomes

By the end of this course a fully engaged student should be able to

1) determine when you need to use regression to help you test your hypothesis

2) use Excel to conduct regression analysis

3) interpret the outcome of this test to correctly draw conclusions


Chapter 6. Associations Between Categorical Variables

Expected Learning Outcomes

By the end of this course a fully engaged student should be able to

1) determine when you need to use a chi square test of association or a chi square goodness of fit test to test your hypotheses

2) calculate the expected values in the chi square test of association or chi square goodness of fit test

3) use Excel to conduct the Chi Squre test

4) interpret the results to correctly draw conclusions


Appendix 1.

I added Appendix 1 to the lab manual for students that might have been a little bit less math phobic and who might actually benefit from understanding a bit more about how the math of the statistical tests work. Because you are all comfortable with math, I hope you take a look at this short section.

Process of Science- Final Thoughts

After you have finished reading the entire book, don't forget that the three most important summaries are found on pages 30 - 32. Enjoy.

Here is a link to the Smart Board Notes from last year.

http://www.slideshare.net/MarkMcGinley/smart-board-notes-617