Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 Excel statistical functions 
 
  Overview  
 Show/Hide lesson sections Excel and statistics: The basics
 Show/Hide lesson sections Write good formulas
 Show/Hide lesson sections Which function to use?
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Overview
Use Excel to handle statistics  

Learn about using statistical functions and formulas in Microsoft Office Excel 2003, from the very basics to choosing the right function for you. Learn also how to troubleshoot common problems.

  • Length: 40–50 minutes
  

Next

GOALS

After completing this course you will be able to:

  • Use a statistical function in an Excel spreadsheet.
  • Assess which statistical function to use in a particular situation.
  • Avoid some common errors when using functions.
  • Understand why some statistical formula results are more accurate in Excel 2003.
  
ABOUT THIS COURSE

This course includes:

  • Three self-paced lessons and three practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.
COURSE TEXT

Whether you're seeking some basic information about using statistical functions in Excel, or you're a statistics expert and are wondering why you're getting more accurate results in Excel 2003, this course has something for you.

If you're a novice, you'll find out the basics of building formulas in Excel. More experienced users will learn more about choosing the right function to use and how to troubleshoot some common problems.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column.

When you're done reading this page, click Next to start the first lesson.

  
BEFORE YOU BEGIN

You should have some basic knowledge of using formulas in Excel. The course Find functions and enter arguments can show you the basics.

If you're an Excel expert, you might prefer to jump straight to Lesson 3 to read about some improvements to statistical formulas in Excel 2003.
  Go to previous page (disabled)    Next Go to next page
advertisement