커뮤니티

부탁드립니다.

프로필 이미지
yes
2021-04-01 16:54:06
915
글번호 147608
답변완료
도움에 감사 드립니다. 수식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);
지표
답변 1
프로필 이미지

예스스탁 예스스탁 답변

2021-04-01 17:21:28

안녕하세요 예스스탁입니다. input : P(11); var : cnt(0),LL(0),HH(0),a(0),ai(0),b(0),bi(0); LL = Lowest(L,P); HH = highest(H,P); ai = -1; bi = -1; For cnt = 0 to P-1 { if ai == -1 and L[cnt] == LL Then { ai = cnt; } if bi == -1 and H[cnt] == HH Then { bi = cnt; } } a = 100*((P-1)-((ai)))/(P-1); b = 100*((P-1)-((bi)))/(P-1); var1 = a-b; Plot1(var1); 즐거운 하루되세요 > yes 님이 쓴 글입니다. > 제목 : 부탁드립니다. > 도움에 감사 드립니다. 수식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);