Scenarios what if analyzes in Excel

[cyberbabes]

Hi
We are having an home exam about PowerPivot, databases and excel. We have got a database from an insurance company, and we are trying to figure out what will happen to the average of the damages (the company sells car-insurances) when the average of horsepowers increase by 5% - also another scenario with -5%. This is because we can clearly see a connection between the number of damages and how fast ppl drive.

Our problem though is that we can't seem to figure out how to use the scenario manager in Excel "What if analyze". Could anybody help us please?

 

[powerpivotpro]

Hi there. I did an example similar to this in my book, but you can search my blog for the terms "disconnected slicers" and "parameters"

Here's one post that is similar to what you are looking for but actually more complicated than your need:

Dynamic TopN Reports via Slicers, Part 2 « PowerPivotPro