Get startedGet started for free

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.

This exercise is part of the course

Intermediate Google Sheets

View Course

Exercise instructions

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

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise