FreakyGirl
Member
hello.
Im tring to predict what the chances are off a player getting a certain score based on their past 18 games (3 month period).
B2:B10 shows possible scores a player can get. (POSSIBLE)
C2:C10 shows how many times they got that score. (MADE)
Based on the player history A2:A10 (CHANCE) should show the % chance a player has of getting a certain score.
The formula appears to be working but I dont understand why the % are so high. Shouldnt they just add to 100?
Also, said player got a 6 more times than any other score. Shouldnt that be the highest %? Or 5 which the player had none of - shouldnt that have the lowest %?
Maybe for what im trying to do Forecast isnt what i want. Im not looking for anything fancy with trendlines & graphs, just a simple formula as shown in workbook.
Thanks in advance for the help.
FreakyGirl
Im tring to predict what the chances are off a player getting a certain score based on their past 18 games (3 month period).
B2:B10 shows possible scores a player can get. (POSSIBLE)
C2:C10 shows how many times they got that score. (MADE)
Based on the player history A2:A10 (CHANCE) should show the % chance a player has of getting a certain score.
The formula appears to be working but I dont understand why the % are so high. Shouldnt they just add to 100?
Also, said player got a 6 more times than any other score. Shouldnt that be the highest %? Or 5 which the player had none of - shouldnt that have the lowest %?
Maybe for what im trying to do Forecast isnt what i want. Im not looking for anything fancy with trendlines & graphs, just a simple formula as shown in workbook.
Thanks in advance for the help.
FreakyGirl