Econ 299 Fall 2015
L. Priemaza
University of Alberta
Econ 299
Assignment #1
Fall 2015
L. Priemaza
1) A beach resort sells beach towels (T) and beach umbrellas (U). Data
on monthly prices and sales are below: (38 marks)
2013
2014
2015
PT
$6
$10
$8
QT
20
30
ECON 365
Sample Questions
1. For the following goods, discuss in what ways they may be considered a public good, and in what ways
they may be excludable or divisible.
a. A movie theatre.
b. A public telephone.
c. A lighthouse.
d. A bus.
e. The music you a
ECON 299 A1 (Fall 2014) Midterm Exam
Version: 1
1. Below is a basket for a typical fisherman:
Fishing Pole
Year
Quantity
Bait
Price
Quantity
Price
2011
2
$50
200
$2
2012
3
$65
250
$4
2013
5
$70
250
$5
a) Create a Laspeyres Price Index for this basket of g
ECON 299 A2
Lab Assignment #2
Name: _
Student ID: _
1. Input the below numbers into excel. Calculate the missing numbers and format them to
one decimal place. Attach an excel print out with your name and student ID when handing
in this assignment. You do
Econ 299
Tutor Questions Chapter 6
University of Alberta
Econ 299 Tutor Questions Chapter 6
Use the following data for the next 2 questions:
Year
1999
2001
2002
2003
6
200
0
4
Car Sales (S)
(Hundreds)
Gas Price (P)
(cents)
5
7
3
60
65
68
72
75
1) Given th
Econ 299 Tutor Questions
Chapter 5
University of Alberta
Econ 299 Tutor Questions
Chapter 5
1) Consider the following hypothetical Oilers data:
Game
Shots
Goals
1
22
4
2
15
3
3
31
3
4
25
1
5
25
5
a) Assuming that the above is the entire population, calcul
Econ 299
Tutor Questions Chapter 6
University of Alberta
Econ 299 Tutor Questions Chapter 6
Use the following data for the next 2 questions:
Year
1999
Car Sales (S)
(Hundreds)
Gas Price (P)
(cents)
1)
2001
2002
2003
6
200
0
4
5
7
3
60
65
68
72
75
Given th
ECON 299 A2
Lab Assignment #3
Name: _
Student ID: _
1. The below data is consumer spending and inflation in the United States since the recession.
Input the provided numbers into excel. Calculate the missing numbers and format them to
one decimal place. A
ECON 299
Lab Assignment #1
Name: _
Student ID: _
Print out this assignment and fill in your answers below. Hand in the assignment to the lab
instructor at the start of the following lab.
1. Input the below numbers into excel. Calculate the missing numbers
Lab 1 Introduction to Excel
LAB 1 QUICK VIEW
Each cell of excel has a letter column and a number row.
Numbers are entered in cells by typing them and pressing enter.
Formulas and equations are entered in cell starting with =
Common formulas are:
=SUM(X:Y)
Lab 4 Importing Data and Basic Graphs
Often we will find data that is not in an excel format. This data could be in text format, or an alternate
spreadsheet or database format, and therefore needs to be converted into an excel format. This lab will
cover
Quantitative Methods in Economics (ECON 299 A2)
University of Alberta - Department of Economics
Fall 2016 Course Outline
Instructor: Alexander Gainer
Class Schedule: Monday/Wednesday/Friday 10:00-10:50
Lecture Room: Tory 1 91
Lab Schedule: Wednesdays 9:00
6. Simple Regression and
OLS Estimation
Chapter 6 will expand on concepts introduced in
Chapter 5 to cover the following:
1) Estimating parameters using Ordinary Least
Squares (OLS) Estimation
2) Hypothesis tests of OLS coefficients
3) Confidence interval
Chapter1:
1.Data Types
time series data one economic agent over
time
Cross Sectional Data multiple economic agents
one timePanel Data
2. Nominal
GDP
quantities X prices
3. Base year Real GDP quantities X prices
base year
4. Nominal=Price Index /100 X Rea
University of Alberta
Department of Economics
Econ 299 B1
Quantitative Methods in Economics
Winter 2016
L. Priemaza
Class Schedule:
Lectures: Tuesday, Thursday, 2:00PM to 3:20PM in T 1 103
Labs: Tuesday 4:00PM - 4:50PM in Tory B-39
Wednesday 9:00AM - 9:50
Econ 299 Fall 2014
L. Priemaza
University of Alberta
Econ 299
Assignment #2
Fall 2014
L. Priemaza
1) For the formula q=10+2p-p2: (16 marks)
a) Calculate general growth and growth at p=2
b) Calculate general elasticity, and find elasticity at p=4. What sho
Econ 299 Fall 2014
L. Priemaza
University of Alberta
Econ 299
Assignment #1
Fall 2014
L. Priemaza
1) McGamer sells three types of games: Board Games (B), Card Games
(C), and Party games (P). Average prices and daily sales are as
follows: (48 marks)
2011
2
Review
Chapter 5 is a brief review of statistical concepts. It is NOT a
replacement for a statistics course.
By the end of the chapter, you will be able to:
1) Identify population and sample data and perform
population and sample statistical calculation
6. Simple Regression and
OLS Estimation
Chapter 6 will expand on concepts introduced in
Chapter 5 to cover the following:
1) Estimating parameters using Ordinary Least
2)
3)
4)
5)
Squares (OLS) Estimation
Hypothesis tests of OLS coefficients
Confidence in
Lab 5 Introduction to Statistics Canada
In this lab and the next, we will be seeing two different ways to collect data from Statistics Canada.
*Important Note: The Statistics Canada and University Library websites described in these two labs
may change ov
Lab 3 Financial Calculations in Excel
In this lab you will cover the financial calculations covered in class, both using the formulas seen
in class, and using excels present value and future value formulas, as seen and explained below.
LAB 3 QUICK VIEW
T
Lab 2 Advanced Excel Introduction
LAB 2 QUICK VIEW
At the bottom of the excel page, you can switch between and rename TABS
The Paste command will copy formulas, whereas the Paste Special Values will
only copy the numbers appearing in a cell.
Additional
Lab 6 Cansim
In this lab and the next, we will be learning how to download data from Statistics Canada (StatCan) using
Cansim.
*Important Note: The Statistics Canada and University Library websites described in these two labs
may change over time. These l
4. Models with Multiple
Explanatory Variables
Up until this point, we have assumed that our
dependent variable (Y) is affected by only ONE
explanatory variable (X).
Sometimes this is the case. Example: The
amount of dollars in your bank account is equal
t