Using Excel

Before encountering SPSS or any other statistical software, we generally have to organise our data in some form using Excel spreadsheets.  Try this  guide to the basics of using Excel  or this pdf document if you are using Excel for Survey Questionnaires.

If you want to go a step further a do some basic statistics in Excel, try this guide to using statistical functions in Excel using Excel 2003.  There are numerous resources out there using Excel Templates for common statistical tests.  For example, Pearson’s Correlation Coefficient or Pearson’s rChi-Squaret-tests, including the One-Sample t-test, the Independent Samples t-test, and the Dependent Samples t-test, and the ANOVA, or Analysis of Variance.  But bear in mind that some statistical tests on Excel are not as accurate as using stats software such as SPSS.   See  numerical methods in Excel for more details.

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks
This entry was posted in Statistics, Statistics Calculation Tools, Uncategorized, Using Excel and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply