MicroandMacro - SUPPLY AND DEMAND ANALYSIS I Lab

MicroandMacro - SUPPLY AND DEMAND ANALYSIS I Lab -...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: PRINCIPLES OF ECONOMICS LAB SUPPLY AND DEMAND ANALYSIS I OBJECTIVES: The purpose of this lab is to use Excel to create tables and plots of the familiar supply and demand relationships. Excel s AutoFill, formula routines and graphical tools are used. Students will be able to apply these procedures to create tables and plots of other common economic relationships. I. Creating Supply and Demand Table (a) Open a new workbook in Excel and name the file Supply-Demand-Name. (Type your name for Name.) (b) Type Price in cell A2 and Qd in cell B2. (c) Generate a column of data ranging from 0 to 20 by increments of 1. Rather than entering each number, use Excel automatic fill function, called AutoFill, by typing 0 in cell A3 and 1 in cell A4. Highlight the two numbers and click on the bottom right corner of cell A4 and drag down until data point 20 appears. When you are done, the worksheet should look as follows: (d) The demand function well use is given by the equation...
View Full Document

Page1 / 6

MicroandMacro - SUPPLY AND DEMAND ANALYSIS I Lab -...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online