bird_song_data_section_1_ss2

bird_song_data_section_1_ss2 - Bird Type Total # phrases #...

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

View Full Document Right Arrow Icon
Bird TypeTotal # phras# phrase types song length (s) NORMAL1 4 4 2.300 NORMAL2 5 4 1.950 NORMAL3 4 4 1.800 NORMAL4 5 5 2.250 NORMAL5 4 4 1.900 NORMAL6 5 5 1.800 ISOLATE1 2 2 1.700 ISOLATE2 4 3 1.900 ISOLATE3 3 2 2.500 ISOLATE4 2 2 1.200 ISOLATE5 2 2 1.600 ISOLATE6 1 1 1.700 HINT: Calculate group averages… AVG # Phrases AVG # phrase typesAVG song length NORMAL ISOLATE SE # Phrases SE # phrase types SE song length NORMAL ISOLATE HELPFUL INFORMATION Calculating Standard Error 1. Find Standard Deviation - in Excel, use formula 'STDEV(datarange)' 2. Divide SD by the square root of the sample size - Excel formula 'SQRT(#)' Adding Error Bars to Graphs 1. Right click on data series BAR on the graph 2. Go to -> Format Data Series 3. Under 'Format Y-Error bars', select "Custom" 4. Enter Data range that contains your Standard Error values, the same values for both "+" and "-" FYI: make sure you assign the correct SE to the correct data series, as you will have d
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 / 3

bird_song_data_section_1_ss2 - Bird Type Total # phrases #...

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