e(t)-5 sin 31.4t+ 2sin 44t write the folowing step in EXCEL Write the algorithm

Question

e(t)-5 sin 31.4t+ 2sin 44t write the folowing step in EXCEL Write the algorithm to construct the amplitude spectrum from the data set (1) If Data Analysis option is not available in the Excel spread sheet activate i om File Options Add-Ins Analysis ToolPak Go Aher dong on Go, Add- Ins window gets opened. Tick on Analysis ToolPak and click OK (2) Create five columns with labels time(t) data e(t), frequency, FFT component and Amplitude (3) Add data to first column starting from O and then incrementing by Aod data lines 4) Add data to the second column using the formula for er (5) Add data to the third column starting from O in the first column and incrementing by 5 (6) The fourth column is generated from data analysis Go to "Data tab and then select Data Analysis" option Select Fourier Analysis and click on OK (7) In the Fourler Analysis menu select Input Range as the entire column B and the Output Range as the first element of column D Click on OK (8) FFT results are appeared in column D (9) Generate the Amplitude column by writing the formula, SORT(2IMABS(D2) (10) Plot the FFT amplitude spectrum 128

Explanation / Answer

step1:LABEL COLUMNS

step 2:IMPORT DATA SAMPLING FREQUENCY,ADJUST NUMBER

step 3:FILL COLUMN Awith Time(t)

step 4:FILL COLUMN B with DATAe(t)

step 5:FILL COLUMN C WITH FREQUENCY FFT

step:plot waveform in the frequency domain

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

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