Accelerometer to Frequency and Amplitude

  • Thread starter rd42
  • Start date
  • #1
6
0

Main Question or Discussion Point

I have a spreadsheet of Accelerometer data out of an iPhone and I have calculated the displacement in the three axis. I would like to figure out how to take this info and calculate the frequency, avg. amplitude, and the highest amplitude. Excel has a frequency function but I would like to understand that math, so I could make the phone calculate this.

Thank you for any help.

Don't worry, this isn't home work, I'm an old f*rt.
 

Attachments

Answers and Replies

  • #2
595
0
Couldn't open your file with my old Y2K Excel, but I looked at the FREQUENCY function in the help and I think that it is a sort of histogram. I first though it might be an FFT thing, but it looks like it just counts the number of times each specific value or range appears in the input data set.

There was (maybe still a separate package) an Excel "Data Analysis" package that had a statistical summary function. It calculates max, min, mean, median and such for a data set. That package also had a regular histogram where you can bin your data and count how many of each. If you don't know what all those m'words are, have a look at a stat's introduction, probably wiki is a good place to start.

If those functions are what you want, then rolling your own is mostly an exercise in iterating through the set and summing/counting the various values.
 

Related Threads on Accelerometer to Frequency and Amplitude

  • Last Post
Replies
24
Views
11K
Replies
12
Views
21K
  • Last Post
Replies
4
Views
12K
Replies
17
Views
22K
  • Last Post
2
Replies
31
Views
3K
  • Last Post
Replies
3
Views
38K
Replies
4
Views
5K
Replies
2
Views
5K
Replies
0
Views
2K
Top