Question

1. Submit the following graphs. May be done in Excel and then paste them.

1. Hospital A has 100 employees. Samples are as follows: Person 1 makes $1000 per week, Person 2 makes $2000 per week, Person 3 makes $3000 per week, person 4 makes $4000 per week and person 5 makes $5000 per week. Identify the type of graph and graph your results.
2. Hospital B has 100 employees. All employees make $5,000 per week. Identify the type of graph and graph your results.
3. Hospital C has 500 residents. The first floor dispenses 500 medications per week. The second floor dispenses 250 medications per week. The third floor dispenses 310 medications per week. The fourth floor dispenses 650 medications per week and the 5^th floor dispenses 822 medications per week. Identify the type of graph and graph your results.

Answer 1

Solution:

a.

Hospital A	(100 employees)
Sample
Employee	Salary per week in $	Average Salary per week
Person 1	1000	3000
Person 2	2000	3000
Person 3	3000	3000
Person 4	4000	3000
Person 5	5000	3000
Average Salary	3000

Average is obtained using the function =AVERAGE(B4:B8)

Bar chart (3D type in excel) can be used to compare with the average salary of the given sample.

b.

Line chart can be used to represent that there is no change in the salaries of 100 employees in Hospital B.

c.

Floor Number	Medication dispensed per week	Average Medication Dispensed
1	500	506.4
2	250	506.4
3	310	506.4
4	650	506.4
5	822	506.4
Average Medication dispensed per week	506.4=AVERAGE(B2:B6)
Residents - 500

Bar Chart (3D type in excel) can be used to compare the number of medication dispensed on each floor with the average medication dispensed in the hospital.

Line chart can also be used to see the trend that which floor dispense the maximum number of medications. From chart we can say that the fifth floor dispenses the maximum medications.