Average based on importance level from 1-9

[krishnakumar0206]

Good morning All,

I'm trying to get an average percentage (or) number based on the importance level (1-9)
example,

total Importance level
30 1
15 2
22 3
10 4
78 5
90 6
40 7
88 8
91 9

 

[Abdmujib]

Can you elaborate on what you want to achieve and make your question clearer

 

[krishnakumar0206]

importance Level 1-9 is based on spend - 1 being likely, and 9 confirmed spend
from the above example 30 will be likely to be spent and 91 is confirmed spend, I have 10 more task in the same structure and wanted to calculate whats the average for each task

 

[Abdmujib]

I am sorry. I still didn't get what you wanted. Can you solve that manually and poat the picture in order to understand what you want to automate.

 

[awoohaw]

ARe the weights to be applied linearly? (is 9 nine times more likely to happen than 1?, is 5 five times more like to happen than 1?

 

[Abdmujib]

importance Level 1-9 is based on spend - 1 being likely, and 9 confirmed spend
from the above example 30 will be likely to be spent and 91 is confirmed spend, I have 10 more task in the same structure and wanted to calculate whats the average for each task

Is it something like this you want?