In 2007 the new york times reported that the median annual household income in the united states was $55,500 (new york times website, august, 21, 2013). answer the following questions based on the following sample of 14 household incomes for 2013 ($1000s).

49.4 52.4 53.4 53.3 52.1 48.7 52.1
52.2 64.5 51.6 41.5 52.9 52.5 51.2

a. what is the median household income for the sample data for 2013?
b. based on the data estimate the percentage change in the median household income from 2007 to 2013.
c. complete the first and third quartiles.

Forecasting as a first step in the team’s decision making, it wants to forecast quarterly demand for each of the two types of containers for years 6 to 8. based on historical trends, demand is expected to continue to grow until year 8, after which it is expected to plateau. julie must select the appropriate forecasting method and estimate the likely forecast error. which method should she choose? why? using the method selected, forecast demand for years 6 to 8.

Rachel died in 2014 and her executor is finalizing her estate tax return. the executor has determined that rachel’s adjusted gross estate is $10,120,000 and that her estate is entitled to a charitable deduction in the amount of $500,000. using 2014 rates, calculate the estate tax liability for rachel’s estate.

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding