You are trying to determine how many (weekly) magazines to produce in any production run. It costs you $1.00 to print each magazine, and you sell the magazines for $2.50 each. If you don't sell all your magazines, then the excess must be disposed of at a cost of $0.05 per magazine. The attached Excel sheet [its just a one column excel file with 104 values] contains the number of magazines demanded (not sold) each week for the last two years. (Never mind how these were obtained.) Assume weekly demands are i.i.d. Let x be the number of magazines you decide to produce each week, and let f(x) be the resulting expected profit per week.
Build a spreadsheet that computes, for any given value of x, an estimate of f(x) along with a 95% condence interval, based on the two years of data.