Lecture 1 MIS-Arithmatic.xlsx - Chart Title 100 90 80 70 60 50 40 30 20 10 0 1 2 3 4 Random Between 5 Sum 6 7-344.56 int abs Round ceiling floor-345

Lecture 1 MIS-Arithmatic.xlsx - Chart Title 100 90 80 70 60...

This preview shows page 1 - 108 out of 108 pages.

1 2 3 4 5 6 7 0 10 20 30 40 50 60 70 80 90 100 Chart Title Random Between Sum
Image of page 1
-344.56 int -345 abs 344.56 Round -344.6 ceiling -340 floor -350 factorial 720 Movie IMDB score Score suicide squad 6.8 287.42 1954.456 sausage party 6.9 83.15 573.735 imperium 6.5 76.45 496.925 rings 6.3 72.01 453.663 now you see me 2 6.6 65.03 429.198 don’t breathe 7.8 35.42 276.276 war dogs 7.3 30.51 222.723 kubo and the two strings 8.4 27.86 234.024 ben hur 5.6 20.69 115.864 mechanic 6.00 10.14 60.84 Box office collection(million dollars)
Image of page 2
correlation how much the value is away from ar Rank sum of top 10 grossing movies 708.68 1 Avg of top 10 grossing movies 70.868 2 Max bo 287.42 3 Min Bo 10.14 4 5 max imdb 8.4 6 min imdb 5.6 8 7 correlation btn imdb and bo -0.025668407 9 10 standard deviation
Image of page 3
Parameter 1 Parameter 2 48 79 1 Rank 49 74 17 77 12 65 38 74 39 71 50 73 0.577007867 13.1003453244
Image of page 4
1 2 3 4 1 Random Count 0.976997409 1 Random Between Sum 0.2084955731 1 6 6.976997409 0.5313813332 1 14 14.2084955731 0.2363868819 1 64 64.5313813332 0.4021892212 1 90 90.2363868819 0 22 22.4021892212 14 14 26 26 36 36 45 274.3554504185 46 85 Lecture 2
Image of page 5
5 6 7 8 9 10 Average Count Product product Serial Number Sumproduct 3.4884987045 4 24.33925 6 1 297.69350491 7.1042477866 4 100.9407 40 2 32.2656906666 4 2082.15 3 45.118193441 4 4071.303 54 4 11.2010946106 4 250.929 5 14 3 196 6 113.1777252093 3 2942.621 7 Quotient 2 36 8 1 9 10 11 12
Image of page 6
11 12 13 14 15 16 17 18 19 Weighted Average Forecast 0.1661189859 12 348.6874
Image of page 7
20 21 22 23 24 25 26 27 28 29
Image of page 8
30 31 32 33 34 35 36 37 38 39
Image of page 9
40 41 42 43 44 45 46 47 48 49
Image of page 10
50 51 52 53 54 55 56 57 58 59
Image of page 11
60 61 62 63 64 65 66 67 68 69
Image of page 12
70 71 72 73 74 75 76 77 78 79
Image of page 13
80 81 82 83 84 85 86 87 88 89
Image of page 14
90 91 92 93 94 95 96 97 98 99
Image of page 15
100 101 102 103 104 105 106 107 108 109
Image of page 16
110 111 112 113 114 115 116 117 118 119
Image of page 17
120 121 122 123 124 125 126 127 128 129
Image of page 18
130 131 132 133 134 135 136 137 138 139
Image of page 19
140 141 142 143 144 145 146 147 148 149
Image of page 20
Image of page 109

You've reached the end of your free preview.

Want to read all 108 pages?

  • Summer '17
  • Rusha Das
  • 175, box office collection, correlation btn imdb, Max bo

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture