HowToUseExcel1

HowToUseExcel1 - Name How to Use Excel to Calculate the...

This preview shows pages 1–2. Sign up to view the full content.

Name: _____________________________ How to Use Excel to Calculate the Mean and the Standard Deviation An Excel worksheet looks like an infinite chart with letters to label the columns and numbers to label the rows. It looks like this: A B C D E F G 1 Cat Dog 2 3 4 5 6 Bird 7 8 So, we can call the cell with the word “Cat” in it A1 . And the cell with the word “Dog” in it can be called B1 . What cell is the word “Bird” in? One of the coolest things about Excel is that we can perform statistics easily using it. It has functions that will calculate things like the Sum, the Average and the Standard Deviation for us (there are many more, but those are the ones that are most useful to us in class). All we have to do is enter the data into a worksheet and use the appropriate commands. For example, say we have the following set of data: { } 45 56, 58, 35, 31, 40, 41, 29, 24, = x which are the ages of the 9 full-time math teachers at Laney College. If we would like to find the Mean and the

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/12/2011 for the course STA 215 taught by Professor Tba during the Spring '08 term at Grand Valley State.

Page1 / 2

HowToUseExcel1 - Name How to Use Excel to Calculate the...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online