elow is the study time data for 65 students (BBA213) at Cavendish University of Zambia. This data is in hours spent preparing for an exam. 16 14 15 16 20 46 48 78 14 15 16 18 30 20 16 10 30 20 14 15 10 30 20 20 16 17 33 17 18 14 19 14 60 20 16 10 60 40 19 24 36 45 50 40 33 32 48 60 90 12 20 40 36 22 15 14 12 36 19 18 23 12 16 50 60 Requirement: Using Excel’s pivot chart report Construct a frequency distribution for this study time data. Construct a histogram for this study time data.
QUESTION 2
Below is the study time data for 65 students (BBA213) at Cavendish University of Zambia. This data is in hours spent preparing for an exam.
16 14 15 16 20 46 48 78 14 15 16 18 30
20 16 10 30 20 14 15 10 30 20 20 16 17
33 17 18 14 19 14 60 20 16 10 60 40 19
24 36 45 50 40 33 32 48 60 90 12 20 40
36 22 15 14 12 36 19 18 23 12 16 50 60
Requirement: Using Excel’s pivot chart report
- Construct a frequency distribution for this study time data.
- Construct a histogram for this study time data.
Step by step
Solved in 3 steps with 1 images
