<p>You need to <strong>rebase</strong> the oldest series, using the base from the new series. This is an example of how to do this, with annual data (same for monthly data):</p>

<p><a href="https://i.sstatic.net/FeNge.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/FeNge.png" alt="enter image description here"></a></p>

<p>So, basically, you need to find a period in which both series have an entry, compute the ratio between them, and then transform the old series using the ratio just calculated. This is how you link two series in different base years.</p>

<p>Remarks: you will have <strong>several months</strong> in which the series have values. If you have reasons to believe that the newest series is better, then I would make sense to take the <strong>earliest month</strong> in which the two have data (probably January of 2005). Nonetheless, the two series might be in fact different (e.g. sector composition or definitions vary). Compare the rate of <strong>monthly growth</strong> of both indexes for the months in which both have data (probably January 2005 to Feb 2011). Are they very different? If so, you might try to <em>adjust</em> the old series. Perhaps, there is a persistent difference, which you can account for when expanding the newest series backwards. See more <a href="https://www.google.co.uk/url?sa=t&amp;rct=j&amp;q=&amp;esrc=s&amp;source=web&amp;cd=7&amp;ved=0ahUKEwj6lfqi9PbSAhWHI8AKHZkMBscQFghMMAY&amp;url=http%3A%2F%2Fwww.reading.ac.uk%2Fssc%2Fresource-packs%2Fsadc-dvd%2F03%2520Higher%2520Level%2FModule%2520H5%2FModule%2520H5%2520Session%252007%2FModule%2520H5%2520Session%25207.doc&amp;usg=AFQjCNG0YCf0dyG356uztmTdRrYB70XXGA&amp;sig2=z30JduKgWwsWVS6RxZbqxw&amp;cad=rja" rel="nofollow noreferrer">in this document</a>.</p>

CC BY-SA 3.0
2017-03-28T17:32:23.323Z
Thanks a lot for your reply. I have computed the rebase. If possible can you please have a look at my calculations and methodology. Please find the link below.  LINK :- https://spaces.hightail.com/space/WRlEc
SOUMYAJIT RAY
CC BY-SA 3.0
2017-03-29T10:29:23.583Z
@SOUMYAJITRAY It looks fine. An alternative is to use the most of the newest series. So, just make the connection in April 2005 (row 116). Use the value in D116 to adjust earlier periods. Comparing the two series might be interesting.
luchonacho
CC BY-SA 4.0
2024-08-06T21:16:45.303Z
In this example, How can we find the year 1998 considering the base year 1997?
studentp
CC BY-SA 3.0
2017-03-27T14:47:53.930Z
2017-03-27T14:47:53.930Z
luchonacho
<p>An alternative procedure would be to extrapolate the data for the most recent time backwards at the growth rate of the first set (earlier periods). By doing this, you do not have to rebase, adjust or splice the two sets. You will have the base year of the data for the most recent years (2004-5) and also will preserve the trend growth of the data for the earlier periods.</p>

CC BY-SA 3.0
2017-09-29T14:54:18.273Z
2017-09-29T15:01:10.020Z
2017-09-29T15:01:10.020Z
london
<p>I have monthly IIP data from <strong>1996-2016</strong>. But the issue is the change of base year. For the year <strong>1996- 2011</strong> the base year is <strong>1993-94</strong> and the index is disconnected from Feb 2011. For the year 2005-2016 the base year is <strong>2004-2005</strong>.</p>

<p>I intend to use the IIP monthly index from April 1996 - March 2016 but as you can see their exists two set of different index. Can you please help suggest some technique/method so that the entire index is on the same base year of 2004-2005?</p>

<p>For your reference I have attached the data.</p>

<p>Edit: see the data and the necessary calculation <a href="https://spaces.hightail.com/space/WRlEc" rel="nofollow noreferrer">here</a>.</p>

CC BY-SA 3.0
2017-03-27T12:17:03.093Z
1) I don't see any data 2) This question would be more useful to others if you spelled out what IIP was in the first use 3) Is it really the case that the 96-11 data uses as a base year values that are not in the data (93-94)?
BKay
CC BY-SA 3.0
2017-03-28T17:31:38.950Z
The IIP numbers are for India and i have attached the excel sheet for your reference.
SOUMYAJIT RAY
<base-year>
How to handle change in base year of index?
SOUMYAJIT RAY
# How to handle change in base year of index?

(Asked by: username_0 on 2017-03-27)

I have monthly IIP data from **1996-2016**. But the issue is the change of base year. For the year **1996- 2011** the base year is **1993-94** and the index is disconnected from Feb 2011. For the year 2005-2016 the base year is **2004-2005**.

I intend to use the IIP monthly index from April 1996 - March 2016 but as you can see their exists two set of different index. Can you please help suggest some technique/method so that the entire index is on the same base year of 2004-2005?

For your reference I have attached the data.

Edit: see the data and the necessary calculation [here](https://spaces.hightail.com/space/WRlEc).

**Tags:** base-year

> **Comments:**
> **username_1**: 1) I don't see any data 2) This question would be more useful to others if you spelled out what IIP was in the first use 3) Is it really the case that the 96-11 data uses as a base year values that are not in the data (93-94)?  
> **username_0**: The IIP numbers are for India and i have attached the excel sheet for your reference.  

---

## 2 answers

### Answer by username_2 on 2017-03-27. Score: 4

You need to **rebase** the oldest series, using the base from the new series. This is an example of how to do this, with annual data (same for monthly data):

[![enter image description here](https://i.sstatic.net/FeNge.png)](https://i.sstatic.net/FeNge.png)

So, basically, you need to find a period in which both series have an entry, compute the ratio between them, and then transform the old series using the ratio just calculated. This is how you link two series in different base years.

Remarks: you will have **several months** in which the series have values. If you have reasons to believe that the newest series is better, then I would make sense to take the **earliest month** in which the two have data (probably January of 2005). Nonetheless, the two series might be in fact different (e.g. sector composition or definitions vary). Compare the rate of **monthly growth** of both indexes for the months in which both have data (probably January 2005 to Feb 2011). Are they very different? If so, you might try to *adjust* the old series. Perhaps, there is a persistent difference, which you can account for when expanding the newest series backwards. See more [in this document](https://www.google.co.uk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=7&ved=0ahUKEwj6lfqi9PbSAhWHI8AKHZkMBscQFghMMAY&url=http%3A%2F%2Fwww.reading.ac.uk%2Fssc%2Fresource-packs%2Fsadc-dvd%2F03%2520Higher%2520Level%2FModule%2520H5%2FModule%2520H5%2520Session%252007%2FModule%2520H5%2520Session%25207.doc&usg=AFQjCNG0YCf0dyG356uztmTdRrYB70XXGA&sig2=z30JduKgWwsWVS6RxZbqxw&cad=rja).

> **Comments:**
> **username_0**: Thanks a lot for your reply. I have computed the rebase. If possible can you please have a look at my calculations and methodology. Please find the link below.  LINK :- https://spaces.hightail.com/space/WRlEc  
> **username_2**: @username_0 It looks fine. An alternative is to use the most of the newest series. So, just make the connection in April 2005 (row 116). Use the value in D116 to adjust earlier periods. Comparing the two series might be interesting.  
> **username_3**: In this example, How can we find the year 1998 considering the base year 1997?  

---

### Answer by username_4 on 2017-09-29. Score: 1

An alternative procedure would be to extrapolate the data for the most recent time backwards at the growth rate of the first set (earlier periods). By doing this, you do not have to rebase, adjust or splice the two sets. You will have the base year of the data for the most recent years (2004-5) and also will preserve the trend growth of the data for the earlier periods.


---

