Calculate and plot using a spreadsheet

Assignment Help Microeconomics
Reference no: EM13319120

Question 1: Consider the following times series for a 2 goods (Bourbon and Cigars) Economy:

1262_Calculate and Plot using a spreadsheet.png

a) Calculate and Plot using a spreadsheet (like Ms Excel) the series for Nominal GDP.

b) Calculate and Plot using a spreadsheet the series for Real GDP (i.e. normalize by the price of Cigar)

c) Calculate and Plot using a spreadsheet the yearly % changes in Nominal GDP (i.e. [GDPt+1-GDPt]/GDPt)

d) Calculate and plot using a spreadsheet the yearly % changes in Real GDP.

e) The yearly % change of Nominal GDP in 2003 (i.e. [GDP2003-GDP2002]/GDP2002) is positive but the yearly % change in Real GDP in 2003 is negative. Why?

For part a), b), c) and d) you may summarize the results of your calculations in table above.

Reference no: EM13319120

Questions Cloud

Build the time series for the index of openness : Build the time series for the Index of Openness (Export of Goods/GDP) using a spreadsheet and build the time series of Imports of Goods/GDP.
Determine the minimum required diameter for the machine : Determine the minimum required diameter for this machine member based on direct, compressive stress. The member is to be made of gray cast iron. Use a factor of safety of 6.0 against compression failure.
The relationship between the inflation rate and changes : Classify the following topics as relating to microeconomics or macroeconomics. a family’s decision about how much income to save. the effect of government regulations on auto emissions
Determine the liquid density in british gravitational units : It is commonly known that there are 16 ounces in 1 lb. Consider a 0.5lbf glass that weighs 1 lbf when filled with 8 ounces of liquid. Determine the liquid density in British gravitational units and in SI units.
Calculate and plot using a spreadsheet : Calculate and Plot using a spreadsheet the series for Real GDP and calculate and Plot using a spreadsheet the yearly % changes in Nominal GDP (i.e. [GDPt+1-GDPt]/GDPt)
Determine the density and pressure in cgs absolute units : A certain gas has a molecular mass of 40. It is under a pressure of 2.5atm and a temperatature of 25 Degree Celsius. Determine its density and pressure in CGS absolute units.
Explain what is the equilibrium concentraction of h30+ : The equilibrium contant Kc for the reaction HF(aq)+H20(l)-->H30+(aq)+F-(aq) is 3.5x10^-4. What is the equilibrium concentraction of H30+ if the initial concentration of HF is 1.0M
What is the opportunity cost of spending the $100 now : You win $100 in a basketball pool. You have a choice between spending the money now or putting it away for a year in a bank account that pays 5 percent interest.What is the opportunity cost of spending the $100 now?
Discuss the sticky-wage model of aggregate supply : Discuss the sticky-wage model of aggregate supply, carefully identifying any assumptions made. How well does the sticky-wage model explain the observed behaviour of real wages over the business cycle?

Reviews

Write a Review

Microeconomics Questions & Answers

  What level of output should this firm produce

What level of output should this firm produce in order to maximize profit or minimize losses - and how many firms in total will there be in this market?

  Who had largely replaced keynesian views

By the 1950s, the views of the Classical economists among American economists: had been largely eclipsed by Keynesian views. had largely replaced Keynesian views. were about as widely held as Keynesian views.

  Define the proportional representation of minorities

government action is based on majority rule, whereas market action is based on mutual consent. The market allows for proportional representation of minorities, but minorities must yield to the views of the majority when activities are undertaken t..

  Relation btwn marginal product of labor and marginal cost

When the firm increases labor input, which of the following is correct about the relationship between marginal product of labor and marginal cost? Answer If marginal product is increasing, marginal cost will be decreasing. Marginal cost is equal t..

  Why scarcity forces individuals to incur opportunity cost

a.)define the concept of economic models b.)define scarcity and choices and their relationship in the study of economics c.) why do economists disagree d.) Name and define economic resources or factors of production

  Consider what you do for work on a day-to-day basis

Many people shy away from careers in selling, often because they think they are not outgoing enough, or because salespeople are dishonest or pushy. In this weekly research paper, describe your most memorable experience with a salesperson that was ..

  How ppf presents a strong rationale for the plausibility

Illustrate with a graph how the PPF presents a strong rationale for the plausibility of the law of supply and supply and demand graphs indicating the change in equilibrium price and quantity.

  Please make a positioning map for kraft yuban coffee

Please make a Positioning map for (Kraft) Yuban coffee without using price or quality as attributes. The competitors are JM Smucker, Nestle, Starbucks, Green Mountain and Sara Lee.

  Question related to international trade

Choose a United States multinational firm. In terms of currency denomination, discuss how the company values its revenues and costs.

  Government policies to increase expending on domestic items

Deep global recession might trigger changes in expending from imported items to domestically manufactured items. What are at least two policies that governments might implement to increase expending on domestic items.

  Find the marginal rate - exchange economy

Find the marginal rate of substitution for both individuals and is the initial allocation pareto efficient

  Explain an increase in aggregate demand

If the economy is operating on the upward sloping portion of the short-run aggregate supply, SAS, curve; show that an increase in aggregate demand, AD, from expansionary fiscal policy will result in an increase in both real income, Y, and the gene..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd