Question: Hi could you please help me with that task, thank you BURGERNOMICS IS BASED ON THE THEORY OF PURCHASING POWER PARITY - THE NOTION THAT
Hi could you please help me with that task, thank you
BURGERNOMICS IS BASED ON THE THEORY OF PURCHASING POWER PARITY - THE NOTION THAT A DOLLAR SHOULD BUY THE SAME AMOUNT IN ALL COUNTRIES. COMPARE THE PURCHASING POWER OF THE COUNTRIES ON THE WORKSHEET AND HOW THE EXCHANGE RATE AND THE PRICE OF A BIG MAC VARY. USE GOOGLE SHEETS TO PERFORM YOUR ANALYSIS (ATTACHED) THEN, ANSWER THE FOLLOWING QUESTIONS (IN SHEETS):
- WHICH TWO COUNTRIES HAVE THE MOST EXPENSIVE BURGERS?
- WHICH TWO COUNTRIES HAVE THE CHEAPEST BURGERS?
- STATE TWO REASONS WHY YOU THINK THE PRICE OF BIG MAC'S VARIES AROUND THE WORLD?
- RESEARCH THE LATEST ON-LINE RESULTS USING THE BIG MAC INDEX AND REPORT THE TWO COUNTRIES WITH THE MOST EXPENSIVE AND THE CHEAPEST BURGERS? ( this article: https://www.economist.comews/2020/07/15/the-big-mac-index

A B C D E F G H J K L M N 0 P Q R S T U 1 2 3 4 5 2 Big Mac Price Exchange Big Mac in Percent(%) in local Rate to CAD Difference 3 Country currency CAD =(2)*(3) =[(4)-2.991/2.99 WHICH TWO COUNTRIES HAVE THE MOST EXPENSIVE BURGERS? QUESTION 1 4 Canada 2.9 2.99 0% 5 Australia 3.00 0.9161 2.75 -8% 6 Question 2: WHICH TWO COUNTRIES HAVE THE CHEAPEST BURGERS? Brazil 3.60 0.2261 0.81 -73% 7 Norway 45.65 0.00 8 Euro 2.57 0.00 Question 3: STATE TWO REASONS WHY YOU THINK THE PRICE OF BIG MAC'S VARIES AROUND THE WORLD? Indonesia 14700 0.00 10 Japan 294 0.00 11 Malaysia 4.52 0.00 12 QUESTION 4: RESEARCH THE LATEST ON-LINE RESULTS USING THE BIG MAC INDEX AND REPORT THE TWO COUNTRIES WITH THE MOST EXPENSIVE AND THE CHE Mexico 21.90 0.00 13 Russia 35.00 0.00 14 Singapore 3.30 0.00 15 South Africa 9.70 0.00 16 South Korea 3000 0.00 17 Switzerland 6.30 0.00 18 Thailand 55.00 19 United Kingdom 1.39 20 United States 2.54
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
