Normalization

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two lots of figures (2 indices, monthly figures, over 10 years). I want to put them into an excel graph and normalise them so they start from the same point. Any ideas please?
 
If all you want to do is have the two indices start with the same
value, subtract the difference between the the starting values of the
two from the larger valued index. Do this subtraction for all values
of that index.

Alternatively, you might want to consider making it easier to compare
the indices across time. Compute the % change year-over-year and plot
that. Then, the starting value for each index will be 100.

Or, you could plot the % change from the starting value for the two
indices.

Or, you could come up with some other comparison basis that appeals to
you.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top