# (Solved):   Part A Use Microsoft Excel to answer all the questions of Part A. Ouestion[1] [2 marks] Th ...

Part A Use Microsoft Excel to answer all the questions of Part A. Ouestion[1] [2 marks] The female students in an undergraduate engineering core course at ASU self-reported their heights to the nearest inch. The data are below. Calculate the sample mean, sample variance, sample standard deviation, sample range and the sample median of height. $\begin{array}{l} 62646667656861656765646367686466686965676266686766656965706567 \\ 686563646767 \end{array}$ Question[2] [3 marks] Construct a frequency distribution and histogram for the data given in Question (1). Question[3] The grams of solids removed from a material $$(\mathrm{y})$$ is thought to be related to the drying time. Ten observations obtained from an experimental study follow: [3 marks] a) Construct a scatter diagram for the data. (b) Fit a simple linear regression model PART B 1. Suppose that $$\widehat{\Theta_{1}}$$ and $$\widehat{\theta_{2}}$$ are unbiased estimators of the parameter. If $$V\left(\widehat{\theta_{1}}\right)=10$$ and $$V\left(\widehat{\theta_{2}}\right)=$$ 4. Which estimator is best and in what sense is it best? Calculate the relative efficiency of the two estimators. [2 marks]

We have an Answer from Expert