Skip to Navigation Skip to Content Skip to Search Skip to Site Map
Search

Author Archives: David Hood

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)

Restructure_in _SPSS

 

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)

Continue reading

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

merge2email

 

 

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)

Continue reading

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

vlookupExample Spreadsheet