| Topics for practical |
1. Introduction to Probability:
Formulate and apply Bayes’ Theorem Calculations for problems like The “TwoSupplier Example”.
[Hint: Use Prior Probabilities and Conditional Probabilities to compute Joint and Posterior Probabilities.]
Design spreadsheet to demonstrate the association Between Two Variables by Computing the Covariance and Correlation Coefficient.
[Hint:Use COVAR and CORREL)] |
2. Discover Probability using formulas:
Design and spreadsheet experiment to compute the probability using the geometric distribution formula.
Create a spreadsheet application to compute the Conditional Probability. Also determine the probability that a randomly chosen event. |
3. Random Variables and Distribution Functions:
Create spreadsheet application to Compute the Expected Value, Variance, and Standard Deviation
Create a spreadsheet application to Compute Binomial Probabilities.
[Hint Use BINOMDIST] |
4. Probability Distribution and Law:
Create a spreadsheet application to Poisson Probability Distribution.
[Hint:Use POISSON]
Create a spreadsheet application to implement joint probability law. |
5. Mathematical Expectation and Chebychev’s Theorem:
Create a spreadsheet application to compute the expectation of a Function of a Random Variable
Create a spreadsheet application to apply Chebychev’s Theorem. |
6. Conditional Expectation and Generating Functions:
Create a spreadsheet application to compute Conditional Expectation and Conditional Variance
Create a spreadsheet application to demonstrate the use of Generating Functions |
7. Theoretical Discrete Distributions 1:
Create spreadsheet application to demonstrate Bernoulli Distribution.
Create spreadsheet application to use excel function for computing hypergeometric probabilities. |
8. Theoretical Discrete Distributions 2:
Create spreadsheet application to Calculate Binomial Distribution in Excel.
[Hint:Use BINOM.DIST]
Create suitable spreadsheet application to work with Power Series Distribution |
9. Theoretical Continuous Distributions 1:
Create spread application for computing probabilities and z values for the standard normal distribution.
[Use NORMSDIST and NORMSINV]
Create spread application for computing probabilities for the exponential probability distribution.
[Hint: Use EXPONDIST] |
10. Theoretical Continuous Distributions 2:
Create spread application for demonstrating Weibull Distribution to obtain a model for data sets.
[Hint: Use WEIBULL.DIST]
Create spread application for demonstrating Pearson\s Distributions. |