Excel^TM for Statistics

Howard Grubb, Colin Grayer, Sandro Leidi and Roger Stern

Resources

• Why use Excel for statistics?
• Add-In for doing statistics (Help file, Booklets) (right click and save each file, then use Tools > Add-Ins > Browse to open in Excel)
• Good Statistics with Excel seminar (PowerPoint)
• Example spreadsheets:
  • anaerob.xls
  • timetables.xls
  • bank.xls
  • survey.xls
  • sample_demo.xls
• Macro writing tutorial
• Booklets:
  • Using Excel for Statistics - Tips and Warnings (PDF)
  • Disciplined Use of Spreadsheet Packages for Data Entry (PDF)
  • The Role of a Database Package for Research Projects (PDF)
  • Guidelines for Good Statistical Graphics with Excel (PDF)
  • Good Tables for Excel Users (PDF)
• Courses on Excel and Statistics
• ASSUME resources