Dear Stata community
I am new in stata and I am trying to calculate the average household income but my data is grouped by chosen alternatives. How do I calculate the average for such data
Q39
R1 584-R7167
R7 168-R16 417
R7 168-R16 417
R16 418-R33 333
R16 418-R33 333
R16 418-R33 333
R16 418-R33 333
R16 418-R33 333
R33 334-R57 334
R33 334-R57 334
R33 334-R57 334
R33 334-R57 334
R33 334-R57 334
I want to achieve something like this, but I do not know how to. Can anyone kindly help me. Thank you
Summary statistics: N mean sd min max
I am new in stata and I am trying to calculate the average household income but my data is grouped by chosen alternatives. How do I calculate the average for such data
Q39
R1 584-R7167
R7 168-R16 417
R7 168-R16 417
R16 418-R33 333
R16 418-R33 333
R16 418-R33 333
R16 418-R33 333
R16 418-R33 333
R33 334-R57 334
R33 334-R57 334
R33 334-R57 334
R33 334-R57 334
R33 334-R57 334
I want to achieve something like this, but I do not know how to. Can anyone kindly help me. Thank you
Summary statistics: N mean sd min max
| Q34 | N | mean | sd | min | max |
| 1. 0 - R1 583 | 25 | 477.44 | 323.077 | 100 | 1296 |
| 2. R1 584 – R7 167 | 14 | 621.357 | 733.049 | 0 | 2900 |
| 3. R7 168 –R16 417 | 26 | 1321.346 | 1055.126 | 70 | 4100 |
| 4. R16 418 – R33 333 | 30 | 1370.6 | 1120.689 | 100 | 4520 |
| 5. R33 334 – R57 333 | 19 | 1153.421 | 743.845 | 100 | 2600 |
| 6. R57 334 – R12~417 | 6 | 1187.333 | 1043.200 | 300 | 3110 |
| 7. R123 418+ | 7 | 1694.286 | 1361.786 | 500 | 4270 |
