답변완료
부탁드립니다.
도움에 감사 드립니다.
수식1)은 Low와 high값이 10개
수식2)은 Low와 high값이 20개
수식3)은 Low와 high값이 30개를 이용한 값을 구하고 있지만
Low와 high값을 10~300개(외부변수n을 이용하여)를 이용한 값을 구하고 싶습니다.
"for cnt = 1 to n"문과 같은 예와같이 간단히 줄여 작성이 가능하지요?
수식1)
var:a(0),b(0);
a=100*(10-((
IFf(l ==lowest(l,11),0,
IFf(l[1]==lowest(l,11),1,
IFf(l[2]==lowest(l,11),2,
IFf(l[3]==lowest(l,11),3,
IFf(l[4]==lowest(l,11),4,
IFf(l[5]==lowest(l,11),5,
IFf(l[6]==lowest(l,11),6,
IFf(l[7]==lowest(l,11),7,
IFf(l[8]==lowest(l,11),8,
IFf(l[9]==lowest(l,11),9,10)))))))))))))/10;
b=100*(10-((
IFf(h ==highest(h,11),0,
IFf(h[1]==highest(h,11),1,
IFf(h[2]==highest(h,11),2,
IFf(h[3]==highest(h,11),3,
IFf(h[4]==highest(h,11),4,
IFf(h[5]==highest(h,11),5,
IFf(h[6]==highest(h,11),6,
IFf(h[7]==highest(h,11),7,
IFf(h[8]==highest(h,11),8,
IFf(h[9]==highest(h,11),9,10)))))))))))))/10;
var1=b-a
Plot1(var1);
수식2)
var:a(0),b(0);
a=100*(20-((
IFf(l ==lowest(l,21),0,
IFf(l[1]==lowest(l,21),1,
IFf(l[2]==lowest(l,21),2,
IFf(l[3]==lowest(l,21),3,
IFf(l[4]==lowest(l,21),4,
IFf(l[5]==lowest(l,21),5,
IFf(l[6]==lowest(l,21),6,
IFf(l[7]==lowest(l,21),7,
IFf(l[8]==lowest(l,21),8,
IFf(l[9]==lowest(l,21),9,
IFf(l[10]==lowest(l,21),10,
IFf(l[11]==lowest(l,21),11,
IFf(l[12]==lowest(l,21),12,
IFf(l[13]==lowest(l,21),13,
IFf(l[14]==lowest(l,21),14,
IFf(l[15]==lowest(l,21),15,
IFf(l[16]==lowest(l,21),16,
IFf(l[17]==lowest(l,21),17,
IFf(l[18]==lowest(l,21),18,
IFf(l[19]==lowest(l,21),19,20))))) ))))) ))))) ))))) )))/20;
b=100*(20-((
IFf(h ==highest(h,21),0,
IFf(h[1]==highest(h,21),1,
IFf(h[2]==highest(h,21),2,
IFf(h[3]==highest(h,21),3,
IFf(h[4]==highest(h,21),4,
IFf(h[5]==highest(h,21),5,
IFf(h[6]==highest(h,21),6,
IFf(h[7]==highest(h,21),7,
IFf(h[8]==highest(h,21),8,
IFf(h[9]==highest(h,21),9,
IFf(h[10]==highest(h,21),10,
IFf(h[11]==highest(h,21),11,
IFf(h[12]==highest(h,21),12,
IFf(h[13]==highest(h,21),13,
IFf(h[14]==highest(h,21),14,
IFf(h[15]==highest(h,21),15,
IFf(h[16]==highest(h,21),16,
IFf(h[17]==highest(h,21),17,
IFf(h[18]==highest(h,21),18,
IFf(h[19]==highest(h,21),19,20))))) ))))) ))))) ))))) )))/20;
var1=b-a
Plot1(var1);
수식3)
var:a(0),b(0);
a=100*(30-((
IFf(l ==lowest(l,31),0,
IFf(l[1]==lowest(l,31),1,
IFf(l[2]==lowest(l,31),2,
IFf(l[3]==lowest(l,31),3,
IFf(l[4]==lowest(l,31),4,
IFf(l[5]==lowest(l,31),5,
IFf(l[6]==lowest(l,31),6,
IFf(l[7]==lowest(l,31),7,
IFf(l[8]==lowest(l,31),8,
IFf(l[9]==lowest(l,31),9,
IFf(l[10]==lowest(l,31),10,
IFf(l[11]==lowest(l,31),11,
IFf(l[12]==lowest(l,31),12,
IFf(l[13]==lowest(l,31),13,
IFf(l[14]==lowest(l,31),14,
IFf(l[15]==lowest(l,31),15,
IFf(l[16]==lowest(l,31),16,
IFf(l[17]==lowest(l,31),17,
IFf(l[18]==lowest(l,31),18,
IFf(l[19]==lowest(l,31),19,
IFf(l[20]==lowest(l,31),20,
IFf(l[21]==lowest(l,31),21,
IFf(l[22]==lowest(l,31),22,
IFf(l[23]==lowest(l,31),23,
IFf(l[24]==lowest(l,31),24,
IFf(l[25]==lowest(l,31),25,
IFf(l[26]==lowest(l,31),26,
IFf(l[27]==lowest(l,31),27,
IFf(l[28]==lowest(l,31),28,
IFf(l[29]==lowest(l,31),29, 30))))) )))) )))))) ))))) ))))) ))))) )))/30;
b=100*(30-((
IFf(h ==highest(h,31),0,
IFf(h[1]==highest(h,31),1,
IFf(h[2]==highest(h,31),2,
IFf(h[3]==highest(h,31),3,
IFf(h[4]==highest(h,31),4,
IFf(h[5]==highest(h,31),5,
IFf(h[6]==highest(h,31),6,
IFf(h[7]==highest(h,31),7,
IFf(h[8]==highest(h,31),8,
IFf(h[9]==highest(h,31),9,
IFf(h[10]==highest(h,31),10,
IFf(h[11]==highest(h,31),11,
IFf(h[12]==highest(h,31),12,
IFf(h[13]==highest(h,31),13,
IFf(h[14]==highest(h,31),14,
IFf(h[15]==highest(h,31),15,
IFf(h[16]==highest(h,31),16,
IFf(h[17]==highest(h,31),17,
IFf(h[18]==highest(h,31),18,
IFf(h[19]==highest(h,31),19,
IFf(h[20]==highest(h,31),20,
IFf(h[21]==highest(h,31),21,
IFf(h[22]==highest(h,31),22,
IFf(h[23]==highest(h,31),23,
IFf(h[24]==highest(h,31),24,
IFf(h[25]==highest(h,31),25,
IFf(h[26]==highest(h,31),26,
IFf(h[27]==highest(h,31),27,
IFf(h[28]==highest(h,31),28,
IFf(h[29]==highest(h,31),29, 30))))) )))) )))))) ))))) ))))) ))))) )))/30;
var1=b-a
Plot1(var1);
2021-04-01
914
글번호 147608
지표