VBA/UDF to find real roots of a 6th degree polynonial equation.

Curious_george

New Member
Joined
Nov 19, 2016
Messages
1
Can anyone please help me or point me in a direction? I am trying to find the real roots of the equation below using VBA/UDF in excel. Thanks in advance. Equation: y= x6 - 7x5 + 4x4 - 14x3 + 12x2 - 5x + 23 = 0
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,007
In general, you have to use numerical methods to find roots of a 6th order polynomial -- unless you can somehow factor the polynomial into cubic / quadratic equations. Good ideas include
roots - Solving a 6th degree polynomial equation - Mathematics Stack Exchange
Roots of polynomial of degree 6 - Mathematics Stack Exchange
and
How to solve an nth degree polynomial equation - Mathematics Stack Exchange


Can anyone please help me or point me in a direction? I am trying to find the real roots of the equation below using VBA/UDF in excel. Thanks in advance. Equation: y= x6 - 7x5 + 4x4 - 14x3 + 12x2 - 5x + 23 = 0
 

Watch MrExcel Video

Forum statistics

Threads
1,099,515
Messages
5,469,086
Members
406,633
Latest member
JamesVN

This Week's Hot Topics

Top