Start with the historical data from the PivotTable created in Question $5,$ create an Excel Forecast Sheet to project Monthly Espresso Profit until December $2014$ using $95\%$ Confidence Interval.

According to your analysis, the Espresso Profit forecast for July $2014$ was $

$($x$,$xxxx$.$xx$).$

The Profit figure should include a thousand separator and appropriately round with two decimal points.

Here is the data from excel sheet:

Product Type Espresso

Row Labels Sum of Profit

Jan $$5,477\mathrm{.}00$

$2012$ $$2,141\mathrm{.}00$

$2013$ $$3,336\mathrm{.}00$

Feb $$5,771\mathrm{.}00$

$2012$ $$2,323\mathrm{.}00$

$2013$ $$3,448\mathrm{.}00$

Mar $$5,606\mathrm{.}00$

$2012$ $$2,257\mathrm{.}00$

$2013$ $$3,349\mathrm{.}00$

Apr $$5,670\mathrm{.}00$

$2012$ $$2,283\mathrm{.}00$

$2013$ $$3,387\mathrm{.}00$

May $$5,480\mathrm{.}00$

$2012$ $$2,302\mathrm{.}00$

$2013$ $$3,178\mathrm{.}00$

Jun $$5,827\mathrm{.}00$

$2012$ $$2,445\mathrm{.}00$

$2013$ $$3,382\mathrm{.}00$

Jul $$5,629\mathrm{.}00$

$2012$ $$2,365\mathrm{.}00$

$2013$ $$3,264\mathrm{.}00$

Aug $$5,642\mathrm{.}00$

$2012$ $$2,370\mathrm{.}00$

$2013$ $$3,272\mathrm{.}00$

Sep $$5,638\mathrm{.}00$

$2012$ $$2,270\mathrm{.}00$

$2013$ $$3,368\mathrm{.}00$

Oct $$6,223\mathrm{.}00$

$2012$ $$2,505\mathrm{.}00$

$2013$ $$3,718\mathrm{.}00$

Nov $$5,937\mathrm{.}00$

$2012$ $$2,391\mathrm{.}00$

$2013$ $$3,546\mathrm{.}00$

Dec $$5,720\mathrm{.}00$

$2012$ $$2,302\mathrm{.}00$

$2013$ $$3,418\mathrm{.}00$

Grand Total $$68,620\mathrm{.}00$