Answer to Question #123633 in Statistics and Probability for Prashika

Question

The following table give the number of orders received for a sample of 30 hours at the Timesaver Mail Order Company.
34 44 31 52 41 47 38 35 32 39 28 24 46 41 49 53 57 33 27 37 30 27 45 38 34 46 36 30 47 50

Construct a frequency distribution table, calculate cumulative frequency for all classes and draw an ogive for the above distribution

Answer 1

Using PivotTables in Excel we construct a frequency distribution table (pic.1 --- 2, Number of Calls --- Count --- % of Grand Total. After we calculate cumulative frequency (pic.1 --- 2, Count --- Cumulative Count --- % of Grand Total).

Using DataAnalysis in Excel we draw an ogive (pic 3). We see for example that 46.67% of the data has less than or equal to 37.2 number of calls.