Question

1) For the following data on Year-end Audit times (in days), 17, 20, 25, 27, 19, 19, 20, 32, 26, 23, 24, 23, 27, 38, 21, 23, 22, 28, 33, 18, 27, 20, 23, 27, 31 Prepare a table showing in columns Audit Time Intervals (days), Frequencies, Cumulative Frequencies, Relative Frequencies, Cumulative Relative Frequencies, Percent Frequencies, and Cumulative Percent Frequencies.

Answer 1

EXCEL Formula USED

Explanation

A frequency is the number of times a given data occurs in a data set;

like in above 27 occur for 4 times

Cumulative Frequencies is  the accumulation of the previous frequencies

A relative frequency is the fraction or proportion of times an Data occurs. To find the relative frequencies, divide each frequency by the total number of data in the sample - in this case, 25

Cumulative relative frequency is the accumulation of the previous relative frequencies

Percent Frequencies = relative frequency*100

Cumulative Percent Frequencies.= is the accumulation of the previous Percent Frequencies