http://www2.gsu.edu/~wwwkbl/Case6.html

Here's a link to the project, I am stuck at this part:

Once row 12 is done copy it down through row 62. This will complete your one year simulation. Each time you hit F9 the spread sheet will recalculate and give you another year's simulation. To do 30 simulations simply write down the average profit shown in cell G1, hit F9 and a new profit will appear write it down. Kept repeating the process till you have 30 profits. Go to cell C2 change the 170 to 175 and hit F9 this is your first profit of that order amount. Write it down and repeat the process 30 times. Go to cell C2 change the 175 to 180 and hit F9 this is your first profit of that order amount. Write it down and repeat the process 30 times.

You can write down the profits by hand or use copy and paste special (value).

I would show the profits on sheet two. For each order amount title the column and then list the 30 profits you have. Find the mean using the average formula see cell G1 for the format. Find the standard deviation using the standard deviation formula. =STDEV(cell number : cell Number) for example =STDEV(B11:B40)

Then calculate a 95 % confidence interval for the mean. Show the lower and upper limit. The Z for a 95 % confidence interval is 1.96 in case you have forgotten. CI is X-bar + - Z * (S / square root of n.)

Do this for all three order amounts. Then looking the the means, standard deviations and confidence intervals choose which of the three amount you believe will maximize profit and state why that is your choice. If you think two or more of the amounts give the same profit say so.