computing data with spreadsheets - city university of new york · 2017-08-29 · computing data...

45
Computing data with spreadsheets Example: Computing triangular numbers and their square roots. Recall, we showed 1 ` 2 `¨¨¨` n npn ` 1q{2.

Upload: others

Post on 22-Jun-2020

1 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Computing data with spreadsheetsExample: Computing triangular numbers and their square roots.

Recall, we showed 1` 2` ¨ ¨ ¨ ` n “ npn` 1q{2.

Enter the following into the corresponding cells:A1: n B1: triangle C1: sqrtA2: 1 B2: “A2*(A2+1)/2 C2: “SQRT(B2)A2: =A2+1 B2: “A3*(A3+1)/2 C3: “SQRT(B3)

The result should look like

Next, select cells A3, B3, and C3 and copy.

Finally, select cells in as many rows as you want below that, in thecolumns A, B, and C, and paste.

Page 2: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Computing data with spreadsheetsExample: Computing triangular numbers and their square roots.

Recall, we showed 1` 2` ¨ ¨ ¨ ` n “ npn` 1q{2.

Enter the following into the corresponding cells:A1: n B1: triangle C1: sqrtA2: 1 B2: “A2*(A2+1)/2 C2: “SQRT(B2)A2: =A2+1 B2: “A3*(A3+1)/2 C3: “SQRT(B3)

The result should look like

Next, select cells A3, B3, and C3 and copy.

Finally, select cells in as many rows as you want below that, in thecolumns A, B, and C, and paste.

Page 3: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Computing data with spreadsheetsExample: Computing triangular numbers and their square roots.

Recall, we showed 1` 2` ¨ ¨ ¨ ` n “ npn` 1q{2.

Enter the following into the corresponding cells:A1: n B1: triangle C1: sqrtA2: 1 B2: “A2*(A2+1)/2 C2: “SQRT(B2)A2: =A2+1 B2: “A3*(A3+1)/2 C3: “SQRT(B3)

The result should look like

Next, select cells A3, B3, and C3 and copy.

Finally, select cells in as many rows as you want below that, in thecolumns A, B, and C, and paste.

Page 4: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Computing data with spreadsheetsExample: Computing triangular numbers and their square roots.

Recall, we showed 1` 2` ¨ ¨ ¨ ` n “ npn` 1q{2.

Enter the following into the corresponding cells:A1: n B1: triangle C1: sqrtA2: 1 B2: “A2*(A2+1)/2 C2: “SQRT(B2)A2: =A2+1 B2: “A3*(A3+1)/2 C3: “SQRT(B3)

Next, select cells A3, B3, and C3 and copy.

Finally, select cells in as many rows as you want below that, in thecolumns A, B, and C, and paste.

Page 5: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Computing data with spreadsheetsExample: Computing triangular numbers and their square roots.

Recall, we showed 1` 2` ¨ ¨ ¨ ` n “ npn` 1q{2.

Enter the following into the corresponding cells:A1: n B1: triangle C1: sqrtA2: 1 B2: “A2*(A2+1)/2 C2: “SQRT(B2)A2: =A2+1 B2: “A3*(A3+1)/2 C3: “SQRT(B3)

Next, select cells A3, B3, and C3 and copy.

Finally, select cells in as many rows as you want below that, in thecolumns A, B, and C, and paste.

Page 6: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Example: Computing triangular numbers and their square roots.

Enter the following into the corresponding cells:A1: n B1: triangle C1: sqrtA2: 1 B2: “A2*(A2+1)/2 C2: “SQRT(B2)A2: =A2+1 B2: “A3*(A3+1)/2 C3: “SQRT(B3)

Next, select cells A3, B3, and C3 and copy.

Finally, select cells in as many rows as you want below that, in thecolumns A, B, and C, and paste. The spreadsheet will extrapolate foryou, and make new formulas relative to their shifted positions.

If you don’t want it toadjust part of a formulawith shifts, add a $ infront of the row number,cell number, or both:A$2, $A2, or $A$2.

Page 7: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Example: Computing triangular numbers and their square roots.

Enter the following into the corresponding cells:A1: n B1: triangle C1: sqrtA2: 1 B2: “A2*(A2+1)/2 C2: “SQRT(B2)A2: =A2+1 B2: “A3*(A3+1)/2 C3: “SQRT(B3)

Next, select cells A3, B3, and C3 and copy.

Finally, select cells in as many rows as you want below that, in thecolumns A, B, and C, and paste. The spreadsheet will extrapolate foryou, and make new formulas relative to their shifted positions.

If you don’t want it toadjust part of a formulawith shifts, add a $ infront of the row number,cell number, or both:A$2, $A2, or $A$2.

Page 8: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Geometric proof: Compare the area of the white spaces in

b

ca

bc

a

b

c a

b c

a

versus

b

ca

bc

a

b

c a

b c

a

Page 9: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Geometric proof: Compare the area of the white spaces in

b

ca

bc

a

b

c a

b c

a

versus

b

ca

bc

a

b

c a

b c

a

Page 10: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Number theorists ask: Are there integer solutions?

If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Z satisfying a2 ` b2 “ c2? Yes!32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172. . .

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Page 11: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Number theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions?

Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Z satisfying a2 ` b2 “ c2? Yes!32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172. . .

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Page 12: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Number theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Z satisfying a2 ` b2 “ c2? Yes!32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172. . .

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Page 13: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Number theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Z satisfying a2 ` b2 “ c2?

Yes!32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172. . .

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Page 14: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Number theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Z satisfying a2 ` b2 “ c2? Yes!32 ` 42 “ 52

, 52 ` 122 “ 132, 82 ` 152 “ 172. . .These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Page 15: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Number theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Z satisfying a2 ` b2 “ c2? Yes!32 ` 42 “ 52, 52 ` 122 “ 132

, 82 ` 152 “ 172. . .These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Page 16: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Number theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Z satisfying a2 ` b2 “ c2? Yes!32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172. . .

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Page 17: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Number theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Z satisfying a2 ` b2 “ c2? Yes!32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172. . .

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Page 18: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Number theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Z satisfying a2 ` b2 “ c2? Yes!32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172. . .

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.

(Don’t forget to look for the simplest solutions!!)

Page 19: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean Triples

The Pythagorean theorem says the lengths of the sides of a righttriangle satisfy the following:

a2 ` b2 “ c2c

b

a

Number theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Z satisfying a2 ` b2 “ c2? Yes!32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172. . .

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Page 20: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean TriplesNumber theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Zě0 satisfying a2 ` b2 “ c2?Yes!

32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Infinitely many?

Claim: If pa, b, cq is a Pythagorean triple, then so is pna, nb, ncqfor any n P Zě0. So, yes, but this doesn’t generate all solutions!

We call a Pythagorean triple pa, b, cq primitive if a, b, and c haveno common factors, meaning there is no d P Zą0 such that a, b,and c are all multiples of d.

Ex: (3,4,5) Non-ex: (6,8,10).

Page 21: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean TriplesNumber theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Zě0 satisfying a2 ` b2 “ c2?Yes!

32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Infinitely many?Claim: If pa, b, cq is a Pythagorean triple, then so is pna, nb, ncqfor any n P Zě0.

So, yes, but this doesn’t generate all solutions!

We call a Pythagorean triple pa, b, cq primitive if a, b, and c haveno common factors, meaning there is no d P Zą0 such that a, b,and c are all multiples of d.

Ex: (3,4,5) Non-ex: (6,8,10).

Page 22: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean TriplesNumber theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Zě0 satisfying a2 ` b2 “ c2?Yes!

32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Infinitely many?Claim: If pa, b, cq is a Pythagorean triple, then so is pna, nb, ncqfor any n P Zě0. So, yes, but this doesn’t generate all solutions!

We call a Pythagorean triple pa, b, cq primitive if a, b, and c haveno common factors, meaning there is no d P Zą0 such that a, b,and c are all multiples of d.

Ex: (3,4,5) Non-ex: (6,8,10).

Page 23: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean TriplesNumber theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Zě0 satisfying a2 ` b2 “ c2?Yes!

32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Infinitely many?Claim: If pa, b, cq is a Pythagorean triple, then so is pna, nb, ncqfor any n P Zě0. So, yes, but this doesn’t generate all solutions!

We call a Pythagorean triple pa, b, cq primitive if a, b, and c haveno common factors, meaning there is no d P Zą0 such that a, b,and c are all multiples of d.

Ex: (3,4,5) Non-ex: (6,8,10).

Page 24: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Pythagorean TriplesNumber theorists ask: Are there integer solutions? If so, are thereinfinitely many integer solutions? Do they all follow some commonpattern, or are the solutions random? etc.

Integer solutions: are there a, b, c P Zě0 satisfying a2 ` b2 “ c2?Yes!

32 ` 42 “ 52, 52 ` 122 “ 132, 82 ` 152 “ 172

These are called Pythagorean triples.

Trivial solution: a “ b “ c “ 0.(Don’t forget to look for the simplest solutions!!)

Infinitely many?Claim: If pa, b, cq is a Pythagorean triple, then so is pna, nb, ncqfor any n P Zě0. So, yes, but this doesn’t generate all solutions!

We call a Pythagorean triple pa, b, cq primitive if a, b, and c haveno common factors, meaning there is no d P Zą0 such that a, b,and c are all multiples of d.

Ex: (3,4,5) Non-ex: (6,8,10).

Page 25: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Primitive Pythagorean triples (PPTs)More examples:

p3, 4, 5q p20, 21, 29q p28, 45, 53q p5, 12, 13qp9, 40, 41q p33, 56, 65q p8, 15, 17q p7, 24, 25qp12, 35, 37q p11, 60, 61q p16, 63, 65q p48, 55, 73q

Generic even numbers are written 2k with k P Z.Generic odd numbers are written 2k ` 1 with k P Z.

Square of an even number: p2kq2 “ 2 p2k2qloomoon

int

Even!

Square of an odd number:p2k ` 1q2 “ 4k2 ` 4k ` 1 “ 2 p2k2 ` 2kq

looooomooooon

integer

`1 Odd!

Similarly, you can show that sum of evens and odds follows thepattern

` even odd

even even odd

odd odd even

Page 26: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Primitive Pythagorean triples (PPTs)More examples:

p3, 4, 5q p20, 21, 29q p28, 45, 53q p5, 12, 13qp9, 40, 41q p33, 56, 65q p8, 15, 17q p7, 24, 25qp12, 35, 37q p11, 60, 61q p16, 63, 65q p48, 55, 73q

Generic even numbers are written 2k with k P Z.Generic odd numbers are written 2k ` 1 with k P Z.

Square of an even number: p2kq2 “ 2 p2k2qloomoon

int

Even!

Square of an odd number:p2k ` 1q2 “ 4k2 ` 4k ` 1 “ 2 p2k2 ` 2kq

looooomooooon

integer

`1 Odd!

Similarly, you can show that sum of evens and odds follows thepattern

` even odd

even even odd

odd odd even

Page 27: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Primitive Pythagorean triples (PPTs)More examples:

p3, 4, 5q p20, 21, 29q p28, 45, 53q p5, 12, 13qp9, 40, 41q p33, 56, 65q p8, 15, 17q p7, 24, 25qp12, 35, 37q p11, 60, 61q p16, 63, 65q p48, 55, 73q

Generic even numbers are written 2k with k P Z.Generic odd numbers are written 2k ` 1 with k P Z.

Square of an even number:

p2kq2 “ 2 p2k2qloomoon

int

Even!

Square of an odd number:p2k ` 1q2 “ 4k2 ` 4k ` 1 “ 2 p2k2 ` 2kq

looooomooooon

integer

`1 Odd!

Similarly, you can show that sum of evens and odds follows thepattern

` even odd

even even odd

odd odd even

Page 28: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Primitive Pythagorean triples (PPTs)More examples:

p3, 4, 5q p20, 21, 29q p28, 45, 53q p5, 12, 13qp9, 40, 41q p33, 56, 65q p8, 15, 17q p7, 24, 25qp12, 35, 37q p11, 60, 61q p16, 63, 65q p48, 55, 73q

Generic even numbers are written 2k with k P Z.Generic odd numbers are written 2k ` 1 with k P Z.

Square of an even number: p2kq2 “ 2 p2k2qloomoon

int

Even!

Square of an odd number:p2k ` 1q2 “ 4k2 ` 4k ` 1 “ 2 p2k2 ` 2kq

looooomooooon

integer

`1 Odd!

Similarly, you can show that sum of evens and odds follows thepattern

` even odd

even even odd

odd odd even

Page 29: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Primitive Pythagorean triples (PPTs)More examples:

p3, 4, 5q p20, 21, 29q p28, 45, 53q p5, 12, 13qp9, 40, 41q p33, 56, 65q p8, 15, 17q p7, 24, 25qp12, 35, 37q p11, 60, 61q p16, 63, 65q p48, 55, 73q

Generic even numbers are written 2k with k P Z.Generic odd numbers are written 2k ` 1 with k P Z.

Square of an even number: p2kq2 “ 2 p2k2qloomoon

int

Even!

Square of an odd number:p2k ` 1q2 “ 4k2 ` 4k ` 1 “ 2 p2k2 ` 2kq

looooomooooon

integer

`1 Odd!

Similarly, you can show that sum of evens and odds follows thepattern

` even odd

even even odd

odd odd even

Page 30: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Primitive Pythagorean triples (PPTs)More examples:

p3, 4, 5q p20, 21, 29q p28, 45, 53q p5, 12, 13qp9, 40, 41q p33, 56, 65q p8, 15, 17q p7, 24, 25qp12, 35, 37q p11, 60, 61q p16, 63, 65q p48, 55, 73q

Generic even numbers are written 2k with k P Z.Generic odd numbers are written 2k ` 1 with k P Z.

Square of an even number: p2kq2 “ 2 p2k2qloomoon

int

Even!

Square of an odd number:

p2k ` 1q2 “ 4k2 ` 4k ` 1 “ 2 p2k2 ` 2kqlooooomooooon

integer

`1 Odd!

Similarly, you can show that sum of evens and odds follows thepattern

` even odd

even even odd

odd odd even

Page 31: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Primitive Pythagorean triples (PPTs)More examples:

p3, 4, 5q p20, 21, 29q p28, 45, 53q p5, 12, 13qp9, 40, 41q p33, 56, 65q p8, 15, 17q p7, 24, 25qp12, 35, 37q p11, 60, 61q p16, 63, 65q p48, 55, 73q

Generic even numbers are written 2k with k P Z.Generic odd numbers are written 2k ` 1 with k P Z.

Square of an even number: p2kq2 “ 2 p2k2qloomoon

int

Even!

Square of an odd number:p2k ` 1q2 “ 4k2 ` 4k ` 1

“ 2 p2k2 ` 2kqlooooomooooon

integer

`1 Odd!

Similarly, you can show that sum of evens and odds follows thepattern

` even odd

even even odd

odd odd even

Page 32: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Primitive Pythagorean triples (PPTs)More examples:

p3, 4, 5q p20, 21, 29q p28, 45, 53q p5, 12, 13qp9, 40, 41q p33, 56, 65q p8, 15, 17q p7, 24, 25qp12, 35, 37q p11, 60, 61q p16, 63, 65q p48, 55, 73q

Generic even numbers are written 2k with k P Z.Generic odd numbers are written 2k ` 1 with k P Z.

Square of an even number: p2kq2 “ 2 p2k2qloomoon

int

Even!

Square of an odd number:p2k ` 1q2 “ 4k2 ` 4k ` 1 “ 2 p2k2 ` 2kq

looooomooooon

integer

`1

Odd!

Similarly, you can show that sum of evens and odds follows thepattern

` even odd

even even odd

odd odd even

Page 33: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Primitive Pythagorean triples (PPTs)More examples:

p3, 4, 5q p20, 21, 29q p28, 45, 53q p5, 12, 13qp9, 40, 41q p33, 56, 65q p8, 15, 17q p7, 24, 25qp12, 35, 37q p11, 60, 61q p16, 63, 65q p48, 55, 73q

Generic even numbers are written 2k with k P Z.Generic odd numbers are written 2k ` 1 with k P Z.

Square of an even number: p2kq2 “ 2 p2k2qloomoon

int

Even!

Square of an odd number:p2k ` 1q2 “ 4k2 ` 4k ` 1 “ 2 p2k2 ` 2kq

looooomooooon

integer

`1 Odd!

Similarly, you can show that sum of evens and odds follows thepattern

` even odd

even even odd

odd odd even

Page 34: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Primitive Pythagorean triples (PPTs)

You try: For solutions a, b, c P ZZ to a2 ` b2 “ c2, complete thefollowing table.

a b c

even even

even odd

odd even

odd odd

Which could possibly be primitive?

Without loss of generality (WLOG), assume a is odd and b is even.(WLOG here means that sincea and b are interchangeable, wedon’t need to also consider the cases where the reverse is true)

Page 35: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Primitive Pythagorean triples (PPTs)

You try: For solutions a, b, c P ZZ to a2 ` b2 “ c2, complete thefollowing table.

a b c

even even

even odd

odd even

odd odd

Which could possibly be primitive?

Without loss of generality (WLOG), assume a is odd and b is even.(WLOG here means that sincea and b are interchangeable, wedon’t need to also consider the cases where the reverse is true)

Page 36: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Looking for more primitive Pythagorean triples (PPTs)Without loss of generality (WLOG), assume a is odd and b is even,so c is odd. (WLOG here means that sincea and b are interchangeable, we don’t

need to also consider the cases where the reverse is true)

If a2 ` b2 “ c2, then a2 “ c2 ´ b2

“ pc´ bqpc` bq.

Claims: Assume a, b, c ą 0.

1. Both c´ b and c` b are positive odd integers.

2. There are no divisors common to c´ b and c` b.

3. Both c´ b and c` b are perfect squares.Later we will talk about the uniqueness of primefactorizations. For today, assume that if

n “ ab for positive integers n, a, and b,

then there is a one-to-one correspondence between

tprime divisors of n, counting multiplicityu and

tprime divs of a, counting multu\tprime divs of b, counting multu.

Page 37: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Looking for more primitive Pythagorean triples (PPTs)Without loss of generality (WLOG), assume a is odd and b is even,so c is odd. (WLOG here means that sincea and b are interchangeable, we don’t

need to also consider the cases where the reverse is true)

If a2 ` b2 “ c2, then a2 “ c2 ´ b2 “ pc´ bqpc` bq.

Claims: Assume a, b, c ą 0.

1. Both c´ b and c` b are positive odd integers.

2. There are no divisors common to c´ b and c` b.

3. Both c´ b and c` b are perfect squares.Later we will talk about the uniqueness of primefactorizations. For today, assume that if

n “ ab for positive integers n, a, and b,

then there is a one-to-one correspondence between

tprime divisors of n, counting multiplicityu and

tprime divs of a, counting multu\tprime divs of b, counting multu.

Page 38: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Looking for more primitive Pythagorean triples (PPTs)Without loss of generality (WLOG), assume a is odd and b is even,so c is odd. (WLOG here means that sincea and b are interchangeable, we don’t

need to also consider the cases where the reverse is true)

If a2 ` b2 “ c2, then a2 “ c2 ´ b2 “ pc´ bqpc` bq.

Claims: Assume a, b, c ą 0.

1. Both c´ b and c` b are positive odd integers.

2. There are no divisors common to c´ b and c` b.

3. Both c´ b and c` b are perfect squares.Later we will talk about the uniqueness of primefactorizations. For today, assume that if

n “ ab for positive integers n, a, and b,

then there is a one-to-one correspondence between

tprime divisors of n, counting multiplicityu and

tprime divs of a, counting multu\tprime divs of b, counting multu.

Page 39: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Looking for more primitive Pythagorean triples (PPTs)Without loss of generality (WLOG), assume a is odd and b is even,so c is odd. (WLOG here means that sincea and b are interchangeable, we don’t

need to also consider the cases where the reverse is true)

If a2 ` b2 “ c2, then a2 “ c2 ´ b2 “ pc´ bqpc` bq.

Claims: Assume a, b, c ą 0.

1. Both c´ b and c` b are positive odd integers.

2. There are no divisors common to c´ b and c` b.

3. Both c´ b and c` b are perfect squares.Later we will talk about the uniqueness of primefactorizations. For today, assume that if

n “ ab for positive integers n, a, and b,

then there is a one-to-one correspondence between

tprime divisors of n, counting multiplicityu and

tprime divs of a, counting multu\tprime divs of b, counting multu.

Page 40: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Looking for more primitive Pythagorean triples (PPTs)Without loss of generality (WLOG), assume a is odd and b is even,so c is odd. (WLOG here means that sincea and b are interchangeable, we don’t

need to also consider the cases where the reverse is true)

If a2 ` b2 “ c2, then a2 “ c2 ´ b2 “ pc´ bqpc` bq.

Claims: Assume a, b, c ą 0.

1. Both c´ b and c` b are positive odd integers.

2. There are no divisors common to c´ b and c` b.

3. Both c´ b and c` b are perfect squares.Later we will talk about the uniqueness of primefactorizations. For today, assume that if

n “ ab for positive integers n, a, and b,

then there is a one-to-one correspondence between

tprime divisors of n, counting multiplicityu and

tprime divs of a, counting multu\tprime divs of b, counting multu.

Page 41: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Looking for more primitive Pythagorean triples (PPTs)Let pa, b, cq be a PPT with a, b, c ą 0. We’ve shown that c´ b andc` b are positive perfect squares with no common divisors.

Define s, t P Zą0 by

c` b “ s2 and c´ b “ t2.

TheoremPrimitive Pythagorean triples are classified by positive integers a,b, and c such that

a “ st, b “s2 ´ t2

2, and c “

s2 ` t2

2,

for odd integers s ą t ě 1 with no common factors.

You try: Exercise 5, parts (c), (d), and/or (e).

Page 42: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Looking for more primitive Pythagorean triples (PPTs)Let pa, b, cq be a PPT with a, b, c ą 0. We’ve shown that c´ b andc` b are positive perfect squares with no common divisors.Define s, t P Zą0 by

c` b “ s2 and c´ b “ t2.

TheoremPrimitive Pythagorean triples are classified by positive integers a,b, and c such that

a “ st, b “s2 ´ t2

2, and c “

s2 ` t2

2,

for odd integers s ą t ě 1 with no common factors.

You try: Exercise 5, parts (c), (d), and/or (e).

Page 43: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Looking for more primitive Pythagorean triples (PPTs)Let pa, b, cq be a PPT with a, b, c ą 0. We’ve shown that c´ b andc` b are positive perfect squares with no common divisors.Define s, t P Zą0 by

c` b “ s2 and c´ b “ t2.

TheoremPrimitive Pythagorean triples are classified by positive integers a,b, and c such that

a “ st, b “s2 ´ t2

2, and c “

s2 ` t2

2,

for odd integers s ą t ě 1 with no common factors.

You try: Exercise 5, parts (c), (d), and/or (e).

Page 44: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,

Looking for more primitive Pythagorean triples (PPTs)Let pa, b, cq be a PPT with a, b, c ą 0. We’ve shown that c´ b andc` b are positive perfect squares with no common divisors.Define s, t P Zą0 by

c` b “ s2 and c´ b “ t2.

TheoremPrimitive Pythagorean triples are classified by positive integers a,b, and c such that

a “ st, b “s2 ´ t2

2, and c “

s2 ` t2

2,

for odd integers s ą t ě 1 with no common factors.

You try: Exercise 5, parts (c), (d), and/or (e).

Page 45: Computing data with spreadsheets - City University of New York · 2017-08-29 · Computing data with spreadsheets Example:Computing triangular numbers and their square roots. Recall,