5 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
5 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Date PatientID 9/23/12 inpatient 1 12/11/12 Inpatient 10 11/12/12 Inpatient 100 11/29/12 Inpatient 1000 8/18/12 Inpatient 1001 4/6/13 Inpatient 1002 12/29/12 Inpatient 1003 5/20/13 Inpatient 1004 5/30/13 Inpatient 1005 4/22/13 Inpatient 1006 7/2/12 Inpatient 1007 4/20/13 Inpatient 1008 2/6/13 Inpatient 1009 8/14/12 Inpatient 101 9/8/12 Inpatient 1010 9/9/12 Inpatient 1011 3/21/13 Inpatient 1012 11/12/12 Inpatient 1013 2/20/13 Inpatient 1014 11/5/12 Inpatient 1015 6/19/12 Inpatient 1016 5/10/13 Inpatient 1017 8/25/12 Inpatient 1018 5/1/13 Inpatient 1019 9/25/12 Inpatient 102 1/31/13 Inpatient 1020 11/12/12 Inpatient 1021 2/21/13 Inpatient 1022 4/30/13 Inpatient 1023 7/8/12 Inpatient 1024 3/4/13 Inpatient 1025 6/12/12 Inpatient 1026 10/15/12 Inpatient 1027 8/9/12 Inpatient 1028 7/24/12 Inpatient 1029 3/12/13 Inpatient 103 11/7/12 Inpatient 1030 11/20/12 Inpatient 1031 D E Height Weight BM Ind BMI Category 19.9 Normal weight 36.2 Obese 30.5 Obese 79 74 72 59 56 56 69 66 79 76 64 60 66 73 78 62 78 76 74 81 62 66 67 57 67 57 74 82 58 58 66 71 76 70 80 82 81 61 177 282 225 223 259 108 126 289 177 176 186 244 214 207 192 191 102 160 106 147 264 234 103 191 141 193 283 106 167 176 114 244 263 228 149 217 277 287 45.0 Obese 58.1 Obese. 24.2 Normal weight 18.6 Normal weight 46.6 Obese 19.9 Normal weight 21.4 Normal weight 31.9 Obese 47.6 Obese 34.5 Obese 27.3 Overweight 22.2 Normal weight 34.9 Obese 11.8 Underweight 19.5 Normal weight 13.6 Underweight 15.8 Underweight 48.3 Obese 37.8 Obese 16.1 Underweight 41.3 Obese 22.1 Normal weight 41.8 Obese 36.3 Obese 11.1 Underweight 34.9 Obese 36.8 Obese 18.4 Underweight 34.0 Obese 32.0 Obese 32.7 Obese 16.4 Underweight 22.7 Normal weight 29.7 Overweight 54.2 Obese PatientSattus Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient inpatient Inpatient Inpatient Inpatient Anpatient Inpatient Inpatient Inpatient inpatient Inpatient Inpatient Inpatient inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Anpatient Inpatient Inpatient Inpatient Inpatient Inpatient Anpatient Inpatient Inpatient H BMI Categories Index Category Nie 0 Underweight 18.5 Normal weight 25 Overweight 30 Obese PatientID Inpatient 10 0 BM Index L 7. Using data validation, structured table references, and index-match, obtain a correct measurement (height, weight, or BMI) for any patient chosen from a list. Data validation will not accept a structured table reference directly, but you can put a structured table reference in data validation by using the indirect function with a text string that looks like a structured table reference. Use Indirect and text strings that look like structured table references for both the row match and column match. See PatientData! 18:39 in solution file. 8. Use COUNTIF to calculate the BMI categories in the BMI Cat column of tblPatients. Count all four BMI categories. See PatientData!I12:J15. 9. Create a small column chart for BMI categories and make it look like the one in the solution file shown in the PatientData worksheet. 10. Show summary statistics, height histogram and BMI histogram like the solution StatOverview worksheet. If you are working with a personal copy of Excel you might have to add-in the Analysis Tool Pack (File > Options > Add-ins. Use the bin range shown in the solution worksheet. 11. Show histogram for random heights-actual data from de-identified health care charts. Also show summary stats. 12. Create a pivot table and pivot chart for average weight by year and quarter as shown in the Pivot-height worksheet. Group date in rows before moving date to the report filter. A FA 13. Use Excel functions to return patient data for the patient chosen in PatientData!18. 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/]. 5 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Date PatientID 9/23/12 inpatient 1 12/11/12 Inpatient 10 11/12/12 Inpatient 100 11/29/12 Inpatient 1000 8/18/12 Inpatient 1001 4/6/13 Inpatient 1002 12/29/12 Inpatient 1003 5/20/13 Inpatient 1004 5/30/13 Inpatient 1005 4/22/13 Inpatient 1006 7/2/12 Inpatient 1007 4/20/13 Inpatient 1008 2/6/13 Inpatient 1009 8/14/12 Inpatient 101 9/8/12 Inpatient 1010 9/9/12 Inpatient 1011 3/21/13 Inpatient 1012 11/12/12 Inpatient 1013 2/20/13 Inpatient 1014 11/5/12 Inpatient 1015 6/19/12 Inpatient 1016 5/10/13 Inpatient 1017 8/25/12 Inpatient 1018 5/1/13 Inpatient 1019 9/25/12 Inpatient 102 1/31/13 Inpatient 1020 11/12/12 Inpatient 1021 2/21/13 Inpatient 1022 4/30/13 Inpatient 1023 7/8/12 Inpatient 1024 3/4/13 Inpatient 1025 6/12/12 Inpatient 1026 10/15/12 Inpatient 1027 8/9/12 Inpatient 1028 7/24/12 Inpatient 1029 3/12/13 Inpatient 103 11/7/12 Inpatient 1030 11/20/12 Inpatient 1031 D E Height Weight BM Ind BMI Category 19.9 Normal weight 36.2 Obese 30.5 Obese 79 74 72 59 56 56 69 66 79 76 64 60 66 73 78 62 78 76 74 81 62 66 67 57 67 57 74 82 58 58 66 71 76 70 80 82 81 61 177 282 225 223 259 108 126 289 177 176 186 244 214 207 192 191 102 160 106 147 264 234 103 191 141 193 283 106 167 176 114 244 263 228 149 217 277 287 45.0 Obese 58.1 Obese. 24.2 Normal weight 18.6 Normal weight 46.6 Obese 19.9 Normal weight 21.4 Normal weight 31.9 Obese 47.6 Obese 34.5 Obese 27.3 Overweight 22.2 Normal weight 34.9 Obese 11.8 Underweight 19.5 Normal weight 13.6 Underweight 15.8 Underweight 48.3 Obese 37.8 Obese 16.1 Underweight 41.3 Obese 22.1 Normal weight 41.8 Obese 36.3 Obese 11.1 Underweight 34.9 Obese 36.8 Obese 18.4 Underweight 34.0 Obese 32.0 Obese 32.7 Obese 16.4 Underweight 22.7 Normal weight 29.7 Overweight 54.2 Obese PatientSattus Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient inpatient Inpatient Inpatient Inpatient Anpatient Inpatient Inpatient Inpatient inpatient Inpatient Inpatient Inpatient inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Inpatient Anpatient Inpatient Inpatient Inpatient Inpatient Inpatient Anpatient Inpatient Inpatient H BMI Categories Index Category Nie 0 Underweight 18.5 Normal weight 25 Overweight 30 Obese PatientID Inpatient 10 0 BM Index L 7. Using data validation, structured table references, and index-match, obtain a correct measurement (height, weight, or BMI) for any patient chosen from a list. Data validation will not accept a structured table reference directly, but you can put a structured table reference in data validation by using the indirect function with a text string that looks like a structured table reference. Use Indirect and text strings that look like structured table references for both the row match and column match. See PatientData! 18:39 in solution file. 8. Use COUNTIF to calculate the BMI categories in the BMI Cat column of tblPatients. Count all four BMI categories. See PatientData!I12:J15. 9. Create a small column chart for BMI categories and make it look like the one in the solution file shown in the PatientData worksheet. 10. Show summary statistics, height histogram and BMI histogram like the solution StatOverview worksheet. If you are working with a personal copy of Excel you might have to add-in the Analysis Tool Pack (File > Options > Add-ins. Use the bin range shown in the solution worksheet. 11. Show histogram for random heights-actual data from de-identified health care charts. Also show summary stats. 12. Create a pivot table and pivot chart for average weight by year and quarter as shown in the Pivot-height worksheet. Group date in rows before moving date to the report filter. A FA 13. Use Excel functions to return patient data for the patient chosen in PatientData!18. 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/].
Expert Answer:
Answer rating: 100% (QA)
Unfortunately without the accompanying Excel file and an ability to interact with it directly I am unable to perform the specific tasks listed in the ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
23) Along a horizontal axis, three masses are present. At position x=2, there is a mass of 5 kg. At position x=8, there is a mass of 4 kg. At position x=17, there is a mass of 11 kg. Determine the...
-
Explain how to apply the rules of Section (61)a to determine taxable items.
-
(a) Let Find vectors -12 -5] -- -- [18-[1] 1 = = S = -5 to U = A = U = in R such that S is the transition matrix from (v1, v2} to {u, u}- (b) Let P4 be the vectors space of all polynomials of degree...
-
In 2017, Barlow moved from Chicago to Miami to start a new job, incurring costs of $1,200 to move household goods and $2,500 in temporary living expenses. Barlow was not reimbursed for any of these...
-
Narragansett Bay is approximately 21 (statute) mi long and has an average depth of 42 ft. Tidal charts for the area indicate a time delay of 30 min between high tide at the mouth of the bay (Newport,...
-
Consider the boundary' value problem - u" = f(x), u(0) = 0, u(l) = 2u'(l). (a) Find the Green's function. (b) Which of the fundamental properties does your Green's function satisfy? (c) Write down an...
-
Figure 20.24 shows the flowsheet for a process for the production of methanol from synthesis gas (a mixture of hydrogen, carbon monoxide, and carbon dioxide and a small quantity of residual methane,...
-
Assume Nortel Networks contracted to provide a customer with Internet infrastructure for $2,000,000. The project began in 2018 and was completed in 2019. Data relating to the contract are summarized...
-
On January 1, 2025, A Pile of Ship Ltd. issued 95,000 convertible preferred shares and received proceeds of $6,000,000. These shares pay cumulative dividends of 6%. Buyers of the preferred shares...
-
A wood beam reinforced by an aluminum channel section is shown in the figure. The beam has a cross section of dimensions 150 mm by 250 mm, and the channel has a uniform thickness of 6 mm. If the...
-
Discussed some business people, like Martha Stewart, engage in unethical behavior. What are some non-legal penalties experienced by firms that engage in unethical practices?
-
17. Consider the following two investors saving into their RRSP earning 9% compounded annually throughout: Scully invests $275 at the end of every month from age 18 to age 35, then stops contributing...
-
An 8% semiannual coupon bond matures in 5 years. The bond has a face value of $1,000 and a current yield of 8.3698%. What are the bond's price and YTM? (Hint: Refer to Footnote 6 for the definition...
-
Explain how a company can both identify and manage a corporate psychopath in their organization to reduce the harm they may cause, and then (2) provide an example of a public person that meets the...
-
Calculate the following for a 3 ft 4 ft window with the label to the right. The summer design conditions for peak cooling load are 70 and 60% RH inside; 90 and 90% outside; and a peak direct solar...
-
If you invest $ 8 0 0 each month at an annual rate of 6 . 5 3 % , in how many month will it become $ 5 0 0 , 0 0 0 ? The answer could be in decimals.
-
Treatment of carcinoma Cervix stage IIIB include: a) Wertheim's hysterectomy b) Schuata's hysterectomy c) Chemotherapy d) Concurrent chemoradiation
-
Below is a sample of the data in the file NFLAttendance which contains the 32 teams in the National Football League, their conference affiliation, their division, and their average home attendance....
-
While preparing Massie Miller's 2012 Schedule A, you review the following list of possible charitable deductions provided by Massie: Cash contribution to a family whose house burned...
-
Patty Bayan is a single taxpayer living at 543 Space Drive, Houston, TX 77099. Her Social Security number is 466-33-1234. For 2012, Patty has no dependents, and her W-2 from her job at a local...
-
Your supervisor has asked you to research the following situation concerning Owen and Lisa Cordoncillo. Owen and Lisa are brother and sister. In May 2012, Owen and Lisa exchange business pickup...
-
If task A is an immediate predecessor of task B, what must be true about the sched- uled timing of these two tasks?
-
Why does a project necessarily have to possess some form of deadline? What is the implication of a project without a deadline?
-
What are the likely consequences to managing a highly uncertain project in the predictive style of project management?
Study smarter with the SolutionInn App