В виде формул

Исходные данные

Вариант 1

Вариант 2

а =

0,232

b =

5,678

c =

9,018

e =

2,561

y=

0,02

Xn =

-10

Xk =

20

Шаг X =

=(B8-B7)/30

Таблица результатов

X

Y

W

=B7

=$B$2*A12^3+$B$3*КОРЕНЬ(ABS(A12-$B$4))+$B$5

=A12*(SIN(A12)+COS($B$6))

=A12+$B$9

=$B$2*A13^3+$B$3*КОРЕНЬ(ABS(A13-$B$4))+$B$5

=A13*(SIN(A13)+COS($B$6))

=A13+$B$9

=$B$2*A14^3+$B$3*КОРЕНЬ(ABS(A14-$B$4))+$B$5

=A14*(SIN(A14)+COS($B$6))

=A14+$B$9

=$B$2*A15^3+$B$3*КОРЕНЬ(ABS(A15-$B$4))+$B$5

=A15*(SIN(A15)+COS($B$6))

=A15+$B$9

=$B$2*A16^3+$B$3*КОРЕНЬ(ABS(A16-$B$4))+$B$5

=A16*(SIN(A16)+COS($B$6))

=A16+$B$9

=$B$2*A17^3+$B$3*КОРЕНЬ(ABS(A17-$B$4))+$B$5

=A17*(SIN(A17)+COS($B$6))

=A17+$B$9

=$B$2*A18^3+$B$3*КОРЕНЬ(ABS(A18-$B$4))+$B$5

=A18*(SIN(A18)+COS($B$6))

=A18+$B$9

=$B$2*A19^3+$B$3*КОРЕНЬ(ABS(A19-$B$4))+$B$5

=A19*(SIN(A19)+COS($B$6))

=A19+$B$9

=$B$2*A20^3+$B$3*КОРЕНЬ(ABS(A20-$B$4))+$B$5

=A20*(SIN(A20)+COS($B$6))

=A20+$B$9

=$B$2*A21^3+$B$3*КОРЕНЬ(ABS(A21-$B$4))+$B$5

=A21*(SIN(A21)+COS($B$6))

=A21+$B$9

=$B$2*A22^3+$B$3*КОРЕНЬ(ABS(A22-$B$4))+$B$5

=A22*(SIN(A22)+COS($B$6))

=A22+$B$9

=$B$2*A23^3+$B$3*КОРЕНЬ(ABS(A23-$B$4))+$B$5

=A23*(SIN(A23)+COS($B$6))

=A23+$B$9

=$B$2*A24^3+$B$3*КОРЕНЬ(ABS(A24-$B$4))+$B$5

=A24*(SIN(A24)+COS($B$6))

=A24+$B$9

=$B$2*A25^3+$B$3*КОРЕНЬ(ABS(A25-$B$4))+$B$5

=A25*(SIN(A25)+COS($B$6))

=A25+$B$9

=$B$2*A26^3+$B$3*КОРЕНЬ(ABS(A26-$B$4))+$B$5

=A26*(SIN(A26)+COS($B$6))

=A26+$B$9

=$B$2*A27^3+$B$3*КОРЕНЬ(ABS(A27-$B$4))+$B$5

=A27*(SIN(A27)+COS($B$6))

=A27+$B$9

=$B$2*A28^3+$B$3*КОРЕНЬ(ABS(A28-$B$4))+$B$5

=A28*(SIN(A28)+COS($B$6))

=A28+$B$9

=$B$2*A29^3+$B$3*КОРЕНЬ(ABS(A29-$B$4))+$B$5

=A29*(SIN(A29)+COS($B$6))

=A29+$B$9

=$B$2*A30^3+$B$3*КОРЕНЬ(ABS(A30-$B$4))+$B$5

=A30*(SIN(A30)+COS($B$6))

=A30+$B$9

=$B$2*A31^3+$B$3*КОРЕНЬ(ABS(A31-$B$4))+$B$5

=A31*(SIN(A31)+COS($B$6))

=A31+$B$9

=$B$2*A32^3+$B$3*КОРЕНЬ(ABS(A32-$B$4))+$B$5

=A32*(SIN(A32)+COS($B$6))

=A32+$B$9

=$B$2*A33^3+$B$3*КОРЕНЬ(ABS(A33-$B$4))+$B$5

=A33*(SIN(A33)+COS($B$6))

=A33+$B$9

=$B$2*A34^3+$B$3*КОРЕНЬ(ABS(A34-$B$4))+$B$5

=A34*(SIN(A34)+COS($B$6))

=A34+$B$9

=$B$2*A35^3+$B$3*КОРЕНЬ(ABS(A35-$B$4))+$B$5

=A35*(SIN(A35)+COS($B$6))

=A35+$B$9

=$B$2*A36^3+$B$3*КОРЕНЬ(ABS(A36-$B$4))+$B$5

=A36*(SIN(A36)+COS($B$6))

=A36+$B$9

=$B$2*A37^3+$B$3*КОРЕНЬ(ABS(A37-$B$4))+$B$5

=A37*(SIN(A37)+COS($B$6))

=A37+$B$9

=$B$2*A38^3+$B$3*КОРЕНЬ(ABS(A38-$B$4))+$B$5

=A38*(SIN(A38)+COS($B$6))

=A38+$B$9

=$B$2*A39^3+$B$3*КОРЕНЬ(ABS(A39-$B$4))+$B$5

=A39*(SIN(A39)+COS($B$6))

=A39+$B$9

=$B$2*A40^3+$B$3*КОРЕНЬ(ABS(A40-$B$4))+$B$5

=A40*(SIN(A40)+COS($B$6))

=A40+$B$9

=$B$2*A41^3+$B$3*КОРЕНЬ(ABS(A41-$B$4))+$B$5

=A41*(SIN(A41)+COS($B$6))

=A41+$B$9

=$B$2*A42^3+$B$3*КОРЕНЬ(ABS(A42-$B$4))+$B$5

=A42*(SIN(A42)+COS($B$6))