There is no exact book on data analysis using Microsoft Excel to meet the requirement of B.Sc/B.A second year students has been made to write a manual (a book of procedures) for meeting the needs of students. The book is also made more suitable for class room teaching.
Contents :
1. Generation of Uniform Random Numbers between (0.1)
2. Generation of Uniform Random Numbers between (a, b)
3. Generation of Poisson Random Numbers
4. Generation of Standard Normal Random Numbers
5. Generation of Normal Random Numbers with specified Mean and S.D
6. Generation of Exponential Random Numbers
7. Generation of Uniform Random Numbers between (0.1) using Excel
8. Generation of Uniform Random Numbers between (a, b) using Excel
9. Generation of Poisson Random Numbers using Excel
10. Generation of Standard Normal Random Numbers using Excel
11. Generation of Normal Random Numbers with specified Mean and S.D. using Excel
12. Generation of Exponential Random Numbers using Excel
13. Fitting of Straight line using Excel
14. Fitting of Parabola using Excel
15. Computation correlation by Excel
16. Fitting of Regression line by Excel
17. Large Sample Test for single mean with raw data using Excel
18. Large Sample Test for single mean with without raw data using Excel
19. Large Sample Test for two means with raw data using Excel
20. Large Sample Test for two means without raw data using Excel
21. Small Sample Test for single mean with raw data using Excel
22. Small Sample Test for single mean without raw data using Excel
23. Small sample Test for two means with raw data using Excel
24. Small Simple Test for two means without raw data using Excel
25. Small Sample Test for Paired samples using Excel
26. Test for the significance of coefficient with raw data using Excel
27. Test for the significance of coefficient without raw data using Excel
28. Test for specified variance using Excel
29. Test for independence of attributes using Excel
30. Test for equality of two variances raw data using Excel
31. Test for equality to variances with raw data using Excel
