代写ANIMAL SCIENCES 2260 Computer Lab # 2代写留学生Matlab程序

ANIMAL SCIENCES 2260

Computer Lab # 2

Use Excel to solve the following problems:

1. Assume that artificial insemination is used in 75% of the sows in the United States. If 10 sows are randomly selected:

a. What is the probability that all 10 sows have been artificially inseminated?

1) Select Formulas →Statistical→BINOM.DIST

2) In the Function Arguments card, type 10 in the Number_s box, 10 in the Trials box, 0.75 in the Probability_s box, and FALSE in the Cumulative box.

 

3) Click OK. You will see the desired probability in cell A1.

 

b. What is the probability that 4 out of the 10 sows have been artificially inseminated?

 1) Select Formulas →Statistical→BINOM.DIST as shown in part a.  In the Function Arguments card, type 4 in the Number_s box, 10 in the Trials box, 0.75 in the Probability_s box, and FALSE in the Cumulative box.

 

2) You will see the desired probability in cell A3.

 

c. What is the probability that 6 or more of the 10 sows have been artificially inseminated?

1) Select Formulas →Statistical→BINOM.DIST as shown in part a.  In the Function Arguments card, type 5 in the Number_s box, 10 in the Trials box, 0.75 in the Probability_s box, and TRUE in the Cumulative box.

 

2) Click OK. You will see a value in cell A5. However, this value is the probability that 5 or fewer of the 10 sows have been artificially inseminated.

 

3) In cell A7, type “=1-”, and select cell A5, you will get the value for 1-0.078127.

 

4) Press the Enter button and you will find the probability that 6 or more of the 10 sows have been artificially inseminated.

 

d. Draw a scatter plot that shows the binomial probability distribution for this problem.

(Determine each probability, put the probabilities in a table, and insert the scatterplot)

1) In column B, which is a blank column, type 0 and 1 in the first two cells.

 

2) Select the two cells, and move the cursor to the lower right corner of the box until a solid + sign appears. Press the left button of the mouse, and drag the box until the data list reaches 10. (Using this method, you can easily generate a continuous integer list in Excel.)

 

3) Select Formulas →Statistical→BINOM.DIST as shown in part a.  In the Function Arguments card, select cell B1 by clicking the  button next to the Number_s box and clicking cell B1.

4) Type 10 in the Trials box, 0.75 in the Probability_s box, and FALSE in the Cumulative box.

 

5) Click OK and you will get the probability that 0 out of the 10 sows have been artificially inseminated.

 

6) Move the cursor to the lower right corner of the box until a solid “+“ sign appears. Double left-click the ”+” sign and you will get the individual probability corresponding to each value in column B.

 

7) Click insert→Scatter→Scatter with only Markers.

 

8) Then you will get the scatter plot that shows the binomial probability distribution.

 

9) If the scatter plot is not shown as above, the default input data for the scatter plot may not be correct. In this case, you can right-click the figure and choose Select Data in the dropdown menu.

 

10) In the pop-up card, you can edit data input by selecting Series 1 and clicking the Edit button.

 

11) Then you can change the series name, X values, and Y in the Edit Series card by typing or clicking the  button.

 

12) Click OK and you will return to the Select Data Source card.

13) Click OK and you will get the modified scatter plot.

 

2.  A Thoroughbred mare has had 15 foals during her lifetime. Assume that the probability of a colt (i.e., a male) is 0.5 and the probability of a filly (i.e., a female) is 0.5.

a. What is the probability that 8 or more of the foals are fillies? 

(Formulas; Statistical; BINOMDIST with input of number=7, trials=15, probability=0.5, cumulative=TRUE, and subtract from 1)

1) Select Formulas →Statistical→BINOM.DIST as shown in part a. In the Function Arguments card, type 7 in the Number_s box, 15 in the Trials box, 0.5 in the Probability_s box, and TRUE in the Cumulative box.

 

2) Click OK and you will find the probability that 7 or fewer of the foals are fillies in cell A14.

 button, and you will obtain the probability that 8 or more of the foals are fillies.

 

Type in cell A15 type “=1-A14”, press Enter

b. What is the probability that none of the 15 foals are fillies? (Formulas; Statistical; BINOMDIST with input of number=0, trials=15, probability=0.5, cumulative=FALSE)

1) Select Formulas →Statistical→BINOM.DIST as shown in part a. In the Function Arguments card, type 0 in the Number_s box, 15 in the Trials box, 0.5 in the Probability_s box, and FALSE in Cumulative box.

 

2) Click OK and you will obtain the probability that none of the foals are fillies in cell A17.

 

You may save and submit your Excel spreadsheet.  Please clearly label your answers.  Include your name and recitation section in the title. This assignment is worth 30 points. Submit your work to the Dropbox on Carmen by 11:55 PM on the due date.