statistic homework

MGT 202 - 601, Assignment 2, Dr. Gerald McLaughlin , Due 1:30 PM May 22, 2014

Create an Excel Workbook titled FirstName_LastName_2 . Each question and graph should be a separate spreadsheet. There should be 8 spreadsheets in the workbook, one spreadsheet for each ‘*’ marked below . When complete place it in the Assignment 2 Dropbox in D2L before the start of class on May 22. You will get an e-mail from the system after successful submission of an assignment. If you can’t get it to go e-mail it to me ([email protected] ).

1. *Do a scatter plot of the following data set. Does a relationship exist between the two variables? (Do in Excel)

Smith	Jones
25	33
26	39
27	32
27	40
28	35
28	35
29	42
30	33
30	42
31	45
32	36
32	37
32	37
32	40
32	42
33	38
33	41
35	43
35	48
35	36
36	43
36	44
37	45
39	47

2. *What is the mean, median, and quartiles for the two individuals (do in Excel) . Does a difference in central tendency seem to exist? Create a Frequency Polygon with the two distributions on the same chart.

3. *Given the following contingency table where “yes” means liking a product and 300 people were selected at random to make the judgments:

	Product A	Product B	Product C	Product D
Yes	33	45	15	57
No	50	25	55	20

a. What is the probability someone who judged Product B liked Product B?

b. What was the most preferred product by the individuals who judged it?

c. If a person was selected at random out of the 300, what is the probability they judged and liked product A?

d. If a person liked a product, what is the probability it was product B?

e. If two people were selected at random without replacement, what is the probability that the first one judged and liked A and the second one judged and liked B?

4. *Give the rule for combinations and the rule for permutations and explain the difference.

5. *If you have 5 students and 2 courses and each student can take each course and you are going to look at student-course sets

a. How many student-course sets can you have?

b. If you pick 3 of these sets, how many different combinations can you have?

c. If order matters for the sequence with which the 3 sets are selected, how many permutations are there?

d. If you select a student, what is the probability the next pick (without replacement) will be the same student? Draw a decision tree.

6. * Given the following data – What is the expected value (Mean) and what is the variance?

Score Probability

60 .4

70 .3

80 .2

90 .1

7. *When is a Binomial Distribution used to calculate the probability of an event? (What are the requirements?) If the probability of getting a good product is .3 and you select a set of 15 products:

a. What is the probability you will get 0 defects?

b. What is the probability you will get 3 or less defects?

c. What is the probability that at least 9 of the products will be good?

8. *When is a Poisson Distribution used to calculate the probability of an event? (What are the requirements?) If the average number of accidents is 3 for every 1000 hours worked. If 40 hours are worked:

a. What is the mean and variance of the Poisson Distribution

b. What is the probability of no accidents?

c. Of 1 accident?

d. Of 2 accidents?