Home /
Expert Answers /
Statistics and Probability /
part-a-use-microsoft-excel-to-answer-all-the-questions-of-part-a-ouestion-1-2-marks-the-female-pa305

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 PARTB 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]

The total number of female students height n=37 Using excel to calculate to values 62 64 66 67 65 SAMPLE MEAN 65.8108 USE =AVERAGE(A1:A37) 68 61 SAMPL