Use Sophia to knock out your gen-ed requirements quickly and affordably. Learn more
×

Introduction into Doing Statistics in Excel

Author: Andrew Gabel

Playing with Statistics on Excel

In this video, you will be learning the basics of how to use excel for statistical purposes. When you go through this video, you will find where the statistical functions are located at, as well as how to write a function in a cell that will call upon the function. It is recommend that you do full screen to get the best visual to see what is going on.

We will also learn about "Data Analysis" that is an optional add on for Excel.

Example of some Statistical use on Excel

We are going to go over some examples of how to use statistics in Excel.

Helpful Links

Here is a guide of helpful links on statistical tools you can use on Excel.

Microsoft Office and "Data Analysis" tool:

http://office.microsoft.com/en-us/excel-help/about-statistical-analysis-tools-HP005203873.aspx

Complete list of Excel statistical functions:

http://office.microsoft.com/en-us/excel-help/statistical-functions-HP005203066.aspx

Now go and practice!

You made it!

Now take what you have learned, and apply it to your own statistical needs.