Statistical tools in Excel

[AgaBoogaBoo]

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)

 

[AgaBoogaBoo]

For what it's worth, I found it easier to manipulate the data just in Excel. I ran into a hurdle and the description is below.

Because I have a scenario number and time that I was dealing with, I eventually went to use vlookups to find the result based on scenario and time. When I did that, I realized I couldn't do 2 vlookups at once, so the little trick that might come in handy for others who come across this thread is to create a "concatenated" column after that data. It should contain the scenario, a dash, then the time. With this, you can do vlookups quite easily for both variables at once and get the result. The reason there is a dash is to separate scenario 3 time 39 from scenario 33 time 9. Otherwise both concatenations result in 339.