Calculation of Function Zeros by Bhaskara

Calculation of function of zeros by Bhaskara

This worksheet returns the zeros of the function by Bhaskara -values in ‘x’ of the points belonging to it and the parabola, the so-called delta value, concatenates the generating function (eg 2x² + 3x-5), the vertex coordinates and the concavity orientation. It also plots the characteristic curve in an xy diagram.

For this, give the so-called ‘a’, ‘b’ and ‘c’ values in cells C2, C3 and C4 (in strong yellow).

In Basic Computing classes (presentation), it is used as an example for the development of programming skills in fourth-generation languages of spreadsheets.

Calculation of function of zeros by Bhaskara

Eduardo Stefanelli

Engenheiro por profissão, professor por vocação