How to find the intersection of a line with a polynomial equation in excel?

04 April 2016 1 5K Report

How to find the coordinates of a point (x,y) where a line of negative slope intersects a curve defined by a four degree polynomial equation?

Is it possible to do that in excel?

Przemysław Kowalik

Yes it can be done numerically by using Solver add-in (also by the Goal seek tool). The issue is that without extra restrictions on parameters of equations of the line and the curve there may be 0 up to 4 points where they intersect.

Badges
Science topic

More Nelson Campos's questions See All

Caliche deposits....classification, genesis, geochemistry?

I am intetested in the chemistry of caliche....major elements and specially the trace element composition

07 August 2017 1,204 2 View

What statistical software should an exploration geoscientist use?

Most geoscientists are not statisticians, and require the use of friendly statistical packages that do not require deep knowledge of programming and mathematical principles, but need a software...

10 November 2013 6,356 21 View

Do anyone here can help us in the field of molecular docking?

We have synthesized various metal complexes with different environment around the metals. Now to see the application of synthesized complexes we need this study also. we are also interested in...

01 March 2021 1,899 2 View

How to address this issue in the analysis of Real-Time PCR results?

To dear Researchers, I was analyzing a series of concentration for estimation of Real-Time PCR efficiency. The concentration was 1:10. I used MS-excel to evaluate Slope. The result of slope was -8...

01 March 2021 8,683 4 View

Can I download BibExcel for MacOs?

Hi everyone, I would like to ask how I can download BibExcel software for MacOs? There are some links which are supported by Windows but I could not find it for Mac. or is there any other software...

01 March 2021 652 1 View

How to find the right number of integration points in second order 3d finite elements?

I am familiar with finite element simulations and numerical schemes like the Gauss Legendre quadrature. I also know that the Gauss integration yields exact values for polynomials up to degree 2n-1...

27 February 2021 6,818 3 View

Anyone with some Transgenomic Wavemaker software? Seeking help from the chromatography community?

I am trying to seek out some Transgenomic Wavemaker software (happy to purchase a computer too) to operate a fraction collector. The only way to connect to the fraction collector so far is to...

23 February 2021 9,181 1 View

Best excel chart to compare algorithms' running time?

Hi I want to compare the running time of robotic path planning algorithms. The grid size is 8X8. I have 100 scenarios of start and goal positions.. Each scenario is run in three obstacles ratio...

22 February 2021 621 1 View

How to open an old ".MTS" file containing spectroscopic data?

Hi supreme hive-mind of the internet, we have some old *.MTS files that are supposed to contain spectroscopic data, probably some coordinates and a long list of single line spectra. Basically,...

16 February 2021 9,385 2 View

How can we determine the positive definiteness of multivariable polyomial? Is there any MATLAB function available for that?

Can we check the positive definiteness of a multivariable polynomial using MATLAB functions? Of course in literature, there are few complex methods that use tensor algebra. However, before going...

16 February 2021 1,218 3 View

Room Occupancy Calculation ?

15 February 2021 1,997 6 View

How to check if the PMF profile obtained from ABF simulation is correct?

I am doing ABF simulations to calculate ligand binding enegy. The PMF profile that I get using single long ABF simulation is attached as pmf_total.png. When I do this ABF calculation with 10...

10 February 2021 4,170 2 View