Box and whisker plot in excel

For detailed method:
https://www.dummies.com/education/math/statistics/box-and-whisker-charts-for-excel/


Some bullet points:

Calculate

• min
• q1
• median
• q3
• max

of each data column for which a box plot is desired

Then calculate

1. q1-min 
2. q1
3. median-q1
4. q3-median
5. max-q3

Select calculated values 2, 3 and 4 for each data column and insert stacked column chart

To add whiskers, select lower half of each stacked column, select error bars, select minus, cap, choose custom, for -ve error value select all q1-minimum values
Then select the upper bars, select error bars, plus, cap, custom, for +ve value specify max-q3 values
Hide the lower bars using formatting options and you are done.

Count LOC of a project

Use the cloc command line tool.

http://cloc.sourceforge.net/

if you want to get the LOC of projects in a folder E:/projects_folder

then you may write the following command

cloc E:/projects_folder

It will begin calculating the metrics and report in command line

More advanced command is:

>cloc f:/testme --force-lang=Java --skip-uniqueness  --csv   --report-file=stats.csv

How to run R script on Codec server(private server) through command line

Please make sure that the R scipt file that you want to execute are transferred to codec server using WinSCP. The input file that the script operates on and the script itself should be on the root server path for your ease. This way, you can specify the file name directly in the script and there will be no need to specify the full path.

On codec server, you have to use putty to login and once logged in, you have to make sure the packages are installed for your code.

1) write R and press enter
2) write install.packages('yourpackagename')
3) q()
Now you are back to normal command line.

You can open the script file on server and change the paths to ones on codec server. e.g. library("tictoc", lib.loc="~/R/x86_64-pc-linux-gnu-library/3.5")

Suppose the name of your script file is a.R

4) Write the following command: Rscript a.R

Your R script will start executing.