MIS lect excel.xlsx - Arithmetic Functions Random Serial...

Arithmetic Functions:
Random Serial Number Random Between Sum Average Count
0.9769974 1 86 387 48.375 8
0.2084956 2 14
0.5313813 3 64
0.2363869 4 90
0.4021892 5 22
0.6265133 6 14
0.1908725 7 26
0.7722732 8 15
387
12 7.2142857143
Notes:
Alt+I+C: Adds a column
To find the forecast for the
12th month:
R
0
50
100
150
200
250
300
350

Product Sumproduct Weighted Average Quotient Remainder
353288 1511 41.9722222222 912 344 356153.35
Random Serial Number Random Between
Row 10
Row 9
Row 8
Row 7
Row 6
Row 5
Row 4

INT ABS ROUND CEILING FLOOR FACT
-345 344.56 -344.6 -300 -400 20922789888000
Parameter1 Parameter2
41 349
10 120
17 263
88 116
70 228
CORRELATION STD DEV RANKING
-0.3701903388 33.25958508 5

Number -344.56

Top 10 movies of Hollywood of 2016 so far
Serial Number Movies IMDB Score WW BO Score
1 Avatar 7.9
760 6004
2 Titanic 7.7
658 5066.6
3 Star Wars: The Force Awakens 8.2
936 7675.2
4 Jurassic World 7
652 4564
5 The Avengers 8.1
623 5046.3
6 Furious 7 7.2
350 2520
7 Avengers: Age of Ultron 7.5
458 3435
8 8.1
380 3078
9 Frozen 7.6
400 3040
10 7.2
408 2937.6
Harry Potter and the Deathly Hallows: Part
2
Iron Man 3

Rank Sum of the top 10 grossing movies: 5625
2
Average of top 10 movies: 562.50
3
1
Max BO amongst top 10 936
5
Min BO amongst top 10 350
4
10
Max IMDB Score 8.2
6
Min IMDB Score 7
7
8
Correlation between IMDB score & BO 0.4519889828
9

Text Functions
CASE FUNCTIONS
First Name Surname Name (Concatenation) Upper Case Lower Case
Gayatri Sawant Ms. Gayatri Sawant GAYATRI gayatri
Jane Doe Ms. Jane Doe JANE jane
Adam Smith Mr. Adam Smith ADAM adam

Proper Length Lef Right Replace
Gayatri 18 Gaya atri AAyatri
Jane 12 Jane ne AAne
Adam 14 Adam am AAam

DATE FUNCTIONS
Substitute DOB Age Years Days
Gayatri 3/24/1990 28.43 28 158
Jane 5/6/1982 36.32 36 117
Adam 2/3/1977 41.58 41 210 5 93
First B'day 210
Years 5Days93
5 Years and 93 Days
5 93
Difference between ages of
Jane and Adam