Share

Modular Arithmetic Visually Explained

Raven62's avatar - binary
In response to ranman17

I Agree!

In mathematics, modular arithmetic is a system of arithmetic for integers, where numbers "wrap around" upon reaching a certain value the modulus (plural moduli).

The MOD function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the MOD function can be entered as part of a formula in a cell of a worksheet.

reddog's avatar - reddog 20avatar.jpg

I made thru 17 minutes of the video and it reminded me of why I dropped out of Algebra 2 !! Oh, man, my brain is fried .  Crazy

pavizlo$'s avatar - Lottery-038.jpg

Using modulo function on pick3 game would be mod(10) since there are 10 numbers. On your data manipulation any result that is greater than 9 will wrap around. For example: pick3 lotto math for addition 6+7=3. To do this in excel using modulo function would be =mod((6+7),10)

The same concept  can be applied to any lotto game. Another example using pick5  from a poll of 36 numbers would be =mod((x+y),36). Thus if x+y>36 ,the result will wrap around.

TopEnd of thread (1 page)

Welcome Guest

Your last visit: Sat, Nov 28, 2020, 7:44 pm

Log In

Log InCancel

Forgot your username?

Forgot your password?