Question: In excel please determine how many principal components you may need to keep for further analysis. Construct and plot those principal component projections. X1 X2
In excel please determine how many principal components you may need to keep for further analysis. Construct and plot those principal component projections.
| X1 | X2 | X3 | X4 | X5 | X6 | X7 | X8 |
| 6.273 | 2.551 | 6.578 | 9.460 | 5.650 | 0.571 | 3.765 | 5.106 |
| -1.798 | -0.917 | 3.432 | 4.003 | -2.097 | -3.035 | -1.700 | -5.640 |
| 6.033 | 6.142 | 6.005 | 11.877 | 3.634 | 4.773 | 5.894 | 6.017 |
| -2.095 | -2.850 | 3.145 | 3.364 | -1.574 | -5.132 | -4.534 | -6.295 |
| 0.733 | -2.896 | 2.995 | 4.372 | 1.530 | -4.697 | -2.684 | -2.478 |
| 1.001 | 2.112 | 5.046 | 7.147 | 0.037 | 0.406 | 1.258 | -1.079 |
| 7.333 | 6.076 | 6.211 | 12.295 | 5.326 | 3.457 | 5.737 | 7.186 |
| 4.338 | 0.345 | 4.626 | 7.419 | 4.354 | -1.919 | 0.088 | 2.342 |
| 7.319 | -0.173 | 4.451 | 8.028 | 7.615 | -0.727 | 0.252 | 5.933 |
| 1.944 | 1.359 | 4.181 | 6.374 | 1.147 | -0.545 | -0.186 | -0.723 |
| -8.824 | -5.158 | 1.354 | -1.576 | -7.978 | -6.406 | -9.118 | -14.908 |
| -0.319 | 1.123 | 4.777 | 5.801 | -1.323 | 0.115 | 0.597 | -3.242 |
| 10.077 | 5.792 | 7.737 | 13.426 | 7.935 | 4.248 | 6.739 | 9.572 |
| -0.851 | 1.595 | 3.339 | 7.152 | -2.037 | -0.330 | -0.268 | -3.827 |
| 3.049 | -2.606 | 3.873 | 4.006 | 3.746 | -3.860 | -4.005 | 0.808 |
| 2.415 | 0.551 | 4.583 | 6.942 | 1.944 | -2.377 | 0.507 | 0.113 |
| 8.141 | 2.571 | 6.127 | 9.596 | 7.348 | 1.385 | 2.863 | 7.363 |
| -1.223 | 5.534 | 4.961 | 9.295 | -4.168 | 1.990 | 2.757 | -3.425 |
| 4.046 | 4.667 | 5.807 | 10.988 | 2.351 | 1.653 | 4.124 | 2.725 |
| -1.943 | 0.679 | 3.475 | 5.513 | -2.965 | -1.682 | -1.061 | -5.428 |
| 17.247 | 8.842 | 9.098 | 18.022 | 14.941 | 6.776 | 11.793 | 19.881 |
| 4.219 | -0.352 | 4.434 | 6.956 | 4.271 | -3.463 | -1.562 | 1.882 |
| 7.809 | 2.394 | 5.688 | 9.181 | 6.882 | 0.884 | 1.006 | 6.945 |
| 1.594 | 5.011 | 5.821 | 10.543 | -0.587 | 3.126 | 2.587 | -0.323 |
| 4.132 | 6.043 | 5.429 | 11.192 | 1.598 | 3.263 | 4.748 | 2.899 |
| 3.387 | 4.013 | 5.278 | 10.137 | 1.801 | 1.075 | 1.904 | 1.646 |
| 8.381 | 4.548 | 5.998 | 12.116 | 6.939 | 1.891 | 4.370 | 7.766 |
| 0.717 | 0.021 | 4.458 | 6.360 | 0.528 | -2.628 | -1.515 | -2.595 |
| 7.283 | 4.953 | 5.902 | 11.857 | 5.403 | 2.847 | 5.134 | 6.724 |
| -6.878 | -2.478 | 1.271 | 1.796 | -7.379 | -4.575 | -5.939 | -12.181 |
| 2.740 | 3.320 | 4.575 | 8.799 | 1.056 | 0.955 | 1.826 | 0.979 |
| 0.262 | 2.189 | 4.731 | 6.460 | -1.140 | -0.038 | 0.307 | -2.124 |
| -1.032 | 3.881 | 5.630 | 8.009 | -3.412 | 1.382 | 1.576 | -3.258 |
| 4.171 | 1.244 | 4.794 | 8.083 | 3.834 | -0.645 | 0.130 | 2.533 |
| 5.402 | 4.071 | 6.331 | 10.244 | 3.952 | 3.286 | 3.074 | 4.843 |
| 4.723 | 4.394 | 6.633 | 10.508 | 3.092 | 3.022 | 2.766 | 3.296 |
| -4.114 | -2.173 | 3.376 | 3.174 | -4.596 | -4.318 | -5.386 | -8.617 |
| 7.841 | 3.567 | 7.091 | 11.510 | 6.319 | 1.699 | 4.071 | 7.451 |
| 7.606 | 7.019 | 6.647 | 13.454 | 5.309 | 5.029 | 6.432 | 7.970 |
| 2.039 | 2.032 | 5.333 | 7.323 | 0.932 | -0.264 | 1.130 | -0.292 |
| 2.463 | 1.112 | 4.592 | 6.765 | 1.888 | -1.125 | 0.252 | -0.015 |
| 2.878 | 3.060 | 4.452 | 9.788 | 1.340 | 1.895 | 3.074 | 0.907 |
| -4.560 | -0.412 | 2.797 | 2.750 | -5.619 | -2.962 | -3.768 | -9.013 |
| 2.728 | 3.181 | 5.335 | 8.862 | 1.289 | 1.178 | 1.592 | 0.977 |
| -0.563 | 0.906 | 4.951 | 5.771 | -1.513 | -0.800 | -0.039 | -3.364 |
| -0.950 | 1.025 | 4.451 | 5.942 | -1.399 | -1.765 | -0.272 | -3.256 |
| -0.711 | 2.304 | 4.431 | 6.181 | -2.396 | -0.840 | -1.587 | -3.509 |
| 3.590 | 5.488 | 6.321 | 10.287 | 1.151 | 4.098 | 4.669 | 2.371 |
| -4.106 | 1.366 | 3.192 | 6.142 | -5.752 | -0.374 | -0.543 | -7.546 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
