Hi,
I've a scenario where I've a set of data for Sales information. I've found 0.25, 0.5, and 0.75 Fractile value for it, After that I'm displaying Quartile 4, Quartile 3, Quartile 2, and Quartile 1 based on comparing Sales value to the corresponding Fractile values obtained.
Now I've to find 0.5 Fractile Sales value within each Quartile and Summarize for the user.
Please advise how I should do it.
Here is the sample data set
Sales Total Rank Quartile
$976,086.50 1 Quartile 4
$783,245.41 2 Quartile 4
$753,885.56 3 Quartile 4
$745,304.97 4 Quartile 4
$723,718.25 5 Quartile 4
$722,650.89 6 Quartile 3
$709,379.75 7 Quartile 3
$668,184.24 8 Quartile 3
$648,683.39 9 Quartile 3
$620,118.76 10 Quartile 3
$617,171.31 11 Quartile 2
$608,873.66 12 Quartile 2
$529,959.86 13 Quartile 2
$511,669.81 14 Quartile 2
$492,137.29 15 Quartile 2
$418,783.34 16 Quartile 1
$365,804.68 17 Quartile 1
$349,612.03 18 Quartile 1
$340,318.39 19 Quartile 1
$322,617.31 20 Quartile 1
Thanks,
Vijay