Roll Of Dice

50 %
50 %
Information about Roll Of Dice

Published on March 5, 2008

Author: sarbashrestha

Source: slideshare.net

Description

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

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

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

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

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

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

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

This is how my months are going to be.. ../.. Panda

This is how my months are going to be.. ../.. Panda

Add a comment

Related presentations

Related pages

RANDOM.ORG - Dice Roller

This page allows you to roll virtual dice using true randomness, which for many purposes is better than the pseudo-random number algorithms typically used ...
Read more

Roll of the Dice: Amazon.de: Musik

Mit Amazon Prime haben Sie Zugriff auf über eine Million Songs, ausgewählte Playlists und Ihr ganz persönliches Radio. Unbegrenzt und ohne Werbung.
Read more

Roll of the Dice

“Roll the Dice is an excellent way to learn about disparities in social and economic outcomes. It is fun, informative and accessible. John-Paul Chaisson ...
Read more

Roll Dice Online

A free online random number generator or dice simulator. Roll any number of dice with any number of sides.
Read more

Roll-the-dice in Maisach Landkreis Fürstenfeldbruck

Roll-the-dice, Maisach Tabletop, Brettspiele, Familien- und Gesellschaftsspiele
Read more

Roll of the dice Synonyms, Roll of the dice Antonyms ...

Synonyms for roll of the dice at Thesaurus.com with free online thesaurus, antonyms, and definitions. Dictionary and Word of the Day.
Read more

Roll of the Dice - Wikipedia, the free encyclopedia

Roll of the Dice is a 1995 studio album by Texas based blues rock band The Fabulous Thunderbirds, their second without Jimmie Vaughan. Track listing "Roll ...
Read more

A Roll of the Dice|Pokemon TCG Strategy, Tip and Tricks

Hello again, A Roll of the Dice readers! It’s been a long time, but I’m back again to talk about my experience at the 2015 U.S. National Championships.
Read more

Dice - Wikipedia, the free encyclopedia

Hence, 6d8 means the player should roll six eight-sided dice and add the results. Modifiers to a die roll can also be indicated as desired.
Read more

dict.cc Wörterbuch :: to roll the dice :: Deutsch ...

Englisch-Deutsch-Übersetzung für to roll the dice im Online-Wörterbuch dict.cc (Deutschwörterbuch).
Read more