DATA Step, Macro, Functions and more

How to Calculate Median and Minimum Value based on Variance,Standard Deviation and Average ?

Reply
New Contributor
Posts: 2

How to Calculate Median and Minimum Value based on Variance,Standard Deviation and Average ?

I have summary data.

i need to caclulate median and minimum value for those summary data.

I have other statistics values - standard deviation, variance, average.

 

so, how we can caclulate median and minimum value using this statistics values ?

 

let me know, if any questions.

Trusted Advisor
Posts: 1,115

Re: How to Calculate Median and Minimum Value based on Variance,Standard Deviation and Average ?

[ Edited ]

Hi @nirav351,

 

So, you don't have access to the original data and the only available information is standard deviation, variance (redundant) and average?

 

This would render the calculation impossible, except for the trivial case that variance=0. With a little more information such as the number of non-missing values (N) and a distributional assumption about the data, at best, you could obtain (possibly very rough) estimates.

 

Also, how does your post relate to text mining (see forum title)? [Edit: In the meantime an administrator or super user has moved the thread to a more appropriate forum. Thanks!]

New Contributor
Posts: 2

Re: How to Calculate Median and Minimum Value based on Variance,Standard Deviation and Average ?

No I do not have any othet data.

##- Please type your reply above this line. Simple formatting, no
attachments. -##
Super User
Posts: 17,831

Re: How to Calculate Median and Minimum Value based on Variance,Standard Deviation and Average ?

Without more info we can't help. 

Given the current provided info it doesn't appear possible. 

Trusted Advisor
Posts: 1,115

Re: How to Calculate Median and Minimum Value based on Variance,Standard Deviation and Average ?

Here is an example:

data test;
input x @@;
dataset=ceil(_n_/5);
cards;
1 10 12 13 14
6 7 8 10 19
;

proc print data=test;
run;

proc means data=test var std mean median min;
by dataset;
run;

The two "datasets" (combined into one dataset TEST just to simplify the code) have 5 observations each. They have the same variance, standard deviation and mean (average), but their medians (12 vs. 8) and minimum values (1 vs. 6) differ considerably.

Super User
Posts: 9,681

Re: How to Calculate Median and Minimum Value based on Variance,Standard Deviation and Average ?

An important thing is what distribution your data conform to? Normal , Poisson ?

Ask a Question
Discussion stats
  • 5 replies
  • 265 views
  • 4 likes
  • 4 in conversation