Everything is in the links for directions. If you have questions just ask.ID
1
2
3
5
6
7
10
11
14
16
17
18
19
20
21
22
24
25
26
27
28
29
32
33
37
39
40
41
42
43
45
46
47
48
49
50
52
54
56
4
8
9
12
13
15
23
30
31
34
35
36
38
44
51
Sex
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
Sex1
Age
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
LOS
46
87
70
82
85
73
94
94
76
91
90
83
82
49
88
75
76
85
84
77
94
66
86
70
83
82
92
79
69
76
83
80
76
77
85
70
83
88
89
72
65
73
79
82
72
81
72
78
72
91
75
82
73
81
DRG
4
8
10
3
2
5
14
11
3
7
6
3
11
2
2
2
4
10
6
3
6
6
3
5
6
10
2
2
2
3
6
4
10
7
4
1
9
3
2
5
6
6
5
6
3
7
1
3
5
3
2
1
2
2
294
139
34
141
15
294
148
89
122
321
174
143
358
140
143
159
294
473
128
15
121
128
143
209
88
430
138
88
447
183
127
444
493
324
140
140
138
140
15
140
241
335
127
89
336
89
140
209
96
144
90
183
140
140
Charges
$
2,426.48
$
6,815.61
$
7,596.68
$
3,542.79
$
2,590.86
$
5,082.83
$
19,708.11
$
8,953.38
$
6,864.63
$
6,424.30
$
5,184.53
$
1,871.78
$
11,179.97
$
3,405.38
$
1,731.73
$
5,384.92
$
2,489.65
$
8,244.25
$
3,548.05
$
4,713.26
$
5,804.21
$
2,945.22
$
4,637.96
$
17,480.97
$
5,482.93
$
9,931.21
$
2,451.69
$
2,834.68
$
1,547.81
$
1,876.70
$
6,460.59
$
3,026.42
$
14,769.92
$
4,425.44
$
5,151.52
$
2,404.39
$
10,421.01
$
2,694.11
$
3,311.66
$
6,450.77
$
3,580.55
$
11,045.79
$
7,000.21
$
5,330.24
$
4,318.13
$
5,216.91
$
1,035.75
$
17,005.45
$
5,029.09
$
3,078.99
$
2,146.99
$
1,078.56
$
2,781.28
$
5,019.86
53 M
55 M
0
0
76
88
2
4
269 $
208 $
4,860.83
2,421.63
Diag
ICD-9
2
4
6
3
5
7
4
4
5
3
6
6
9
1
4
2
3
4
8
4
5
2
5
5
2
1
2
1
3
1
5
1
4
5
5
1
5
2
3
5
6
1
5
4
2
2
5
1
8
5
2
6
4
2
0
4
0
7
4
2
0
0
4
0
5
0
6
0
7
0
0
0
4
0
7
0
0
0
0
0
4
0
0
0
0
6
5
5
0
4
0
0
0
0
0
0
0
0
0
4
4
7
4
4
4
5
0
0
4
2
1
0
Homework 1
This homework is designed to give you some experience with Excel. With this exercise, you’ll
perform several tasks, such as data entry, using the functions command and if statements.
Read through all the problems and set them up and then solve them. Once you are
comfortable with your responses, go to Moodle and submit them. You have only one
opportunity to submit your responses. Therefore, you should only open the link to submit your
answers when you are fully ready to submit all responses. Be very careful to submit your
responses as instructed or Moodle with grade them as incorrect.
A well-baby clinic record the weight for the following infants receiving services during one
work-day. The weight of the infants is given below in pounds. Enter the data into a
spreadsheet and answer the following questions. You should enter these data into a single
column, not in three rows as shown.
10.7
17.1
17.2
18.2
20.6
15.8
17.8
18.8
10.8
16.0
15.4
19.6
17.8
20.8
17.9
15.9
19.8
17.8
21.5
18.3
14.5
1. Use the COUNT function to determine the number of observations. Report as an
integer.
________
2. Use the SUM function to obtain the total weight of all infants coming to the clinic on
the given day. Round to nearest tenth – 1 decimal place.
________
3. Use the AVERAGE function to determine the average weight of infants coming to the
clinic. Round to the nearest tenth – 1 decimal place.
________
4. Use the MEDIAN function to determine the median weight of the infants coming to
the clinic. Round to the nearest tenth.
________
5. Use the MAX function to determine the weight of the heaviest child coming to the
clinic. Round to the nearest tenth.
________
1
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.
_________
3
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.