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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online