a. How could you improve the readability of this table? b. The file GDPyears contains sample...

a. How could you improve the readability of this table?

b. The file GDPyears contains sample data from the United Nations Statistics Division on 30 countries and their GDP values from 2005 to 2010 in U.S. dollars ($). Create a table that provides all these data for a user. Format the table to make it as easy to read as possible. (Hint: It is generally not important for the user to know GDP to an exact dollar. It is more typical to present in millions or billions of dollars).

	Gross Domestic Product (in US Dollars, $)
Country	2005	2006	2007	2008	2009	2010
Albania	7385937423	8105580293	9650128750	11592303225	10781921975	10569204154
Argentina	169725491092	198012474920	241037555661	301259040110	285070994754	339604450702
Australia	704453444387	758320889024	916931817944	982991358955	934168969952	1178776680167
Austria	272865358404	290682488352	336840690493	375777347214	344514388622	341440991770
Belgium	335571307765	355372712266	408482592257	451663134614	421433351959	416534140346
Brazil	756761641553	935524319719	1175033105497	1407000163598	1370758418238	1782398471516
Canada	1056764109603	1193932279193	1332065087100	1404821988284	1245175828773	1469916064839
Costa Rica	18893517773	21230215608	24655866790	28030042814	28009123104	33905025636
Czech Republic	111667298575	128682670286	156601123503	194554700771	170904474637	172587854908
Finland	169949758742	180215332088	214820618980	236575337186	206669962260	207860471865
France	1914994403820	2015024513652	2312816861987	2541588228527	2367945716006	2301837109724
Germany	2516900462618	2632759372298	2984694872628	3258945971441	2973716393852	2966114791044
Greece	217161244590	234256472873	273778583771	307118451216	292570455971	269121592648
Ireland	177716687783	195313957743	229646992299	233265541112	199473873017	186171836063
Israel	122406785388	133194082920	153413480830	185728651622	178703093654	199765687403
Italy	1597329082733	1661915043524	1892698351200	2063917610274	1899970629238	1836900137057
Mexico	823342099045	928538728612	1011883508388	1085597798926	858289266602	1010289508403
Netherlands	567305874745	600912636726	694804194967	775360492025	707958187114	700804632367
New Zealand	108881144881	105105148952	128957665803	125687055678	112947748003	136162628586
Peru	72314760266	84376682203	98467906190	117848795625	120420055288	144337582246
Poland	267758758351	300074601414	371914955111	463413868126	382575897996	413367492455
Portugal	165251339352	172902905279	200110952422	218714808886	206009262965	200497996313
Saudi Arabia	317350027799	358379172230	386671647765	477341066667	374370666667	436158666667
Singapore	119723503550	139119367290	167031664530	179324986615	173771016315	209693107853
South Africa	220316820671	232194873182	254359710249	247453302921	256866025215	328761784955
Spain	1012008157986	1099963724520	1293150159963	1458983295560	1360989146711	1287874314552
Switzerland	350576683292	368164325764	409158397175	474711164468	464915154033	498158945877
Turkey	425514779241	467931441541	578990442724	656604657571	557723948435	655837737113
United Kingdom	2030278879633	2177981673883	2504551745297	2381881228845	1959165383433	2005634155207
United States	12579700000000	13336300000000	14010900000000	14369500000000	14113315344659	14601646157279

Expert Solution

A)

Since GDP is given in the $ for all countries. But it is making very difficult to read and interpret anything due to large digit number. We can make it readable by converting it into billion $ from $ value. We can also sort data based on dollar value if want to check which country has best GDP.

B)

All values are $billion

