Descriptive and Inferential Statistics with Excel

This book covers many topics of practical Statistics:frequency tables, arithmetic mean, median, mode, quartile and decile, variance, standard deviation, variation coefficient, histograms, Chebishev Theorem, combinations, permutations and variations, probability distribution for discrete and continuous random variable, joint probability distribution, expectation value, variance and covariance, discrete distributions: uniform, binomial, multinomial, poisson, geometric, hypergeometric and the binomial negative distribution, continuous uniform distribution: uniform, exponential, gamma, chi-square, normal logarithmic, weibull, normal, central limit theorem, confidence intervals for a mean and for a proportion, selection of the right size of a sample, hypothesis testing of a sample and proportions, hypothesis testing for two samples and proportions,analysis of the variance, Anova test, inferences about pairs of means, Anova two way, the regression analysis, correlation coefficient, application problems etc. It is hoped that this book fills all needs of the students to get the fundaments of the Statistics and to achieve the interest and motivation of the students for this topic.