Question

MS Access find median of frequency table

A) AccessMedianFreq
B) MSAccessFreqMedian
C) MedianFreqMSAccess
D) AccessMSMedianFreq

Answer 1

To find the median of a frequency table using MS Access, you need to follow certain steps and use interpolation if necessary.

Step-by-step explanation:

Find the Median in MS Access

To find the median of a frequency table using MS Access, you need to follow these steps:

1. Look at the Cumulative Relative Frequency column and find the value that is closest to 0.50.
2. Determine the position of the median by multiplying the total number of values by the value from step 1. Round this number down to the nearest whole number.
3. Count the number of values in the frequency table up to the position from step 2.
4. If the position from step 2 falls within a frequency range, use interpolation to estimate the median.
5. Repeat steps 3 and 4 until the median value is found.

For example, if the Cumulative Relative Frequency is 0.52 and the total number of values is 50, the median would be the average of the 25th and 26th values.