Share via

Fourier Analysis input

Anonymous
2016-07-31T12:54:31+00:00

Hi there 

I am trying to use the tool to get FTT output. I have the long column of data ( to be exact 785 data). when i put the input range accordingly, get this : the number of input values must be a power of 2, so i change the range to match the data number to 512 , still get the same error ? can any one help please.... what i am missing here ?

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-07-31T13:39:59+00:00

    Thanks dear Bernard very much,

    Not only for the link you provided but also by mentioning you would look at the data, so i checked it carefully, it may seem silly for me but, i have not noticed before that two rows are actually empty ( for some reason ... perhaps during gathering data, has been sort of error ....) anyhow excel would not count them as value as we know and that was the reason of confusion .... by taking out, now the problem solved ... again thanks very much for you kind help. appreciate it a lot.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more