Statistical Data Analysis Using Ms-Excel

Statistics plays an important role in every walk of life right from simple situation such as finding average marks in examination to a very complex phenomenon such as rain fall prediction or measuring changes in prices. Statistics helps in decision-making whenever phenomenon contains uncertainties. LIC, Banks, Defense, Government agencies, Industries, Business, trade etc. Make use of statistics in planning, forecasting, Controlling, Decision Making, Index Numbers are widely used in almost all fields such as economics, business, import, export etc.

Statistical analysis is a vital component in every aspect of contemporary research. Social surveys, laboratory experiments, clinical trials etc. require statistical treatment of the findings before arriving at valid conclusions. The research requirements today call for the use of statistical techniques in every field of knowledge. Statistics is studied at both undergraduate and postgraduate levels. A course on research methodology for doctoral programme includes sampling design, data collection, statistical analysis and report writing procedures

This book Useful for B.Sc., B.Com., B.C.S., B.C.A., B.B.A., M.B.A. and C.A students.

1. Windows And Ms-Office

2. Ms-Excel

3. Nature Of Data

4. Classification Of Tabulation

5. Diagrammatic Representation

6. Graphical Representation

7. Measures Of Central Tendency

8. Measures Of Dispersion

9. Moments, Skewness And Kurtosis

10. Correlation And Regression

11. Multiple Regression, Multiple Correlation And Partial Correlation

12. Fitting Of Straight Line And Second Degree Curves

13. Attributes

14. Fitting Of Distributions And Testing Goodness Of Fit

15. Model Sampling

16. Testing Of Hypothesis

17. Statistical Quality Control

18. Index Numbers

19. Time Series

20. Sequencing

21. Demography

22. Analysis Of Variance