We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 5
  5. Discussions

Weather Observation Station 5

  • oraibymohand
     + 1 comment

    To calc the median..

    EX: (2 4 5) 6 (7 8 10) 

       1  2 3  4  5  6  7  (the order from small to big 1..2..3....) we got 7 numbers
          The median = 6 which is Number 4  in ascending order
            How we get number 4? it is (7+1)/2 ....so if the number was odd 
            the median  will be number=(n+1)/2 which n is the count in asc order...if you counted the dataset it will be 499...(499+1)/2=250 
            so the data which number is 250  is the median