Transcript Descriptive stats and Graphing

Assignment:
Descriptive stats and Graphing using
Excel 2010
Open Excel 2010
• File
• New
• Blank
worksheet
• Create
New worksheet
Keep this
worksheet
open
Go to Word file
Copy the
data from the
Assignment
Word file
New worksheet
Back to Excel
to paste.
Click on the
first icon –
Keep source
formatting
(K)
Paste
…and save
the file.
Average
Type: =average(
In the cell below
first column then
left click/hold
while highlighting
(blue box) all the
data for the
Female column.
Finish by closing
parenthesis and
=average(B4:B11)
clicking Enter
Standard Error of the Mean
Below the mean
cell type:
=stdev(
Highlight the
data and close
parenthesis.
Type: /sqrt(8)
It should look
something like
this:
=stdev(B4:B11)/s
qrt(8)
Then hit enter.
Extending formula cells
Left click and
hold to select
the mean
and SEM cells
for the 1st
column.
Extending formula cells
Click and
hold lower
left corner
and extend
over to
expand to
the next
column.
Descriptive stats done!
Next let’s
make the
graph…
Making the bar graph
• Insert
• Column
• 2-D column
left box
(clustered
column)
Excel thinks for itself
If Excel does
something
automatically
like this…
Click on
select data
and we’ll
correct
Excel’s error
Excel thinks for itself
Remove any
series that
Excel automade and
let’s start
from scratch.
Your first bar (not drink-related)
Click Add
Series name
“Female”
Delete ={1}
from series
values and
click on the
mean for the
first column
(Females).
Your second bar
Click Add again
Series name
“Males”
Delete ={1}
from series
values and click
on the mean for
the second
column (Males).
This is how it should look
Clean up…
Right click
the vertical
axis and
select Format
axis
Clean up…
• Number
• Change
decimimal
places: to
zero
Axis labels
• Click on
graph
• Layout
• Axis title
• Primary
vertical axis
• Rotated
title
Axis labels
Type
‘Absolute
Heading
Error’
Axis labels
• Axis title
• Primary
Horizontal
Axis
• Title below
axis
Axis labels
Type ‘Group’
and delete
the number 1
above the
axis label
Error Bars
• Layout
• Error bars
• More error
bar options
Error Bars
•
•
•
•
Select female
Custom
Specify values
Delete ={1}
from each
box
• Click on the
SEM for the
first mean in
both positive
and negative
values
Error Bars
• Click on 2nd
bar and
repeat the
custom bar
selection as
performed
for the first
bar.
Error Bars
• Choose the
right SEM
value for
the Male
column.
Finished
You may play
around with
the
formatting
but I want to
see correct
values
represented
in the graph