"Test_1_dat.txt" is the data provided, need help with this hw

FDA_ID COUNTRY B BA CA K MG MN P RB ZN 2939 BEL 0.298 0.237 109.1 1802 102.3 0.453 2940 BEL 0.288 0.236 108.4 1797 102.3 0.455 2962 BEL 0.421 0.271 43.4 1634 85.1 0.160 2984 BEL 0.434 0.117 53.4 1504 84.5 0.265 4395 BEL 0.578 0.145 82.9 1486 94.5 0.330 4396 BEL 0.575 0.144 81.8 1464 93.8 0.327 4427 BEL 0.811 0.196 266.2 1761 113.0 0.360 4428 BEL 0.794 0.193 270.4 1731 113.2 0.353 159 LSP 0.181 0.092 31.2 1233 64.3 0.253 193 LSP 0.733 0.034 34.7 1640 69.4 0.132 228 LSP 0.514 0.026 28.9 1753 61.9 0.119 261 LSP 0.504 0.040 36.7 1759 73.2 0.133 339 LSP 0.744 0.040 43.3 1814 76.8 0.149 340 LSP 0.771 0.045 43.3 1793 77.2 0.151 367 LSP 0.453 0.059 42.0 1819 81.5 0.172 368 LSP 0.445 0.054 40.3 1779 81.1 0.168 476 LSP 0.127 0.077 39.0 1570 98.1 0.136 1017 LSP 0.431 0.084 44.0 1564 86.1 0.200 1018 LSP 0.433 0.084 44.4 1585 87.3 0.202 1045 LSP 0.609 0.065 39.7 1553 81.9 0.126 1046 LSP 0.604 0.068 38.6 1518 80.9 0.125 1128 LSP 0.410 0.073 48.1 1713 119.4 0.176 1129 LSP 0.404 0.073 45.3 1693 119.4 0.172 1162 LSP 0.564 0.048 34.5 1128 76.6 0.114 1163 LSP 0.554 0.051 33.4 1130 76.6 0.112 126 NSP 0.517 0.020 42.9 1593 84.0 0.131 2852 TME 1.013 0.050 102.6 1555 75.0 0.135 2859 TME 1.017 0.050 95.0 1559 74.3 0.130 2891 TME 1.491 0.032 111.5 1462 70.5 0.157 2898 TME 1.500 0.031 109.7 1456 70.5 0.156 4267 TME 0.795 0.089 389.5 1305 74.6 0.217 4268 TME 0.805 0.087 399.7 1327 76.2 0.217 2766 VME 0.440 0.709 64.7 1549 93.6 0.162 2767 VME 0.417 0.646 79.8 1420 84.7 0.148 2773 VME 0.402 0.633 77.0 1387 82.2 0.150 4300 VME 0.754 0.472 76.4 1507 91.6 0.542 4301 VME 0.758 0.471 75.5 1484 90.7 0.544 122.2 2.98 121.9 2.99 124.9 7.26 135.5 2.35 148.6 1.98 147.6 1.96 194.5 5.28 192.9 5.23 52.4 1.89 103.4 1.37 104.1 1.44 124.3 2.99 125.3 1.45 125.4 1.45 121.1 3.11 120.0 3.11 80.4 1.18 95.6 1.11 96.6 1.10 89.7 2.14 88.9 2.12 119.5 1.82 117.7 1.85 95.6 0.83 94.8 0.80 137.0 1.11 132.1 0.22 132.5 0.26 115.1 0.59 114.3 0.60 126.9 0.26 127.4 0.23 157.5 2.74 144.3 2.48 143.7 2.48 170.64.12 171.9 4.08 0.323 0.328 0.277 0.397 0.356 0.365 0.477 0.439 0.306 0.244 0.232 0.194 0.291 0.305 0.279 0.265 0.276 0.268 0.273 0.247 0.231 0.479 0.464 0.174 0.170 0.304 0.270 0.261 0.225 0.220 0.411 0.393 0.355 1.045 1.050 0.324 0.337 There are totally 11 variables in the dataset: they are FDA_ID, COUNTRY, B, BA, CA, K, MG, MN, P, RB, and ZN. Please pro- vide your R code for completing the following work and an- swer corresponding problems in what follows. (1) For the dataset Test_1_dat.txt", remove variable COUNTRY and write it out to an external EXCEL file with file name: "Test_1_b.xls. (5 points) (2) Read the file "Test 1.b.xls into R dataset: Test 1.c.(5 points) (3) How many subjects are there in the dataset you just created? and how many variables there? Use R to find the answer. (10 points) (4) Perform a PCA on the z scores of the dataset you just created with variable Country removed, and answer the following questions: How many principle components are required to describe ade- quately the space in which these data actually fall? (10 points) Perform some univariate analyses on the first two principle components. What do you find? (10 points) Create a three-dimensional blob plot using the first three prin- ciple component variables. (10 points) FDA_ID COUNTRY B BA CA K MG MN P RB ZN 2939 BEL 0.298 0.237 109.1 1802 102.3 0.453 2940 BEL 0.288 0.236 108.4 1797 102.3 0.455 2962 BEL 0.421 0.271 43.4 1634 85.1 0.160 2984 BEL 0.434 0.117 53.4 1504 84.5 0.265 4395 BEL 0.578 0.145 82.9 1486 94.5 0.330 4396 BEL 0.575 0.144 81.8 1464 93.8 0.327 4427 BEL 0.811 0.196 266.2 1761 113.0 0.360 4428 BEL 0.794 0.193 270.4 1731 113.2 0.353 159 LSP 0.181 0.092 31.2 1233 64.3 0.253 193 LSP 0.733 0.034 34.7 1640 69.4 0.132 228 LSP 0.514 0.026 28.9 1753 61.9 0.119 261 LSP 0.504 0.040 36.7 1759 73.2 0.133 339 LSP 0.744 0.040 43.3 1814 76.8 0.149 340 LSP 0.771 0.045 43.3 1793 77.2 0.151 367 LSP 0.453 0.059 42.0 1819 81.5 0.172 368 LSP 0.445 0.054 40.3 1779 81.1 0.168 476 LSP 0.127 0.077 39.0 1570 98.1 0.136 1017 LSP 0.431 0.084 44.0 1564 86.1 0.200 1018 LSP 0.433 0.084 44.4 1585 87.3 0.202 1045 LSP 0.609 0.065 39.7 1553 81.9 0.126 1046 LSP 0.604 0.068 38.6 1518 80.9 0.125 1128 LSP 0.410 0.073 48.1 1713 119.4 0.176 1129 LSP 0.404 0.073 45.3 1693 119.4 0.172 1162 LSP 0.564 0.048 34.5 1128 76.6 0.114 1163 LSP 0.554 0.051 33.4 1130 76.6 0.112 126 NSP 0.517 0.020 42.9 1593 84.0 0.131 2852 TME 1.013 0.050 102.6 1555 75.0 0.135 2859 TME 1.017 0.050 95.0 1559 74.3 0.130 2891 TME 1.491 0.032 111.5 1462 70.5 0.157 2898 TME 1.500 0.031 109.7 1456 70.5 0.156 4267 TME 0.795 0.089 389.5 1305 74.6 0.217 4268 TME 0.805 0.087 399.7 1327 76.2 0.217 2766 VME 0.440 0.709 64.7 1549 93.6 0.162 2767 VME 0.417 0.646 79.8 1420 84.7 0.148 2773 VME 0.402 0.633 77.0 1387 82.2 0.150 4300 VME 0.754 0.472 76.4 1507 91.6 0.542 4301 VME 0.758 0.471 75.5 1484 90.7 0.544 122.2 2.98 121.9 2.99 124.9 7.26 135.5 2.35 148.6 1.98 147.6 1.96 194.5 5.28 192.9 5.23 52.4 1.89 103.4 1.37 104.1 1.44 124.3 2.99 125.3 1.45 125.4 1.45 121.1 3.11 120.0 3.11 80.4 1.18 95.6 1.11 96.6 1.10 89.7 2.14 88.9 2.12 119.5 1.82 117.7 1.85 95.6 0.83 94.8 0.80 137.0 1.11 132.1 0.22 132.5 0.26 115.1 0.59 114.3 0.60 126.9 0.26 127.4 0.23 157.5 2.74 144.3 2.48 143.7 2.48 170.64.12 171.9 4.08 0.323 0.328 0.277 0.397 0.356 0.365 0.477 0.439 0.306 0.244 0.232 0.194 0.291 0.305 0.279 0.265 0.276 0.268 0.273 0.247 0.231 0.479 0.464 0.174 0.170 0.304 0.270 0.261 0.225 0.220 0.411 0.393 0.355 1.045 1.050 0.324 0.337 There are totally 11 variables in the dataset: they are FDA_ID, COUNTRY, B, BA, CA, K, MG, MN, P, RB, and ZN. Please pro- vide your R code for completing the following work and an- swer corresponding problems in what follows. (1) For the dataset Test_1_dat.txt", remove variable COUNTRY and write it out to an external EXCEL file with file name: "Test_1_b.xls. (5 points) (2) Read the file "Test 1.b.xls into R dataset: Test 1.c.(5 points) (3) How many subjects are there in the dataset you just created? and how many variables there? Use R to find the answer. (10 points) (4) Perform a PCA on the z scores of the dataset you just created with variable Country removed, and answer the following questions: How many principle components are required to describe ade- quately the space in which these data actually fall? (10 points) Perform some univariate analyses on the first two principle components. What do you find? (10 points) Create a three-dimensional blob plot using the first three prin- ciple component variables. (10 points)