Scribd
Upload
8 views2 pages

Calculate Statistics in Excel

Spreadsheet programs like Excel can easily calculate statistics by using built-in functions. Users can calculate the average of a range of cells by using the AVERAGE function and specifying the cell range. The standard deviation of a data set can also be calculated using Excel's STDEV function. Standard error is calculated using a formula that divides the standard deviation by the square root of the number of observations.

Uploaded by

maria
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
8 views2 pages

Calculate Statistics in Excel

Spreadsheet programs like Excel can easily calculate statistics by using built-in functions. Users can calculate the average of a range of cells by using the AVERAGE function and specifying the cell range. The standard deviation of a data set can also be calculated using Excel's STDEV function. Standard error is calculated using a formula that divides the standard deviation by the square root of the number of observations.

Uploaded by

maria
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Calculating the statistics using Excel

Spreadsheet programs (like Microsoft Excel) can calculate statistics easily. Once you have the data in Excel, you can use the built-in statistics
package to calculate the average and the standard deviation.

To calculate the average of cells


A4 through A8:

Select the cell you want



the average to appear in
(D1 in this example)
Type "=average(a4:a8)"

Press the Enter key

To calculate the standard


deviation of the five numbers, use
Excel's built-in STDEV function.
Excel doesn't have a standard
error function, so you need to use
the formula for standard error:

where N is the number of


observations

You might also like