Create sine waves using an Excel spreadsheet (call sheet Simple Sine) using the formula:
y (t) = A * sin (2πft + p)
, where A=amplitude, f = frequency, t = time, p = period.
To do so, you need to divide a second into time intervals of 0.01 seconds and calculate the values of y(t) for t = 0, 0.1, 0.2, 0.3, ..., 0.97, 0.98, 0.99, 1.

(a) Draw a sine wave for A = 1, f = 1, p = 0.
(b) Draw a sine wave for A = 1/3, f = 3, p = 0.
(c) Draw the composite of the waves in a. and b.

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

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

(b) The second graph is for the function

The image with the red line corresponds to this function.

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

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

answervpn;

make sure each item is its own paragraph.