How to Make an APA 7 Bar Chart with Error Bars in Excel

This is a tutorial for making APA 7 style bar charts in Excel! Check out APA 7 guidelines here: apastyle.apa.org/products/pub...
Another helpful resource: owl.purdue.edu/owl/research_a...
Data used in the example: www.kaggle.com/datasets/ydala...

[@dayfani_]

Thank you! This was super helpful :)

[@alivahabov1703]

Thank you teacher

[@yamyosh8005]

You are a legit life saver

[@JasperD-oi5vh]

So just double check the CI diff is essentially the standard error of the mean, right?

[@karyssa_]

Standard error is computed by dividing the standard deviation by the square root of n. In this case, the standard error of "Less than 20" would be 3.05/sqrt(1819) = .07. Thus you would need to divide the "CI_Diff/2" column by 2 to get the standard error.

[@JasperD-oi5vh]

@@karyssa_ Much obliged

[@prodbyfm]

bro i haaateeee apa why do the bars have be grey and why do we have to write out numbers under 10 its like they want the information to be hard to access to reader like bro damnnnn psychologists are losers fr why did i choose to study with losers thats how im feelin today

[@jackbombay1423]

Yes, they are just charlatans with a degree. But you can earn money scamming people.

[@prodbyfm]

man thank you for the tutorial but damn this is slow