AutoSave O Off) School100(2) - Excel Search (Alt+ Q) H File Home Insert Page Layout Formulas Data Review View Help & Cut Calibri * 11 - A A ab Wrap Text Genera Paste LG Copy Conditional Form LEE Merge & Center Format Painter Formatting Table Clipboard Font Alignment Number E1 X V A B C D E F G H K M N GPS_AVEF MAT_AVE READ_AVERAGE 108 108 108 W 103 101 101 113 110 110 104 103 103 106 106 106 100 100 100 103 104 105 107 106 106 99 98 99 107 107 106 102 101 100 96 97 96 105 104 105 105 105 103 107 102 104 109 108 105 108 108 109 106 103 103 109 108 109 101 101 102 108 106 107 105 102 102 108 109 108 110 108 110 102 103 101 27 110 108 109 28 106 103 106 29 102 99 98 30 106 103 102 31 109 106 107 32 103 102 103 33 103 102 100 34 105 102 101 35 109 107 106 36 109 105 104 37 112 108 106 106 103 103 SCHOOLGRPMATREADx +AutoSave O Off H Beer21(2) - File Home Insert Page Layout Formulas Data Review View Help & Cut Calibri * 11 AA = = 29 Wrap Text General LO [B Copy * Paste BIU~ A 3 Merge & Center $ ~ % " Format Painter Clipboard Font Alignment Number A1 X V fic D E F G H K L A aby ibu id name style brewery_i ounces 1032 0.049 2183 Kaua'i Gol American 204 12 W N - 1938 0.07 18 1972 LuckenBor Bock 257 16 1576 0.09 60 391 One Hit WAmerican 166 12 1972 0.082 2136 God Damr American 175 16 860 0.05 28 2427 Suncaster American 105 12 13 0.085 1980 Troll Desti Belgian IP 177 12 1259 0.072 1628 Festivus (: Winter Wi 356 12 323 0.06 1607 Bohemian Dortmund 364 12 1644 0.061 60 2312 Camelback American 157 12 11 186 0.046 1019 Longfin La Munich He 34 12 12 795 0.08 1664 Sobek & S American 256 16 13 846 0.052 20 1872 Local Buzz American 287 12 14 1871 0.059 47 778 Brownstol American 46 16 15 233 0.053 20 1317 Steel Rail American 278 12 16 774 0.063 55 2089 Trail Head American 224 12 17 2066 0.099 60 394 Johan the English Ba 25 16 18 1232 0.048 700 The Farm American 456 16 19 682 0.053 11 1263 El Hefe Sp Hefeweiz 227 12 20 923 0.054 143 Grand Can American 536 12 21 2344 0.058 55 1550 Charlie in American 351 12 22 63 0.055 26 431 Colorado | American 462 12 23 24 25 26 27 28 29 30 31 32 33 34 35 36STAT 151 Assignment 4 Total: ll? marks Finish the following questions using R and R commander. Make sure that you copy and paste the computer outputs into the space below each question and write down your answers in statements. Graphs should include titles and axis labels, as appropriate. 1. For the following variables of interest. i] Use it to create a normal probability plot and a histogram. Paste your work into your report ii] Describe your ndings. in particular. do the graphs provide evidence against the assumption of a normally distributed population? iii] Based on your descriptions [as well as the sample size n]. determine if one mean inference is valid, and whether z-procedures or t-proceclures should be employed. For each dataset, you may assume the data are obtained via random sampling and that the population standard deviation is unknown. a] The dataset "Scboollxisx" contains information regarding a sample of 100 schools from Great Britain. The variable of interest is GPSAVERAGE [average grammar scores on an aptitude test for students at that school]. [3 marks] b) The dataset"Beer21.xls:-t" contains information regarding a sample of 21 beers brands in the United States. The variable of interest is abv [alcohol by volume] for the beer brands. [3 marks} c] [n the above work, we did not examine the boxplots for the considered samples. What can a boxplot show us that cannot be seen in a normal probability plot or histogram? [2 marks]