Cart | Help
 You are here: NI Home > NI Developer Zone > NI Discussion Forums Select Community English Français Italiano 日本語 한국어 Español 简体中文 繁体中文 Português (BR)

Member
Posts: 12

Finding Average of Signal

Hello,

I have 60 seconds of voltage data that I acquired using a USB-6210. When I used the Statistics step to compute the mean/average of this signal, I got a certain value. However, when I ported the data to Excel and calculated the mean/average using Excel, I got a different value.

Any possible explanations?

Thanks,

Akshay

Member
Posts: 172

Re: Finding Average of Signal

Good morning,

How different are the values? Are you comparing mean to mean and average to average, or main to average?

Member
Posts: 12

Re: Finding Average of Signal

SignalExpress Mean =345.805

Microsoft Excel Average =341.934

MATLAB Mean =317.7009

In SignalExpress I had my DAQ setup to take samples at a 1 kHz rate for 60 seconds (total of 60k samples).

What exactly is the difference between the mean and the average in this scenario?

Thanks,

Akshay

Member
Posts: 172

Re: Finding Average of Signal

An average is a value of central tendency; it is the sum of the elements in that sample divided by the number of elements. The mean is one of the averages depending if it is arithmetic, geometric or harmonic, which are also different from the mode and the median of a set of values. The mode is the most repeated value, while the median is the middle value that separates the higher half from the lower half of data. So it depends on what value is it calculating or what reference is it referring to. Between Signal Express and Excel I would think maybe we have a difference because of decimals, but the one of Matlab is odd, do you know what is it calculating?

Member
Posts: 12

Re: Finding Average of Signal

Thanks for the explanation.

Matlab describes its "mean" function as "Average or mean value."

Best,

Akshay

Member
Posts: 172

Re: Finding Average of Signal

Hello Akshay,

That doesn’t say a lot. In all programs I guess you must be displaying the data as one array, right? I also checked for the Mean function in MATLAB, and the type seems to be arithmetic. Are you sure you’re using the same data in the three programs? I tested with some data in LabVIEW and Excel and I got the same value for the average.

Have a great weekend!

By using this web site, you accept the Terms of Use for this web site. Please read these Terms of Use carefully before using any part of this site. Please go here for information on ni.com's copyright infringement policy.
 My Profile | Privacy | Legal | Contact NI © 2011 National Instruments Corporation. All rights reserved.    |    E-Mail this Page