MIS lect excel.xlsx - Arithmetic Functions Random Serial Number 0.9769974 1 0.2084956 2 0.5313813 3 0.2363869 4 0.4021892 5 0.6265133 6 0.1908725 7

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

This preview shows page 1 - 11 out of 22 pages.

Arithmetic Functions:RandomSerial NumberRandom BetweenSumAverageCount0.976997418638748.37580.20849562140.53138133640.23638694900.40218925220.62651336140.19087257260.7722732815387127.2142857143Notes:Alt+I+C: Adds a column To find the forecast for the 12th month:R050100150200250300350
Background image
ProductSumproductWeighted AverageQuotientRemainder353288151141.9722222222912344356153.35RandomSerial NumberRandom BetweenRow 10Row 9Row 8Row 7Row 6Row 5Row 4
Background image
INTABSROUNDCEILINGFLOORFACT-345344.56-344.6-300-40020922789888000Parameter1Parameter24134910120172638811670228CORRELATIONSTD DEVRANKING-0.3701903388 33.259585085
Background image
Background image
Number-344.56
Background image
Top 10 movies of Hollywood of 2016 so farSerial NumberMoviesIMDB ScoreWW BOScore1 Avatar7.976060042 Titanic7.76585066.63 Star Wars: The Force Awakens8.29367675.24 Jurassic World765245645 The Avengers8.16235046.36 Furious 77.235025207 Avengers: Age of Ultron7.5458343588.138030789 Frozen7.64003040107.24082937.6Harry Potter and the Deathly Hallows: Part 2Iron Man 3
Background image
RankSum of the top 10 grossing movies: 56252Average of top 10 movies:562.5031Max BO amongst top 109365Min BO amongst top 10350410Max IMDB Score8.26Min IMDB Score778Correlation between IMDB score & BO0.45198898289
Background image
Text FunctionsCASE FUNCTIONSFirst NameSurnameName (Concatenation)Upper CaseLower CaseGayatriSawantMs. Gayatri SawantGAYATRIgayatriJaneDoeMs. Jane DoeJANEjaneAdamSmithMr. Adam SmithADAMadam
Background image
ProperLengthLefRightReplaceGayatri18 GayaatriAAyatriJane12 JaneneAAneAdam14 AdamamAAam
Background image
DATE FUNCTIONSSubstituteDOBAgeYearsDaysGayatri3/24/199028.4328158Jane5/6/198236.3236117Adam2/3/197741.5841210593First B'day210Years 5Days935 Years and 93 Days593Difference between ages of Jane and Adam
Background image
Image of page 11

You've reached the end of your free preview.

Want to read all 22 pages?

  • Summer '17
  • Rusha Das
  • Gujarat, Err, Vidarbha

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture