Dear Statalist,

I hope you are well.

Please, I need help on how to overlay distributions using a pie chart using StataMP 17?

In my paper, I made a pie chart - using the below syntax - I found the Distribution of ‘i’ more extreme for micro-businesses. Therefore, I have been advised to overlay the distributions (said: just plot both distributions on the same graph).

Code:
graph pie, over( Int_RATE_01 ) plabel(_all percent) by(, legend(on)) by( Ent_size )
Another syntax I used to make a pie chart that shows interest rate distribution by bank finance application status (whether received finance or not)

Code:
graph pie, over( Int_RATE_01 ) plabel(_all percent) by(, legend(on)) by( Finance_App_Status )

The questionnaire question of the related information is this: What was the average interest rate you paid for the loan? The nature of the data is categorical variables. The response categories are as follows:
  1. 0-3% (number of the responses 51)
  2. 4-5% (number of the responses 7)
  3. 6-7% (number of the responses 13)
  4. 8-9% (number of the responses 12)
  5. Over 10% (number of the responses 0)
Here is a partial dataset of about 83 firms (Small and Medium Enterprises):

Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input int firm float Ent_size long(Int_RATE_01 Finance_App_Status)
 1 4 2 0
 2 4 1 1
 3 3 1 0
 4 3 4 1
 5 4 4 1
 6 3 1 1
 7 3 4 1
 8 1 4 1
 9 1 3 1
10 1 1 1
11 1 1 1
12 1 2 1
13 3 1 0
14 1 1 0
15 1 2 1
16 3 1 1
17 4 3 1
18 4 1 1
19 4 1 1
20 1 1 1
21 3 1 0
22 1 1 1
23 4 1 1
24 1 1 1
25 3 4 1
26 1 1 1
27 3 3 1
28 1 4 1
29 4 2 1
30 3 3 1
31 4 1 1
32 1 1 0
33 3 2 1
34 4 3 1
35 1 3 1
36 3 3 1
37 1 1 1
38 3 4 1
39 3 1 1
40 3 1 1
41 3 1 1
42 1 1 1
43 3 1 1
44 3 1 1
45 1 1 1
46 1 4 1
47 1 4 1
48 4 4 1
49 4 2 1
50 1 1 1
51 4 1 1
52 3 3 1
53 1 1 1
54 4 1 1
55 3 3 1
56 4 1 1
57 4 1 1
58 4 1 1
59 3 3 1
60 1 4 1
61 3 1 1
62 1 1 1
63 3 1 1
64 4 3 1
65 4 1 1
66 3 1 1
67 3 1 1
68 1 1 1
69 1 1 1
70 3 1 1
71 4 2 1
72 3 1 1
73 4 3 1
74 4 1 1
75 1 4 1
76 3 1 1
77 1 1 1
78 1 1 1
79 1 1 1
80 3 3 1
81 4 1 1
82 4 1 1
83 3 1 1
end
label values Ent_size Ent_size
label def Ent_size 1 "Micro", modify
label def Ent_size 3 "small", modify
label def Ent_size 4 "Medium", modify
label values Int_RATE_01 Int_RATE
label def Int_RATE 1 "0 -3%", modify
label def Int_RATE 2 "4 -5%", modify
label def Int_RATE 3 "6 -7%", modify
label def Int_RATE 4 "8 -9%", modify
label values Finance_App_Status Needing_Funding
label def Needing_Funding 0 "Not Recieved", modify
label def Needing_Funding 1 "Recieved", modify
I am struggling with how to answer the above question

Greatly appreciate your help

Best regards,
Rabab