Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Calculate the Median, first quartile and third quartile using AWK Post 302256473 by nica on Monday 10th of November 2008 12:06:21 AM
Old 11-10-2008
Calculate the Median, first quartile and third quartile using AWK

Hi all,

I have a data range as follow:

28
33
42
12
9
68
81
55
6
47

Since I want to create Box & Whisker Plot, I need to calculate the median, first quartile and third quartile of above data using AWK.( so far I can only writing a code for determine smallest value & largest value using AWK)

Anyone can help me...Please..Smilie

Thanks
 

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to calculate with awk

Hi, I have below awk statement and I need to convert the second field ( substr($0,8,6))from minutes to hours with 2 decimail place. How can I achieve this? /usr/bin/awk '{print substr($0,23,4),substr($0,8,6)}' /tmp/MANAGER_LIST.$$ >> /tmp/NEWMANAGER_LIST.$$ Thanks for any help! (4 Replies)
Discussion started by: whatisthis
4 Replies

2. Shell Programming and Scripting

awk to median

hi! i have a file like the attachement. you can see on the last column, there is a marker from 1 to 64 for each time. I'd like to have the median for each marker: i want to get a median every 128 values the result is : for an hour and marker x, i have the median value thank you for... (5 Replies)
Discussion started by: riderman
5 Replies

3. Shell Programming and Scripting

Help with calculate median, first quartile, second quartile and third quartile

Input file: 21.08 21.06 20.98 20.65 18.52 16.34 13.58 12.2 10.66 10.22 9.8 8.6 7.4 3.9 3.5 Desired output file: (10 Replies)
Discussion started by: perl_beginner
10 Replies

4. Shell Programming and Scripting

Compute the median of a set of numbers with AWK?

Is there a way in awk to compute the median of a set of numbers in a file in the following format. 34 67 78 100 23 45 67 (3 Replies)
Discussion started by: Lucky Ali
3 Replies

5. Shell Programming and Scripting

Awk based script to find the median of all individual columns in a data file

Hi All, I have some data like below. Step1,Param1,Param2,Param3 1,2,3,4 2,3,4,5 2,4,5,6 3,0,1,2 3,0,0,0 3,2,1,3 ........ so on Where I need to find the median(arithmetic) of each column from Param1...to..Param3 for each set of Step1 values. (Sort each specific column, if the... (5 Replies)
Discussion started by: ks_reddy
5 Replies

6. Shell Programming and Scripting

How to print median values of matrix -awk?

I use the following script to print the sum and how could I extend this to print medians instead? thanks name s1 s2 s3 s4 g1 2 8 6 5 g1 5 7 9 9 g1 6 7 8 9 g2 8 8 8 8 g2 7 7 7 7 g2 10 10 10 10 g3 3 12 1 24 g3 5 5 24 48 g3 12 3 12 12 g3 2 3 3 3 output name s1 s2 s3 s4 g1 5 7 8 9... (5 Replies)
Discussion started by: quincyjones
5 Replies
PGASetRealInitPercent(2)					      PGAPack						  PGASetRealInitPercent(2)

NAME
PGASetRealInitPercent - sets the upper and lower bounds for randomly initializing real-valued genes. DESCRIPTION
For each gene these bounds define an interval from which the initial allele value is selected uniformly randomly. With this routine the user specifies a median value and a percent offset for each allele. INPUT PARAMETERS
ctx - context variable median - an array containing the mean value of the interval percent - an array containing the percent offset to add and subtract to the median to define the interval OUTPUT PARAMETERS
none SYNOPSIS
#include "pgapack.h" void PGASetRealInitPercent(ctx, median, percent) PGAContext *ctx double *median double *percent LOCATION
real.c EXAMPLE
Set the initialization routines to select a value for each real-valued gene i uniformly randomly from the interval [i-v,i+v], where $v = i/2$. Assumes all strings are the same length. PGAContext *ctx; double *median, *percent; int i, stringlen; : stringlen = PGAGetStringLength(ctx); median = (double *) malloc(stringlen*sizeof(double)); percent = (double *) malloc(stringlen*sizeof(double)); for(i=0;i<stringlen;i++) { median[i] = (double) i; percent[i] = 0.5; } PGASetRealInitPercent(ctx, median, percent); 05/01/95 PGASetRealInitPercent(2)
All times are GMT -4. The time now is 01:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy