Restructuring Data in SPSS
This demonstration shows how to convert rows to columns in SPSS, also known as converting long data to wide data, using the Data menu, Restructure command.
You can watch the 1:35 recording or right click on the link below and download it to your computer (mp4 format)
Coordinates and annotations in R. 20th May 2016
This demonstration covers knowing how to place extra things on graphs at particular locations.
You can watch the recording (5 minutes 4 seconds):
or download (right click and choose the save/download link option) the recording to your computer via the link:
Coordinates in R: cord.mp4 (.mp4 format, 65.2 MB)
and read the parts of the script below (code available when viewing the full article)
Excel plus Word + Outlook mailout. 18th May 2016
This demonstration covers using Excel as a data source to compose a message in Word that is sent out in an email in Outlook (this demonstration uses Office 2013, but the principles are the same for other versions).
You can watch the recording (2:51 in length)
or download the video file
Double Axis Graph in Excel – 1st April 2016
This demonstration covers making a single axis graph into a two axis graph to solve the problem of trying to see a set of small numbers and a set of big numbers on the same graph.
You can watch the recording (3:43 in length)
or download the recording to your computer via the link:
Double Axis Excel Graph video download (.m4v format, 6.2 MB)
and download a copy of the example spreadsheet
Excel data Download (xlsx format)
About Data Demos
These videos are part of the data demo series, showing key demonstrations of things involving spreadsheet, database, and data analysis programs.
If you have a topic you think would be useful to have a canonical example of, contact it.training@otago.ac.nz
R publication quality graph – 31st March 2016
This demonstration covers the kinds of things you might want to adjust in a basic plot to improve the graph for publication.
You can watch the recording (18 minutes 59 seconds):
or download (right click and choose the save/download link option) the recording to your computer via the link:
PublicationGraphInR (.m4v format, 68.1 MB)
and read the parts of the script below (code available when viewing the full article)
Vlookup – 21st March 2016
This demonstration covers the two ways the VLOOKUP function is used in Excel, to match numbers into ranges, and to match exact values to combine data from different sources.
You can watch the recording:
or download the recording to your computer via the link:
vlookup movie download (16 MB, m4v movie file)
and download the example spreadsheet with finished formula