# Short Excel/Stata work

Go to the website for the University of Pennsylvania World Tables 9:

(a) [url removed, login to view]

Export the data in either Excel Format or Stata Format. Choose seven countries: Canada, China, Japan, the U.K. and three other countries where the first letters of the three additional countries must correspond to your own initials.

[Example: Someone named John Smith might choose Jordan and Senegal or Jamaica and Seychelles. If a name begins with the letters W, X, or Y choose countries whose names begin with A or Z instead.]

(b) Choose the variables pl_gdpo (Price Level of Gross Domestic Product) and xr (Exchange Rate) for each of these countries, and also pl_gdpo for the US.

(c) Calculate the real exchange rate relative to the US for each chosen country as rer=pl_gdpo(US)/pl_gdpo. Now normalise the value of xr so that the first year in the data series (usually 1950, but for some countries such as China it starts a few years later) is equal to rer1950. Then divide all subsequent values of xr by the normalised initial ratio xr1950/rer1950. The idea here is to be able to compare the movements of the real and nominal exchange rates on the same axes.

(d) Plot both the variables you calculated together in the same graph (years on the horizontal axis, nominal and real exchange rates on the vertical axes). (10 marks)

(e) Answer the following questions, next to the graph or at the top of the spread-sheet: (i) According to your calculations which countries’ exchange rates are usually over-valued? Under-valued? Correspond to the theory of Purchasing Power Parity (PPP)? (10 marks)

(ii) What explains the difference between the nominal and real exchange rates, i.e. what is happening to relative prices? (10 marks)

( 3 comentários ) london, United Kingdom

ID do Projeto: #13359318

## 11 freelancers estão ofertando em média £35 para esse trabalho

editchamp

hi sir I have 5 years extreme experience on Internets research, data entry, excel, Virtual assistance etc ... we are an expert team (10 experts ) to do that job quickly in the proper way. for more detail visit my pr Mais

£18 GBP em 1 dia
(112 Comentários)
6.4
£30 GBP em 1 dia
(147 Comentários)
5.8
suyashdhoot

Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d Mais

£100 GBP em 1 dia
(41 Comentários)
5.8
aminbros

A proposal has not yet been provided

£110 GBP em 1 dia
(13 Comentários)
5.6
The24CarrotsInc

A proposal has not yet been provided

£10 GBP em 1 dia
(21 Comentários)
4.3
shahiddar

Hello My name is shahid from Kashmir Over the last 7 years, I have worked for several clients. Joined Freelancer with over 7 years rich experience in the field.I have successfully completed more than 1000 projects in Mais

£10 GBP in 5 dias
(6 Comentários)
4.2
mstbilkisakter

Hello, I have read your job description. I have proper experience about many data entry, research, internet research, market research, information research, data collection, data input, MS word, Excel sheet, power poi Mais

£13 GBP em 1 dia
(6 Comentários)
2.4
cracken

Hi, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements Mais

£49 GBP em 1 dia
(4 Comentários)
2.0
yasiranwar39

i have a good excel work experience and skills................................................................................................................

£15 GBP em 1 dia
(3 Comentários)
1.2
toolpusher

This is a very interesting and a simple task. I guess it is a semester assignment. I did something like this back in the university. I will do it for you at a very cheap rate. I am looking for positive review to boost Mais

£18 GBP em 1 dia
(0 Comentários)
0.0
shaikhmdrakib

Hello Sir, I have overview your job posting. I think I will provide you 100% service in my best experience. I have done this type of work on a farm & ongoing in our team. Based on my skills and prior experience, Mais

£15 GBP in 2 dias
(0 Comentários)
0.0