Customer Service Chat
Get quote & make Payment
Excel Graphing/Writing Assignments for EC215-Princip, Microeconomics
1. Go to the website for MarginalRevolution.
two posts that related to microeconomic topics that we are covering and write about one half to three fourths of a page on each post explaining the topic. You can also click on the links to other blogs on the left-hand side of the MarginalRevolution website and choose something from those blogs. Your writing should be about blog posts that are dated since August 20, 2012 to the present date.
2. Find an article from either The Economist, or, The Wall Street Journal that addresses some aspect of supply/demand and explain it. For instance, the article might explain that the price of some good or service is rising (or falling). Why? Is the price changing because of a change in demand, or, a change in supply? Both The Economist and The Wall Street Journal are available via Kent Library. The article should be dated since August 20, 2012.
3. In this problem we want to answer the question “Which country manufactures more good? China (Peoples Republic of), India, Japan, Germany, or the US?
Click on the United Nations link:
“GDP and Its Breakdown at constant 2005 prices in US Dollars” and click on “All Countries for all years-sorted alphabetically”. The data are for 1970 to 2010. It will probably be easiest to Sort the data by the column “Indicator Name.” Scroll down the spreadsheet until you come to “Manufacturing (ISIC D)”. Copy the lines for the five countries into a new spreadsheet and then make a line graph of the countries. Put all 5 countries on the same graph. Identify each country (if you don’t have a color printer you need to use different markers such as * and ¦ and ?etc., and identify the year on the horizontal axis. Which country manufactures the most? Does your answer meet your intuition?
I give an example for the United Kingdom up to 2009. You should put all the countries on the same graph.
4. There are three parts to this assignment. First, follow the link to the Case-Shiller House Price Index (click on the “Economic” tab to find the index). Click on the most recent month available (June 2011) and use the “not-seasonally adjusted” data. The data download into an Excel spreadsheet. The house price index for the entire US is given in the column labeled "Composite-10 CSXR".
A. Make a line graph of this index for the period January 1987 to the most recent month. Make sure you provide a title to your figure and label the horizontal axis using the dates.
B. Choose two cities and repeat part A. Note: For some cities, such as Phoenix or Atlanta, the data begin at a later date than January 1987. (I give an example for San Francisco.)
C. Choose the latest date and make a bar chart of all the cities. The cities are all indexed to 100 in January 2000. Therefore, the bar chart will give the percent of house prices in February 2011 relative to January 2000. For instance, Los Angeles has an index of 168.25 which means that house prices are 68.25% higher in February 2011 than they were in January of 2000. Make sure you label the axis to identify each and every city in your bar chart.
(I give an example of a bar Chart for Phoenix, LA, San Diego, and San Francisco.)
D. Given your chart in part C., why do you think Detroit and Washington, DC. Are moving in opposite directions?
5. In this problem you will find out about what has been happening in the restaurant industry and to several corporations in the restaurant industry.
a. Go the St. Louis Federal Reserve Bank website:
“Categories”, then choose “Production and Business Activity”, then choose “Retail Sales”, then choose “Real Retail and Food Service Sales”. Make a line graph in Excel (you have to download the data-don’t copy and paste the graph from the Federal Reserve Website into your paper.) Make a line graph of the data from 1992 to the present. Give your graph an appropriate title and put the dates on the horizontal axis.
b. Go to
In the window for “Symbol lookup”
Choose the following 3 corporations that are in the food service business. For each corporation click on “historical prices” and then download the data for the particular corporation for the period 2004-January to the present. Make a line graph of the adjusted closing price. (Note: you have to sort your EXCEL file by the date, since at the top of the file is the present date and at the bottom is January 1, 2004.
` i. Dine Equity, Inc. This company owns Applebee’s and other similar restaurants. Ticker symbol: DIN
ii. Buffalo Wildwings Ticker symbol: BWLD
iii. Dominos Pizza, Ticker symbol: DPZ
c. Write one typed page describing the market structure of the restaurant industry. Given your graph from part a., how is the industry doing? How are the three corporations doing in the last couple of years?
6. In this problem we want to learn something about “Who pays the taxes?”
Go to the Tax Foundation website
the years 1980, 1990, 2000, and 2009 complete the following table: (find the data in Table 5, 6, and 8. (Type the data-you can copy and paste this table into a WORD document)
Adjusted gross income share
Year Top 1% Top 5% Between 5-10% Between 10-25% Between 25-50% Bottom 50%
% of taxes paid
Average tax rate
Write about one typed page explaining who pays the taxes and earns the income, whether the tax system is progressive, regressive, or proportional, and whether or not you think the tax system is equitable (is it okay as is, or should it be more progressive or regressive?).
Posted Date: 11/27/2012 12:30:31 PM | Location : United States
Ask an Expert
Excel Graphing/Writing Assignments for EC215-Princip, Assignment Help, Ask Question on Excel Graphing/Writing Assignments for EC215-Princip, Get Answer, Expert's Help, Excel Graphing/Writing Assignments for EC215-Princip Discussions
Write discussion on Excel Graphing/Writing Assignments for EC215-Princip
Your posts are moderated
Write your message here..
Reserve accounts, if a bank has $6000 in checkable deposits and the require...
if a bank has $6000 in checkable deposits and the required reserve ratio is 0.2 then the bank can lend how much money?
Production, introduction of production
introduction of production
Rational expectations and economic theory , RATIONAL EXPECTATIONS AND ECONO...
RATIONAL EXPECTATIONS AND ECONOMIC THEORY : We assumed above that the role of economic theory is not to provide quantitative predictions about the future. Suppose we assume ins
#title., if the marginal production of labor is rising, is the marginal cos...
if the marginal production of labor is rising, is the marginal cost of production rising or falling? Briefly explain
Price elasticity of demand, Explain why each of the following factors may i...
Explain why each of the following factors may influence the own price elasticity of demand for a commodity. The narrowness of the definition of the commodity
Mrs and mrts, compare marginal rate of technical substitution and marginal ...
compare marginal rate of technical substitution and marginal rate of substitution
Banks, Banks: A company which accepts deposits and issues new loans. It mak...
Banks: A company which accepts deposits and issues new loans. It makes profit by charging more interest for loans than it pays on deposits, and through several service charges. By
Duality theorems, Duality Theorems: The relationship between the direc...
Duality Theorems: The relationship between the direct and indirect utility functions may be described by a set of duality theorems. The following illustrative theorems are pro
Money demand function, what are the values of real money supply and the cur...
what are the values of real money supply and the current price level
Indirect utility functions, Indirect Utility Functions: Let qi denotes...
Indirect Utility Functions: Let qi denotes commodity i and pi is the price of that commodity. Let y denotes money income of the consumer. Suppose vi = pi/y. The budget constra
Accounting Assignment Help
Economics Assignment Help
Finance Assignment Help
Statistics Assignment Help
Physics Assignment Help
Chemistry Assignment Help
Math Assignment Help
Biology Assignment Help
English Assignment Help
Management Assignment Help
Engineering Assignment Help
Programming Assignment Help
Computer Science Assignment Help
Why Us ?
~24x7 hrs Support
~Quality of Work
~Time on Delivery
~Privacy of Work
Human Resource Management
Literature Review Writing Help
Follow Us |
T & C
Copyright by ExpertsMind IT Educational Pvt. Ltd.