Excel question :<?xml:namespace prefix = o ns = \"urn:schemas-microsoft-com:offi

Question

Excel question :<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

For this question you will have to plot the function below between user ,you will also need the Excel solver tool to analyze the function :

F(t) = ((i ( )sin(t))/t)+ i

Include the appropriate labels to describe all information on your spreadsheet .

Select a cell location to store the beginning value of the plot range.Name this cell ‘a’

Select a cell location to store the ending value of the plot range .name this cell ‘b’

Create a column,labeled’t’ that has approximately 40 values,evenly spaced from ‘a’ unites are in second

Create a column,labeled ‘f(t)’ that contains the function value for each value of t. t values in meter

Plot the function on an x-y scatter plot.Make the plot line color green.

Include appropriate title and axis labels.

For the plot range of a=2 and b= 10 use the solver tool to find the exact peak,the valley,and where f(t) is equal to 4

Make a table that clearly shows your initial guess ,the actual time and the value for these three points of interest .

Make sure your solution is clearly labeled including units

Explanation / Answer

this site can help you also

http://www.assignmentexpert.com/programming/computer-science-project.html

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.