ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

Roll Of Dice

?Download as PPT, PDF?
?
Sarbashrestha Panda
Sarbashrestha Panda

Can you predict your future based on random numbers generated. Well since i had a try because anyway i have no idea how it is going to be, the tool is excel

1 of 7
Predicting my future: Roll of dice Is it possible to predict how your life is going to turn out based on random numbers. Well since I can¡¯t anyway find my life predictable, let me see how this works. ../. Panda
1 Used excel to generate the random numbers between 1-6 Used the built in RANDBETWEEN(x,y) function where x and y are1 and 6 Inserted a column to left for date.. Generated series for a year. 366 days including today Replaced the random formulae in column B by values.. Using paste special This is because any change in the sheet was regenerating the random numbers. This could have been a problem when I did further analysis ../. Panda
2 Inserted a column on the left for month. Should help me show how a month is going to go Added the column to show a qualitative value of how the day would go 0-2 bad, 3-4 average, 5-6 good Added the cumulative column This should let me draw the line graph showing how it is going to be in the next year Now the problem is that with a cumulative score, the graph can go nowhere except northwards.. Not satisfactory Added the second Logical cumulative column A day which was not better than the previous adds a negative effect to the total cumulative score ../. Panda
This is how the cumulative graph will look like.. ../. Panda
3 Made a pivot table to filter out how each month would go.. For each month a pie chart shows the breakup of bad average and good days Derived a table (trend worksheet) to see the breakup Gave weightage to each type (9good, 3average and (-)3Bad) Added a line graph to see the trend of how the months are going to be ../. Panda
This is how my months are going to be.. ../. Panda
This is how my months are going to be.. ../. Panda

More Related Content

Roll Of Dice

  • 1. Predicting my future: Roll of dice Is it possible to predict how your life is going to turn out based on random numbers. Well since I can¡¯t anyway find my life predictable, let me see how this works. ../. Panda
  • 2. 1 Used excel to generate the random numbers between 1-6 Used the built in RANDBETWEEN(x,y) function where x and y are1 and 6 Inserted a column to left for date.. Generated series for a year. 366 days including today Replaced the random formulae in column B by values.. Using paste special This is because any change in the sheet was regenerating the random numbers. This could have been a problem when I did further analysis ../. Panda
  • 3. 2 Inserted a column on the left for month. Should help me show how a month is going to go Added the column to show a qualitative value of how the day would go 0-2 bad, 3-4 average, 5-6 good Added the cumulative column This should let me draw the line graph showing how it is going to be in the next year Now the problem is that with a cumulative score, the graph can go nowhere except northwards.. Not satisfactory Added the second Logical cumulative column A day which was not better than the previous adds a negative effect to the total cumulative score ../. Panda
  • 4. This is how the cumulative graph will look like.. ../. Panda
  • 5. 3 Made a pivot table to filter out how each month would go.. For each month a pie chart shows the breakup of bad average and good days Derived a table (trend worksheet) to see the breakup Gave weightage to each type (9good, 3average and (-)3Bad) Added a line graph to see the trend of how the months are going to be ../. Panda
  • 6. This is how my months are going to be.. ../. Panda
  • 7. This is how my months are going to be.. ../. Panda