<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="individual-project-style.css">
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=1024, initial-scale=1.0">
<title>DATS 6401 - Individual Project - Joseph Valle (Home)</title>
<script src="https://www.gstatic.com/charts/loader.js"></script>
<script>
google.charts.load('current', {'packages':['corechart','geochart']});
google.charts.setOnLoadCallback(drawAllSheets);
function drawAllSheets() {
drawSheetName('data', 'SELECT A,BX', gdpPctChangeResponseHandler);
drawSheetName('data', 'SELECT A,CB', populationPctChangeResponseHandler);
}
// drawAllSheets establishes a function that selects a sheet within the data's structure on Google and what columns to include.
function drawSheetName(sheetName, query, responseHandler){
var queryString = encodeURIComponent(query);
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheets/d/1Ig9G4lXtKgSdBzU0NNRTALwu5cebPNdkeYjgxh98U2M/gviz/tq?sheet='
+ sheetName + '&headers=1&tq=' + queryString);
query.send(responseHandler);
}
// drawSheetName connects to the specific Google Sheets page to work with over the duration of this project.
function checkError(response){
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
return;
}
}
// As a precaution, checkError warns against any mistakes made when querying the Google data.
function gdpPctChangeResponseHandler(response){
checkError(response);
var data = response.getDataTable();
data.sort({column: 1});
var options = {
colorAxis: {colors: ['#76ee00','#006400']},
backgroundColor: '#add8e0'
};
var formatter = new google.visualization.NumberFormat({
fractionDigits: 2, suffix: '%'}); // This formats the data as percentages rounded to two decimal places.
formatter.format(data,1);
var chart = new google.visualization.GeoChart(document.getElementById('gdp_pct_change_div'));
chart.draw(data, options);
}
// gdpPctChangeResponseHandler shows the countries' GDP growth rates from 2013 to 2017.
function populationPctChangeResponseHandler(response){
checkError(response);
var data = response.getDataTable();
data.sort({column: 1});
var options = {
colorAxis: {colors: ['b0e2ff','#000080']},
backgroundColor: '#add8e0'
};
var formatter = new google.visualization.NumberFormat({
fractionDigits: 2, suffix: '%'});
formatter.format(data,1);
var chart = new google.visualization.GeoChart(document.getElementById('population_pct_change_div'));
chart.draw(data, options);
}
// populationPctChangeResponseHandler shows the countries' population growth rates from 2013 to 2017.
</script>
</head>
<body>
<div id="main">
<div id="header">
<div id="logo">
<div id="logo_text">
<h1><a href="g20_home.html"></a>The G20: A Military, Educational, and Healthcare Perspective</h1>
<h3></h3>
<h3>DATS 6401 | Joseph Valle</h3>
</div>
</div>
</div>
<div id="menubar">
<ul id="menu">
<li class="selected"><a href="g20_home.html">Home</a></li>
<li><a href="g20_military.html">Military</a></li>
<li><a href="g20_education.html">Education</a></li>
<li><a href="g20_healthcare.html">Healthcare</a></li>
<li><a href="g20_case_study.html">Case Study</a></li>
<li><a href="g20_conclusions.html">Conclusions</a></li>
<li><a href="g20_references.html">References</a></li>
</ul>
</div>
<div id="content">
<h1>The G20: A Visualized Overview from 2013 to 2017</h1>
<p>
Welcome!
You are now browsing at a visual presentation analyzing a select number of countries who are members of the G20 forum.
The data assembled covers the following nations: Australia, Brazil, China, France, Germany, Italy, Japan, Mexico, Russia, South Korea, the United Kingdom (UK), and the United States (US).
Over the course of this presentation, you will have the opportunity to explore these nations' trends in military, educational, and healthcare spending from 2013 to 2017, and grasp at these variables' relationships with their respective economies.
Refer to the menu-bar located at the top for your studies.
</p>
<p>
Our data for GDP, population, and military and healthcare spending from 2013 to 2017 can be found at the World Bank's Indicator files.
Figures representing the educational shares of GDP were located at several other sources.
While China's figures were posted on Statista, the US reported its current educational expenditures at the Federal Reserve Bank of St. Louis' Economic Data page, which were then used to calculate its GDP shares over our timespan of interest.
As for the other countries in our study, their shares were reported from the data site Knoema.
Regarding the latter, as an important sidenote, Japan and South Korea's educational shares were missing in 2015 and 2017, respectively.
Thus, during the data cleanup stage, these were adjusted by calculating the means for the other four years that already included figures for both countries.
References for this project are included under its corresponding tab.
</p>
<p>
For a little background, let's report on the rates of GDP and population growth among the nations listed between 2013 and 2017.
</p>
<h2>Rate of GDP Growth across the G20 Forum (2013 - 2017)</h2>
<div id="gdp_pct_change_div" style="width: 880px; height:500px;"></div>
<br>
<p>
As shown by the green geographic chart, the majority of countries actually saw their economies decline over our timespan.
However, the three outliers - China, South Korea, and the US - expanded at relatively high rates, at 28.63%, 18.46%, and 16.29%, respectively.
Note as well how four European countries - France, Germany, Italy, and the UK - shrank at some level between 1% and 8.50% from 2013 to 2017.
</p>
<h2>Rate of Population Growth across the G20 Forum (2013 - 2017)</h2>
<div id="population_pct_change_div" style="width: 880px; height:500px;"></div>
<br>
<p>
On the other hand, every country except Japan witnessed a rise in its population over our timespan.
Taken alongside our findings for the growth rates of GDP, we can deduce that the GDP per capita in most nations shrank from 2013 to 2017.
This is likely the case with Australia in particular, whose economy declined by more than 15% despite its population rising by more than 6%.
</p>
</div>
</div>
</body>
</html>