Ch10Spreadsheets

Ch10Spreadsheets - 8.2 4.3 8.0 4.3 8.0 4.3 8.3 4.3 8.3 6.0...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Company and Government Corruption 2002 2002 2003 2003 2004 2004 2005 2005 2006 2006 Govt. Bribe Govt. Bribe Govt. Bribe Govt. Bribe Govt. Bribe Corrupt Payers Corrupt Payers Corrupt Payers Corrupt Payers Corrupt Payers Country Index Index Index Index Index Index Index Index Index Index Australia 8.6 8.5 8.8 8.5 8.8 8.5 8.8 8.5 8.7 7.5 Sweden 9.3 8.4 9.3 8.4 9.2 8.4 9.2 8.4 9.2 7.6 Switzerland 8.5 8.4 8.8 8.4 9.1 8.4 9.1 8.4 9.1 7.8 Austria 7.8 8.2 8.0 8.2 8.4 8.2 8.7 8.2 8.6 7.5 Canada 9 8.1 8.7 8.1 8.5 8.1 8.4 8.1 8.5 7.4 Netherlands 9 7.8 8.9 7.8 8.7 7.8 8.6 7.8 8.7 7.2 Belgium 7.1 7.8 7.6 7.8 7.5 7.8 7.4 7.8 7.3 7.2 UK 8.7 6.9 8.7 6.9 8.6 6.9 8.6 6.9 8.6 7.3 Singapore 9.3 6.3 9.4 6.3 9.3 6.3 9.4 6.3 9.4 6.7 Germany 7.3 6.3 7.7 6.3 8.2 6.3 8.2 6.3 8.0 7.3 Spain 7.1 5.8 6.9 5.8 7.1 5.8 7.0 5.8 6.8 6.6 France 6.3 5.5 6.9 5.5 7.1 5.5 7.5 5.5 7.4 6.5 USA 7.7 5.3 7.5 5.3 7.5 5.3 7.6 5.3 7.3 7.2 Japan 7.1 5.3 7.0 5.3 6.9 5.3 7.3 5.3 7.6 7.1 Malaysia 4.9 4.3 5.2 4.3 5.0 4.3 5.1 4.3 5.0 5.5 Hong Kong
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 8.2 4.3 8.0 4.3 8.0 4.3 8.3 4.3 8.3 6.0 Italy 5.2 4.1 5.3 4.1 4.8 4.1 5.0 4.1 4.9 5.9 S. Korea 4.5 3.9 4.3 3.9 4.5 3.9 5.0 3.9 5.1 5.8 Taiwan 5.6 3.8 5.7 3.8 5.6 3.8 5.9 3.8 5.9 5.4 China 3.5 3.5 3.4 3.5 3.4 3.5 3.2 3.5 3.3 4.9 Russia 2.7 3.2 2.7 3.2 2.8 3.2 2.4 3.2 2.5 5.1 Correlation To work out a correlation for 2002 just type "=Correl(b7:b27, c7:c27)" in cell b29 Then do four more correlations for the years 2003, 2004, 2005 and 2006. The Bribe Payers Index is the average ratings of 800 business experts in 15 different countries that companies from the country offer or pay bribes. The higher the score the lower the bribe paying (see www.transparency.org) The Corruption Index rating is an aggregation of corruption surveys undertaken by seven different, independent research instiutions from around the World. The higher the score the lower the corruption of public officials (see www.transparency.org)...
View Full Document

Ask a homework question - tutors are online