contestada

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.

Respuesta :

elcharly64

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

[tex]y (t) = sin (2\pi t)[/tex]

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

(b) The second graph is for the function

[tex]y (t) = 1/3\cdot sin (6\pi t)[/tex]

The image with the red line corresponds to this function.

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

[tex]y (t) = sin (2\pi t)+1/3\cdot sin (6\pi t)[/tex]

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

Ver imagen elcharly64
Ver imagen elcharly64
Ver imagen elcharly64