# Formula to Excel to Odd Number - PowerPoint

Description

Formula to Excel to Odd Number document sample

Shared by:
Categories
Tags
-
Stats
views:
30
posted:
4/23/2011
language:
English
pages:
16
Document Sample

```							1                                9
5
ODD NUMBERS

3                              7
By Ellen Lawler and Michelle Ross
Choose any odd number

Square it
Divide it by 2

What
Choose neighbouring         do
you
find
whole numbers
• I came up with the idea that there had to be a
way to investigate a series of odd numbers. I
created an excel formular for the investigating
question on odd numbers.
• Once I constructed the excel spreadsheet I could
investigate the patterns of odd numbers both
vertically and horizontally
• When investigating vertically I found numerous
patterns that led to no findings.
=IF(MOD(C3,1)=0,C3-
=A3*A3   =B3/2                         )=0,C35+1,TRU
1,TRUNC(C3,0))
NC(D35,0)+1)
On Michelle’s excel spreadsheet I initially noted
•Column B ( square it) was always odd
•Column C( divided by 2) always ended in a decimal of .5
•Column D (lower neighbouring number) was always even
•Column E (higher neighbouring number) was always odd
•Column D and E always had a variance of one

My second idea was to investigation columns in excel looking for
patterns running vertically
• Columns C,D and E all increase in a pattern which were multiples of four
e.g. 4,8,12,16,20…
• After sometime we decided to explore other
areas. This drew us back to the original question
and we paid special attention to neighbouring
numbers.

• We discovered that adding column D and E and
finding the square root of the answer gives you
the original odd number.

e.g. 40 + 41 =81    √81= 9
• We thought we had discovered the formula to always
give a result of an odd number
• By adding an even and an odd number ( that have the
difference of one) and taking the square root, you will
always end with an odd number
e.g. x + (x+ 1) = √ of = odd number
• When applying an even and an odd number (that have
the difference of one) and taking the square root the
result was not an odd number
e.g. 6 + (6+1) = √13=3.6055513
• What if you choose any odd number. Square it.
Divide it by 4. Choose neighbouring whole
numbers.
• What do you find?

• What we discovered when dividing odd
numbers by two, doesn’t apply when dividing
by four
10
2
6
EVEN NUMBERS

4        8
Choose any even number

Square it
Divide it by 4

What

Choose neighbouring         do
you
find

whole numbers
• I came up with the idea that there had to be a way to
investigate a series of even numbers. I created an excel
formula for the investigating question on even numbers.

• Once I constructed the excel spreadsheet I could
investigate patterns both vertically and horizontally

• When investigating vertically I found numerous patterns
that led to no findings.
=IF(MOD(C40,1)=0,C   =IF(MOD(C40,1)=
=A40*A40   =B40/4   40-1,TRUNC(C40,0))   0,C40+1,TRUNC(
D40,0)+1)
On Michelle’s excel spreadsheet I initially noted

•     Column B ( square it) was always even
•     Column C( divided by 4) were whole numbers
•     Column D (lower neighbouring number) had a repetitive pattern of even then odd
•     Column E (higher neighbouring number) had a repetitive pattern of even then odd
•     Column D and E always had a variance of two

My second idea was to investigate the columns created in excel
looking for pattern running vertically
• Columns C,D and E all increased by two and were odd
e.g. 3,5,7,9,11..
•After some time we decided to explore other
areas. This drew us back to the original question
and we paid special attention to neighbouring
numbers
• We discovered that by adding column D and E,
multiplying the answer by two and taking the
square root, it will take you back to the original
even number
e.g. 2 (80 + 82) = 324   √324 = 18
• We thought we had discovered the formula to always give a result of
an even number

• By adding any two numbers ( that have the difference of two)
multiply by two and taking the square root, you will always end with
an even number

e.g. 2 ( x + (x + 2)) = √of = even number

• When applying any two numbers (that have the difference of two)
multiplying by two and taking the square root, the result will always
be an even number

e.g. 2 ( 6+ (6+2)) = √20 =4.472136
• What if you choose any even number. Square it. Divide it by 2.
Choose neighbouring whole numbers

•   What do you find?

• The finding of dividing even numbers by four don’t apply to
dividing by two

```
Related docs
Other docs by whn12745
FORMULAIRE I DROITS
Formula to Calculate Adjusted Eps - PowerPoint
Floating Lien Real Estate Credit Line