Modern methods of statistical analysis of experimental data have been `discussed in detail in this review using Microsoft Excel 2002 and Minitab 2002 software. Start is made from population and sample mean, median, mode, quantiles, variance, standard deviation and coefficient of variation. Normal distribution of data is then discussed with standard normal curve, Z-score and its application with probability. Distribution of means is also discussed with Zscore. A brief introduction to statistical hypothesis testing (Null hypothesis and Alternate hypothesis) is then introduced. One-sample hypothesis is then discussed slightly in detail with a student Nest and confidence limits. Estimation of population mean is described and related hypotheses are also discussed. Two-sample hypothesis is described with a test difference between the two means and t-testing. Violation of two-sample t-test is also discussed with confidence limits for the two-sample hypotheses. Test for differences between two variances are also discussed with F-test and pooled variances. In the end Paired-sample hypothesis is discussed with mean differences. The confidence limit and t-test for, paired-sample hypothesis are also introduced.