Answer to Question #114780 in Excel for Badd

Question

Solve the following problems showing clearly all steps taken to arrive at the solution sets.

1. 3x²-5x-2=0​where ​-3<x<4



2. 2x²-4y+y²-5x+3xy-5=0; Let​-1<x<3​and​0>y>-2


3. 4x3m – 5x2y + 3y2x – 3x + 2y – 10 = 0

​-2=<x<=2
​0=<m<2
​-4<y<3​as their respective variable ranges.

Answer 1

Step 1: Solve the equations using a search engine.

wolframalpha.com/input/?i=solve+3*x*x-5*x-2%3D0%E2%80%8B%2C-3<x<4%2C+over+Z
wolframalpha.com/input/?i=solve+2*x*x-4*y%2By*y-5*x%2B3*x*y-5%3D0%2C-1<x<3%E2%80%8B%2C-2<y<0%2C+over+Z
wolframalpha.com/input/?i=solve+4*x^3*m-5*x^2*y%2B3*y^2*x-3*x%2B2*y-10%3D0%2C%E2%80%8B-2<%3Dx<%3D2%2C%E2%80%8B0<%3Dm<2%2C%E2%80%8B-4<y<3%E2%80%8B%2C+over+Z

Step 2:

Open an worksheet editor, create and fill up a 4X10 table, variables can be initialised with any valid values, configure the equation solver to solve non-linear problems.

Step 3:

Run the solver for each equation manually editing every field (target, variables, conditions). If the result is not equal to zero, the equation cannot possibly be solved under the domain / with the chosen method.

Step 4:

Analyse the results for each equation (how many solutions you may get over Z, the field of integers), substitute the variables and check the values, create 3 additional tables for all integer values of x, y, and m.

Step 5:

Save the worksheet in a format that you will need later.