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?

[Dave H9]

Hi cyberbabes,

If you post an example worksheet we will be able to help you out.

Dave H

[cyberbabes]

Hi
Here I do have an example worksheet. Don't know if it gives you enough information. In the first table you can see the original data that we got from the database (number of damages, average of damages and average of horsepowers), and a different column for each year (2000-2005). Our problem will be to find out what will happen to the average of damages IF the average of horsepowers increase by 5% or decrease by 5%

Oppgave 4a)

Scenario 1 2000 2001 2002 2003 2004 2005 Økning
Number of damages 10991 10902 10679 11377 11852 12146 1155
Average of damages 0,028 0,028 0,027 0,027 0,026 0,026 -0,0016
Number of Horsepowers 31996053 34274441 37734259 43042056 47521936 50807396 18811343
Average of horsepowers 80 88 95 101 105 109 29
Average of damages/average of horsepowers 0,000343511 0,00031808 0,000283005 0,000264323 0,000249401 0,00023906 -0,00006

Horsepowers
Reduction in % growth factor 2000 2001 2002 2003 2004 2005
5 % 0,95 Increase 84,27 92,01 99,62 105,77 110,37 114,03
Increase in % Reduction 76,24 83,25 90,13 95,70 99,86 103,17
5 % 1,05

Average of damages if increase by 5% Average of damages if reduction by 5%
2000 0,029 2000 0,0262
2001 0,029 2001 0,0265
2002 0,028 2002 0,0255
2003 0,028 2003 0,0253
2004 0,028 2004 0,0249
2005 0,027 2005 0,0247

[Dave H9]

Can you post the actual sample data with the formula you are using at present. Use the "Go Advanced button at the bottom of the Quick Reply box then manage attachments.

Just finding it difficult from just looking at your post.

Cheers

Dave H