Site pages

Current course

Participants

General

28 July - 3 August

4 August - 10 August

11 August - 17 August

18 August - 24 August

25 August - 31 August

1 September - 7 September

8 September - 14 September

15 September - 21 September

22 September - 28 September

29 September - 5 October

6 October - 12 October

13 October - 19 October

20 October - 26 October

27 October - 2 November

3 November - 9 November

10 November - 16 November

17 November - 23 November

Solve the following problem using Excel:

1. A new drug for treating some disease has been proven to be effective 70% of the time. The drug is administrated to a sample of 9 patients suffering with the disease. Let the random variable X denote the number of patients cured. Simulate this sampling process 20 times, tabulate the simulated results, obtain the theoretical binomial distribution (n=9, p=0.7), and compare the simulated results.

2. Final exam grades on a particular standardized exam are normally distributed with a mean grade of 60 and a standard deviation of 10. Simulate the grades obtained on this examination by a random sample of 50 students and obtain a histogram of results.

3. A certain brand of light bulb lasts, on the average, 10,000 hour, with a standard deviation of 500 hours. The bulb lifetimes are normally distributed. Simulate the lifetime of 50 such bulbs and obtain a histogram of the results.

Link: Introduction to Probability Distribution

1. A new drug for treating some disease has been proven to be effective 70% of the time. The drug is administrated to a sample of 9 patients suffering with the disease. Let the random variable X denote the number of patients cured. Simulate this sampling process 20 times, tabulate the simulated results, obtain the theoretical binomial distribution (n=9, p=0.7), and compare the simulated results.

2. Final exam grades on a particular standardized exam are normally distributed with a mean grade of 60 and a standard deviation of 10. Simulate the grades obtained on this examination by a random sample of 50 students and obtain a histogram of results.

3. A certain brand of light bulb lasts, on the average, 10,000 hour, with a standard deviation of 500 hours. The bulb lifetimes are normally distributed. Simulate the lifetime of 50 such bulbs and obtain a histogram of the results.

Link: Introduction to Probability Distribution

Last modified: Wednesday, 10 July 2013, 3:09 PM