The following table shows the values in General Government Consumption Expenditure (in US) for the Philippines from 2007 to 2016. General government final consumption expenditure includes all government current expenditures for purchases of goods and services (including compensation of employees.) It also includes most expenditures on national defense and security but excludes government military expenditures that are part of government capital formation. (Source: World Bank national accounts data, and OECD National Accounts data files.) Year Consumption Expenditure 2007 $13,867,990,000 2008 $15,384,520,000 2009 $16,598,320,000 2010 $19,403,620,000 2011 $21,744,840,000 2012 $27,117,510,000 2013 $29,468,210,000 2014 $30,054,320,000 2015 $31,993,260,000 2016 $33,926,500,000 Use any statistical tool or program to construct a bar graph, a pie chart, and a line graph. Which chart/graph is the most appropriate in this data set? Explain why.
Answer using MS Excel.
The following table shows the values in General Government Consumption Expenditure (in US) for the Philippines from 2007 to 2016. General government final consumption expenditure includes all government current expenditures for purchases of goods and services (including compensation of employees.) It also includes most expenditures on national defense and security but excludes government military expenditures that are part of government capital formation. (Source: World Bank national accounts data, and OECD National Accounts data files.)
Year Consumption Expenditure
|
2007 |
$13,867,990,000 |
|
2008 |
$15,384,520,000 |
|
2009 |
$16,598,320,000 |
|
2010 |
$19,403,620,000 |
|
2011 |
$21,744,840,000 |
|
2012 |
$27,117,510,000 |
|
2013 |
$29,468,210,000 |
|
2014 |
$30,054,320,000 |
|
2015 |
$31,993,260,000 |
|
2016 |
$33,926,500,000 |
Use any statistical tool or program to construct a bar graph, a pie chart, and a line graph. Which chart/graph is the most appropriate in this data set? Explain why.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 3 images
