《EXCEL统计分析》07.4 动态数列

增长速度% 年份累计逐年 不比 环比 1993 1994=$B5-$Bs=$B5-$B4=$B5/$BS4*100=$B5/$B4*100=G5-100=5-100 1995=$B6-$B$4=$B6-$B5=$B6/$B84*100=8B6/$B5*100=G6-100=H6-100 1996=$B7-$B$4=$B7-$B6=$B7/$B$4*100=$B7/$B6*100 7-100≡H7-100 1997=$B8-$B$4=$B8-$B7=$B8/$Bs4*100=$B8/$B7*100=G8-100=H8-100 1998=$B9-$Bs4=$B9$B8=$B9/$B$4*100=$B9/$B8*100=G9-100=9-10 1999=$B10-$Bs4=$B10-$B9=$BlO/$BS4*100=$B10/$B9*100=G10-100=H10-100

年份 绝对增长量％ 发展速度％ 增长速度％ 累计 逐年 定基 环比 定基 环比 1993 － － － － － － 1994 =$B5-$B$4 =$B5-$B4 =$B5/$B$4*100 =$B5/$B4*100 =G5-100 =H5-100 1995 =$B6-$B$4 =$B6-$B5 =$B6/$B$4*100 =$B6/$B5*100 =G6-100 =H6-100 1996 =$B7-$B$4 =$B7-$B6 =$B7/$B$4*100 =$B7/$B6*100 =G7-100 =H7-100 1997 =$B8-$B$4 =$B8-$B7 =$B8/$B$4*100 =$B8/$B7*100 =G8-100 =H8-100 1998 =$B9-$B$4 =$B9-$B8 =$B9/$B$4*100 =$B9/$B8*100 =G9-100 =H9-100 1999 =$B10-$B$4 =$B10-$B9 =$B10/$B$4*100 =$B10/$B9*100 =G10-100 =H10-100 2000 =$B11-$B$4 =$B11-$B10 =$B11/$B$4*100 =$B11/$B10*100 =G11-100 =H11-100

平均发展速度% 平均增长速度% (B5/$B$4)(l/(A5-$A$4)*100=M5-100 (B6/$B$4)^(1/(A6-A$4))*100=M6-100 =(B7/$B$4)(1/(A7-$A$4))*100=M7-100 (B8/$B$4)^(1/(A8-$A$4))*100=M8-100 (B9/$B$4)^(1/(A9-$A$4))* (BI0/$Bs4)^(1/(A10-$A$4))*100=M10-100

平均发展速度％ 平均增长速度％ － － =(B5/$B$4)^(1/(A5-$A$4))*100 =M5-100 =(B6/$B$4)^(1/(A6-$A$4))*100 =M6-100 =(B7/$B$4)^(1/(A7-$A$4))*100 =M7-100 =(B8/$B$4)^(1/(A8-$A$4))*100 =M8-100 =(B9/$B$4)^(1/(A9-$A$4))*100 =M9-100 =(B10/$B$4)^(1/(A10-$A$4))*100 =M10-100 =(B11/$B$4)^(1/(A11-$A$4))*100 =M11-100