Use ‘Solver' to find a solution to following equation:
If Solver successfully finds a solution create only the ‘Answer' Report. Excel will insert a new worksheet containing the report. Copy the contents of this worksheet into ‘Question 1' worksheet and delete it afterwards.
Plot following functions between [-5,5] using an increment of 0.05 on one chart.
Note that x is in radians. Using your chart, approximate the roots of each of following equations for the
given interval:
2
2
2
2sin cos
3
1
1
x
f x x x
g x
x
h x e
2
2
2
2
2
) 2sin cos
3
) 1 0 0.0 3.0
1
) 2sin cos 1 5 5
ider matrices A, B and C defined by:
[
] [
] [
]
Using Excel find matrix X given by:
(((( ) )
) )
Hint:
a. Find ( )
b. Find (( ) )
c. Find (( ) )
d. Find ((( ) )
)
e. Find (((( ) )
) )