calculating row-wise standard deviation using awk Post: 302666009

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script for finding standard deviation

I have a CSV file that looks like 0,0,0,0,1,0,1,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0 10,11,7,0,4,12,2,3,7,0,11,3,12,4,0,5,5,4,5,0,8,6,12,0,9,3,3,0,2,7,8 19,11,7,0,4,14,16,10,8,2,13,7,15,6,0,76,6,4,10,0,18,10,17,1,11,3,3,0,9,9,8...

2. Shell Programming and Scripting

Mean and Standard deviation

Hi all, I am new to shell scripting and wanna calculate the mean and standard deviation using shell programming. I have a file with letters that are repeating and their corresponding duration a 0.32 a 0.89 aa 0.34 aa 0.23 au 0.012 au 0.26...

3. UNIX for Dummies Questions & Answers

Calculating the Standard Deviation for a column

Hi all, I want to calculate the standard deviation for a column (happens to be column 3). Does any know of simple awk script to do this? Thanks

4. Shell Programming and Scripting

using awk to print average and standard deviation into a file

Hi I want to use awk to print avg and st deviation but it does not go into a file for column 1 only. I can do average and # of records but i cannot get st deviation. awk '{sum+=$1} END { print "Average = ",sum/NR}' thanks

5. Shell Programming and Scripting

awk-gsub on column-wise on each row

awk '{ gsub(/....=/,""); print }' want.dat >final.dat the above awk command which removes all the chars before and including '=' on the entire row. --thats what it meant be.:) but i need to remove text on column-wise on each row. many thanks, EM ---------- Post updated at 10:00 AM...

6. Shell Programming and Scripting

Standard deviation in awk

Hi all, I need to find the standard deviation of each column of a dataset below for each hour. The data is given in 5 second intervals as shown below DATE TIME FRAC_DAYS_SINCE_JAN1 FRAC_HRS_SINCE_JAN1 EPOCH_TIME ...

7. Shell Programming and Scripting

AWK script for standard deviation / root mean square deviation

I have a file with say 50 columns, each containing a whole lot of data. Each column contains data from a separate simulation, but each simulation is related to the data in the last (REFERENCE) column $50 I need to calculate the RMS deviation for each data line, i.e. column 1 relative to...

8. Shell Programming and Scripting

Loop for row-wise averaging of multiple files using awk

Hello all, I need to compute a row-wise average of files with a single column based on the pattern of the filenames. I really appreciate any help on this. it would just be very difficult to do them manually as the rows are mounting to 100,000 lines. the filenames are as below with convention as...

9. Shell Programming and Scripting

Calculating the epoch time from standard time using awk and calculating the duration

Hi All, I have the following time stamp data in 2 columns Date TimeStamp(also with milliseconds) 05/23/2012 08:30:11.250 05/23/2012 08:30:15.500 05/23/2012 08:31.15.500 . . etc From this data I need the following output. 0.00( row1-row1 in seconds) 04.25( row2-row1 in...

10. Shell Programming and Scripting

Output mean and standard deviation of a row

I have a file that looks that this: 820 890 530 1650 1600 1800 1850 1900 2270 1640 2300 1670 2080 2200 2350 1150 1630 2210 I would like to output the mean and standard deviation of each row so that my final output would look like this 820 890 530 746.667 155.849 1650 1600 1800...

LEARN ABOUT HPUX

gcomp

GCOMP(1)						      General Commands Manual							  GCOMP(1)

NAME

       gcomp - do computations on a graph file.

SYNOPSIS

       gcomp [ -amilh ][ +variable value ..  ][ file ..  ]

DESCRIPTION

       Gcomp reads each graph file in sequence and computes the specified calculations.  The type options are as follows:

       -n	 Print the name of each curve.

       -a	 Print average and standard deviation of each curve.

       -m	 Print minimum and maximum for each curve.

       -i	 Print Romberg's approximation to the integral of each curve.

       -l	 Print the slope, intercept, and correlation coefficient using the least squares method of linear regression.

       -h	 Do not print a header in the output.

       The  calculations  will	be  displayed as columns in the order they are specified on the command line.  If no files are given, the standard
       input is read.

       Variables can be set explicitly with +variable value options.  The only truely useful variables for this program are xmin and  xmax.   They
       determine boundaries for the calculations.

EXAMPLE

       To compute the approximate integral of sin(x)/log(x) from 2 to 4:
	    gcomp -i
	    A(x)=sin(x)/log(x);
	    Anpoints=100;
	    xmin=2;
	    xmax=4;
	    ^D

AUTHOR

       Greg Ward

BUGS

       Only the y values can be used for computation.

SEE ALSO

       bgraph(1), dgraph(1), icalc(1), igraph(1)

RADIANCE
							      6/24/98								  GCOMP(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script for finding standard deviation

Discussion started by: RJ17

2. Shell Programming and Scripting

Mean and Standard deviation

Discussion started by: lakshmikanth.pg

3. UNIX for Dummies Questions & Answers

Calculating the Standard Deviation for a column

Discussion started by: kylle345

4. Shell Programming and Scripting

using awk to print average and standard deviation into a file

Discussion started by: phil_heath