Square root transformations
There are many more mathematical transformations that you can apply to your data. In fact, it's possible to create very complex transformations by building them step-by-step.
Asteroids have roughly elliptical orbit around the sun, as shown in this image.
Using the distance from the center of the ellipse to the aphelion and the perihelion, you can can calculate the area of the orbit.
To solve this, you'll need:
この演習はコースの一部です
中級 Google Sheets
演習の手順
- In column
H, calculate the semi-major axis as the aphelion (columnF) plus perihelion (columnG), all divided by two. - In column
I, calculate the semi-minor axis as the square-root of the product of the aphelion and the perihelion. - In column
J, calculate the area as pi times the semi-major axis (columnH) times the semi-minor axis (columnI).
