안녕하세요 예스스탁입니다. 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 = 0; bi = 0; Condition1 = False; Condition2 = False; For cnt = 0 to P-1 { if Condition1 == False and L[cnt] == LL Then { Condition1 = true; ai = L-LL[cnt]; } if Condition2 == False and H[cnt] == HH Then { Condition2 = true; bi = H-HH[cnt]; } } a = 100*((P-1)-((ai)))/(P-1); b = 100*((P-1)-((bi)))/(P-1); Plot1(a); plot2(b); 즐거운 하루되세요 > yes 님이 쓴 글입니다. > 제목 : 부탁 드립니다. > 도움에 깊이 감사 드립니다. 수식1),수식2)와 같은 것을 통합하여 외부변수 p를 입력하는 방식으로 "For cnt = 0 to P-1" 등을 사용하여 1개의 식으로 다양한 변수를 입력 가능토록 간단히 작성 부탁 드립니다. 수식1) var:a(0),b(0); a=100*(10-(( iff(L ==Lowest(L,11),L-Lowest(L,11), IFf(L[1]==Lowest(L,11),L-Lowest(L,11)[1], IFf(L[2]==Lowest(L,11),L-Lowest(L,11)[2], IFf(L[3]==Lowest(L,11),L-Lowest(L,11)[3], IFf(L[4]==Lowest(L,11),L-Lowest(L,11)[4], IFf(L[5]==Lowest(L,11),L-Lowest(L,11)[5], IFf(L[6]==Lowest(L,11),L-Lowest(L,11)[6], IFf(L[7]==Lowest(L,11),L-Lowest(L,11)[7], IFf(L[8]==Lowest(L,11),L-Lowest(L,11)[8], IFf(L[9]==Lowest(L,11),L-Lowest(L,11)[9], L-Lowest(L,11)[10]))))) ))))) )))/10; b=100*(10-(( iff(H ==Highest(H,11),H-Highest(H,11), IFf(H[1]==Highest(H,11),H-Highest(H,11)[1], IFf(H[2]==Highest(H,11),H-Highest(H,11)[2], IFf(H[3]==Highest(H,11),H-Highest(H,11)[3], IFf(H[4]==Highest(H,11),H-Highest(H,11)[4], IFf(H[5]==Highest(H,11),H-Highest(H,11)[5], IFf(H[6]==Highest(H,11),H-Highest(H,11)[6], IFf(H[7]==Highest(H,11),H-Highest(H,11)[7], IFf(H[8]==Highest(H,11),H-Highest(H,11)[8], IFf(H[9]==Highest(H,11),H-Highest(H,11)[9], H-Highest(H,11)[10]))))) ))))) )))/10; 수식2) var:a(0),b(0); a=100*(20-(( iff(L ==Lowest(L,21),L-Lowest(L,21), IFf(L[1]==lowest(L,21),L-Lowest(L,21)[1], IFf(L[2]==lowest(L,21),L-Lowest(L,21)[2], IFf(L[3]==lowest(L,21),L-Lowest(L,21)[3], IFf(L[4]==lowest(L,21),L-Lowest(L,21)[4], IFf(L[5]==lowest(L,21),L-Lowest(L,21)[5], IFf(L[6]==lowest(L,21),L-Lowest(L,21)[6], IFf(L[7]==lowest(L,21),L-Lowest(L,21)[7], IFf(L[8]==lowest(L,21),L-Lowest(L,21)[8], IFf(L[9]==lowest(L,21),L-Lowest(L,21)[9], IFf(L[10]==lowest(L,21),L-Lowest(L,21)[10], IFf(L[11]==lowest(L,21),L-Lowest(L,21)[11], IFf(L[12]==lowest(L,21),L-Lowest(L,21)[12], IFf(L[13]==lowest(L,21),L-Lowest(L,21)[13], IFf(L[14]==lowest(L,21),L-Lowest(L,21)[14], IFf(L[15]==lowest(L,21),L-Lowest(L,21)[15], IFf(L[16]==lowest(L,21),L-Lowest(L,21)[16], IFf(L[17]==lowest(L,21),L-Lowest(L,21)[17], IFf(L[18]==lowest(L,21),L-Lowest(L,21)[18], IFf(L[19]==lowest(L,21),L-Lowest(L,21)[19], L-Lowest(L,21)[20] ))))) ))))) ))))) ))))) )))/20; b=100*(20-(( iff(H ==Highest(H,21),H-Highest(H,21), IFf(H[1]==Highest(H,21),H-Highest(H,21)[1], IFf(H[2]==Highest(H,21),H-Highest(H,21)[2], IFf(H[3]==Highest(H,21),H-Highest(H,21)[3], IFf(H[4]==Highest(H,21),H-Highest(H,21)[4], IFf(H[5]==Highest(H,21),H-Highest(H,21)[5], IFf(H[6]==Highest(H,21),H-Highest(H,21)[6], IFf(H[7]==Highest(H,21),H-Highest(H,21)[7], IFf(H[8]==Highest(H,21),H-Highest(H,21)[8], IFf(H[9]==Highest(H,21),H-Highest(H,21)[9], IFf(H[10]==Highest(H,21),H-Highest(H,21)[10], IFf(H[11]==Highest(H,21),H-Highest(H,21)[11], IFf(H[12]==Highest(H,21),H-Highest(H,21)[12], IFf(H[13]==Highest(H,21),H-Highest(H,21)[13], IFf(H[14]==Highest(H,21),H-Highest(H,21)[14], IFf(H[15]==Highest(H,21),H-Highest(H,21)[15], IFf(H[16]==Highest(H,21),H-Highest(H,21)[16], IFf(H[17]==Highest(H,21),H-Highest(H,21)[17], IFf(H[18]==Highest(H,21),H-Highest(H,21)[18], IFf(H[19]==Highest(H,21),H-Highest(H,21)[19], H-Highest(H,21)[20] ))))) ))))) ))))) ))))) )))/20; 유사한 참고 수식) (71756번의 질문과 답변 수식) 1)답변하신 수식 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); 질문수식) 수식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);