In Microsoft Excel open a sheet. In any column, in raw one type this command (-10+100 RAND()), then press enter. Drag the lower right corner of this cell, to cell number 100 in the same column. This will generate 100 random values between 10 and 110. Format the number so that all of them have 2 decimal places only. Then, 1) Calculate all descriptive statistics you learned. 2) Draw all representative charts and figures you learned. 3) Does the data follow a normal distribution? Fully explain why, and in more than one method. 4) Assume the data represents lengths of Molokheyya rods in CM, and those rods spreading more than 70 CM will sell better. a. Describe the performance of these 100 rods in sales. b. Dissect the rod into lengths groups, with each group is between 10s, then assume that any rod less than 20 cm will not cell while prices of each rod above that equals to length X 0.0011 JD. Describe the sales of the farmer who got these 100 rods out of one squared meter in his farm, knowing that he planted 7 Donoms. c. In part b, which group has the highest sales? Which has the lowest? Make a table of sales of all groups 5) Base on part 4: a. What is the probability of getting one rod between 30 and 40 cm 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 rod between 30 and 40 cm given that it is less than 60 cm? 6) Draw the cumulative distribution function of the data 7) What is the mean and variance of the random variable X shown in part 6? 8) Anything else you do is a welcomed extra Please deliver this report as a project report, not as a homework. Deadline: Class time 6th of January, 2021 (subject to change)