Business Data Analysis
ASSIGNMENT 1- BU1007
Question 1
(i) The following data represent the cost of electricity during July 2006 for a random sample of 50 one-bedroom apartment in a large city
Electricity Charge ($) | 96 | 157 | 141 | 95 | 108 | 171 | 185 | 149 | 163 | 119 | 202 | 90 | 206 | 150 | 183 | 178 | 116 | 175 | 154 | 151 | 147 | 172 | 123 | 130 | 114 | 102 | 111 | 128 | 143 | 135 | 153 | 148 | 144 | 187 | 191 | 197 | 213 | 168 | 166 | 137 | 127 | 130 | 109 | 139 | 129 | 82 | 165 | 167 | 149 | 158 | | | | | | a. Form a frequency distribution and a percentage frequency distribution that have class intervals with upper class limits $99, $119 and so on.
82, 90, 95, 96, 102, 108, 109, 111, 114, 116, 119, 123, 127, 128, 129, 130, 130, 135, 137, 139, 141, 143, 144, 147, 148, 149, 149, 150, 151, 153, 154, 157, 158, 163, 165, 166, 167, 168, 171, 172, 175, 178, 183, 185, 187, 191, 197, 202, 206, 213 |
Limits ($) | Frequency | Percentage% | 200-219 | 4 | 8 (8/50 x100) | 180-199 | 7 | 14 (14/50 x100) | 160-179 | 9 | 18 (18/50 x100) | 140-159 | 13 | 26 (26/50 x100) | 120-139 | 9 | 18 (18/50 x100) | 100-119 | 5 | 10 (10/50 x100) | 80-99 | 3 | 6 (6/50 x100) | | | |
b. Construct a histogram and a percentage frequency polygon (Use Excel).
| | | | Mid-point | Frequency | Lower Limit | Upper Limit | Class | Frequency | 200 | 0 | 200 | 219 | 200 up to 219 | 4 | 209.5 | 4 | 180 | 199 | 180 up to 199 | 7 | 209.5 | 7 | 160 | 179 | 160 up to 179 | 9 | 209.5 | 9 | 140 | 159 | 140 up to 159 | 13 | 209.5 | 13 | 120 | 139 | 120 up to 139 | 9 | 209.5 | 9 | 100 | 119 | 100 up to 119 | 5 | 209.5 | 5 | 80 | 99 | 80 up to 99 | 3 | 209.5 | 3 | | | | | 209.5 | 0 |
c. Form a cumulative percentage frequency distribution and draw a cumulative percentage frequency curve. (4 Marks)
Limits ($) | Frequency | Percentage% | Cumulative
Question 1
(i) The following data represent the cost of electricity during July 2006 for a random sample of 50 one-bedroom apartment in a large city
Electricity Charge ($) | 96 | 157 | 141 | 95 | 108 | 171 | 185 | 149 | 163 | 119 | 202 | 90 | 206 | 150 | 183 | 178 | 116 | 175 | 154 | 151 | 147 | 172 | 123 | 130 | 114 | 102 | 111 | 128 | 143 | 135 | 153 | 148 | 144 | 187 | 191 | 197 | 213 | 168 | 166 | 137 | 127 | 130 | 109 | 139 | 129 | 82 | 165 | 167 | 149 | 158 | | | | | | a. Form a frequency distribution and a percentage frequency distribution that have class intervals with upper class limits $99, $119 and so on.
82, 90, 95, 96, 102, 108, 109, 111, 114, 116, 119, 123, 127, 128, 129, 130, 130, 135, 137, 139, 141, 143, 144, 147, 148, 149, 149, 150, 151, 153, 154, 157, 158, 163, 165, 166, 167, 168, 171, 172, 175, 178, 183, 185, 187, 191, 197, 202, 206, 213 |
Limits ($) | Frequency | Percentage% | 200-219 | 4 | 8 (8/50 x100) | 180-199 | 7 | 14 (14/50 x100) | 160-179 | 9 | 18 (18/50 x100) | 140-159 | 13 | 26 (26/50 x100) | 120-139 | 9 | 18 (18/50 x100) | 100-119 | 5 | 10 (10/50 x100) | 80-99 | 3 | 6 (6/50 x100) | | | |
b. Construct a histogram and a percentage frequency polygon (Use Excel).
| | | | Mid-point | Frequency | Lower Limit | Upper Limit | Class | Frequency | 200 | 0 | 200 | 219 | 200 up to 219 | 4 | 209.5 | 4 | 180 | 199 | 180 up to 199 | 7 | 209.5 | 7 | 160 | 179 | 160 up to 179 | 9 | 209.5 | 9 | 140 | 159 | 140 up to 159 | 13 | 209.5 | 13 | 120 | 139 | 120 up to 139 | 9 | 209.5 | 9 | 100 | 119 | 100 up to 119 | 5 | 209.5 | 5 | 80 | 99 | 80 up to 99 | 3 | 209.5 | 3 | | | | | 209.5 | 0 |
c. Form a cumulative percentage frequency distribution and draw a cumulative percentage frequency curve. (4 Marks)
Limits ($) | Frequency | Percentage% | Cumulative