Obtain the sum of the squares of values, Mathematics

Assignment Help:

This question is in the form of an exercise and questions designed to give you more insight into signal processing. On the Moodle site for the module there is an EXCEL file called "FFT_exercise_2012". The first column contains the numbers 1 to 32. Then there is a column representing a "random time series", i.e. a digitised signal. The next eight columns are sine waves and cosine waves in pairs. The first pair is the fundamental based on 32 samples, i.e. one complete cycle. Then there are the second harmonics, and the third harmonics. The graphs for each of the digitised functions have been created to help you visualise these standard functions.

The time series given to you is the exact sum of a mean value plus a different multiple of each of these 8 sine and cosine components plus one further mystery harmonic. Your main task is to find these 10 values. But there are some initial tasks to help you think through how to find the values.

(a) Generate the columns on the EXCEL spreadsheet you will need for sin1, cos1, sin2, cos2, ... , sin4, cos4. Please note that the EXCEL function SIN(value) requires the value to be in radians. Also the EXCEL function PI() will give ??to lots of significant figures.

(b) Obtain the sum of the squares of values in each of the sine and cosine columns using EXCEL. What values do you obtain?

(c) What is the mean value of the random time series?

(d) What are the amplitudes of the 8 sinusoidal components that added to the mean make up the time series? Produce a table corresponding to sin1, cos1, sin2, cos2, etc.

(e) What is the amplitude of the mystery harmonic component and which component is it? Use the notation sin or cos plus a harmonic number, e.g. sin5, cos6, etc.


Related Discussions:- Obtain the sum of the squares of values

Decomposing polygons to find area, find the area of this figure in square m...

find the area of this figure in square millimeter measure each segment to the nearest millmeter

How many different words can be formed out from varanasi, Determine how man...

Determine how many different words can be formed out of the letters of the word VARANASI? Ans: 720 different words can be formed out of the letters of the word VARANASI.

How to add fractions involving negative numbers, Q. How to add fractions In...

Q. How to add fractions Involving Negative Numbers? Ans. Adding fractions involving negative numbers, and subtracting them, are only slightly different. But, I'll write do

Determine the team having similar code-pigeon hole principle, Shirts number...

Shirts numbered consecutively from 1 to 20 are worn by 20 members of a bowling league. While any three of these members are selected to be a team, the league aims to use the sum of

Trigonometry, 1-tan^2 A/1+tan^2 = cos A - sinA/cos A

1-tan^2 A/1+tan^2 = cos A - sinA/cos A

Problem word solving, Mrs. Jones and Mr. Graham had the same amount of mone...

Mrs. Jones and Mr. Graham had the same amount of money at first. After Mrs. Jones bought a computer that cost $2,055, she had 1/4 as much money as Mr. Graham. How much money di

Problem Solving, the low temperature in anchorage alaska today was negative...

the low temperature in anchorage alaska today was negative four degrees what is the difference in the two low temperatures

How to subtract fractions involving negative numbers, Q. How to Subtract fr...

Q. How to Subtract fractions involving negative numbers? Ans. This is the same as adding them, but just remember the rule that two negatives on the same fraction cancel ou

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd