how to generate lower quartile and upper quartile

[ALKEBSEE RADWAN]

Hello every one

I need to know how to run the command of summarizing with getting lower quartile and upper quartile instead of min and max results.
could anyone help here?
in addition, i have an inquiry about the result of mine
when i calculate the percentage of one variable to another the mean comes out over 100%

    Variable |            Obs        Mean          Std. Dev.       Min        Max
-------------+---------------------------------------------------------
cfo_pow_to~w |       4,338    55.97291    2507.881          0        136670.4

i will show you the summary before the calculation

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
ceo_power_~o |      7,148     12.7447    64.42129          0    2923.12
cfo_power_~o |      7,148    .5444823    6.830068          0   501.4317

Do you think that i did the calculation process wrongly or it is correct but my data is the reason?

[Nick Cox]

Type

help summarize

to get information about the detail option which shows you lower and upper quartiles.

Your question about your results is not answerable so far as I can see. You show results for a variable which has mean about 56 and for two other variables with different means. Whether your code to get from one place to another was wrong can't be answered because you don't show that code. I don't see what is "over 100%".

If you're puzzled by your results one fact that may be important is that you have 7148 observations with non-missing values for two variables but only 4338 observations with non-missing values for the third variable.

[ALKEBSEE RADWAN]

@Nick Cox thank you for answering
as for my question. first result is about (ceo_power_~o / cfo_power_~o) means it expresses the perecetage of cfo power into ceo power.
the code as follows

gen cfo_pow_to~w=ceo_power_~o / cfo_power_~o
sum cfo_pow_to~w

[ALKEBSEE RADWAN]

sorry Nick Cox
I could not find the command of quartile option

[ALKEBSEE RADWAN]

i need to do the analysis like this table
please someone helps

[Rich Goldstein]

help tabstat

[ALKEBSEE RADWAN]

thanks

[Nick Cox]

Perhaps you need the information that

lower quartile = 25th percentile and

upper quartile = 75th percentile

given that 1/4 = 25/100 and 3/4 = 75/100.

[ALKEBSEE RADWAN]

thanks it is working
yes you are right i did not recognize the meaning of lower and upper quartile
i got
and i have done it.

[hatem ali]

Hello Dr Alkebsee,

I have similar problem as well.
How did you do it?
Can you show it to me
I have similar data ,n, mean, and standard deviation
looking forward to heaing back from you

[ALKEBSEE RADWAN]

hi hatem ali
you just need to type this command

tabstat vars, statistics( count mean SD p25 p75

[ALKEBSEE RADWAN]

Hello Dr @Nick Cox please i have an issue with logistic regression
my coefficient comes out over 1
why and how can i fix such issue ?

[William Lisowski]

This question was later posted as a new topic (which was the correct thing to do) and subsequently answered at

https://www.statalist.org/forums/for...cient-of-logit

[ALKEBSEE RADWAN]

thanks