• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer

Gregory C. Mason

Research and teaching in public-policy

  • Publications
    • Agricultural Commentary
    • Articles (academic)
    • Chapters in Books
    • Current Research and Working Papers
    • Book Reviews
    • Technical Reports & Monographs
    • Workshops & Presentations
  • Guiding the Invisible Hand
  • Teaching
    • Resources for students
    • Economic Analytics Using Computer Methods
  • ISER
  • Economic Analytics
    • Methodology Notes
  • Mincome
  • PRA INC.

Economic Analytics Using Computer Methods

Excel and economics are made for each other. The material on this page represents the teaching materials for ECON2050 Economic Analytics Using Computer Methods. The text includes links to videos that explain techniques and procedures in more detail. The material here excludes practice problems and answers and tests with answers, all of which are essential for completing this course.

Several caveats exist for this course:

  • The course presumes no knowledge in Excel, but the reader will be served well by remembering basic math and first year micro and macro economics.
  • Excel often has more than one way to solve a problem and the course starts with simple approaches that will strike the experienced Excel user as simplistic. As the course proceeds, more advanced methods come into play.
  • The course materials rely on Microsoft 365, but many videos still refer to Office 2019; the functionality is essentially the same for problems addressed. I will update these videos in due course.
  • This is not a course in Excel. It is a course in economic analytics that uses Excel to explain economic and business processes.  Therefore, it focuses on the financial and statistical formulas and does not really treat the data management tools available in Excel.

Module 1 – Excel Basics

This is an orientation to Excel for the uninitiated and those who need a refresher.

Primary Sidebar

Latest Commentary

The search for the truth never ends

May 31, 2022 By Greg Mason

Winnipeg Free Press, May 30, 2022 Tributes to David Milgaard all highlight the strength of an individual who persevered through more that two decades of imprisonment for a murder he never committed. His mother Joyce Milgaard, Lloyd Axworthy, and the lawyer who believed his story, Hersch Wolch, deserve recognition for their efforts in righting a […]

We need COVID measures we can trust

April 14, 2022 By Greg Mason

Winnipeg Free Press, April 8, 2022 It is curious that the only recent indicator I have seen that COVID-19 still stalks us is that Kyle Connor and Nate Schmidt of the Winnipeg Jets were placed in virus protocol last week. I do not know what Canada’s self-styled virologists in chief (Stefanson, Kenney, Ford et al) […]

Time to rethink vaccine strategy

April 7, 2022 By Greg Mason

December 13, 2021 Omicron is on the prowl. While early indications are that it does not cause serious illness, it is very infectious. The current approach to enforcing vaccination mandates will not probably get us to 90-per-cent-plus of everyone over six being fully vaccinated, which is probably the level needed manage this disease. (Read more…)

Time to examine treaty annuities and the land

April 7, 2022 By Greg Mason

Sheilla Jone, Wayne Helgason, and Gregory Mason Winnipeg Free Press, December 29, 2021 The November Ontario Court of Appeal ruling that the Crown violated Robinson Treaty terms by failing to increase annuity payments highlights the necessity of understanding the link between annuities and the land as a step toward reconciliation. Because without reconciliation, Canada risks […]

Online learning is here to stay

April 7, 2022 By Greg Mason

Winnipeg Free Press, August 9, 2021 Fill in the blank. Virtual learning is to live learning as phone sex is to ______ sex. There you have it … a question from the 2021 Mensa test.(Read full Article)

Footer

About

Specializing in economic policy, the basic annual income, health economics, and Indigenous economics, Greg joined the Department of Economics at the University of Manitoba in 1974. Recently he has written on the economics of COVID, telemedicine, electronic health records, the modern annuity, and urban reserves.

Recent

  • The search for the truth never ends
  • We need COVID measures we can trust
  • Time to rethink vaccine strategy
  • Time to examine treaty annuities and the land
  • Online learning is here to stay

Copyright © 2022 Gregory C. Mason