Excel ( Probability Distribution ) Due Midnight tonight

Homework3.xlsx

Question 1

Homework 3 Question 1
The U.S. Coast Guard provides a wide range of information on boating accidents including the wind conditions
at the time of the accident. The following table shows the results obtained from 4001 accidents.
Wind Conditions	Random Variable for wind condition (x)	Percentage of Accidents
None	0	9.6
Light	1	57
Moderate	2	23.8
Sstrong	3	7.7
Storm	4	1.9
a) Develop a probability distribution for x
b) Compute the expected value of x
c) Compute the variance and standard devation for x
d) Comment on what the results about the wind cconditions during boating accidents.

Quiz 3 Question 2
A bookstore at Hartsfield- Jackson Airport in Atlanta sells reading material (paper-back books,
newspapers, and magazines) as well as snacks (peanuts, pretzels, candy). A point of sale terminal
collects a variety of information about customer purchases. Shown below is a table showing the
number of snack items and the number of items of reading material purchased by the most recent
600 customers.
			Reading material (y)
Snacks		0	1	2
(x)	0	0	60	18
	1	240	90	30
	2	120	30	12
Using the data in the table construct an emperical dicrete bivariate probability distribution for
x = the number of snack items and y = number of reading materials in a randomly selected
customer purchase.
What is the probability of a customer purchase consisting of 1 item of reading
material and 2 snack items?
Why is the probability f(x=0,y=0) = 0?
Show the marginal probability distribution for the number of snack items purchased. Compute the expected value and variance.
Show the marginal probability distribution for the number of reading material items purchased. Compute
the expected value and variance
Show the probability distribution for t = total number of items in a customer purchase. Compute its expected value and variance
Compute the covariance and correlation coefficient between x and y.
What is the relationship, if any, between the number of reading materials and the number of snacks purchased on a customer visit?