Open Sheet in Microsoft Excel type the following function (=10+40*RAND()), produce 100 random values ranging from 10 to 50 and format the number so that it has only 1 decimal place for all of them then,

Assume that the date is the weight of a randomly chosen sample of cows raised on American farm.

Part 1:

a. If the survey is representative, approximately 35000 cows are owned by the farmer. Describe the weight of his cows with numbers (how is it distributed?).

b. Dissect the weights of the cows into weight groups, each group being between 5s, then conclude that any cow weighing less than 15 kilos is not sold and preserved until next year, while each cow's prices above that are equal to Dollars. (Weight X 1.25) Describe the farmer's transactions.

c. In part b, which group has the highest sales? What one got the lowest? Create a sales table for both groups. ( please calculate the sales price for each group )

Part 2:

a. What is the probability of getting one goat with weight between 30 and 35 Kilograms at random? b. What is the group that will have the highest likelihood of being selected at random? c. What is the expected value of the price for each group? d. What is the probability of selecting a goat with weight between 30 and 35 kilograms given that it is less than 45 Kilograms?