Question
Offered Price \$15.00

# PAD505: Ch 4 Exercises Question 1&2

Question # 00016409
Subject: Statistics
Due on: 06/01/2014
Posted On: 05/29/2014 06:23 AM

Rating:
4.1/5
Posted By
Questions:
8
Tutorials:
0
Feedback Score:

Question

Expenditures Analysis in Current Dollars: A. You are a fiscal analyst in the city's budget office. Complete the current dollar portion of table Table 4.4 analyzing the Health Department's expenditures, use the available data in Table 4.1 .

B. Write a memo from you (as a fiscal analyst) to the budget director explaining the trends.

2.Expenditure Analysis in Constant Dollars A. In this exercise, you will complete the rest of the spreadsheet in Table 4.4, conducting the same analysis you did above, only you will convert all the Dollars in constant Dollars. This exercise allows you to adjust a spreadsheet for inflation. The technique is to convert current Dollars expenditures using cost of living indexes to constant (real) Dollars by removing inflations as a factor.

B. After you complete the spreadsheet calculating constant Dollars, write a paragraph from you, as a fiscal analyst, to OMB's budget director. In it you will explain what differences you found when you controlled for inflation compared with the first exercise when you did not control for inflation.

To complete the following two exercises, use the spreadsheet file titled 'Budget Tools Ch 4 text examples and exercises'

Attachments
Tutorials for this Question
Available for
\$24.00

#### PAD505: Ch 4 Exercises Question 1&2

Tutorial # 00015871
Posted On: 05/29/2014 12:35 PM
Posted By:
mac123
Questions:
4789
Tutorials:
6536
Feedback Score:
Tutorial Preview …Ch x…
Attachments
solutions.xls (379 KB)
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + \$0.30) applicable