Country	2005	2006	2007	2008	2009	2010
Albania	7.39	8.11	9.65	11.59	10.78	10.57
Argentina	169.73	198.01	241.04	301.26	285.07	339.60
Australia	704.45	758.32	916.93	982.99	934.17	1178.78
Austria	272.87	290.68	336.84	375.78	344.51	341.44
Belgium	335.57	355.37	408.48	451.66	421.43	416.53
Brazil	756.76	935.52	1175.03	1407.00	1370.76	1782.40
Canada	1056.76	1193.93	1332.07	1404.82	1245.18	1469.92
Costa Rica	18.89	21.23	24.66	28.03	28.01	33.91
Czech Republic	111.67	128.68	156.60	194.55	170.90	172.59
Finland	169.95	180.22	214.82	236.58	206.67	207.86
France	1914.99	2015.02	2312.82	2541.59	2367.95	2301.84
Germany	2516.90	2632.76	2984.69	3258.95	2973.72	2966.11
Greece	217.16	234.26	273.78	307.12	292.57	269.12
Ireland	177.72	195.31	229.65	233.27	199.47	186.17
Israel	122.41	133.19	153.41	185.73	178.70	199.77
Italy	1597.33	1661.92	1892.70	2063.92	1899.97	1836.90
Mexico	823.34	928.54	1011.88	1085.60	858.29	1010.29
Netherlands	567.31	600.91	694.80	775.36	707.96	700.80
New Zealand	108.88	105.11	128.96	125.69	112.95	136.16
Peru	72.31	84.38	98.47	117.85	120.42	144.34
Poland	267.76	300.07	371.91	463.41	382.58	413.37
Portugal	165.25	172.90	200.11	218.71	206.01	200.50
Saudi Arabia	317.35	358.38	386.67	477.34	374.37	436.16
Singapore	119.72	139.12	167.03	179.32	173.77	209.69
South Africa	220.32	232.19	254.36	247.45	256.87	328.76
Spain	1012.01	1099.96	1293.15	1458.98	1360.99	1287.87
Switzerland	350.58	368.16	409.16	474.71	464.92	498.16
Turkey	425.51	467.93	578.99	656.60	557.72	655.84
United Kingdom	2030.28	2177.98	2504.55	2381.88	1959.17	2005.63
United States	12579.70	13336.30	14010.90	14369.50	14113.32	14601.65

We have change dollar to billion dollar value where 1 billion =(1,000,000,000)

Now everyone easily see US has largest GDP and values are easy to read.

Please feel free to ask any doubt or clarification.

orchestra answered 1 year ago

1.) How many grams of B are there in a sample of B that contains 6.55×1023...

1.) How many grams of B are there in a sample of B that contains 6.55×1023 atoms? 2.) A 19.35 gram sample of chromium is heated in the presence of excess fluorine. A metal fluoride is formed with a mass of 33.49 g. Determine the empirical formula of the metal fluoride. (Enter the elements in the order Cr , F) 3.) A 25.34 gram sample of chromium is heated in the presence of excess iodine. A metal iodide is formed...

Describe the possible sources of error in the experiment. How could you improve the experiment?

The data file contains the Body Mass Index (BMI) for a sample of men and a...

The data file contains the Body Mass Index (BMI) for a sample of men and a sample of women. Two of the columns, OW_male and OW_female code the BMI values as: 0 - if BMI ≤ 25.4 (these are considered “not overweight”); 1 - if BMI >= 25.5 (these are considered “overweight”). (a) Test whether there is sufficient evidence to show that the proportion of overweight males (proportion of males who are overweight) is different than the proportion of overweight...

how could mechanical engineering improve plastic recycle?

As an eyewitness to a crime, how could you use information from memory distortions to improve...

As an eyewitness to a crime, how could you use information from memory distortions to improve your memory for specific details?

Question B.1 A company has the following master schedule (Table B.1) and master file (Table B.2)...

Question B.1 A company has the following master schedule (Table B.1) and master file (Table B.2) for its most popular Lapdesk. Table B.1 Master Production Schedule Week 1 2 3 4 5 6 Lapdesk 400 300 450 330 450 400 Table B.2 Master file Lapdesk Pressboard On hand 200 300 On order 100(week 2) 0 LLC 0 1 Lot Size L4L Mult 100 Lead Time 1 1 Each lapdesk has two pressboards. Use MRP to schedule planned order releases for...

The Excel file: OfficeEnergy.xlsx contains information recorded on a sample of 40 of the company’s city...

The Excel file: OfficeEnergy.xlsx contains information recorded on a sample of 40 of the company’s city branches. The file contains the amount of renewable energy (kWh) consumed in the previous year and the size (square metres) of each branch. Download these data and fit a linear regression model for predicting RenewableEnergy (Y) from Size (X). Use your Excel output, and any other information provided, to answer the following questions. For each question, either choose the most correct option, or type...

The file FastFood contains the amount that a sample of fif- teen customers spent for lunch...

The file FastFood contains the amount that a sample of fif- teen customers spent for lunch ($) at a fast-food restaurant: 7.42 6.29 5.83 6.50 8.34 9.51 7.10 6.80 5.90 4.89 6.50 5.52 7.90 8.30 9.60 At the 0.05 level of significance, is there evidence that the mean amount spent for lunch is different from $6.50? Determine the p-value in (a) and interpret its meaning. What assumption must you make about the population distribu- tion in order to conduct the...

How could domestic policy improve outcomes for workers in sweatshops?

How could television be used to improve social and political life?

Question