Introduction to Statistical Functions of Excel: Concept of Population and Sample, Qualitative and Quantitative Variables, Raw Data, Basic Spreadsheet Concept, Data Entry and its Summary Statistics Using Excel Functions, Preparation of Grouped and Ungrouped Frequency Distribution Using Excel, Creating Bar Charts and Pie Chart, Frequency Curves and Ogive Curves.
(There will be no theory question on above chapter separate practical exam of 20 marks of one hour should be conducted on it.)
Methods of Counting
Fundamental Principals of Counting: Permutations and Combination of n Dissimilar Objects taken r at a time, Example and Problems.
Elements of Probability Theory: Random Experiments, All Possible Outcomes (Sample Space), Events, Algebra of Events. Classical Definition of Probability, Addition Theorem of Probability (without Proof), Independence of Events, Simple Numerical Problems.
Standard Discrete Distributions: Discrete Uniform – Probability Distribution, Cumulative Probability Distribution, Mean, Variance (without Proof).
Bernoulli – Probability Function, Mean and Variance.
Binomial – Probability Distribution, Cumulative Probability Distribution, Mean, Variance (without Proof).
Examples and problems.
Simulation Techniques: Random Number Generator.
Model Sampling from Discrete Uniform and Binomial Distributions.