Excel Statistics

[cepa47]

I am trying to project volumes for new gas wells coming on line throughout the year based on two months information. Is there a statistical anaylsis in Excel that would provide the probablity of outcome as new properties are added. The wells will vary in volume by area.
Thanks

[tgsekhar]

Sample Worksheet will provide clarity on your requirement.

[cepa47]

Hope this helps- I know there are simpler formulas but would like to use a more statistical approach, it has been 30 years since I took statistics.

[tgsekhar]

Thanks for the sample file. But you have not mentioned the details of your forcasting process. Excel has lot of statistical formula, but your process need to be understood to link it to available forumla. This forum may not have statisticians who can suggest you with a few options. Either provide the normal statistical formula you may like to use in a manual calculation or go through the list of statistical formula support by Excel. You can view a list of formula by using Formulas->More Functions->Statistical. Review of these formula may suggest a process to select. You can then raise fresh query providing the formula in which you may need any help.

[cepa47]

I am using dglinfo with if statements, and I know that the spreadsheet is updated but the only way I can show the value in particular cell is by hitting the fx. Is their a way to show all the values at once instead of going cell by cell?
Thanks