Если у вас возникли сложности с курсовой, контрольной, дипломной, рефератом, отчетом по практике, научно-исследовательской и любой другой работой - мы готовы помочь.
Предоплата всего
Подписываем
Задание №1
Вычислить значение выражения при Х=2
Таблица с результатами и формулами для вычислений:
|
Задание 1 Вариант№5 |
|
|
X |
Y |
|
2,0000000000 |
0,0000000000 |
|
Задание 1 Вариант№5 |
|
|
X |
Y |
|
2 |
=(3^(2*A11^2+7)+3^((A11+3)*(A11+1)))/3^(8*A11*LOG(4^A11;2)) |
Задание №2
Дано действительное число х. Вычислить значение функции на заданном отрезке .
Шаг на каждом интервале вычисляется по формуле , где ai и bi – верхняя и нижняя границы интервалов, i – интервалы (1,2,3), n – число точек (10) на каждом интервале.
Таблица с результатами и формулами для вычислений:
|
Задание 2 Вариант№1 |
|||||
|
a |
b |
X |
F(X) |
X |
F(X) |
|
-5,00000 |
10,00000 |
-5,00000 |
0,96154 |
=A3 |
=ЕСЛИ(C3<=1/6;C3^2/(C3^2+1);ЕСЛИ(1/6<C3<4;C3^2;1/(10*C3^5))) |
|
-4,42593 |
0,95143 |
=C3+ABS($C$3-1/6)/9 |
=ЕСЛИ(C4<=1/6;C4^2/(C4^2+1);ЕСЛИ(1/6<C4<4;C4^2;1/(10*C4^5))) |
||
|
-3,85185 |
0,93686 |
=C4+ABS($C$3-1/6)/9 |
=ЕСЛИ(C5<=1/6;C5^2/(C5^2+1);ЕСЛИ(1/6<C5<4;C5^2;1/(10*C5^5))) |
||
|
-3,27778 |
0,91485 |
=C5+ABS($C$3-1/6)/9 |
=ЕСЛИ(C6<=1/6;C6^2/(C6^2+1);ЕСЛИ(1/6<C6<4;C6^2;1/(10*C6^5))) |
||
|
-2,70370 |
0,87966 |
=C6+ABS($C$3-1/6)/9 |
=ЕСЛИ(C7<=1/6;C7^2/(C7^2+1);ЕСЛИ(1/6<C7<4;C7^2;1/(10*C7^5))) |
||
|
-2,12963 |
0,81934 |
=C7+ABS($C$3-1/6)/9 |
=ЕСЛИ(C8<=1/6;C8^2/(C8^2+1);ЕСЛИ(1/6<C8<4;C8^2;1/(10*C8^5))) |
||
|
-1,55556 |
0,70758 |
=C8+ABS($C$3-1/6)/9 |
=ЕСЛИ(C9<=1/6;C9^2/(C9^2+1);ЕСЛИ(1/6<C9<4;C9^2;1/(10*C9^5))) |
||
|
-0,98148 |
0,49066 |
=C9+ABS($C$3-1/6)/9 |
=ЕСЛИ(C10<=1/6;C10^2/(C10^2+1);ЕСЛИ(1/6<C10<4;C10^2;1/(10*C10^5))) |
||
|
-0,40741 |
0,14235 |
=C10+ABS($C$3-1/6)/9 |
=ЕСЛИ(C11<=1/6;C11^2/(C11^2+1);ЕСЛИ(1/6<C11<4;C11^2;1/(10*C11^5))) |
||
|
0,16667 |
0,02703 |
=C11+ABS($C$3-1/6)/9 |
=ЕСЛИ(C12<=1/6;C12^2/(C12^2+1);ЕСЛИ(1/6<C12<4;C12^2;1/(10*C12^5))) |
||
|
0,59259 |
1,36842 |
=C12+ABS(4-$C$12)/9 |
=ЕСЛИ(C13<=1/6;C13^2/(C13^2+1);ЕСЛИ(1/6<C13<4;C13^2;1/(10*C13^5))) |
||
|
1,01852 |
0,09123 |
=C13+ABS(4-$C$12)/9 |
=ЕСЛИ(C14<=1/6;C14^2/(C14^2+1);ЕСЛИ(1/6<C14<4;C14^2;1/(10*C14^5))) |
||
|
1,44444 |
0,01590 |
=C14+ABS(4-$C$12)/9 |
=ЕСЛИ(C15<=1/6;C15^2/(C15^2+1);ЕСЛИ(1/6<C15<4;C15^2;1/(10*C15^5))) |
||
|
1,87037 |
0,00437 |
=C15+ABS(4-$C$12)/9 |
=ЕСЛИ(C16<=1/6;C16^2/(C16^2+1);ЕСЛИ(1/6<C16<4;C16^2;1/(10*C16^5))) |
||
|
2,29630 |
0,00157 |
=C16+ABS(4-$C$12)/9 |
=ЕСЛИ(C17<=1/6;C17^2/(C17^2+1);ЕСЛИ(1/6<C17<4;C17^2;1/(10*C17^5))) |
||
|
2,72222 |
0,00067 |
=C17+ABS(4-$C$12)/9 |
=ЕСЛИ(C18<=1/6;C18^2/(C18^2+1);ЕСЛИ(1/6<C18<4;C18^2;1/(10*C18^5))) |
||
|
3,14815 |
0,00032 |
=C18+ABS(4-$C$12)/9 |
=ЕСЛИ(C19<=1/6;C19^2/(C19^2+1);ЕСЛИ(1/6<C19<4;C19^2;1/(10*C19^5))) |
||
|
3,57407 |
0,00017 |
=C19+ABS(4-$C$12)/9 |
=ЕСЛИ(C20<=1/6;C20^2/(C20^2+1);ЕСЛИ(1/6<C20<4;C20^2;1/(10*C20^5))) |
||
|
4,00000 |
0,00010 |
=C20+ABS(4-$C$12)/9 |
=ЕСЛИ(C21<=1/6;C21^2/(C21^2+1);ЕСЛИ(1/6<C21<4;C21^2;1/(10*C21^5))) |
||
|
4,66667 |
0,00005 |
=C21+ABS($C$21-10)/9 |
=ЕСЛИ(C22<=1/6;C22^2/(C22^2+1);ЕСЛИ(1/6<C22<4;C22^2;1/(10*C22^5))) |
||
|
5,33333 |
0,00002 |
=C22+ABS($C$21-10)/9 |
=ЕСЛИ(C23<=1/6;C23^2/(C23^2+1);ЕСЛИ(1/6<C23<4;C23^2;1/(10*C23^5))) |
||
|
6,00000 |
0,00001 |
=C23+ABS($C$21-10)/9 |
=ЕСЛИ(C24<=1/6;C24^2/(C24^2+1);ЕСЛИ(1/6<C24<4;C24^2;1/(10*C24^5))) |
||
|
6,66667 |
0,00001 |
=C24+ABS($C$21-10)/9 |
=ЕСЛИ(C25<=1/6;C25^2/(C25^2+1);ЕСЛИ(1/6<C25<4;C25^2;1/(10*C25^5))) |
||
|
7,33333 |
0,00000 |
=C25+ABS($C$21-10)/9 |
=ЕСЛИ(C26<=1/6;C26^2/(C26^2+1);ЕСЛИ(1/6<C26<4;C26^2;1/(10*C26^5))) |
||
|
8,00000 |
0,00000 |
=C26+ABS($C$21-10)/9 |
=ЕСЛИ(C27<=1/6;C27^2/(C27^2+1);ЕСЛИ(1/6<C27<4;C27^2;1/(10*C27^5))) |
||
|
8,66667 |
0,00000 |
=C27+ABS($C$21-10)/9 |
=ЕСЛИ(C28<=1/6;C28^2/(C28^2+1);ЕСЛИ(1/6<C28<4;C28^2;1/(10*C28^5))) |
||
|
9,33333 |
0,00000 |
=C28+ABS($C$21-10)/9 |
=ЕСЛИ(C29<=1/6;C29^2/(C29^2+1);ЕСЛИ(1/6<C29<4;C29^2;1/(10*C29^5))) |
||
|
10,00000 |
0,00000 |
=C29+ABS($C$21-10)/9 |
=ЕСЛИ(C30<=1/6;C30^2/(C30^2+1);ЕСЛИ(1/6<C30<4;C30^2;1/(10*C30^5))) |
Задание №3
Построить кривую Циклоида
на отрезке [-6;6] по 50-ти точкам.
а = 0,5
Шаг вычисляется по формуле: , где n – число точек (50).
Таблица с результатами и формулами для вычислений:
|
Задание 3 Вариант№6 |
||||||||
|
t1 |
t2 |
ti |
X |
Y |
a |
ti |
X |
Y |
|
-6,000 |
6,000 |
-6,000 |
-3,140 |
0,020 |
0,500 |
=A8 |
=$F$8*(C8-SIN(C8)) |
=$F$8*(1-COS(C8)) |
|
-5,755 |
-3,129 |
0,068 |
=C8+ABS($A$8-$B$8)/49 |
=$F$8*(C9-SIN(C9)) |
=$F$8*(1-COS(C9)) |
|||
|
-5,510 |
-3,104 |
0,142 |
=C9+ABS($A$8-$B$8)/49 |
=$F$8*(C10-SIN(C10)) |
=$F$8*(1-COS(C10)) |
|||
|
-5,265 |
-3,058 |
0,237 |
=C10+ABS($A$8-$B$8)/49 |
=$F$8*(C11-SIN(C11)) |
=$F$8*(1-COS(C11)) |
|||
|
-5,020 |
-2,987 |
0,348 |
=C11+ABS($A$8-$B$8)/49 |
=$F$8*(C12-SIN(C12)) |
=$F$8*(1-COS(C12)) |
|||
|
-4,776 |
-2,887 |
0,468 |
=C12+ABS($A$8-$B$8)/49 |
=$F$8*(C13-SIN(C13)) |
=$F$8*(1-COS(C13)) |
|||
|
-4,531 |
-2,757 |
0,590 |
=C13+ABS($A$8-$B$8)/49 |
=$F$8*(C14-SIN(C14)) |
=$F$8*(1-COS(C14)) |
|||
|
-4,286 |
-2,598 |
0,707 |
=C14+ABS($A$8-$B$8)/49 |
=$F$8*(C15-SIN(C15)) |
=$F$8*(1-COS(C15)) |
|||
|
-4,041 |
-2,412 |
0,811 |
=C15+ABS($A$8-$B$8)/49 |
=$F$8*(C16-SIN(C16)) |
=$F$8*(1-COS(C16)) |
|||
|
-3,796 |
-2,202 |
0,897 |
=C16+ABS($A$8-$B$8)/49 |
=$F$8*(C17-SIN(C17)) |
=$F$8*(1-COS(C17)) |
|||
|
-3,551 |
-1,975 |
0,959 |
=C17+ABS($A$8-$B$8)/49 |
=$F$8*(C18-SIN(C18)) |
=$F$8*(1-COS(C18)) |
|||
|
-3,306 |
-1,735 |
0,993 |
=C18+ABS($A$8-$B$8)/49 |
=$F$8*(C19-SIN(C19)) |
=$F$8*(1-COS(C19)) |
|||
|
-3,061 |
-1,490 |
0,998 |
=C19+ABS($A$8-$B$8)/49 |
=$F$8*(C20-SIN(C20)) |
=$F$8*(1-COS(C20)) |
|||
|
-2,816 |
-1,248 |
0,974 |
=C20+ABS($A$8-$B$8)/49 |
=$F$8*(C21-SIN(C21)) |
=$F$8*(1-COS(C21)) |
|||
|
-2,571 |
-1,016 |
0,921 |
=C21+ABS($A$8-$B$8)/49 |
=$F$8*(C22-SIN(C22)) |
=$F$8*(1-COS(C22)) |
|||
|
-2,327 |
-0,799 |
0,843 |
=C22+ABS($A$8-$B$8)/49 |
=$F$8*(C23-SIN(C23)) |
=$F$8*(1-COS(C23)) |
|||
|
-2,082 |
-0,605 |
0,744 |
=C23+ABS($A$8-$B$8)/49 |
=$F$8*(C24-SIN(C24)) |
=$F$8*(1-COS(C24)) |
|||
|
-1,837 |
-0,436 |
0,631 |
=C24+ABS($A$8-$B$8)/49 |
=$F$8*(C25-SIN(C25)) |
=$F$8*(1-COS(C25)) |
|||
|
-1,592 |
-0,296 |
0,511 |
=C25+ABS($A$8-$B$8)/49 |
=$F$8*(C26-SIN(C26)) |
=$F$8*(1-COS(C26)) |
|||
|
-1,347 |
-0,186 |
0,389 |
=C26+ABS($A$8-$B$8)/49 |
=$F$8*(C27-SIN(C27)) |
=$F$8*(1-COS(C27)) |
|||
|
-1,102 |
-0,105 |
0,274 |
=C27+ABS($A$8-$B$8)/49 |
=$F$8*(C28-SIN(C28)) |
=$F$8*(1-COS(C28)) |
|||
|
-0,857 |
-0,051 |
0,173 |
=C28+ABS($A$8-$B$8)/49 |
=$F$8*(C29-SIN(C29)) |
=$F$8*(1-COS(C29)) |
|||
|
-0,612 |
-0,019 |
0,091 |
=C29+ABS($A$8-$B$8)/49 |
=$F$8*(C30-SIN(C30)) |
=$F$8*(1-COS(C30)) |
|||
|
-0,367 |
-0,004 |
0,033 |
=C30+ABS($A$8-$B$8)/49 |
=$F$8*(C31-SIN(C31)) |
=$F$8*(1-COS(C31)) |
|||
|
-0,122 |
0,000 |
0,004 |
=C31+ABS($A$8-$B$8)/49 |
=$F$8*(C32-SIN(C32)) |
=$F$8*(1-COS(C32)) |
|||
|
0,122 |
0,000 |
0,004 |
=C32+ABS($A$8-$B$8)/49 |
=$F$8*(C33-SIN(C33)) |
=$F$8*(1-COS(C33)) |
|||
|
0,367 |
0,004 |
0,033 |
=C33+ABS($A$8-$B$8)/49 |
=$F$8*(C34-SIN(C34)) |
=$F$8*(1-COS(C34)) |
|||
|
0,612 |
0,019 |
0,091 |
=C34+ABS($A$8-$B$8)/49 |
=$F$8*(C35-SIN(C35)) |
=$F$8*(1-COS(C35)) |
|||
|
0,857 |
0,051 |
0,173 |
=C35+ABS($A$8-$B$8)/49 |
=$F$8*(C36-SIN(C36)) |
=$F$8*(1-COS(C36)) |
|||
|
1,102 |
0,105 |
0,274 |
=C36+ABS($A$8-$B$8)/49 |
=$F$8*(C37-SIN(C37)) |
=$F$8*(1-COS(C37)) |
|||
|
1,347 |
0,186 |
0,389 |
=C37+ABS($A$8-$B$8)/49 |
=$F$8*(C38-SIN(C38)) |
=$F$8*(1-COS(C38)) |
|||
|
1,592 |
0,296 |
0,511 |
=C38+ABS($A$8-$B$8)/49 |
=$F$8*(C39-SIN(C39)) |
=$F$8*(1-COS(C39)) |
|||
|
1,837 |
0,436 |
0,631 |
=C39+ABS($A$8-$B$8)/49 |
=$F$8*(C40-SIN(C40)) |
=$F$8*(1-COS(C40)) |
|||
|
2,082 |
0,605 |
0,744 |
=C40+ABS($A$8-$B$8)/49 |
=$F$8*(C41-SIN(C41)) |
=$F$8*(1-COS(C41)) |
|||
|
2,327 |
0,799 |
0,843 |
=C41+ABS($A$8-$B$8)/49 |
=$F$8*(C42-SIN(C42)) |
=$F$8*(1-COS(C42)) |
|||
|
2,571 |
1,016 |
0,921 |
=C42+ABS($A$8-$B$8)/49 |
=$F$8*(C43-SIN(C43)) |
=$F$8*(1-COS(C43)) |
|||
|
2,816 |
1,248 |
0,974 |
=C43+ABS($A$8-$B$8)/49 |
=$F$8*(C44-SIN(C44)) |
=$F$8*(1-COS(C44)) |
|||
|
3,061 |
1,490 |
0,998 |
=C44+ABS($A$8-$B$8)/49 |
=$F$8*(C45-SIN(C45)) |
=$F$8*(1-COS(C45)) |
|||
|
3,306 |
1,735 |
0,993 |
=C45+ABS($A$8-$B$8)/49 |
=$F$8*(C46-SIN(C46)) |
=$F$8*(1-COS(C46)) |
|||
|
3,551 |
1,975 |
0,959 |
=C46+ABS($A$8-$B$8)/49 |
=$F$8*(C47-SIN(C47)) |
=$F$8*(1-COS(C47)) |
|||
|
3,796 |
2,202 |
0,897 |
=C47+ABS($A$8-$B$8)/49 |
=$F$8*(C48-SIN(C48)) |
=$F$8*(1-COS(C48)) |
|||
|
4,041 |
2,412 |
0,811 |
=C48+ABS($A$8-$B$8)/49 |
=$F$8*(C49-SIN(C49)) |
=$F$8*(1-COS(C49)) |
|||
|
4,286 |
2,598 |
0,707 |
=C49+ABS($A$8-$B$8)/49 |
=$F$8*(C50-SIN(C50)) |
=$F$8*(1-COS(C50)) |
|||
|
4,531 |
2,757 |
0,590 |
=C50+ABS($A$8-$B$8)/49 |
=$F$8*(C51-SIN(C51)) |
=$F$8*(1-COS(C51)) |
|||
|
4,776 |
2,887 |
0,468 |
=C51+ABS($A$8-$B$8)/49 |
=$F$8*(C52-SIN(C52)) |
=$F$8*(1-COS(C52)) |
|||
|
5,020 |
2,987 |
0,348 |
=C52+ABS($A$8-$B$8)/49 |
=$F$8*(C53-SIN(C53)) |
=$F$8*(1-COS(C53)) |
|||
|
5,265 |
3,058 |
0,237 |
=C53+ABS($A$8-$B$8)/49 |
=$F$8*(C54-SIN(C54)) |
=$F$8*(1-COS(C54)) |
|||
|
5,510 |
3,104 |
0,142 |
=C54+ABS($A$8-$B$8)/49 |
=$F$8*(C55-SIN(C55)) |
=$F$8*(1-COS(C55)) |
|||
|
5,755 |
3,129 |
0,068 |
=C55+ABS($A$8-$B$8)/49 |
=$F$8*(C56-SIN(C56)) |
=$F$8*(1-COS(C56)) |
|||
|
6,000 |
3,140 |
0,020 |
=C56+ABS($A$8-$B$8)/49 |
=$F$8*(C57-SIN(C57)) |
=$F$8*(1-COS(C57)) |
Кривая: