With the datafile DF1.7A (located in a folder under the CML Quizzes tab) use Excel Data Analysis to compute the descriptive statistics for BCom (column C). Calculate mean-standard deviation (correct to 1 decimal place) (ii) mean + standard deviation (correct to 1 decimal place) C) 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 BCom are within the range of one standard deviation to either side of the mean (nearest whole number)? J18 fx G on C 12 14 15 BC DE 1 BABSCBCOM BENG BLAW 34865 37609 50658 44915 59605 33536 47583 45743 39319 47397 37850 4562738288 40976 49352 39500 47831 40226 34684 44379 39020 47022 41093 37761 54681 32617 36915 51659 45548 49205 30112 34065 48677 34515 51350 36693 48464 49924 46415 49236 32634 48958 47397 41941 59618 38665 31901 49352 44468 53788 3196335389 44379 34992 40998 27014 49850 54681 34740 59618 39459 42449 42510 47186 51818 39699 37518 43856 40037 59986 41878 39660 49236 41766 46495 30233 44864 43382 40013 56537 35465 36850 53788 38225 46801 34373 41648 40998 39049 64350 33008 38375 39623 46775 53361 37038 50245 40708 48987 55426 37379 43441 59986 41075 54230 39125 43144 46495 44812 41527 37704 36134 56537 46340 44569 41011 41005 46801 34529 45185 31090 44469 35945 40850 44357 39160 40894 53361 34403 50700 38201 46800 55426 38623 40676 39746 35659 54230 30632 44828 33024 43118 41527 38617 39355 36981 39182 44569 39915 51646 39234 43390 45185 36741 43313 34606 45301 44357 36202 48178 34 38193 37705 38306 54321 37196 39430 40676 32594 46540 33504 41909 44828 45367 53745 27938 45630 39355 37987 44118 38 34720 50050 51646 33435 37090 38520 43676 43313 38136 45305 40785 49968 48178 41941 43226 37101 40320 54321 46331 45175 42 35494 3172737024 38422 50072 43 38914 48445 53745 30848 56202 31597 47356 44118 35850 55250 41968 38813 37090 37445 39949 36 44 #t Ax & fx J18 39500 39020 32617 30112 36693 32634 38665 31963 27014 39459 39699 41878 30233 35465 34373 33008 37038 37379 39125 37704 41011 31090 39160 38201 39746 33024 36981 39234 34606 38193 37196 33504 27938 34720 38520 40785 37101 35494 38914 31597 41968 36095 38809 31408 33056 37218 37168 C 4783140226 47022 41093 36915 51659 34065 48677 48464 49924 48958 47397 31901 49352 35389 44379 49850 54681 42449 42510 37518 43856 39660 49236 44864 43382 36850 53788 41648 40998 38375 39623 50245 40708 43441 59986 43144 46495 36134 56537 4100546801 44469 35945 40894 53361 46800 55426 35659 54230 43118 41527 39182 44569 43390 45185 45301 44357 44699 37705 39430 40676 41909 44828 45630 39355 5005051646 43676 -43313 49968 48178 40320 54321 31727 37024 48445 53745 47356 44118 38813 37090 30486 45305 46063 43226 39850 45175 39650 50072 29500 56202 29500 33617 D 34684 37761 45548 34515 46415 41941 44468 34992 34740 47186 40037 41766 40013 38225 39049 46775 48987 41075 44812 46340 34529 40850 34403 38623 30632 38617 39915 36741 36202 38306 32594 45367 37987 33435 38136 41941 46331 38422 30848 35850 37445 42154 35027 35136 38126 36756 46067 44379 54681 49205 51350 49236 59618 53788 40998 59618 51818 59986 46495 56537 46801 64350 53361 55426 54230 41527 44569 45185 44357 50700 40676 44828 39355 51646 43313 48178 54321 46540 53745 44118 37090 45305 43226 45175 50072 56202 55250 39949 48675 59297 56943 52477 40023 63050 48 49