Name _________________

Problem 1

ANSI 5303 - Advanced Animal Breeding

 

1. The following is in an Excel file on the G drive (Prob1.xls). Complete the information in the boxes using the matrix functions in Excel and print it.

 

Y

 

mean

t1

t2

 

 

 

 

 

 

X'

 

 

 

 

 

87

 

1

1

0

 

 

 

 

 

 

 

 

 

 

 

 

84

 

1

1

0

 

 

 

 

 

 

 

 

 

 

 

 

89

 

1

1

0

 

 

 

 

 

 

 

 

 

 

 

 

86

 

1

1

0

 

 

 

 

 

 

 

 

 

 

 

 

83

 

1

0

1

 

 

 

X'X

 

 

 

X'Y

 

 

 

 

85

 

1

0

1

 

 

 

 

 

 

 

 

 

 

 

 

86

 

1

0

1

 

 

 

 

 

 

 

 

 

 

 

 

83

 

1

0

1

 

 

 

 

 

 

 

 

 

 

 

 

82

 

1

0

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

mean t1

 

 

 

 

X'X inverse (reduced)

solution = X'XinvX'Y

 

 

mean t2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

difference

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2. Yearling weight is a function of weaning weight and postweaning average daily gain (ww+160adg). Assume the standard deviations of ww and adg are 60 and .5, respectively and the correlation between the two variables is .50.  Calculate the standard deviation of yearling weight.