Geography	2021 # of new vehicles registered	Cars per 100K people	Population	Average Monthly Wages	2021 Total Personal Disposable Income	Total Consumer Expenditure	Expenditure on Fuel	GDP per Capita $
Vietnam	230,200	234	98,170,000	$ 294	$ 210,700	$ 193,607	$ 31,441	$ 291
Venezuela	2,047	7	28,980,000	$ 8	$ 55,210	$ 46,027	$ 2,895	$ 74
United States of America	3,532,000	1,061	332,900,000	$ 5,890	$ 18,407,000	$ 15,658,230	$ 3,077,982	$ 22,788
United Kingdom	1,646,000	2,413	68,210,000	$ 4,320	$ 2,119,000	$ 1,943,851	$ 504,748	$ 3,202
United Arab Emirates	193,000	1,913	10,090,000		$ 164,200	$ 148,640	$ 48,289	$ 437
Ukraine	93,120	224	41,640,000	$ 477	$ 103,700	$ 131,399	$ 14,858	$ 175
Turkey	646,600	760	85,040,000	$ 903	$ 415,044	$ 403,178	$ 76,896	$ 675
Thailand	257,400	368	69,950,000	$ 483	$ 270,400	$ 265,513	$ 21,877	$ 503
Taiwan	390,900	1,661	23,530,000	$ 1,960	$ 355,800	$ 347,968	$ 61,297	$ 751
Switzerland	290,900	3,332	8,731,000	$ 7,920	$ 457,000	$ 406,691	$ 99,177	$ 779
Sweden	365,100	3,583	10,190,000	$ 4,280	$ 302,652	$ 273,912	$ 73,104	$ 616
Sri Lanka	39,170	182	21,500,000	$ 121	$ 69,905	$ 57,960	$ 11,668	$ 81
Spain	1,044,000	2,233	46,750,000	$ 3,110	$ 883,700	$ 828,888	$ 180,881	$ 1,433
South Korea	1,566,000	3,052	51,310,000	$ 3,170	$ 916,500	$ 849,166	$ 153,030	$ 1,792
South Africa	287,600	479	60,040,000	$ 1,320	$ 251,670	$ 219,600	$ 37,808	$ 412
Slovakia	84,050	1,539	5,461,000	$ 1,620	$ 74,040	$ 68,534	$ 20,141	$ 118
Singapore	61,850	1,134	5,454,000	$ 4,310	$ 200,800	$ 139,684	$ 23,415	$ 380
Saudi Arabia	406,200	1,134	35,820,000		$ 419,826	$ 317,222	$ 66,419	$ 785
Russia	1,711,000	1,149	148,900,000	$ 757	$ 892,300	$ 837,262	$ 92,919	$ 1,685
Romania	147,800	773	19,130,000	$ 1,370	$ 207,100	$ 194,737	$ 44,087	$ 279
Portugal	177,200	1,720	10,300,000	$ 1,830	$ 179,400	$ 169,511	$ 29,859	$ 250
Poland	496,500	1,313	37,800,000	$ 1,460	$ 417,500	$ 382,294	$ 78,745	$ 663
Philippines	80,020	72	111,000,000	$ 217	$ 283,800	$ 286,638	$ 68,392	$ 392
Peru	113,600	342	33,210,000	$ 405	$ 148,100	$ 135,607	$ 12,313	$ 220
Pakistan	131,100	58	225,200,000	$ 112	$ 242,900	$ 234,645	$ 67,461	$ 281
Norway	155,400	2,862	5,429,000	$ 5,720	$ 199,800	$ 188,190	$ 42,450	$ 433
Nigeria	4,783	2	211,400,000	$ 60	$ 448,100	$ 301,172	$ 59,296	$ 462
New Zealand	104,300	2,067	5,047,000	$ 3,490	$ 135,754	$ 140,385	$ 35,010	$ 233
Netherlands	336,200	1,932	17,400,000	$ 5,060	$ 457,300	$ 426,173	$ 110,020	$ 986
Mexico	562,400	432	130,300,000	$ 465	$ 842,600	$ 814,089	$ 136,995	$ 1,242
Malaysia	529,600	1,616	32,780,000	$ 707	$ 218,100	$ 216,344	$ 30,723	$ 371
Kazakhstan	76,890	405	18,990,000	$ 571	$ 88,020	$ 102,082	$ 17,120	$ 202
Japan	4,085,000	3,239	126,100,000	$ 3,510	$ 2,956,000	$ 2,717,114	$ 664,758	$ 5,018
Italy	1,510,000	2,501	60,370,000	$ 2,940	$ 1,299,000	$ 1,199,132	$ 266,850	$ 2,122
Israel	319,400	3,403	9,385,000	$ 3,560	$ 273,800	$ 235,146	$ 55,938	$ 462
Ireland	134,500	2,699	4,983,000	$ 5,140	$ 140,600	$ 129,362	$ 31,657	$ 517
Iran	715,700	842	85,030,000		$ 111,400	$ 99,261	$ 36,077	$ 194
Indonesia	517,000	192	269,800,000	$ 189	$ 747,100	$ 636,455	$ 152,841	$ 1,131
India	2,944,000	211	1,393,000,000	$ 169	$ 2,000,000	$ 1,765,334	$ 256,623	$ 2,989
Hungary	137,800	1,430	9,634,000	$ 1,400	$ 93,050	$ 85,115	$ 15,554	$ 176
Hong Kong	39,280	526	7,465,000	$ 2,300	$ 260,700	$ 249,074	$ 29,847	$ 361
Greece	94,690	913	10,370,000	$ 1,860	$ 213,100	$ 144,628	$ 27,716	$ 209
Germany	3,018,000	3,641	82,890,000	$ 4,290	$ 2,412,000	$ 2,126,576	$ 495,680	$ 4,202
France	1,785,000	2,728	65,430,000	$ 3,950	$ 1,854,000	$ 1,525,519	$ 385,954	$ 2,960
Finland	113,300	2,042	5,548,000	$ 4,350	$ 156,600	$ 152,538	$ 42,825	$ 296
Egypt	208,500	204	102,400,000	$ 398	$ 373,600	$ 346,364	$ 62,809	$ 404
Ecuador	52,650	297	17,750,000	$ 615	$ 62,630	$ 61,971	$ 5,086	$ 101
Denmark	203,500	3,501	5,813,000	$ 6,150	$ 174,300	$ 178,545	$ 49,819	$ 399
Czech Republic	182,800	1,705	10,720,000	$ 1,710	$ 168,447	$ 133,753	$ 36,285	$ 287
Colombia	107,700	210	51,270,000	$ 475	$ 213,100	$ 214,575	$ 34,137	$ 312
China	########	1,492	1,422,000,000	$ 1,380	$ 7,783,000	$ 6,547,535	$ 1,452,654	$ 17,860
Chile	269,800	1,404	19,210,000	$ 1,100	$ 187,400	$ 175,484	$ 26,529	$ 290
Canada	447,900	1,177	38,070,000	$ 4,800	$ 1,145,000	$ 1,088,123	$ 264,004	$ 1,908
Bulgaria	27,950	406	6,892,000	$ 877	$ 46,322	$ 46,111	$ 9,480	$ 79
Brazil	1,855,000	870	213,300,000	$ 510	$ 1,040,000	$ 974,453	$ 160,188	$ 1,632
Belgium	456,300	3,923	11,630,000	$ 4,690	$ 276,900	$ 310,125	$ 73,919	$ 628
Azerbaijan	4,422	43	10,220,000	$ 433	$ 29,488	$ 27,294	$ 2,690	$ 54
Austria	276,600	3,184	8,688,000	$ 4,680	$ 264,500	$ 258,540	$ 59,155	$ 488
Australia	299,000	1,159	25,800,000	$ 4,370	$ 950,340	$ 833,483	$ 190,597	$ 1,576
Argentina	338,500	742	45,610,000	$ 425	$ 289,500	$ 277,162	$ 35,184	$ 436
Algeria	53,900	119	45,170,000		$ 74,390	$ 73,261	$ 6,823	$ 148

1.calculate correlation between 2021 # of new vehicle registrations and other variables using Data Analysis tool in Excel. 2. display the correlations on the bar graph. 3. Which variable is highly correlated with 2021 # of new registered vehicles? What is the correlation?