LoslegenKostenlos starten

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.

Diese Übung ist Teil des Kurses

<Kurs>Google Sheets: Fortgeschrittene Funktionen</Kurs>
Kurs ansehen

Übungsanweisungen

  • 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.

Interaktive praktische Übung

Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis

Übung starten