BSHA 382 HA1-F19-Escd o Page Formule View Tell me what you want to do... Sign in Share 10 2.65m 2 P A Gone Bad Good Neutral Calculation File * Cut Cowy Paste Foimalan Clipboard B I J , 8 , , A Wie Test === EE Merge & Center - Nigament $%. Normal Conditional Format as Check Cell Formatting Table Explanatory... input Linked Cell Note Insert Ddete Format FIL- Clar Sort Find & Filter Caring Tom Numbe Shyles 123 2 D E H LMV 0 P 0 F U V w 2 AD AF AG AH u Charge A han ICD- 11 2F 4 7 5 F GF 7 F AZ 70 az 88 73 94 94 78 2014 FA 7996 15,427 1104 294 $ 503) 48 $ 19.70.1 0 3 2 5 2 TI 3 7 F 3 5 7 4 4 5 3 5 0 0 II F 14 F F 17! TF 221 $ 4243 YLt 9 1871 I 11.17: 92 04 323 23 14 D 5 D 6 11 2 20 4 21 1: 1 11 ti 22 F SF F 4 0 2- 79 99 841 72 94 68 1 0 2 31 4 B 4 5 2 3 B B 3 F 29 F 32 F 33 F 37 F 38 F F 0 2 0 0 O 0 U 2 U 82 D 21 2 . 20 5 2 1 2 1 3 1 5 1 4 5 5 1 2 H 5 A 79 1 7 7 4 1 9 3 6 5 5 0 37 SF 26F 27 F F 9F OF 52F AF F 4M OM SM UM TUM 21 173 $ AM 7815410 4.71328 CAT 28 $ 2.9422 43 $ 4.631 98 209$ 1,2909 ! 22 430 9.9012 i 16 2846 112 151.0 1022 -27 144 TI 114 123HY 32 $ 1:44 40 ch 40 2024043 40 $ 2.6:4.1 3.3165 40+ 6.43.77 241 $ 3.89 2331 10:13 ut 70 21 S 5:23. 24 G 4:11 5219 HO TIL ZA TREE % ; 5 42307895 30 $ 2.449 RB 1. LOTE 40 $ 2.792 40 1.0138 88 41 42 5 5 5 5 2 3 5 5 1 5 0 0 O D D D U 73 2 2 FI 7 17 . 29 50 51 2 31 72 78 72 9 1 3 5 3 2 82 5 1 B 5 2 5 4 2 4 2 4 M M 4M 51 M 5 M BM 2 5 0 0 1 0 1 67 208 1 12 OB-014 Rudy + 795 X 1:11 PM 127/2011 6. Use the MIN function to determine the weight of the lightest child coming to the clinic. Round to the nearest tenth. 7. Create an IF statement (using the IF Function) that determines whether the infant is greater or less in weight than the overall average for all infants and assign a 1 to those greater than the average and = to or less than the average. How many infants are above the average weight? Report as an integer. Hint: After creating the IF statement, use the SUM function to count the number of infants with above average weight. Now open the Excel file on Moodle in the HW1 Folder entitled BSHA 382 HW1.xls. Within this file are some sample Medicare billing data. By now you should begin to recognize which function should be used given the question. In each question, you aren't always given the function and should think about the question and use the appropriate function. 8. What is the average age of the patients in your database? Round to the nearest tenth. 9. What is the median age of the patients in your database? Round to the nearest tenth. 10. What is the most common age of the patients in your database? Hint - use the Mode. Report as an integer. 11. How old is your oldest patient? Report as an integer. 2 12. How old is your youngest patient? Report as an integer. 13. There are more male than female patients in your database. True/False 14. What is the Average Length of Stay (LOS) for female patients in your database? Hint: Use the AVERAGEIF function. Round to the nearest tenth. BSHA 382 HA1-F19-Escd o Page Formule View Tell me what you want to do... Sign in Share 10 2.65m 2 P A Gone Bad Good Neutral Calculation File * Cut Cowy Paste Foimalan Clipboard B I J , 8 , , A Wie Test === EE Merge & Center - Nigament $%. Normal Conditional Format as Check Cell Formatting Table Explanatory... input Linked Cell Note Insert Ddete Format FIL- Clar Sort Find & Filter Caring Tom Numbe Shyles 123 2 D E H LMV 0 P 0 F U V w 2 AD AF AG AH u Charge A han ICD- 11 2F 4 7 5 F GF 7 F AZ 70 az 88 73 94 94 78 2014 FA 7996 15,427 1104 294 $ 503) 48 $ 19.70.1 0 3 2 5 2 TI 3 7 F 3 5 7 4 4 5 3 5 0 0 II F 14 F F 17! TF 221 $ 4243 YLt 9 1871 I 11.17: 92 04 323 23 14 D 5 D 6 11 2 20 4 21 1: 1 11 ti 22 F SF F 4 0 2- 79 99 841 72 94 68 1 0 2 31 4 B 4 5 2 3 B B 3 F 29 F 32 F 33 F 37 F 38 F F 0 2 0 0 O 0 U 2 U 82 D 21 2 . 20 5 2 1 2 1 3 1 5 1 4 5 5 1 2 H 5 A 79 1 7 7 4 1 9 3 6 5 5 0 37 SF 26F 27 F F 9F OF 52F AF F 4M OM SM UM TUM 21 173 $ AM 7815410 4.71328 CAT 28 $ 2.9422 43 $ 4.631 98 209$ 1,2909 ! 22 430 9.9012 i 16 2846 112 151.0 1022 -27 144 TI 114 123HY 32 $ 1:44 40 ch 40 2024043 40 $ 2.6:4.1 3.3165 40+ 6.43.77 241 $ 3.89 2331 10:13 ut 70 21 S 5:23. 24 G 4:11 5219 HO TIL ZA TREE % ; 5 42307895 30 $ 2.449 RB 1. LOTE 40 $ 2.792 40 1.0138 88 41 42 5 5 5 5 2 3 5 5 1 5 0 0 O D D D U 73 2 2 FI 7 17 . 29 50 51 2 31 72 78 72 9 1 3 5 3 2 82 5 1 B 5 2 5 4 2 4 2 4 M M 4M 51 M 5 M BM 2 5 0 0 1 0 1 67 208 1 12 OB-014 Rudy + 795 X 1:11 PM 127/2011 6. Use the MIN function to determine the weight of the lightest child coming to the clinic. Round to the nearest tenth. 7. Create an IF statement (using the IF Function) that determines whether the infant is greater or less in weight than the overall average for all infants and assign a 1 to those greater than the average and = to or less than the average. How many infants are above the average weight? Report as an integer. Hint: After creating the IF statement, use the SUM function to count the number of infants with above average weight. Now open the Excel file on Moodle in the HW1 Folder entitled BSHA 382 HW1.xls. Within this file are some sample Medicare billing data. By now you should begin to recognize which function should be used given the question. In each question, you aren't always given the function and should think about the question and use the appropriate function. 8. What is the average age of the patients in your database? Round to the nearest tenth. 9. What is the median age of the patients in your database? Round to the nearest tenth. 10. What is the most common age of the patients in your database? Hint - use the Mode. Report as an integer. 11. How old is your oldest patient? Report as an integer. 2 12. How old is your youngest patient? Report as an integer. 13. There are more male than female patients in your database. True/False 14. What is the Average Length of Stay (LOS) for female patients in your database? Hint: Use the AVERAGEIF function. Round to the nearest tenth