Jeromy Anglim's Blog: Psychology and Statistics


Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

Monday, April 12, 2010

Exporting PDFs from JabRef using a Batch File

If you do research, JabRef is a great tool for managing a personal repository of PDFs. JabRef allows you to link your citations with full text PDFs. This post discusses one way of exporting a subset of your PDF repository using JabRef, Excel, and a Windows Batch file. This is useful (copyright permitting) in many situations.
For example:
(a) You need to extract a subset of references for a subject you are teaching.
(b) You need to give a colleague or research student a subset of your references.
(c) You want to transfer a subset of your references to another device or computer.

Saturday, October 3, 2009

Data Mining and Statistics Video Course

David Mease has an online course presented with complete videos (Statistics 202: Statistical Aspects of Data Mining ). The course uses Excel and R.

Thursday, September 24, 2009

Recovering a Corrupted Excel 2007 File | XLSX and XLSM Format

An Excel 2007 file that I was working on recently became corrupted. The following are some things that I learnt in my process of recovering the file.

Thursday, February 19, 2009

Formatting Correlation Matrices in Psychology

Researchers in psychology often want to present a correlation matrix of the main variables in a study. This post sets out one way of producing a formatted correlation matrix that conforms to APA style.

Thursday, January 15, 2009

Saving Tab Delimited Text Files in Excel without Warnings

Since using R, I have started generally storing my data in tab delimited text files. I tend to edit this data in Excel. Excel is easier to use than the current editor built into R.