How would you do this r script?

Clerical staff work hours. In any production pro-cess in which one or more workers are engaged in a variety of tasks, the total time spent in production varies as a function of the size of the work pool and the level of output of the various activities. For example, in a large metropolitan department store, the number of hours worked (y)per day by the clerical staff may depend on the following variables: x1 = Number of pieces of mail processed (open, sort, etc.)x2 = Number of money orders and gift certificates sold x3 = Number of window payments (customer charge accounts) transacted x4 = Number of change order transactions processed x5 = Number of checks cashed x6 = Number of pieces of miscellaneous mail processed on an as available basis x7 = Number of bus tickets sold. The output counts for these activities on each of 52 working days were recorded, and the data saved in the CLERICAL file.

(a) Conduct a stepwise regression analysis of the data using an available statistical soft-ware package.

(b) Interpret the estimates in the resulting stepwise model.

(c) What are the dangers associated with drawing inferences from the stepwise model?

How would you do this r script?

CLERICAL OBS. 21 X2 13 IS 16 DAY OF WEEK M T 644 589 1081 891 Th 537 886 962 1342 1153 803 1127 627 748 876 685 436 M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 737 1029 830 1468 335 918 335 962 665 577 214 484 456 907 951 1446 440 1133 456 968 660 555 899 W Th F S M T W Th F S M T w Th F S M T W Th F S M T W Th F S M 203 1285 113.6 146.6 124.3 100.4 119.2 1095 128.5 131.2 1122 95.4 124.6 103.7 103.6 133.2 111.4 97.7 132.1 1359 131.3 150.4 124.9 97.0 114.1 88.3 117.6 128.2 138.8 109.5 118.9 122.2 142.8 133.9 100.2 116.8 97.3 98.0 136.5 111.7 98.6 116.2 108.9 120.6 131.8 112.4 92.5 120,0 112.2 113.0 138.7 122.1 86.6 7781 7004 7267 2129 4878 3999 11777 5764 7392 8100 4736 4337 3079 7273 4091 3390 6319 7447 7100 8035 S579 4338 6895 3629 5149 5241 2917 4390 4957 7099 7337 8301 4889 6308 6908 5345 6994 6781 3142 5738 4931 6501 5678 4619 1832 5445 4123 5884 5505 2882 2395 6847 100 110 61 102 45 144 123 78 172 126 115 110 96 51 116 70 58 83 80 115 83 78 18 133 92 110 69 70 24 130 128 115 86 81 145 116 59 78 106 27 174 69 94 100 124 52 84 89 45 94 89 14 570 826 1060 957 559 1050 568 709 568 900 442 644 389 612 1057 974 783 1419 1137 946 750 461 864 604 714 917 809 546 891 643 828 777 626 432 432 1061 562 601 637 810 235 388 398 457 577 345 326 161 219 287 235 127 180 118 206 284 220 174 124 174 223 115 118 155 124 222 378 195 358 374 238 191 214 132 164 127 107 171 335 126 129 129 107 164 158 121 153 100 84 139 201 230 563 402 495 823 555 456 573 428 463 961 745 539 553 428 498 683 556 479 SOS 405 477 970 1027 893 609 461 771 513 430 549 360 473 805 702 455 481 56 57 59 57 49 64 60 57 62 86 38 73 59 53 67 77 41 63 SS 78 79 84 41 57 59 55 80 81 51 62 51 74 69 49 57 48 53 74 70 52 71 47 52 67 71 42 42 31 36 44 30 40 781 236 616 1210 1452 616 957 968 719 489 341 902 126 726 1100 1721 502 737 473 1083 841 627 313 654 280 814 907 1666 614 Th 334 M T W Th F S M 384 834 571 458 544 44 45 46 47 48 49 50 51 52 391 444 799 747 547 Th Source: Adapted from Work Measurement, by G. L. Smith, Grid Publishing Co., Columbus, Ohio, 1978 (Table 3.1). CLERICAL OBS. 21 X2 13 IS 16 DAY OF WEEK M T 644 589 1081 891 Th 537 886 962 1342 1153 803 1127 627 748 876 685 436 M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 737 1029 830 1468 335 918 335 962 665 577 214 484 456 907 951 1446 440 1133 456 968 660 555 899 W Th F S M T W Th F S M T w Th F S M T W Th F S M T W Th F S M 203 1285 113.6 146.6 124.3 100.4 119.2 1095 128.5 131.2 1122 95.4 124.6 103.7 103.6 133.2 111.4 97.7 132.1 1359 131.3 150.4 124.9 97.0 114.1 88.3 117.6 128.2 138.8 109.5 118.9 122.2 142.8 133.9 100.2 116.8 97.3 98.0 136.5 111.7 98.6 116.2 108.9 120.6 131.8 112.4 92.5 120,0 112.2 113.0 138.7 122.1 86.6 7781 7004 7267 2129 4878 3999 11777 5764 7392 8100 4736 4337 3079 7273 4091 3390 6319 7447 7100 8035 S579 4338 6895 3629 5149 5241 2917 4390 4957 7099 7337 8301 4889 6308 6908 5345 6994 6781 3142 5738 4931 6501 5678 4619 1832 5445 4123 5884 5505 2882 2395 6847 100 110 61 102 45 144 123 78 172 126 115 110 96 51 116 70 58 83 80 115 83 78 18 133 92 110 69 70 24 130 128 115 86 81 145 116 59 78 106 27 174 69 94 100 124 52 84 89 45 94 89 14 570 826 1060 957 559 1050 568 709 568 900 442 644 389 612 1057 974 783 1419 1137 946 750 461 864 604 714 917 809 546 891 643 828 777 626 432 432 1061 562 601 637 810 235 388 398 457 577 345 326 161 219 287 235 127 180 118 206 284 220 174 124 174 223 115 118 155 124 222 378 195 358 374 238 191 214 132 164 127 107 171 335 126 129 129 107 164 158 121 153 100 84 139 201 230 563 402 495 823 555 456 573 428 463 961 745 539 553 428 498 683 556 479 SOS 405 477 970 1027 893 609 461 771 513 430 549 360 473 805 702 455 481 56 57 59 57 49 64 60 57 62 86 38 73 59 53 67 77 41 63 SS 78 79 84 41 57 59 55 80 81 51 62 51 74 69 49 57 48 53 74 70 52 71 47 52 67 71 42 42 31 36 44 30 40 781 236 616 1210 1452 616 957 968 719 489 341 902 126 726 1100 1721 502 737 473 1083 841 627 313 654 280 814 907 1666 614 Th 334 M T W Th F S M 384 834 571 458 544 44 45 46 47 48 49 50 51 52 391 444 799 747 547 Th Source: Adapted from Work Measurement, by G. L. Smith, Grid Publishing Co., Columbus, Ohio, 1978 (Table 3.1)