Question

NOTE: the simple method of calculating quartiles by hand (taught in class) MUST be used for this quiz. You may use Kaddstat to check your answer. However, if the answer from your hand calculation and Kaddstat are not the same, you MUST enter your hand calculation answer. DO NOT use any complex algorithms built into calculators, or the Excel function 'quartile' Some questions list data. Type the data into Excel and use the Data Analysis or Kaddstat Boxplot for working. PLEASE MAKE SURE TO RE-CHECK ALL YOUR ANSWERS BEFORE SUBMITTING YOUR QUIZ. Ensure that all your answers are entered with the correct amount of decimal places, including the correct amount of zeros. Some web browsers may drop the zeros at the end of an answer if you save, exit and then return to the quiz (eg your browser may change your entered answer of 21.30 [to two decimal places] to 21.3 if you exit and re-enter the quiz). You must have the correct decimal places and correct number of zeros in your answer to be marked correct. Therefore, PLEASE double check all your answers directly before submitting them. These rules and tips, as well as other important rules and tips (eg NOT to use symbols such as % and $ in your answers), are listed in detail in the CML Information Sheet. Please ensure you read, understand and follow ALL these rules when completing your quiz and when you submit your quiz. This will save you losing precious marks for errors that can be easily avoided! QUESTION 8 With the datafile DF1.7A (located in a folder under the CML Quizzes tab) use Excel Data Analysis to compute the descriptive statistics for BEng (column D). Calculate ) mean standard deviation (correct to 1 decimal place) (i) mean + standard deviation (correct to 1 decimal place) (ii) Using the empirical rule how many data points are expected to be within one standard deviation to either side of the mean (nearest whole number)? (iv) In the data file, count how many actual sample data points for BEng are within the range of one standard deviation to either side of the mean (nearest whole number)? BSC BCOMBENG BLAW 34865 33536 37850 3950047831 39020 2 37609 47583 45627 50658 45743 38288 40226 39319 40976 34684 37761 59605 47397 49352 44379 54681 4 47022 32617 36915 51659 4554849205 48677 49924 47397 49352 44379 54681 42510 43856 49236 43382 53788 40998 39623 40708 59986 39125 43144 46495 4481241527 56537 34065 48464 48958 36693 32634 38665 31901 31963 2701449850 39459 39699 49236 59618 53788 40998 34740 59618 44468 34992 35389 42449 37518 39660 44864 36850 40037 41766 30233 35465 34373 33008 37038 37379 59986 46495 56537 46801 64350 53361 55426 54230 38225 39049 46775 48987 38375 50245 44569 34529 45185 44357 50700 37704 46340 4100546801 44469 40894 31090 35945 53361 40850 34403 55426 54230 33024 43118 41527 38617 39355 44569 38201 39746 46800 35659 38623 30632 40676 44828 29 30 36981 39234 4339045185 36741 34606 39182 45301 39430 39915 36202 32594 51646 43313 48178 32 44357 38193 446993770538306 54321 40676 33504419094482845367 53745 39355 51646 43313 46540 35 36 37196 27938 34720 38520 4078549968 4817841941 37101 45630 50050 43676 37987 33435 38136 44118 37090 45305 43226 45175 38 39 54321 35494 317273702438422 50072 53745 31597 47356441183585055250 37090 3609530486 45305 42154 48675 43226 314083985045175 35136 56943 50072 56202 33617 40320 48445 38813 46063 46331 30848 37445 35027 42 38914 41968 38809 56202 39949 59297 46 47 48 49 50 33056 37218 37168 39650 29500 29500 38126 36756 46067 52477 40023 63050

Answer 1

BENG 44915 39319 37761 45548 34515 6415 11941 34992 34740 47186 40037 41766 40013 38225 39049 46775 48987 41075 44812 46340 34529 40850 34403 38623 30632 38617 Mean sda 39499.58 4625.311 A-3/sqrtln) i) Mean-sd 34874.3 LCL-mean-A"sd 34872.95 ii) Mean+sd 44124.9 UCL-mean A sd 34875.64 ให้ Sheet1 , Sheet2 .. Sheet3