Savings By Nation 2012
Savings By Nation
Directions: Enter the data below into a spreadsheet and create a column chart.
In cell A15 add the label "Average Savings". Using an Excel function in cell B15, compute the mean of the nation savings listed.
In cell A17 answer the following question using an Excel formula. How much less does the United States save compared to the highest saving nation?
In cell A19 answer the following question (you can use a calculator for this one). What is the average saving rate in Europe.
In Sheet2 create a table with Excel formulas to answer the following question. Based on an average individual income of $40,000, calculate the average amount of money a person would save in each nation.
Net Savings - 2012
Australia 8.9
Austria 7.9
Belgium 8.5
Czech Republic 6.8
Germany 10.5
Ireland 4.0
Italy 4.4
Norway 9.0
Swiss 13.2
United States 3.7
Source: OECD Library 12/5/12