Answer complete question (all four parts), if you are going to solve it incomplete then there is no need to solve please. Once you attach the answers make sure you attach complete data including excel calculations. And get 100% feedback with thumbs up. All the excel required data is provided.

1 user_type Gender hand_leng hand_wid height 2 student female 7.25 8.75 67 3 student female 7.25 9 69 4 student female 5.75 6 62 5 student female 6.25 8 64 6 student female 7.5 8.5 68.5 7 student female 6.875 7.25 66.5 8 student female 7.75 7.375 64 9 student female 6.5 7.5 65 10 student female 7 7 64 11 student female 7 8 65.75 12 student female 6 6.5 60 13 student female 6.5 7.9 64.5 14 student female 6.5 6.8 65 15 student female 6.4 7.25 62.6 16 student female 6.7 8 67 17 student female 7 7.5 64.5 18 student female 7 7.5 62 19 student female 6.75 7.25 64.5 20 student female 6.75 7.75 64 21 student female 7.5 8.5 72 22 student female 6.5 8.25 67 23 student female 7.5 6.9 70 24 student female 7.25 7.5 68 25 student female 7 7.2 63 7.25 68 63 7 7.5 7.2 9 7.9 68 8.25 7.1 64 67 7 8.5 7.5 7.6 65 62 8.5 7 6.5 6.8 7.875 8.2 7.5 6.75 U 00 8.5 65 71 76 69.5 70 74 8.75 7.875 un 00 7.75 7.5 9 72 24 student female 25 student female 26 student female 27 student female 28 student female 29 student female 30 student female 31 student female 32 student male 33 student male 34 student male 35 student male 36 student male 37 student male 38 student male 39 student male 40 student male 41 student male 42 student male 43 student male 44 student male 45 student male 46 student male 47 student male 48 student male 49 student male 50 student male 51 student male 8.3 9.7 8 7.75 8.5 8.75 75 67 72.5 69 7.5 9 69 76 un ini 00 00 0 8.5 68.5 00 00 00 8.5 72 72 70 8.5 7.75 8 9.5 7.5 7.75 8.75 73 69 70 7.5 7.5 9.4 75 7. The case found in (6) is not possible, since Hand Width cannot be smaller than Hand Length. Therefore, there must be some measuring error in this case. Are there any other cases you notice Hand Width is less than Hand Length? If so, we need to delete these cases as well. After cleaning up the 'data errors', re-analyze the data, and answer the following questions. (a) Regression Line: (b) An individual has hand width 8.5, use the model in to predict his height: (c) Suppose an individual has height 72 and hand width 9.0. Use the model to predict his height: and obtain the corresponding residual: (d) Report the following information from the Analysis of Variance Table in the output: Source Degrees of Freedom SS MS (Sum of Square) (Mean of Square) 1 user_type Gender hand_leng hand_wid height 2 student female 7.25 8.75 67 3 student female 7.25 9 69 4 student female 5.75 6 62 5 student female 6.25 8 64 6 student female 7.5 8.5 68.5 7 student female 6.875 7.25 66.5 8 student female 7.75 7.375 64 9 student female 6.5 7.5 65 10 student female 7 7 64 11 student female 7 8 65.75 12 student female 6 6.5 60 13 student female 6.5 7.9 64.5 14 student female 6.5 6.8 65 15 student female 6.4 7.25 62.6 16 student female 6.7 8 67 17 student female 7 7.5 64.5 18 student female 7 7.5 62 19 student female 6.75 7.25 64.5 20 student female 6.75 7.75 64 21 student female 7.5 8.5 72 22 student female 6.5 8.25 67 23 student female 7.5 6.9 70 24 student female 7.25 7.5 68 25 student female 7 7.2 63 7.25 68 63 7 7.5 7.2 9 7.9 68 8.25 7.1 64 67 7 8.5 7.5 7.6 65 62 8.5 7 6.5 6.8 7.875 8.2 7.5 6.75 U 00 8.5 65 71 76 69.5 70 74 8.75 7.875 un 00 7.75 7.5 9 72 24 student female 25 student female 26 student female 27 student female 28 student female 29 student female 30 student female 31 student female 32 student male 33 student male 34 student male 35 student male 36 student male 37 student male 38 student male 39 student male 40 student male 41 student male 42 student male 43 student male 44 student male 45 student male 46 student male 47 student male 48 student male 49 student male 50 student male 51 student male 8.3 9.7 8 7.75 8.5 8.75 75 67 72.5 69 7.5 9 69 76 un ini 00 00 0 8.5 68.5 00 00 00 8.5 72 72 70 8.5 7.75 8 9.5 7.5 7.75 8.75 73 69 70 7.5 7.5 9.4 75 7. The case found in (6) is not possible, since Hand Width cannot be smaller than Hand Length. Therefore, there must be some measuring error in this case. Are there any other cases you notice Hand Width is less than Hand Length? If so, we need to delete these cases as well. After cleaning up the 'data errors', re-analyze the data, and answer the following questions. (a) Regression Line: (b) An individual has hand width 8.5, use the model in to predict his height: (c) Suppose an individual has height 72 and hand width 9.0. Use the model to predict his height: and obtain the corresponding residual: (d) Report the following information from the Analysis of Variance Table in the output: Source Degrees of Freedom SS MS (Sum of Square) (Mean of Square)