LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Normalize time series

How do I normalize a time series so the series starts at 100.
As per some of my clients its a common procedure to do in Bloomberg to
normalize a data series.
He says it divides by the starting level * 100, so the series starts
at 100. It would be great if some one can provide me a formula for
this.. As a example , I have historical 5 year treasury yields as
follows. I would like to know the formula to normalize this series so
it starts from 100. Appreciate your help.

10/30/2007 4.052
10/29/2007 4.045
10/26/2007 4.036
10/25/2007 3.998
10/24/2007 3.967
10/23/2007 4.055
10/22/2007 4.057
10/19/2007 4.041
10/18/2007 4.153
10/17/2007 4.211
10/16/2007 4.342
10/15/2007 4.389
10/12/2007 4.412
10/11/2007 4.371
10/10/2007 4.369
10/9/2007 4.366
10/5/2007 4.335
10/4/2007 4.207

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to normalize in excel? tzeyeh Excel Discussion (Misc queries) 1 September 7th 07 07:44 PM
Normalize score austuni Excel Worksheet Functions 2 May 31st 07 08:10 AM
Normalize Frank Excel Worksheet Functions 6 November 23rd 06 08:24 PM
Normalize frequency Knowledge001 Excel Discussion (Misc queries) 1 November 22nd 05 12:20 AM
Normalize the second pie in a pie of pie chart Judy Charts and Charting in Excel 1 January 21st 05 11:48 AM


All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"