Student Handouts on Using Excel in Economics Projects

David Allen, University of the West of England, Bristol, wrote this “Using Excel in your economics assignments” guide from his 3rd year course.  It makes extensive use of screen shots and word art to take students through the stages of preparing graphs for incorporation in a report.

Purpose

  1. To introduce you to the use of Excel spreadsheets to plot and analyse time series data.
  2. Demonstrate how diagrams can be created in Word using the drawing features found in this software.

Sections

  1. Importing data from a Word table in to an Excel file
  2. Plotting time series data using Excel’s chart wizard
  3. Formatting a data plot (the Excel chart)
  4. Creating a duplicate data plot
  5. Transferring an Excel chart to a Word document
  6. From time series data create a scatter plot and fit a trend line (line of best fit)
  7. Creating a diagram in Word using ‘Insert Object’
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s