Question: hi Please I need help. thanks Census Use a cell reference or a single formula where appropriate in order to receive full credit. Do not

hi Please I need help. thanks
Census Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers a ) Item % The table shows the costs of the 2010 Census. Source: Fortune Magazine April 2010 2010 Decennial Census a.) Cost (millions 2010$) Decimal American Community Survey $1,700.0 Master Address Mapping File $499.9 IT Systems for Data Collection $2,050.0 Advertising and Communications $338.0 Printing $116.5 Non-response Follow-up $2,740.0 Vacancy Confirmation $341.1 Regional/Local Offices and Staff $1,500.0 Other Field Operations $654.2 Postage $257.2 Other (Headquarters, Research, Planning...) $4,330.0 a.) Compute the total cost and the percentage that each item is of the total. Format the total cost as currency to 1 decimal place and the percentage of items to the total as a decimal to 3 places and as a percentage to 1 decimal place, respectively. b.) The table below compares total costs (2010 S) over the years and the costs per household. Compute the total change and percent change for each decade formatted to one decimal place. c.) The table below compares total costs (2010 s) over the years and the costs per household. Compute the number of households each year, Total: No. Hshlds. Total Cost (billions 2010$) Total Change % Change $1.0 Per Household Total Change % Change $2.6 1970 1980 1990 2000 2010 54 $14.4 $29.5 $39.6 $68.9 $112.1 $8.1 $14.5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
