Common data transformations

Intermediate Google Sheets

Richie Cotton

Data Evangelist at DataCamp

Caterpillar to butterfly

Logarithmic & exponential transformations (1)

	A	B	C
1	Value	Command	Result
2	1234567890	=LOG10(A2)	9.091514977
3		=10 ^ C2	1234567890

Logarithmic & exponential transformations (2)

	A	B	C
1	2.718281828	=LN(A1)	1
2		=EXP(C1)	2.718281828

Square root transformations

	A	B	C
1	144	=SQRT(A1)	12
2		=B1 ^ 2	144

Summary

• LOG10() and LN() perform logarithmic transformations.
• 10 ^ x and EXP() perform exponential transformations.
• SQRT() performs square root transformations.

Let's practice!

Intermediate Google Sheets