© 2014 Pacific Crest
239
book build your heuristics, helping you select which ideas and techniques are most appropriate for a
given quantitative reasoning challenge.
Tables for Heuristics
Experience 1.3
Best Practices in Learning Mathematics
Experience 2.2
Common Fallacies
Experience 4.4
Validation of Learning and Validation of Problem Solving
Experience 5.4
Transforming Data
Experience 6.2
Translating Between Symbolic, Numerical, and Graphical Representations
Experience 6.3
Graphical Analysis
R
eadings
R
esources
S
trategies
T
ransforming
D
ata
Technique
A
ccum
T
otal
Category
Ease of Use
New Attribute
➌
Description
The summation of values across the rows
Benefits
Limitations
Can see how the total looks as we continue to sum
the numbers
Hard to see the contribution of each individual value
to the total
Tool
Accumsum
Application
Seeing the total production over time
Example
Accsum(“rev”)
Technique
I
ndexing
Category
Ease of Use
New Attribute
➋
Description
Weighting of multiple variables into a single index
Benefits
Limitations
Being able to use a single variable as an indicator of
measurement
Lose the information on contribution of each variable
to the total index
Tool
Math formula
Application
CPI, Stock Market indices
Example
Prodindex=(3*var1 + 2*var2 + 5*var3)/10
5.4 Transforming Data