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
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
