- #1
The Investor
- 34
- 0
- TL;DR
- Hi! I wanted to see if there is a formula to get x in excel without using solver: 0.5^x+0.2^x+0.25^x=1. Thanks!
0.5^x+0.2^x+0.25^x=1.
High School Is there a formula to get x in Excel without using solver: 0.5^x+0.2^x+0.25^x=1
Click For Summary
SUMMARY
The equation 0.5^x + 0.2^x + 0.25^x = 1 does not have a neat analytical solution. Instead, it requires an iterative approach for resolution. Users can utilize Excel's Solver tool, write a macro, or implement methods such as the Newton method directly in Excel cells to find the value of x. There is no standard formula available for this specific problem.
PREREQUISITES- Understanding of exponential functions
- Familiarity with Excel's Solver tool
- Basic knowledge of macros in Excel
- Concept of iterative methods, specifically the Newton method
- Explore how to use Excel's Solver for non-linear equations
- Learn to write macros in Excel for iterative calculations
- Study the Newton-Raphson method for root-finding
- Investigate other numerical methods for solving equations in Excel
Mathematicians, data analysts, and Excel users seeking to solve complex equations without standard formulas.
- #2
- 7,320
- 2,841
I don't think there is a neat formula for x.
https://www.wolframalpha.com/input/?i=0.5^x+0.2^x+0.25^x=1
https://www.wolframalpha.com/input/?i=0.5^x+0.2^x+0.25^x=1
- #3
mfb
Mentor
- 37,398
- 14,226
There is no analytic solution to it and it's not a standard problem, so you need some sort of iterative approach. You can do that with the solver, you can write a macro to do it, you can even do it in some Excel cells (e.g. using the Newton method), but Excel won't have a nice formula for it.
- #4
The Investor
- 34
- 0
OK, that's what I thought. Cheers guys.
The game is to find the number of triangles in this complicated figure by other than brute force counting and explain your method.
Similar threads
- · Replies 19 ·
- · Replies 15 ·
- · Replies 6 ·
- · Replies 6 ·
Undergrad
Excel projectile trajectory
- · Replies 6 ·
- · Replies 4 ·
- · Replies 9 ·
- · Replies 4 ·
- · Replies 12 ·