Superstore data: confidence intervals

One of the manufacturers, Howard Miller, has been having issues with their IT systems. It seems that until now, their data flow is inconsistent and you only get 30% of their actual orders in your database. Although the data is incomplete, you have the tools to make an estimate about the complete dataset, awaiting a fix of the data flow. Use a 95% confidence interval to make an educated guess on their true profit, based on order date and shipping mode data.

If you lost progress, load the workbook 2_5_ci.twbx from the Workbooks folder on the Desktop.