Print
User's Guide
Preparing data for analysis
Transform functions
Useful Microsoft Excel functions for transforming data.
Transform
Excel function
Natural log
=LN(
cell
)
Inverse natural log
=EXP(
cell
)
Reciprocal
=1 /
cell
Square root
=SQRT(
cell
)
Power
=
cell
^
power
Log base 10
=LOG(
cell
) or =LOG10(
cell
)
Inverse log base 10
=10^
cell
Log base 2
=LOG(
cell
, 2)
Inverse log base 2
=2^
cell
Related tasks
Transforming variables
What is Analyse-it?
What's new?
Administrator's Guide
User's Guide
Getting to know Analyse-it
Preparing data for analysis
Datasets
Variables
Measurement scales
Missing values
Case and frequency form data
Setting the measurement scale of a variable
Setting the minimum, maximum and units of a variable
Ordering categorical data
Setting the number format of a variable
Labeling cases
Assigning labels to categories
Assigning colors/symbols to categories
Transforming variables
Transform functions
Analyzing a subset of the data
Working with analyses
Feedback and crash reports
Statistical Reference Guide
Version 6.15
Published 18-Apr-2023
Products
Store
Support
Blog
About us
Download trial
Search
Sign in
Contact us
Analyse-it Software, Ltd.
The Tannery, 91 Kirkstall Road,
Leeds, LS3 1HS,
United Kingdom
Home
Products
Blog
Contact us
Privacy policy
® Copyright Analyse-it Software, Ltd. 2026.
All rights reserved.
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our
Privacy policy
.
Use essential only
Enable analytics
×
Last update 12:03:57 AM
AnalyseIt.Public 4.0.9539.36426 Production US Remote database