Excel in Statistics: How to tackle day to day statistical work with Microsoft Excel

by Pradip Kumar Ghosh

This book is about using Microsoft Excel for day to day statistical work. Excel is very convenient for statistical work for a number of reasons. It neatly arranges data in columns and rows. The data can be inspected manually or through VBA programming. Excel has many functions for extracting data selectively and then we can have statistical functions work on them. Excel also has good indexing or sorting feature. It does not require command line programming and you need not learn complex syntax ( unless you want to use VBA).Excel is very powerful in making complex and visually appealing charts. It is visually comprehensible, interactive and dynamic. You can make, what if analysis and reverse calculation through Excel. Written in a lucid language, this book helps you to master statistical calculation through Microsoft Excel, from the beginner to advanced level. Topics covered included (a) Resource needed, (b) Checking the Microsoft Excel Environment, (c)Why is Excel suitable for Statistical Analysis?(d) Discrete and Continuous Series, (e) Pre-Processing of Data,(f) Basic Statistics, (g) The roundabout for Geometric Mean,(h) Verification of Statistical Calculations,(8) Quartile and Percentile,(i) Use of Data Analysis tools,(j) Correlation Co-efficient, (k) Charting with Vertical scales on both right and left side of the Chart ( Or use of Secondary Axis ),(l) Moving Average, (m)Working with data which have Normal Distribution,(n) Working with regression, (o)ANOVA ,(p) Skewness ,(q) Kurtosis and (r) stunning charts. Happy learning !

51 pages, Kindle Edition

Published September 15, 2017