Statistic with word and excel Essay Example | Topics and Well Written Essays - 2000 words

Statistic with word and excel - Essay suitFactors that argon expected to influence female fertility rate are the countrys wealth, the womens position in society, the general state of health of the country, and the strength of family formulation programmes adopted in the country. The followers versatiles are designated for the study OBS = observation, i.e. record count TFR = the total fertility rate, proxy of the growth of the universe GNPPC = realise National Product per capita in US Dollars, the proxy for country wealth FL = the percentage of the female population who are literate, the proxy for womens social position CM = the child mortality rate per pace of live births, as proxy of the countrys state of health FP = an index of the strength of family planning in the country This study shall seek to de nameine the extent to which population growth (TFR) may be explained by the country wealth (GNPPC), womens social position (FL), the countrys state of health (CM), and the stre ngth of family planning in the country (FP). 2. Descriptive statistics Data have been gathered for 64 periods, indicating the variables TFR, GNPPC, FP, CM, and FL. The tabulated set have been collated and their descriptive statistics follow Descriptive statistics of data gathered TFR GNPPC FP CM FL Mean 5.55 1401.25 36.60 141.50 51.19 Mode 6.50 300.00 16.70 142.00 22.00 normal 6.04 620.00 28.65 138.50 48.00 Max 8.49 19830.00 101.10 312.00 95.00 Min 1.69 120.00 3.70 12.00 9.00 Std Dev 1.51 2725.70 27.03 75.98 26.01 Six descriptive statistics have been garnered mean, which is the average of the data items the mode which is the lever that appears close to frequently, and the median value which is the value of the term in the middle of the put of values. The range is indicated by the maximum and the minimum, which are also determined above. Finally, the standard deviation, which is a measure of how much the individual observations in each term differ from the mean value for the g roup it is a measure of the dispersion of the data from the mean. The interpret future(a) shows the observations for the variables except GNPPC. The reason why GNPPC was left out of the graph was because the values of this variable are of a much higher order than the other variables, rendering the latter indistinguishable in a graph scaled to meet GNPPC. The line graphs do not appear to show any strong correlations in the variation of any of the variables with each other. A cursory inspection of the descriptive statistics shows that the mean is higher than the median and mode for the GNPPC, FP and FL, and higher than the median, but not the mode, for CM. This indicates that the distribution tends to converge towards the higher end of the value range for these independent variables. On the other hand, the mean for TFR is lower than both the mode and the median, suggesting that the values for the dependent variable tended towards the lower end of the value range. The difference in d irections between dependent and independent variables appears to suggest a negatively correlated relationship. Moreover, outliers appear to exist in GNPPC, given the very high maximum value compared to either mean, mode or median. The high outlier may account for the abnormally high mean in comparison to the mode and median. In this