Question: For each question, put it on its own sheet in Excel. Scatter vs line: Use Excel to create a table of the following function: f(x)=3e^(-(t/k)
For each question, put it on its own sheet in Excel. Scatter vs line: Use Excel to create a table of the following function: f(x)=3e^(-(t/k) ) sin(t) Where k is a named cell that contains the value 0.4 sec, and is a named cell that contains a value of 500 radians/sec. The table will contain a column of t from 0 to 2 seconds in steps of 0.1 seconds. Create a line graph for the value of f(x) as a function of time. The graph should have the x- and y-axis labeled, graph title, and a key. Create a scatter plot for the value of f(x) as a function of time. The graph should have the x- and y-axis labeled, graph title, and a key. In a cell near your graphs, explain which graph is better and why
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
