Cumulative distrubution curve and excel?

Question

I have a excel spreadsheet of the amount of flow of water every hour for a set of dates. This data also includes the standard deviations. I need a cumulative distribution curve plotting the flow. How do I do this in excel?

Answer 1

Insert a row above your flow data, and insert a column next to the flow data to the right. In the cell in the new column enter
=[cell above] + [cell to the left]
Use the Fill Down feature to copy the formula all the way down the new column..
If the row above the data is a row of labels, omit the insertion of the new row. Excel treats text as a numerical zero unless you use one of the text value functions.