새 UI(Beta)를 사용 중입니다.기존 UI로 돌아가기

이 페이지는 기계 번역으로 자동 번역되었습니다. 번역이 정확하지 않을 수 있으니 양해 부탁드립니다.

keisan일상생활과 업무에 도움이 되는 고정밀 계산 사이트
로그인|회원가입

엑셀에서 4차 방정식 계산하기

작성자: kegasa 님실행 횟수: 816
TOP/모두가 만든 공식 (수학)/일반 수학

※ 이 라이브러리는 회원이 작성한 작품입니다. 본 사이트는 그 내용에 대해 관여하지 않습니다.

북마크 관리
엑셀 셀에 복사하기만 하면 4차 방정식의 근을 구할 수 있는 공식
x1 = -1*b2/4 + (sqrt(2*(2*sqrt(((b5 - b2*b4/4 + b2^2*b3/16 - 3*b2^4/256)/3) + (b3 - 3*b2^2/8)^2/36)*cos(acos(((b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/12+((b4+b2^3/8-b2*b3/2)^2-4*(b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256))/16+(b3-3*b2^2/8)^3/216)/sqrt(-1*(-((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)-(b3-3*b2^2/8)^2/36)^3))/3)+(b3-3*b2^2/8)/6)-(b3-3*b2^2/8))+sqrt(-(2*(2*sqrt(((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36)*cos(acos(((b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/12+((b4+b2^3/8-b2*b3/2)^2-4*(b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256))/16+(b3-3*b2^2/8)^3/216)/sqrt(-1*(-((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)-(b3-3*b2^2/8)^2/36)^3))/3)+(b3 - 3*b2^2/8)/6) + (b3 - 3*b2^2/8)) - 2*(b4 + b2^3/8 - b2*b3/2)/sqrt(2*(2*sqrt(((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36)*cos(acos(((b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/12+((b4+b2^3/8-b2*b3/2)^2-4*(b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256))/16+(b3-3*b2^2/8)^3/216)/sqrt(-1*(-((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)-(b3 - 3*b2^2/8)^2/36)^3))/3)+(b3 - 3*b2^2/8)/6)-(b3 - 3*b2^2/8))))/2;
print(x1);

x2 = -1*b2/4 + (sqrt(2*(2*sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3) + (b3-3*b2^2/8)^2/36))*cos(acos(((b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/12+((b4+b2^3/8-b2*b3/2)^2-4*(b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256))/16+(b3-3*b2^2/8)^3/216)/sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36)^3))/3)+(b3-3*b2^2/8)/6)-(b3-3*b2^2/8))-sqrt(-(2*(2*sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36))*cos(acos(((b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/12+((b4+b2^3/8-b2*b3/2)^2-4*(b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256))/16+(b3-3*b2^2/8)^3/216)/sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36)^3))/3)+(b3-3*b2^2/8)/6)+(b3-3*b2^2/8))-2*(b4+b2^3/8-b2*b3/2)/sqrt(2*(2*sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36))*cos(acos(((b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/12+((b4+b2^3/8-b2*b3/2)^2-4*(b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256))/16+(b3 - 3*b2^2/8)^3/216)/sqrt((((b5 - b2*b4/4 + b2^2*b3/16 - 3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36)^3))/3)+(b3-3*b2^2/8)/6)-(b3-3*b2^2/8))))/2;
print(x2);

x3 = -1*b2/4 - (sqrt(2*(2*sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3) + (b3-3*b2^2/8)^2/36))*cos(acos(((b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/12+((b4+b2^3/8-b2*b3/2)^2-4*(b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256))/16+(b3-3*b2^2/8)^3/216)/sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36)^3))/3)+(b3-3*b2^2/8)/6)-(b3-3*b2^2/8))+sqrt(-(2*(2*sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36))*cos(acos(((b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/12+((b4+b2^3/8-b2*b3/2)^2-4*(b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256))/16+(b3-3*b2^2/8)^3/216)/sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36)^3))/3)+(b3-3*b2^2/8)/6)+(b3-3*b2^2/8))+2*(b4+b2^3/8-b2*b3/2)/sqrt(2*(2*sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36))*cos(acos(((b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/12+((b4+b2^3/8-b2*b3/2)^2-4*(b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256))/16+(b3-3*b2^2/8)^3/216)/sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36)^3))/3)+(b3-3*b2^2/8)/6)-(b3-3*b2^2/8))))/2;
print(x3);

x4 = -1*b2/4 - (sqrt(2*(2*sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36))*cos(acos(((b3-3*b2^2/8)*(b5 - b2 * b4 / 4 + b2^2 * b3 / 16 - 3 * b2^4 / 256) / 12 + ((b4 + b2^3 / 8 - b2 * b3 / 2)^2 - 4 *(b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256))/16+(b3-3*b2^2/8)^3/216)/sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36)^3))/3)+(b3-3*b2^2/8)/6)-(b3-3*b2^2/8))-sqrt(-(2*(2*sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36))*cos(acos(((b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/12+((b4+b2^3/8-b2*b3/2)^2-4*(b3-3*b2^2/8)*(b5-b2*b4/4+b2^2*b3/16-3*b2^4/256))/16+(b3-3*b2^2/8)^3/216)/sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2^4/256)/3)+(b3-3*b2^2/8)^2/36)^3))/3)+(b3-3*b2^2/8)/6)+(b3-3*b2^2/8))+2*(b4+b2^3/8-b2*b3/2)/sqrt(2*(2*sqrt((((b5-b2*b4/4+b2^2*b3/16-3*b2
b2
b3
b4
b5
x1 
x2 
x3 
x4 
엑셀로 4차 방정식 계산하기 - 메모
http://math7755.s1010.xrea.com/Quartic_Equation/Quartic_equation1.htm

이 계산에 대한 고객 피드백이 아직 없습니다.