Member Analysis Last Name Age Total dues Start Weight Current Weight Weight Loss
ID: 3777343 • Letter: M
Question
Member Analysis Last Name Age Total dues Start Weight Current Weight Weight Loss Trainer Visits Age Groups Count Total Fees 4 Hernandez 65 S 35.63 197 1809 :17 12 25 5 Huang 55 363.75 127 120.65 6.35 81 50 Jayaraman 35 s 245.00 265 252.7 13.3 2 7 Kang 29 322.50 157 149.15 7.85 61 8 Wilson 63 s 202.50 297 225 72 1 AE e Groups 5 lost 9 Huang 300 s 405.75 270 240 30 51 25 Rivera 57 s 225.25 177 16 .15 8.85 15 50 Lim 24 s 380.63 152 152 0 91 Correlation 30 S 93.75 211 200.45 10.55 8 Gonzalez Evans 21 s 238.13 240 200 40 14 15 Hyat 50 275.35 245 233.7 12.3 7 16 Carter 59 S 265.25 180 171 9 3 37 s 84.38 273 259.35 13.65 31 Jeong Diaz 55 345.00 276 262.2 13.8 14 s 253 240.35 12.65 3 19 Matsumoto 28 125.00 49 s 324.38 151 143.45 7.55 101 Rodriguez Yoshida 39 341.25 198 188.1 9.9 3 239 195 44 15 Flores 60 $310.00 Hamieh 29 324.38 123 116.85 6.15 13 Azzi 51 s 350.00 195 185.25 9.75 31 25 Hassan 65 275.50 236 226-1, 11.9 7 26 Hussein 200 S 238.13 136 129.2 6.8 3 Mistry 25 792.50 310 294.5 15.5 3 28 Yoshida 37 s 635.00 170 161.5 8.5 41 Yoo 47 775.00 272 258.4 13.6 12 30 Lim 55 540.00 225 213.75 11.25 14 3,1 Gonzalez 44 S 211.88 232 175 57 15 32 Sato 38 s 365.63 179 160 19 13 Park 31 s 852.50 110 110 0 91 34 Hyat 300 s 378.75 197 187.15 9.85 7 35 Patil 23 s 887.50 169 160.55 8.45 101 36 Lim 29 234.38 124 165.3 8.7 8Explanation / Answer
Answer
2.
L4 conditional function is:: =COUNTIF(C4:C53,">=25")-COUNTIF(C4:C53,">50")
3.
L5 condition function total number of members over the age of 25 is::
=COUNTIF(C4:C53,">=25")
4.
Condition function for M4 , to get the total of membership paid by those of 25 years or younger:
=SUMIF(C4:C53,"<=25",D2:D10)
6.
L9 to calculate total number of members 25 or younger who lost atleast 5pounds:
=COPUNTIF(A2:A10,"<=25",C2:C10, ">=5.0")