Question

Create sine waves using an Excel spreadsheet (call sheet Simple Sine) using the formula:

Answer 1

Answer:

Graphs below

Explanation:

Graphics in Excel

Excel is a powerful tool to produce excellent graphs. Combined with its capacity to process mathematical formulas, it can generate graphs of any function given the values of the independent variable and the formula.

We are given the expression for three sinusoid functions and the range of values for x from 0 to 1 in steps of 0.01. Please note the first values 0, 0.1, 0.2 are wrong. We have assumed 0, 0.01, 0.02, 0.03, ..., 0.99, 1.

(a) The first graph is for the function

$y (t) = sin (2\pi t)$

The corresponding graph is shown in one of the images provided below (blue line).

(b) The second graph is for the function

$y (t) = 1/3\cdot sin (6\pi t)$

The image with the red line corresponds to this function.

(c) The third graph is for the sum of the previous functions, i.e.

$y (t) = sin (2\pi t)+1/3\cdot sin (6\pi t)$

We can see the graph of the green line in the third image