Page 8 of 22PREVNEXT

Excel statistical functions

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


To use statistical functions with Excel you must have:

A statistical add-in package.

You can't do statistics in Excel.

A computer with Excel installed.

A degree in statistics.

How do you create a statistical formula in Excel?

It's exactly like any other formula: type =, then the function name followed by the data information.

On the Data menu, click Statistics.

On the Insert menu, click Statistics Function.

Which of these is a formula in Excel?

STDEV

=STDEV(A1:A33)

NaCl

Page 8 of 22PREVNEXT