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. 2024.
All rights reserved.
MSA (Measurement System Analysis) software
Measurement System Analysis software
Reference interval software
ROC curve software
Sensitivity & Specificity analysis software
Method comparison software
Bland-Altman software
Deming regression software
Passing Bablok software
Method Validation software
Statistical Process Control (SPC) statistical software
SPC software
Six Sigma statistical software
Excel SPC addin
Excel Statistical Process Control (SPC) add-in
Pareto plot software software for Excel
Pareto plot add-in software for Excel
Pareto chart add-in software for Excel
Control chart Excel add-in
Process Capability statistical software
Capability Analysis add-in software
Principal Component analysis addin software
Excel PCA add-in
Excel ANOVA add-in
ANCOVA software
Multiple Regression analysis add-in software
Multiple Linear Regression statistical software
Excel model fitting software
Excel statistics analysis addin software
Excel statistical analysis addin software
Statistics software
Statistical analysis software
Last update 5:00:47 PM
AnalyseIt.Public 4.0.9096.31831 Production US Remote database