Calculate central tendency tht are interval or ratio measurement?

T

tamainor

I need help figuring out how to calculate measures of central tendency for
data that are interval or ratio in measurement, and in standard deviation for
the data that are interval or ratio in measurement.
 
M

Mike Middleton

tamainor -

Worksheet functions are AVERAGE(data_range) for arithmetic mean, MEDIAN for
median, MODE for mode, and STDEV for standard deviation.

Of course, median is appropriate for ordinal, interval, and ratio data, and
mode is appropriate for nominal, ordinal, interval, and ratio data.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
Calculating Sortino Ration (Downside Deviation) 7
Calculating the difference between 2 percentages (Ratios) 1
Calculate average in intervals 1
Converting measurements 3
Will VLOOKUP and MATCH work to find combinations of pulley diamete 3
how do I calculate staffing ratios 4
annualized return calculation for the purpose of portfolio performance evaluation 2

Top