Maths Related

(2)

(3)

(4)

Numbers added = 10554

Average number = 49.625

(Unfortunately I think the list regenerated several times so may not be correct)

(5)

I'm not too sure what we were supposed to expect here, due to the random input I was expecting a random answer.

Random Numbers
1:	83
2:	101
3:	104
4:	118
5:	86
6:	108

(6)

These numbers were perhaps a bit closer grouped than I would of expected from a random source of numbers.

Random Numbers 1000
1:	160
2:	190
3:	167
4:	144
5:	184
6:	155

(7)

My Three Averages (100)
55.04	50.75	43.21
The sum of the numbers on the right of the decimal point (.04,.75,.21) equals exactly 1.0 which is a nice coincidence

(8)

My Three Averages (1000)
51.99	50.82	50.50
I also ran 2000, 2500, 2750, 3000 and 10,000 through without noticing a variation of more than 4

(9)&(10)

(11)

 1, 2, 3, 4, 6, 12

1,13 (PRIME)

1, 2, 7, 14

1, 3, 5, 15

(12)

(13) 

 First 200 Prime Numbers

2 3 5 7 11 13 17 19 23 29 31 37 41 43 47 53 59 61 67 71 73 79 83 89 97 101 103 107 109 113 127 131 137 139 149 151 157 163 167 173 179 181 191 193 197 199 211 223 227 229 233 239 241 251 257 263 269 271 277 281 283 293 307 311 313 317 331 337 347 349 353 359 367 373 379 383 389 397 401 409 419 421 431 433 439 443 449 457 461 463 467 479 487 491 499 503 509 521 523 541 547 557 563 569 571 577 587 593 599 601 607 613 617 619 631 641 643 647 653 659 661 673 677 683 691 701 709 719 727 733 739 743 751 757 761 769 773 787 797 809 811 821 823 827 829 839 853 857 859 863 877 881 883 887 907 911 919 929 937 941 947 953 967 971 977 983 991 997 1009 1013 1019 1021 1031 1033 1039 1049 1051 1061 1063 1069 1087 1091 1093 1097 1103 1109 1117 1123 1129 1151 1153 1163 1171 1181 1187 1193 1201 1213 1217 1223


(14) 

1) http://primes.utm.edu/
2) http://mathworld.wolfram.com/PrimeNumber.html 
3) http://www.aaamath.com/fra63a-primecomp.html

(15) 

a) Factors are the numbers you multiply together to get another number. eg: 1, 2, 3, 4, 6 and 12 are factors of 12.

b) The multiples of a whole number are found by taking the product of any number and that whole number. eg: The multiples of 4 are 4, 8, 12, 16, 20, 24, 28, 32,...

c) A prime number is a number bigger than 1 that has no divisors other than 1 and itself. eg: 2 3 5 7 11 13 17 19 23 29 31.

d) The least common multiple is the smallest positive number that is divisible by two numbers. eg: The least common multiple of 4 and six is 12.

e) The greatest common divisor is the biggest number that divides the numbers without a remainder. eg: The greatest common divisor of 8 and 12 is 4.

f) A composite number is a number that can be divided evenly by numbers other than 1 or itself. eg: 4 can be evenly divided by 2.

g)  A twin prime is a prime number that differs from another prime number by 2. eg: 5 and 7.

(16) 

a) The MOD() function returns what is left after a number is divided by a divisor.

b) The Excel LCM() function returns the least common multiple of two or more supplied integers.

c) GCD() returns the greatest common divisor of two or more numbers. The greatest common divisor is the largest number that divides two numbers without a remainder.

d) The ROMAN() function converts a number to roman numeral.

e) The INT() function is used to round a number down to the next lowest number. 

(17) 

a) 123 = 1.23x10²

b) 56 = 5.6x10¹

c) 14,300 = 1.43x10⁴

d) 31.4 = 3.14x10¹

e) 3.1415 = 3.1415x10⁰

(18) 

To convert a random number to standard form you need to format the cell containing the number to scientific.

(19) 

Sieve of Erosthenes
	2	3	4	5	6	7	8	9	10
11	12	13	14	15	16	17	18	19	20
21	22	23	24	25	26	27	28	29	30
31	32	33	34	35	36	37	38	39	40
41	42	43	44	45	46	47	48	49	50
51	52	53	54	55	56	57	58	59	60
61	62	63	64	65	66	67	68	69	70
71	72	73	74	75	76	77	78	79	80
81	82	83	84	85	86	87	88	89	90
91	92	93	94	95	96	97	98	99	100
2, 3, 5, 7, 11, 13, 17, 19, 23, 29, 31, 37, 41, 43, 47, 53, 59, 61, 67, 71

(20)

(21)

(22)

3.141592654

(23)

B3=RANDBETWEEN(0,10)   B4=PI()*B3*B3

(24)(25)(26)
 (COMPLETE)