Business Statistics

 

The directions are given in the attachment. This is to be done in Excel.

PART I
1. Open the following website: http://www.rug.nl/research/ggdc/data/pwt/pwt-8.1
2. Click on the “Productivity” tab, and then click on “Penn World Table”. Go to “Earlier Releases” and choose “PTW 8.1”
3. Click on “Excel” under the Expert Data Access
4. Make sure you navigate the website to learn about the variables
5. Make sure to SAVE the Excel file in your computer or a flash drive
6. In the excel file that you just downloaded, open a new tab (new sheet at the bottom of the spreadsheet) and generate a random number between 1 and 167 [=randbetween(1,167)]. Drag down this command until you generate 30 random numbers. Highlight the newly created random numbers and copy them in a new column. When pasting the values choose “Paste Special” and then “Values”. The new numbers may change. Please double check that none of the new numbers is repeated.
7. Refer to the list of countries below and add the name to the right of the random number
8. As part of the initial notes, write up the process of creating a new database.

PART II
1. With you new list of 30 countries (rows) choose the data for RGDPE, POP, csh_c (columns). Make sure that you know what is the meaning of these variables
2. Create a scatter plot with csh_c (y axis) and RGDPE (x-axis).
3. Calculate the mean value per country for these variables between 1990 and 2011. For instance, if your country is Zambia, type =average( , then go to the data table, locate Zambia, identify the year 1990 for RGDPE, click on it, press the key “shift” and highlight the data down to 2011. Close parenthesis and click ENTER.
4. Repeat this action for the rest of the countries and all variables.
5. Create a frequency distribution table for the variable RGDPE using 5 classes. Create a histogram to determine the underlying distribution.
6. Create other graphs that you consider useful for your analysis
7. Write up your results

PART III
1. After filling out your table, calculate the over all mean, variance and standard deviation for your sample.
2. Copy and paste values for RGDPE in a different place or spreadsheet. Make sure you use the “paste special” and “values” function to avoid errors in the calculations. Calculate and explain the 5-number summary (smallest observation, first quartile, median, third quartile and largest observation). Use the excel function =QUARTILE(array, quartile number) to find the quartiles
3. What is the probability that a country will have a RGDPE less than $500,000 (remember these data is in millions, which is equivalent to $500 billion). Use the z-score to calculate this value for your sample. Is it usual or unusual in your sample?
4. Write up your findings

PART IV
Write a report with this information. Include graphs and create a table with your main results.

LIST OF COUNTRIES
country
1 Angola
2 Albania
3 Argentina
4 Armenia
5 Antigua and Barbuda
6 Australia
7 Austria
8 Azerbaijan
9 Burundi
10 Belgium
11 Benin
12 Burkina Faso
13 Bangladesh
14 Bulgaria
15 Bahrain
16 Bahamas
17 Bosnia and Herzegovina
18 Belarus
19 Belize
20 Bermuda
21 Bolivia
22 Brazil
23 Barbados
24 Brunei Darussalam
25 Bhutan
26 Botswana
27 Central African Republic
28 Canada
29 Switzerland
30 Chile
31 China, People’s Republic of
32 Côte d’Ivoire
33 Cameroon
34 Democratic Republic of the Congo
35 Congo
36 Colombia
37 Comoros
38 Cape Verde
39 Costa Rica
40 Cyprus
41 Czech Republic
42 Germany
43 Djibouti
44 Dominica
45 Denmark
46 Dominican Republic
47 Ecuador
48 Egypt
49 Spain
50 Estonia
51 Ethiopia
52 Finland
53 Fiji
54 France
55 Gabon
56 United Kingdom
57 Georgia
58 Ghana
59 Guinea
60 Gambia
61 Guinea-Bissau
62 Equatorial Guinea
63 Greece
64 Grenada
65 Guatemala
66 Hong Kong SAR
67 Honduras
68 Croatia
69 Hungary
70 Indonesia
71 India
72 Ireland
73 Iran (Islamic Republic of)
74 Iraq
75 Iceland
76 Israel
77 Italy
78 Jamaica
79 Jordan
80 Japan
81 Kazakhstan
82 Kenya
83 Kyrgyzstan
84 Cambodia
85 Saint Kitts and Nevis
86 Republic of Korea
87 Kuwait
88 Lao People’s Democratic Republic
89 Lebanon
90 Liberia
91 Saint Lucia
92 Sri Lanka
93 Lesotho
94 Lithuania
95 Luxembourg
96 Latvia
97 Macao SAR
98 Morocco
99 Republic of Moldova
100 Madagascar
101 Maldives
102 Mexico
103 Republic of Macedonia
104 Mali
105 Malta
106 Montenegro
107 Mongolia
108 Mozambique
109 Mauritania
110 Mauritius
111 Malawi
112 Malaysia
113 Namibia
114 Niger
115 Nigeria
116 Netherlands
117 Norway
118 Nepal
119 New Zealand
120 Oman
121 Pakistan
122 Panama
123 Peru
124 Philippines
125 Poland
126 Portugal
127 Paraguay
128 Qatar
129 Romania
130 Russian Federation
131 Rwanda
132 Saudi Arabia
133 Sudan
134 Senegal
135 Singapore
136 Sierra Leone
137 El Salvador
138 Serbia
139 Sao Tome and Principe
140 Suriname
141 Slovakia
142 Slovenia
143 Sweden
144 Swaziland
145 Syrian Arab Republic
146 Chad
147 Togo
148 Thailand
149 Tajikistan
150 Turkmenistan
151 Trinidad and Tobago
152 Tunisia
153 Turkey
154 Taiwan
155 United Republic of Tanzania
156 Uganda
157 Ukraine
158 Uruguay
159 United States
160 Uzbekistan
161 St. Vincent and the Grenadines
162 Venezuela
163 Viet Nam
164 Yemen
165 South Africa
166 Zambia
167 Zimbabwe

find the cost of your paper