Open the transaction JMP file and study it (under the transaction panel, right click MetaData > Edit). Perform K-Means Clustering using the fields Age and # Rentals as [Y, Columns). Specify 3 and 10 as the Number of Clusters and Range of Clusters respectively. Based on the K Means NCluster output that corresponds to the optimal CCC, fill in the blanks of each of the following questions with either an integer or a number rounded to 2 decimal places as indicated: 1. What is the number of clusters related to the optimal CCC? (integer) 2. What is the value of the optimal CCC? (2 decimal places) 3. Which cluster has most members? (integer) 4. Which cluster has the youngest members based on average age? (integer) 5. Which cluster has the lowest average number of rentals? (integer) Customer Gende ID r State 5060F AR Marrie Age d 36 No Kids Under 12 # Rentals 127 1 2 5006 F CA 76 No No 137 3 No 125 4 CA CA CA No Yes 5 5066 F 5002 M 5032 M 5046 M 5082 M 5015 M 5052 M 58 No 23 No 30 No 74 No 21 No 30 No 112 220 146 6 CA 7 CA 133 8888888599 8 % % % % % % % % % % % % % % % No 125 9 FL No 116 139 10 5026 M IA MD 11 5092 F 140 12 MD No 138 64 No 61 No 66 No 62 No 56 No 25 No 72 No 65 No 13 No 14 MI NC NC No 129 127 126 5072 M 5011 F 5051 F 5059 F 5096 F 5071 M 5077 M 5023 F 15 16 NC No 133 17 NC 125 NC 18 19 137 53 NV No 20 5085 F NY No 27 No 29 No 19 No 26 No 20 No 22 No 36 No 22 No 126 121 21 5025 M % % % % % % % % NY OR No 22 5079 M No 148 5020 M 127 23 24 PA SC 5097 M 58 Marrie Age d 23 No Kids Under 12 # Rentals 151 130 25 26 67 No 27 20 No 210 No No Yes No No Yes 28 29 128 126 224 30 31 No 133 32 239 254 33 34 Customer Gende ID State 5018 F TN 5019 F TN 5084 F TX 5063 M TX 5038 F VA 5075 F 5067 M WV 5037 M AL 5021 M CA 5028 M CA 5040 M CA 5058 M CA 5094 M CA 5089 M 5043 M DC 5007 F FL 5088 F. FL 5034 M FL 5041 F GA 5008 M GA 74 No 40 No 33 No 70 No 42 Yes 34 Yes 35 Yes 69 Yes 26 Yes 42 Yes 59 Yes 70 Yes 69 Yes 35 36 Yes Yes Yes No Yes Yes No No No 229 161 217 37 228 38 39 40 129 153 147 41 21 Yes 240 Yes Yes 42 30 Yes No 43 44 246 154 242 Yes 45 GA 64 Yes 39 Yes 32 Yes 64 Yes 18 Yes 5061 M 5042 F 220 46 IL Yes No No 143 47 5054 F IL 154 48 5087 F IN 76 Yes No 146 Marrie Age d 47 Yes Kids Under 12 # Rentals 220 49 Yes 50 58 Yes 139 No Yes 51 252 18 Yes 56 Yes 134 52 53 No Yes 221 36 Yes 59 Yes 54 163 55 133 Customer Gende ID r State 5013 F LA 5030 F LA 5049 M LA 5050 M MA 5093 M MA 5095 M MD 5036 M MI 5047 M 5001 F NC 5027 F NC 5091 F NC 5039 M NC 5053 M NC 5065 M NC 5083 M NC 5086 M NC MI 56 57 140 159 58 134 59 No No No No No Yes Yes No Yes No 233 isss 999999999222222 60 235 35 Yes 46 Yes 51 Yes 59 Yes 45 Yes 39 Yes 75 Yes 47 Yes 70 Yes 48 Yes 36 Yes 55 Yes 34 Yes 61 62 153 226 144 63 64 Yes 229 65 NC 5099 M 5033 M 5012 F No No 66 67 NJ NV 136 131 117 Yes 24 Yes 86 NV NV Yes Yes 33 Yes 118 88RT2 5055 F 5076 F 5074 M 5070 F 97 NV NY OH 33 Yes 41 Yes 64 Yes Yes Yes No 219 5029 F 135 Gende Kids Under Customer ID 12 State OH # Rentals 135 No No 169 PA SC SC 90 Marrie Age d 64 Yes 60 Yes 60 Yes 22 Yes 57 Yes 44 Yes 21 Yes 41 Yes No Yes 5029 F 5078 F 5005 F 5031 F 5044 F 5062 F 5069 F 5057 F 129 No 100 SC SC Yes 77 78 79 SC TN Yes No 145 173 126 5068 F TN 40 Yes Yes 214 TN No 135 32 Yes 42 Yes 82 Yes 229 TN TN 83 Yes 237 5010 M 5016 M 5022 M 5003 F 5004 F 5024 F No 84 85 TX TX 149 124 No 86 TX 53 Yes 39 Yes 69 Yes 42 Yes 46 Yes 31 Yes 36 Yes 230 Yes Yes 87 TX 238 88 5035 F 5056 F 5073 F TX Yes No 244 131 89 90 5090 F TX TX TX 19 Yes 219 Yes Yes 91 5014 M. 213 92 5080 M TX Yes 239 93 No 44 Yes 51 Yes 57 Yes 36 Yes 30 Yes 135 5064 F 5081 F 5009 M 94 VA VA VA 215 Yes Yes 95 238 94 275 VA VA 95 5081 F 5009 M 5045 M 5048 M Yes Yes Yes No 96 36 Yes 30 Yes 31 Yes 68 Yes 58 Yes 75 Yes VA 238 241 121 97 VA 98 5098 M No 141 VA W 99 5017 F No 153