ComenzarEmpieza gratis

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.

Este ejercicio forma parte del curso

Intermediate Google Sheets

Ver curso

Instrucciones del ejercicio

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

Ejercicio interactivo práctico

Pon en práctica la teoría con uno de nuestros ejercicios interactivos

Empezar ejercicio