Introduction
Population statistics is one of the data regarding a country that can be used to determine many factors regarding the said country. Different economic measures can be obtained as a result of population data, including growth rate and the determination of the population under the poverty line. Moreover, it is easy for national planning where trends on population growth are available. As a result, it is critical to obtain population data and notice trends to enable future planning catering for expected growth in population. This paper tables a report on the population statistics in the different cities in Germany.
Descriptive Statistics
Descriptive Statistics |
1987 |
1995 |
2001 |
2011 |
2012 |
Mean |
167756.7857 |
179391.5165 |
176621.989 |
174172.7637 |
176304.3077 |
Standard Error |
22399.8612 |
23450.76594 |
23050.36241 |
22851.326 |
23382.15861 |
Median |
83303 |
90470.5 |
91899 |
86471 |
87510.5 |
Mode |
0 |
#N/A |
#N/A |
#N/A |
#N/A |
Standard Deviation |
302190.649 |
316368.129 |
310966.39 |
308281.242 |
315442.5654 |
Sample Variance |
91319188316 |
1.00089E+11 |
96700095704 |
95037324175 |
99504012097 |
Kurtosis |
63.55605332 |
68.10327026 |
66.60348475 |
61.88345663 |
62.4533616 |
Skewness |
6.985991134 |
7.308523911 |
7.243737721 |
6.979623779 |
7.016914589 |
Range |
3260000 |
3425835 |
3341052 |
3242708 |
3324662 |
Minimum |
0 |
45583 |
47382 |
49657 |
50560 |
Maximum |
3260000 |
3471418 |
3388434 |
3292365 |
3375222 |
Sum |
30531735 |
32649256 |
32145202 |
31699443 |
32087384 |
Count |
182 |
182 |
182 |
182 |
182 |
Delegate your assignment to our experts and they will do the rest.
Assuming that the missing values present zero (which is not the case, since population cannot be zero), the above descriptive statistics has been determined for the years highlighted. The population in the various cities shows growth between the 1987 to 1995 period as seen from the mean values of the growth. Nevertheless, the population experienced slight reductions over the following census. This statistic can be confirmed from the median values, which also confirm that the population was experiencing reduction based on the median values obtained. While the 1987 data can be taken with a pinch of salt due to the addition of zero values to cater for cities without census data, data from the year 1995 is fully reliable as all values are present for analysis. Consider the table below, which represents the data explained above:
Figure 1 : Median and Mean Value Graph
Z Testing
Having determined the measures available to each city, the dataset also presents the different outliers, which the data has. Using z-tests, the population data was subjected to measures to determine outliers. From the above data, an analysis has provided variances, which shall be used to determine outliers. The table below was obtained after conducting z-tests for two means:
z-Test: Two Sample for Means (Data 1) |
data set 1 |
Data set 2 |
Data set 3 |
|||
247923 |
245778 |
245778 |
236420 |
236420 |
240086 |
|
Mean |
179012.8895 |
176239.9116 |
176239.9116 |
173828.8564 |
173828.8564 |
175951.9227 |
Known Variance |
0.95 |
0.96 |
0.96 |
0.95 |
0.95 |
0.99 |
Observations |
181 |
181 |
181 |
181 |
181 |
181 |
Hypothesized Mean Difference |
0 |
0 |
0 |
|||
Z |
26994.10994 |
23470.90124 |
-20506.9928 |
|||
P(Z<=z) one-tail |
0 |
0 |
0 |
|||
z Critical one-tail |
1.644853627 |
1.644853627 |
1.644853627 |
|||
P(Z<=z) two-tail |
0 |
0 |
0 |
|||
z Critical two-tail |
1.959963985 |
1.959963985 |
1.959963985 |
In each of the years, there were at least 181 observations. In this case, the analysis for the year 1987 was left out as this dataset contained non-numeric data. From the above data, variances as provided in the previous table are rounded off to two decimal places and inserted for optimal results. Again, the data confirms the above assertion that the population dipped at one point, and then begins to recover. Adding the mean to the z-value, one finds that cities with a population value over 206,007 people is an outlier city. On the minimum value, cities having people under the minimum population of 152,019 have less than expected individuals.
Correlation
Taking the values for the city of Aachen and assuming that all cities are growing at the same rate, a correlation table for the data is provided:
Column 1 |
Column 2 |
Column 3 |
Column 4 |
Column 5 |
|
Column 1 |
1 |
||||
Column 2 |
#DIV/0! |
1 |
|||
Column 3 |
#DIV/0! |
#DIV/0! |
1 |
||
Column 4 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
1 |
|
Column 5 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
1 |
From the above data, correlation is available for all five values. According to this information, correlation coefficient is one, showing that a linear positive relationship exists between the data points. As a result, it can be said that a positive correlation exists between the census years for the city, thereby supporting a linear growth path.
Conclusion
Conclusively, data from the various censuses has shown that there exists population growth in Germany despite experiencing a drop in population in the 1990s. Nevertheless, the country is on the path to population recovery having registered population growth in recent years.