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)

1. *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.
2. *Given the following contingency table where “yes” means liking a product and 300 people were selected at random to make the judgments:

1. What is the probability someone who judged ProductB liked Product B?
2. What was the most preferred product by the individuals who judged it?
3. If a person was selected at random out of the 300, what is the probability they judged and liked product A?
4. If a person liked a product, what is the probability it was product B?
5. 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?

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

1. *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
   1. How many student-course sets can you have?
   2. If you pick 3 of these sets, how many different combinations can you have?
   3. If order matters for the sequence with which the 3 sets are selected, how many permutations are there?
   4. If you select a student, what is the probabilitythe next pick (without replacement) will be the same student? Draw a decision tree.

1. * 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

1. *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:
   1. What is the probability you will get 0 defects?
   2. What is the probability you will get 3 or less defects?
   3. What is the probability that at least 9 of the products will be good?

1. *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:
   1. What is the mean and variance of the Poisson Distribution
   2. What is the probability of no accidents?
   3. Of 1 accident?
   4. Of 2 accidents?

Need a Professional Writer to Work on this Paper and Give you Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN