|
|||||
|
|
|
|
|
|
To complete this assignment successfully, you should:
§ Discrete Probability §
Assignments
Send to your instructor a single Excel file (including written answers)
as e-mail an attachment through WebMail. addressed
to BA501@mail.cba.nau.edu and put "BA501
(last name) Assignment name and number" somewhere
in the e-mail "subject." If you have any questions on this home work,
please e-mail me with questions.
Put the different exercise outputs on separate sheets in the Excel file.
Here is the Excel
worksheet for this assignment. Use "save as"
to save it to your computer or to a floppy.
Exercise 1
Use the information in the following table to calculate the probability of selecting a data value from the 3rd class. Use Excel to help get the answers.
|
Class |
CW |
f = m |
|
1 |
10 - 20 |
9 |
|
2 |
20 - 30 |
6 |
|
3 |
40 - 50 |
8 |
|
4 |
50 - 60 |
7 |
P(40 - 50) = ?
(click me)
Exercise 2
Find the mean and variance of the following random variable X with probability mass function P[x]. Use Excel to help get the answers. Can a value of x be negative as shown in the table?
| xi | P[xi] | |
| -2 | 0.1 | |
| 0 | 0.1 | |
| 4 | 0.2 | |
| 6 | 0.3 | |
| 9 | 0.3 |
(click
me)
Exercise 3
The shipping department of the XYZ Company sends an average of four loads of goods daily to wrong addresses. Assume a Poisson distribution.
(a) What is the probability that exactly two loads of goods are shipped daily to wrong addresses? Use the Poisson table and confirm the result in Excel with Paste Function-Statistical-Poisson.
(b) What is the standard deviation of the number of loads of goods are shipped daily to wrong addresses?
(click me)