Aan de slagGa gratis aan de slag

Logarithmic transformations

In this chapter, you'll work with data on asteroids that are predicted to pass close to the Earth. It's good to be prepared!

Here you'll explore logarithm-transformations of data ("log" for short), which can be very useful if the values span several orders of magnitude.

  • LOG10() takes a number or cell location, and returns the log, base 10.
  • LN() does the same, with Euler's number ("e") as the base.

Deze oefening maakt deel uit van de cursus

Intermediate Google Sheets

Cursus bekijken

Oefeninstructies

  • In column H, rescale the nominal geocentric distance ("distance from Earth") in column C to astronomical units by dividing by the value in B14.
  • In column I, take a log 10 transformation of these numbers.
  • In column J, take the natural log of the numbers in column H.

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen