Powerball lottery

How to play

6 picks out of 69 numbers

One pick out of 26 numbers

Plan which data you will organize

• Counting frequency
• Counting frequency of powerball number
• By No1~No5 ?
• By draw?
• Any game rule change?

Extract counting from the data

• Import data by choosing csv file -> select powerball data (please download from the website)

• Go “pivot” and choose Number_1 and create pivot table (select show table and show plot)
• Store in “powerball_n1”

• You can create separate five data of power_n1 … powerball_n5 which shows frequency distribution by Number_1~Number_5.

• Collect all data(distribution) into one
• Combine -> select two data one for ‘datasets’ and the other for ‘combine with’ -> combine type ‘bind columns’
• Comined dataset as “powerball_n1_n2”
• You should do the same thing with n3, n4, n5.

• Transform->create-> total=n1+n2+n3+n4+n5

• Now you have n1~n5 counting data and total counting data!
• Let’s play with data

• Top 10 frequent numbers

• Top 10 least-frequent numbers

Click here to arrange the data

• Is this frequency the normal that we can get from the data?
• How we can evaluate this result?

Draw: 587

Probability: 5/69

Draw: 587

Probability: 5/69

You will pick Number 28?? Based on the data?

Standard for frequency?

Higher than the normal probablity

Lower than the normal probablity

Must-have numbers?

Must-not-have numbers?

Distribution of frequency

Normal distribution zone

• Rule changed

261 draw

Data process – group by

-First, to figure out your data and its structure.

X1, X2, X3, X4, … Xn

-To understand the data by X1, use the function of ‘group by’

X1, X3, X4, … Xn

group by X1 for X2

X2

No

group by X1 and X2, data size=max 69*69 (in case of powerball)

X1, X2, X3, X4, … Xn

X1

X2

X3

X4

X1, X2, X3, X4, … Xn

X1

X2

X3

X4

Filter -> we should find each variable

Need to look at one variable

How can we find the frequency of the number set?

How many of (12, 3) in the data?

Filter 12 in gathered data (tidy data) -> save draw -> ‘innerjoin’ with original data

Innerjoin saves only shared data between two data (<->antijoin)

Filter 12 in gathered data and save only data with ‘12’

Innerjoin data with ‘12’ and original gathered data with ‘draw’

6 times showing the data has (12,3)