EXCEL
Statistics Tutorials

Tutorials Home

KWIKSTAT 

New -- Kwikstat
Data Generator

Generate data sets with continuous, categorical, grouped and correlated data. Great for creating data sets for examples and for quality assurance testing. Data sets are created in standard .CSV format so they can be opened in most statistical programs such as SAS, SPSS, WINKS and into spreadsheet programs such as Microsoft Excel. Order now.

These tutorials briefly explain the use and interpretation of standard statistical analysis techniques. The examples include how-to instructions for Excel. Although there are different version of Excel in use, these should work about the same for most recent versions. They also assume that you have installed the Excel Analysis Pak which is free and comes with Excel (Go to Tools, Addins... if it is not already installed in your version of Excel.)

Index to Excel Statistics Tutorials

• Descriptive Statistics with histogram
• New - Calculate Pearson's Correlation
• T-Test Tutorial (Two-Group, Independent Groups)
• Paired T-Test Tutorial (Paired, Matched, Repeated Measures sample)
• watch for more tutorials soon..

• Data files

General Statistical Tutorials

• Interpreting p-values

• Understanding hypothesis testing

• Statistical comparison of two groups

 

• Your comments are welcome

• For more information... we recommend:

  • WINKS -- a simple to use and affordable statistical software program that will help you analyze, interpret and write-up your results. Download a free trial copy.
     

  • Additional statistics tutorials.
     

  • Against All Odds VIDEOS - Now in VHS or DVD formats Teaching Videos from Annenberg/PBS Click here for info
     

  • BeSmartNotes Reference sheets for SAS, SAS ODS, SPSS and WINKS  - Click here for info. (www.besmartnotes.com)
     

  • Statistical Analysis Quick Reference Guidebook: With SPSS Examples is a practical "cut to the chase" handbook that quickly explains the when, where, and how of statistical data analysis as it is used for real-world decision-making in a wide variety of disciplines. It contains examples using SPSS Statistics software. In this one-stop reference, the authors  provide succinct guidelines for performing an analysis, avoiding pitfalls, interpreting results, and reporting outcomes. Paperback. Sage Publishers ISBN: 1412925606 Order book from Amazon

  | Send comments | Tutorial Index | WINKS Software | BeSmartNotes |

© Copyright TexaSoft, 1996-2008

This site is not affiliated with Microsoft