- Feb 16, 2003
- 26,107
- 4
- 81
I have multiple scenarios of data and want to create a graph based on the mean and 10th/90th percentiles of it all, shown over time.
Is there a plugin to do this?
If not, here is my thought process:
Data Sample
Scenario # Result Time
1 .2 1
1 .1 2
1 .5 3
1 .6 4
2 .2 1
2 .9 2
Calculations
I would start by taking all the data at time 1 (scenarios 1, 2, and all the rest), then performing calculations to find the mean, 10th percentile, and 90th percentile. Repeat at time 2, 3, 4, and so on.
Graph
I want to take each of the means and put it on the graph with a somewhat smooth line connecting them. (Ideas on how to do this are welcomed) This is down over time. So X axis is time while y axis is Result.
Is there an easy tool to do this, or is it best to just setup spreadsheets and do this? I'm avoiding packages like R, Matlab, etc. because I'm not yet sure if this is a 1-time project I'm working on, or if this will become the norm. (This is for work, not school)
Is there a plugin to do this?
If not, here is my thought process:
Data Sample
Scenario # Result Time
1 .2 1
1 .1 2
1 .5 3
1 .6 4
2 .2 1
2 .9 2
Calculations
I would start by taking all the data at time 1 (scenarios 1, 2, and all the rest), then performing calculations to find the mean, 10th percentile, and 90th percentile. Repeat at time 2, 3, 4, and so on.
Graph
I want to take each of the means and put it on the graph with a somewhat smooth line connecting them. (Ideas on how to do this are welcomed) This is down over time. So X axis is time while y axis is Result.
Is there an easy tool to do this, or is it best to just setup spreadsheets and do this? I'm avoiding packages like R, Matlab, etc. because I'm not yet sure if this is a 1-time project I'm working on, or if this will become the norm. (This is for work, not school)