Topic > Example of descriptive statistics - 3030

1221643CHAPTER 5ANALYZABLE DATA 1Descriptive statisticsMean Std. Deviation NMC 7.2105 2.75805 9MVA 7.0439 3.03403 9MBV .1777 .77716 9ROE 2.2422 .92574 9 QR -.2171 .77814 9INTERPRETATIONStandard deviation is a measure of variability. In SPSS, you can calculate this by choosing Analyze/Descriptive Statistics/Descriptive. The average value for:-• Market Capitalization – 7.2105 • Market Value Added – 7.0439 • Market Value to Book - 0.1777 • Return on Equity – 2.2422 • Quick Ratio - -.2171La standard deviation for:-• Market capitalization – 2.75805• Market value added –5.1 Net operating profit after tax NOPAT resume includes interest income, other income less interest on deposit and other operating expenses less taxes so as to give an overall emphasis on operating profit. Net operating profit is considered in place of net profit so as to highlight the economic value of a business.NOPAT = (Net Profit + Provisions and Contingencies + Interest on Loans ) less (Taxes)TABLE 1CALCULATION OF NOPAT (in Cr.)NET OPERATING PROFIT2012-2013 2011-2012 2010-2011SBI 14,104.98 11,707.29 7,370.35Bank of Baroda 4,480.72 5,006.96 4.24 1.68ICICI 8,325.47 6,465, 26 5,151.38HDFC 6,726.28 5,167.09 3,926.40TAX 2012-2013 2011-2012 2010-2011SBI 4,231.49 3,512.18 2,211.10Bank of Baroda 1,344.21 1.50 2.08 1,272.50 ICICI 2,497.64 1,939, 57 1,545.41HDFC 2,017.88 1,550.12 1,177.92NOPAT2012-2013 2011-2012 2010-2011SBI 9,873.49 8,195.11 5,159.25Lawyer's Bank 3,136.51 04.88 2,969.18ICICI 5,827.83 4,525.69 3,605 ,97HDFC 4,708.40 3,616.97 2,748.48GRAPH 1NOPATINTERPRETATIONAs per the tables above, the following interpretation was given. Comparing all four banks (SBI, Bank of Baroda, ICICI, ...... half of the paper ...... Cal. test: Linear regression was used to test the correlation. TABLE 15 SPSS STATISTICAL OUTPUT FOR PUBLIC AND PRIVATE BANKSCorrelationsEVA CLOSING_PRICEEVA Pearson correlation 1 .818Sig. (2-tailed) .018N 4 4CLOSING_PRICE Pearson correlation .818 1Sig (2-tailed) .018N 4 4INTERPRETATION From the correlation table above the Pearson correlation is 0.818 is closer to 1, so it means that there is a strong relationship between the two variables (EVA and stock price). So, if one variable changes, it also leads to the change of another variable. When we talk about statistical correlation (Sig . 2-tailed), the value we get is 0.018 which is less than the alpha value (0.05), so in this case the variables are highly correlated with each other. Therefore the null hypothesis will be rejected and the alternative hypothesis will be accepted.