Home Random Page


CATEGORIES:

BiologyChemistryConstructionCultureEcologyEconomyElectronicsFinanceGeographyHistoryInformaticsLawMathematicsMechanicsMedicineOtherPedagogyPhilosophyPhysicsPolicyPsychologySociologySportTourism






JOB 1. Use of graphic opportunities of MS Excel

1. Construct a function graph = cos2(px) with Î[0, 1]:

1.1.In cells 1, 1 1 enter according values , Y with step 0.1

1.2.In cell 2 enter formula =cos(()*2)^2 and copy this formula into block of cells 3:12

1.3.Mark out values and , exert master of charts, choose the chart Diagram, correctly fill dialogue fields

2. Construct in one system of coordinates of graphics of the following functions at Î[-2, 2] with step 0.2:

= Z=

 

Note: in cell 2 enter formula =(2<=0;6*sin(A2)^2-cos(A2); 4*A2^3*sin(A2)^2)

in cell C2 enter formula =(2<0;(10+2*A2^2)/(1+A2^2);((2>=0;A2<=1);sin(A2)^2;cos(A2)^2*exp(0,5*A2)))

 

JOB 2. Creation of function graphs

1. To construct in one system of coordinates of graphics of the following functions at Î[-2; 2]: y=2sin(x)cos(x) z=3cos2(x)sin(x)

1.1. In the cells 1, 1, nd 1 2 enter according , Y Z

1.2. In the range of cells 2:22 enter values of argument from -2 to 2 with step 0.2

In the cell 2 and 2 enter formula =2*sin(2)*cos(2) and =3*cos(2)^2*sin(2) accordingly

Copy these formulas into block of cells 3:22

Mark all of the table and create the chart Diagram

2.Create the chart of function with three conditions when Î[-1.5; 1.8] with step 0.2:

JOB 3.

Create the chart of function with two conditions whenÎ[-1.8; 1.8] with step 0.2

in the cells 1, 1 enter accordingly , Y

in the range of cells 2:20 enter values of argument from -1.8 to 1.8 with step 0.2

in the cell 2 enter the formula with the help of Master of functions: =(A2<=0;(3+sin(A2))/(1+A2^2);2*A2^2*cos(A2)^2) and copy the formula into the range of cells 3:20 create the table of functions.

 

JOB 4.

On the Page4 create in different systems of coordinates when Î[-1.4;1.9] with step 0.2 charts of following functions:

 

JOB 5.

Creation of surface. Solution of the equations with the method of selecting parameters

1. On a blank work sheet construct a surface z=3e0.3xx3-3y4 when , y Î[-1, 1]with changing step 0.2,for it:

In the range of cells 2:12 enter following of values of changing with step 0.2 (in 2 enter -1, in 3 enter -0,8, mark these two cells and stretch to 12)

In the range of cells B1:L1enter following of values of changing Y with step 0.2 (in B1 enter -1, in 3 enter -0,8, mark these two cells and stretch to L1)

In the cell 2 enter formula =3*EXP(0,3*$A2)*$A2^3-3*B$1^4 and with the help of filling marker fill the block of cells B2:L12 with correspondind formulas.

Mark the range of formulas 1:L12 and create the chart Surface

2. Create in different systems of coordinates of surfaces when x, yÎ [-1,1] with step 0.2

z1=x2-3y2 z2

2x2 ey, if çx + y½ < 0.5,

z3 = xe2x y, if 0.5 £½x + y½< 1

2exyey, if 1 £ çx + yç.

 



x - e2y, if |x| + |y| < 0.5,

z4 = 2x2 - ey, if 0.5 £ |x| + |y| < 1

e2x - y, if 1 £ |x| + |y|

3. Solve an equation 3-0,012-0,7044+0,139104=0 by trial and error, for it:

3.1. Enter into cell 2 value 1, into cell 3 value 0,8. Marking these two values, stretch the filling marker (dagger in the right bottom corner of a cell) till value 1.

In the cell 2 enter formula: =2^3-0.01*A2^2-0.7044*A2+0.139104 (left part of equation), with the filling marker fill the other values 3.3. Note that the function change the sign on intervals [-1;-0.8], [0.2;0.4], [0.6;0.8], thus it is reasonable to take average points of intervals for initial approximations of a root. Enter them in the cells 2; 3; 4

3.4. In the cell D2 enter the formula: =2^3-0.01*2^2-0.7044*2+0.139104, with the filling marker stretch the other values.

3.5. Mark the cell D2 .

3.6. Choose the command Service/Selection of parameter. On the screen the Parameter Selection window will be displayed, in the field to Establish in a cell the cell will be displayed D2, in the field Value enter 0. Here value of the right part of equation is specified. In the field Changing value of a cell enter 2, using the reference to this cell, e.i. with the mouse. In this field the reference to the cell which has been taken away under a variable is given.

3.7. Enter .

3.8. Similarly in cells of C3 and C4 there are two remained roots.

3.9. In the graphic way show equation roots, i.e. construct a function graph y.

 
 

 

4. Create the surface , Î[-1;1] on variations (column Task 1)

5. Find the roots of equation on variations (column Task 2)

 

version Task 1 Task 2
Z=5x2cos2(y) 2y2ey x3-2.56x2-1.3251x+4.395006=0
Z=2x2cos2(x) 2y2 x3+2.84x2-5.6064x-14.766336=0
Z=2e0.2xx2 2y4 x3+0.85x2-0.4317x+0.043911=0
Z=x2 2e0.2yy2 x3-0.12x2-1.4775x+0.191906=0
Z=3x2sin2(x) 5e2yy x3+0.77x2-0.2513x+0.016995=0

 


Date: 2015-12-24; view: 258


<== previous page | next page ==>
JOB 1. Data analysis | Laboratory work 14.
doclecture.net - lectures - 2014-2017 year. (0.008 sec.)