case statistics ( business statistics )

profileqn-pownr-965
answer1.xlsx

Sheet1

July, 2006 August, 2006 % of total cost in July % of total cost in August
Hospital Services - Inpatient 203,425.00 212,250.00 22% 22%
Hospital Services - Outpatient 182,440.00 180,700.00 20% 18%
Surgical Services 101,250.00 103,400.00 11% 11%
Physician Office Visit 337,900.00 391,450.00 37% 40%
Administrative expenses 90,000.00 90,000.00 10% 9%
Total 915,015.00 977,800.00
Week Cost of Physician visits % Change
1 77322 2%
2 79177 -5%
3 74889 -2%
4 73428 2%
5 74535 1%
6 75487 -2%
7 74222 2%
8 75499 1%
9 76300 -0%
10 76033 4%
11 78832 1%
12 79755 1%
13 80243 -2%
14 78993 3%
15 81227 4%
16 84219 -2%
17 82177 0%
18 82456 -2%
19 81100 4%
20 84211 7%
21 90133 6%
22 95120 5%
23 99865 -2%
24 97752 1%
25 98713
1%

Sheet2

Sheet3