270 likes | 388 Views
C81MPR. How to produce a histogram in APA style for your practical with Excel Jasper Robinson – April 2007. Use “=average(DATA)” to get the mean for your two sets of data…. …use “=sqrt(var(DATA)/N)” to get the SEM (standard error of the mean) . Notice N is 5 here; you’ll need to count
E N D
C81MPR How to produce a histogram in APA style for your practical with Excel Jasper Robinson – April 2007
Use “=average(DATA)” to get the mean for your two sets of data…
…use “=sqrt(var(DATA)/N)” to get the SEM (standard error of the mean) Notice N is 5 here; you’ll need to count your own data
Click the Chart button to open the Chart Wizard Choose “Column”
Repeat those steps to name the other condition
Step through the Wizard’s tabs and do what follows on the next slides…
Chart title? Abscissa? Ordinate?
We now have a histogram but the font is too small… make it 14 Point, BOLD Arial…
Now for SEMs: RIGHT CLICK the Control bar of the histogram & choose Format Data Series…
Look in Fill Effects for cross hatchings Make sure the Patterns are clear…I’ve chosen black & white (avoid relying on colours alone)
Copy & paste your histogram into your article…make it BIG (between ½ page and a whole page)
Give your histogram a sensible “Figure Legend”…e.g… Figure 1. Mean percentage recalled from test in Experiment 1. Error bars indicate one standard error of the mean. See Procedure for full details.
…voila! Tip: keep your APA-formated Exl file for future histograms Figure 1. Mean percentage recalled from test in Experiment 1. Error bars indicate one standard error of the mean. See Procedure for full details.