Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Attached is the instructions and then also attached is what the problem should look like, and then attached is also the worksheet that the instructions
Attached is the instructions and then also attached is what the problem should look like, and then attached is also the worksheet that the instructions is referring to. I just need help with the formulas.
13. Use Excel functions to return patient data for the patient chosen in PatientData!I8. Use text functions to return data to B3 and B4 of the Text worksheet. Include units as shown in the sample solution. 14. Use concatenation to create the following sentence: [Inpatient/Outpatient] number [Number] has a [height/weight/BMI) reading of [measurement] [in/lbs/l. Units Height in Weight Ibs BM Index Inpatient 1003 Height 1 Data below refers to patient evaluated in PatientData worksheet 2 3 Inpatient or Outpatient? 4 Patient Number 5 Measurement 6 Result returned in PatientData J9 7 8 Inpatient number 1003 has a Height reading of 69 in 9 .O 69 in A B T L M N 0 BMI Categories Index CatName O Underweight 18.5 Normal weight 25 Overweight 30 Obese Height Patient ID Inpatient_1003 69 BMI Category Distribution Underweight Normal weight Overweight Obese 710 1137 949 2204 BMI Categories PatientStatus Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient 2500 2000 22 C D E - Height - Weight BM Index - BMI Cat 79 177 19.9 Normal weight 74 282 36.2 Obese 72 225 30.5 Obese 59 223 45 Obese 56 259 58.1 Obese 56 108 24.2 Normal weight 69 126 18.6 Normal weight 66 289 46.6 Obese 79 177 19.9 Normal weight 76 176 21.4 Normal weight 64 186 31.9 Obese 60 244 47.6 Obese 66 214 34.5 Obese 73 207 27.3 Overweight 78 192 22.2 Normal weight 62 191 34.9 Obese 78 102 11.8 Underweight 76 160 19.5 Normal weight 74 106 13.6 Underweight 81 147 15.8 Underweight 62 264 48.3 Obese 66 234 37.8 Obese 67 103 16.1 Underweight 57 191 41.3 Obese 67 141 22.1 Normal weight 57 193 41.8 Obese 74 283 36.3 Obese 82 106 11.1 Underweight 58 167 34.9 Obese 58 176 36.8 Obese 66 114 18.4 Underweight 71 244 34 Obese 76 263 32 Obese 70 228 32.7 Obese 80 149 16.4 Underweight 82 217 22.7 Normal weight 81 277 29.7 Overweight 61 287 54.2 Obese 74 199 25.5 Overweight 67 109 17.1 Underweight 78 190 22 Normal weight 69 126 18.6 Normal weight 70 157 22.5 Normal weight 1 Date PatientID 2 9/23/12 Inpatient_1 3 12/11/12 Inpatient_10 4 11/12/12 Inpatient_100 5 11/29/12 Inpatient_1000 6 8/18/12 Inpatient_1001 7 4/6/13 Inpatient_1002 8 8 12/29/12 Inpatient_1003 9 5/20/13 Inpatient_1004 10 5/30/13 Inpatient_1005 11 4/22/13 Inpatient_1006 12 7/2/12 Inpatient_1007 13 4/20/13 Inpatient_1008 14 2/6/13 Inpatient_1009 15 8/14/12 Inpatient_101 16 9/8/12 Inpatient_1010 17 9/9/12 Inpatient 1011 18 3/21/13 Inpatient_1012 19 11/12/12 Inpatient_1013 20 2/20/13 Inpatient_1014 21 11/5/12 Inpatient_1015 6/19/12 Inpatient_1016 23 5/10/13 Inpatient_1017 24 8/25/12 Inpatient_1018 25 5/1/13 Inpatient_1019 26 9/25/12 Inpatient_102 27 1/31/13 Inpatient_1020 28 11/12/12 Inpatient_1021 29 2/21/13 Inpatient_1022 30 4/30/13 Inpatient_1023 31 7/8/12 Inpatient_1024 32 3/4/13 Inpatient_1025 33 6/12/12 Inpatient_1026 34 10/15/12 Inpatient_1027 35 8/9/12 Inpatient_1028 36 7/24/12 Inpatient_1029 37 3/12/13 Inpatient_103 38 11/7/12 Inpatient_1030 39 11/20/12 Inpatient_1031 40 5/11/13 Inpatient_1032 41 1/9/13 Inpatient_1033 42 11/30/12 Inpatient_1034 43 12/8/12 Inpatient_1035 44 3/22/13 Inpatient 1036 1500 1000 1 500 a Underweight Normal weight Dverweight Obese Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient InpatientStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started