開始使用免費開始

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.

本練習屬於課程

Google Sheets 中級

檢視課程

練習說明

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

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習