Can Excel Solve for y in a Power 4 Equation?

  • Context: Undergrad 
  • Thread starter Thread starter edmondng
  • Start date Start date
  • Tags Tags
    Power
Click For Summary
SUMMARY

This discussion centers on solving the power 4 equation -383^(4-y) + 408^(4-y) + 297^(4-y) - 301^(4-y) = 3.358*10^10 using Excel. The user initially attempted to use a TI89 calculator but found it inadequate. They later confirmed that Maple provided a solution of y = -0.2822793449, while another user suggested y = -0.283068 as a possible solution. The conversation highlights the limitations of certain tools and the potential for multiple solutions in polynomial equations.

PREREQUISITES
  • Understanding of polynomial equations and their properties
  • Familiarity with Excel's formula capabilities
  • Basic knowledge of numerical methods for solving equations
  • Experience with graphing calculators, specifically the TI89
NEXT STEPS
  • Research how to implement numerical methods in Excel for solving equations
  • Explore the use of Maple for polynomial equation solutions
  • Learn about the limitations of graphing calculators like the TI89
  • Investigate alternative software tools for solving complex equations, such as Python with NumPy
USEFUL FOR

Mathematicians, students, and professionals looking to solve complex polynomial equations using accessible tools like Excel, as well as those interested in comparing solutions from different software platforms.

edmondng
Messages
159
Reaction score
0
I tried TI89 and it did not work

Trying to solve for y in the following equation. I don't have a lot of software resource available to me so no matlab/mathematica/mathcad etc
I'm going try in excel if it can do it.

-383^(4-y) + 408^(4-y) + 297^(4-y) - 301^(4-y) = 3.358*10^10Thanks

edit: did anyone get y = -0.283068? TI work but said multiple solution may exist
 
Last edited:
Physics news on Phys.org
Maple gives y = -.2822793449
 
thanks that work out. i rounded those numbers i posted above the 383 etc so should be the same or close
 

Similar threads

Undergrad Solving Differential Equation Using Reduction of Order
  • · Replies 2 ·
Replies
2
Views
4K
MHB Linearization of this equation / Inverse function
  • · Replies 4 ·
Replies
4
Views
4K
Undergrad Runge-Kutta 4 w/ some sugar on the top: How to do error approximation?
  • · Replies 65 ·
3
Replies
65
Views
9K
Undergrad Question about solving linear first order non-homogeneous ODEs
  • · Replies 3 ·
Replies
3
Views
3K
Undergrad Solving this integral equation
  • · Replies 4 ·
Replies
4
Views
2K
How Can I Solve a Differential Equation in Physics Homework?
  • · Replies 4 ·
Replies
4
Views
1K
Simmons 7.10 & 7.11: Find Curves Intersecting at Angle pi/4
  • · Replies 1 ·
Replies
1
Views
2K
Undergrad Solving 2D Heat Equation w/ FEM & Galerkin Method
  • · Replies 7 ·
Replies
7
Views
3K
Undergrad Can the ODE \psi''-y^2\psi=0 be solved using a general method?
  • · Replies 2 ·
Replies
2
Views
3K
MHB Quadratic equations ( solving for zeros/roots) trickey
  • · Replies 1 ·
Replies
1
Views
2K