Category Archives: Instructional Videos

APA-style graphs in Excel

So, you have some neat data and want to bung them in your report with funky colours and whacky axes? Sorry to burst your excitable bubble, but APA have strict guidelines for graphs, too. This short video shows you how to navigate the APA-graph-jungle.

Tagged , ,

APA (6th Edition) formatting in MS Word

So, you have conducted some nice research and wish to write it up for publication (or just to submit to your University). Most students are put off right from the get-go as they have to tackle the fiddly-demon that is APA formatting. (For those unfamiliar, APA stands for American Psychological Association.) These APA guidelines provide a uniform structure to all articles, and it is good practice to adhere closely to their guidelines.

This short video takes away some of the sting by showing you how to set up your Microsoft Word document according to APA (6th edition) standards.

Tagged ,

T-test in Excel

I had requests from some viewers of my videos asking how to conduct t-tests in Microsoft Excel. It’s easy, and this video shows you how. Excel is a very powerful program, with lots of neat functions and capabilities that most users never explore. Expect more posts about Excel in future.

Tagged ,

Independent t-test in SPSS

..and what if the means come from two separate, independent groups? Yup, you guessed it! It’s the independent t-test in SPSS!

Tagged ,

Related (paired) t-test in SPSS

This video shows how to conduct a related (paired-samples) t-test in SPSS

Tagged ,

Two-way repeated measures ANOVA in SPSS

This video shows how to conduct a two-way repeated measures analysis of variance (ANOVA) in SPSS. See, it’s not so bad!

Tagged ,