This document presents my statistics coursework, focusing on data analysis techniques using Excel, with examples from Nigeria and Germany. It includes calculations for statistical measures such as median, mode, and range, which summarize key data points for each country. The document also explains ...
This report shows two countries of different socio-economic backgrounds one is from Germany a
European higher income country, and one is from Nigeria a non- European developing country. I have
received the information from (World Banks, 2021) open data website. For Germany and Nigeria, the
data covers 50 years from 1972 till 2021. However, there is some data missing when I obtained
information From Germany such as labor force 1972-1989, unemployment, total (% of total labor force)
(national estimate) from 1972-1982. On the other hand, Nigeria is also missing information for labor
, force from 1972-1989 and for unemployment 1972-1987 and then again for 1989-1991. The data is also
missing data for gross saving and government final consumption from 1972-1980
Part 1
1.1 Descriptive Statistics
Figure 1 presents the descriptive statistics for Nigeria and Germany between 1972-2021. The first
column represents life expectancy at birth in years.
Figure 1: Descriptive statistics for Nigeria and Germany
Panel A: Germany
Life expectancy at birth, Population growth
Labor force, total GDP (current US$)
total (years) (annual %)
2171910926678
Mean 76.72 Mean 0.12 Mean 41261907.78 Mean
.97
173865282517.
St Error 0.47 St Error 0.06 St Error 287238.60 St Error
56
2163258487902
Median 76.87 Median 0.14 Median 41466557.50 Median
.17
Mode #N/A Mode #N/A Mode #N/A Mode #N/A
1229413202810
St. Dev. 3.32 St. Dev. 0.44 St. Dev. 1624866.90 St. Dev.
.83
2640192443315
S Variance 11.00 S Variance 0.19 S Variance S Variance 1.51146E+24
.85
Count 50 Count 50 Count 32 Count 50
Panel B: Nigeria
Life expectancy at birth, Population growth
Labor force, total GDP (current US$)
total (years) (annual %)
174351110104
Mean 47.76 Mean 2.65 Mean 48746705.78 Mean
.34
24443736754.
St Error 0.43 St Error 0.02 St Error 1970654.47 St Error
67
73615090339.
Median 46.53 Median 2.62 Median 48230018 Median
86
Mode #N/A Mode #N/A Mode #N/A Mode #N/A
172843320167
St. Dev. 3.03 St. Dev. 0.17 St. Dev. 11147705.11 St. Dev.
.68
1242713291381
S Variance 9.16 S Variance 0.03 S Variance S Variance 2.98748E+22
37.00
Count 50 Count 50 Count 32 Count 50
We can see the mean life expectancy of Germany which is 76.72 which we can see an increase from
2005 as the mean life expectancy from 1972-2005 was 75.20. The increase in life expectancy seen in
Germany is due to having a “better health care system…. and in 2008 the IN-FORM initiative was
launched to promote healthier lifestyle and exercise.” 1 The median for Germany is 76.87 and the mode
is not applicable for this set of data. On the other hand, Nigeria’s life expectancy is lower than Germany
with a life expectancy of 47.76 as they do not have the same level of healthcare or education that can be
seen in Germany. The median for Nigeria is 46.53 which is quite close to the mean and again the mode is
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller khadijahzahir. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $5.14. You're not tied to anything after your purchase.
