Hi I want to do some multiplication using quarterly weights with annual data,
YEAR / Quarterly Weight / Year / Annual Figure
1960Q1, 0.243062075, 1960 , 51.81711062
1960Q2, 0.243510145 , 1961 , 57.96708711
1960Q3, 0.251873542 , 1962 , 62.98765423
1960Q4, 0.261554238 , 1963 , 68.48925534
1961Q1, 0.24091194,
1961Q2, 0.246046693,
1961Q3, 0.250768104,
1961Q4, 0.262273263,
To illustrate:
For 1960Q1, I want to get 0.243062075*51.81711062
For 1960Q2, I want to get 0.243510145*51.81711062
For 1960Q3, I want to get 0.251873542*51.81711062 ...
Can someone tell me how to do this in excel? Any help will be appreciated!!
Thanks!
Bookmarks