Note: Attempt all questions as per the rubric. All problems carry equal weightage (approximately 7.14 marks each). The maximum you can score is 100. Use Excel function wherever possible. Unless otherwise noted, use a = 0.05. Chapter-7 Problems: TABLE 7.1 RANDOM NUMBERS 63271 59986 71744 51102 15141 80714 58683 93108 13554 79945 88547 09896 95436 79115 08303 01041 20030 63754 08459 28364 55957 57243 83865 09911 19761 66535 40102 26646 60147 15702 46276 87453 44790 57122 45573 84358 21625 16909 13385 22782 55363 07449 34835 15290 76616 67191 12777 21861 68689 03263 69393 92785 49902 58447 42048 30378 87618 26933 40640 16281 13186 29431 88190 04588 38733 81290 89541 70290 40113 08243 17726 28652 56836 78351 47327 18518 92222 55201 27340 10493 36520 64465 05550 30157 82242 29520 69753 72602 23756 54935 81628 36100 39254 56835 37636 02421 98063 89641 64953 99337 84649 48968 75215 75498 49539 74240 03465 49292 36401 45525 63291 11618 12613 75055 43915 26488 41116 64531 56827 30825 70502 53225 03655 05915 37140 57051 48393 91322 25653 06543 06426 24771 59935 49801 11082 66762 94477 02494 88215 27191 2071 1 35609 29430 70165 45406 78484 31639 52009 18873 96927 41990 70538 77191 25860 55204 73417 83920 69468 74972 38712 72432 36618 76298 26678 89334 33938 95567 29380 75906 91807 37042 40318 57099 10528 09925 89773 41335 96244 29002 46453 53766 52875 15987 46962 67342 77592 5765 95508 80033 69828 90585 58955 53122 16025 84299 53310 67380 84219 25348 04332 32001 96293 37203 64516 51530 37069 40261 61374 05815 06714 62606 64324 46354 72157 67248 20135 49804 09226 64419 29457 10078 28073 85389 50324 14500 15562 64165 06125 71353 77669 91561 46145 24177 15294 10061 98124 75732 00815 83452 97355 13091 98112 53959 79607 52244 63303 10413 63839 74762 :0289 Problem-1 Fortune publishes business-related data for the 500 largest U.S. industrial corporations. Assume that you want to select a simple random sample of 10 corporations from the Fortune 500 list. Use the last three digits in column 9 of Table 7.1, beginning with 554. Read the column and identify the numbers of the 10 corporations that would be selected. Problem-2 A simple random sample of 8 employees of a corporation provided the following information. Employee 2 3 4 5 6 7 8 25 32 26 40 50 54 22 23 Age Gender M M M F M M F M a) Determine the point estimate for the average age of all employees. b) What is the point estimate for the standard deviation of the population? c) Determine a point estimate for the proportion of all employees who are female