122 Chapter 3 Data Visualization 2. The following table shows of countries over

Question

122 Chapter 3 Data Visualization 2. The following table shows of countries over six years in equivalent U.S. an example of gross domestic product values for five Year 6 Gross Domestic Product (in U Year 5 Country Year 1 Year 4 Year 2 Year 3 81921975 105692 7385937423 -105580293 965012875-11592303225 9947541 339604450702 Albania na 1697254910921198012474920 2410375556611301259040110| 2 Australia 04453444 38 758320889024 | 916931817944 98299 1358955-93 Austha 272865358404 290682488352 336840690493375777347214 344 934168969952 1178776680 44514388 421433351959 4165 3 404 Belgium 335571307765 3553727 12266 408482592257 45166313461 How could you improve the readability of this table? a. b. The file GDPyears contains sample data from the United Nations Statistics Divisio DATA on 30 countries and their GDP values from Year 1 to Year 6 in USS. Create a table that provides all these data for a user. Format the table to make it as easy to read as possible. GDPyears Hint: It is generally not important for the user to know GDP to an exact dollar figure It is typical to present GDP values in millions or billions of dollars.

Explanation / Answer

a) As it is given in the hint that it is generally not important for the user to know the GDP to an exact dollar figure. One should understand how it is improving over the years. Is it doing up with the time or is it going down.

From the table we cannot understand as the numbers are huge. We cannot interpret anythng. Instead of using dollar figures we should use GDP%. ({GDP (this year) - GDP (last year)} / GDP (last year))

If the Y-O-Y Gdp % is growing then the country is performing well. and if it is going down then the economy is going towards trough.

b)The file is not provided here. But it can be solved in excel by making the matrix with columns as years and rows as countries' name. And use the formula of GDP %(stated above) and fill the table.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.