Home | About | Books | Contact | Statistics Resources
New Office 2.0 Worksheet Templates
"Office 2.0" is part of Web 2.0, and involves the use of online productivity tools to make shareable documents that are hosted online. With Office 2007, Microsoft discontinued this functionality, which was known as "web components." I have located a number of online productivity suites, and the one most suited for these templates is Zoho Sheet, an online spreadsheet that uses Excel formulas and is Excel-compatible. These worksheets are generally limited to 500 cases.
I use these templates as transparent teaching tools. Most online statistical calculators do not show the mechanics of the calculations, while a spreadsheet model can make them visible. I make it possible for you to see the formulas and functions I use to produce the results so that you can see how the statistical formula is working.
Feel free to use and share the templates shown here for personal and educational use. You may use the template interactively in this web page, or open it in full view. You may also save the template as an Excel file if you like. I will be adding templates over time. Type or paste your raw data into the green-shaded data entry area.
Descriptive Statistics
Confidence Intervals (95% and 99%) for Population Mean (t Distribution)
One Sample t Test for a Population Mean
Independent-Samples t Test
Paired-Samples t Test
Copyright © 2009 TwoPaces LLC