Cover Letter for Journal JSS

I found this really good deck of slides that gives pointers on how to write a good cover letter. It is very important!

https://www.slideshare.net/AmericanJournalExperts/writing-a-cover-letter-for-your-scientific-manuscript

Making an academic website using Academic

https://sourcethemes.com/academic/

The above link is the home page for the website that allows the creation of an academic website with the help of a template.

Installation requirements are git, hugo and hugo-extended and visual studio code for code editing.

Install with git using the instructions on this link: https://sourcethemes.com/academic/docs/install/#install-with-git
Then to customize the template, follow the instructions on the following link:
https://sourcethemes.com/academic/docs/get-started/#introduce-yourself

Change the menu as desired in the menus.toml file. Hide the widgets you don't need to be shown by setting the active variable in a page's code to false. Instead of the default avatar.jpg, put your own image and rename it to avatar.jpg. You can also add publication pages for each of your publication using the instructions here: https://sourcethemes.com/academic/docs/managing-content/#manually

Test the web site by running hugo server command and check http://localhost:1313/ in the browser. Deploy the website on GitHub by following these instructions:
https://sourcethemes.com/academic/docs/deployment/#github-pages
Once deployed, you can make future changes to your website and execute the following commands:
git add . git commit -m "Initial commit" git push -u origin master
hugo cd public git add . git commit -m "Build website" git push origin master cd ..


Here is mine :  https://shamsa-abid.github.io/

Excel Macro Code to change x axis maximum scale of chart

Sub setXAxisMaximumScale()
 ActiveSheet.ChartObjects("Chart 2").Activate
    ActiveChart.Axes(xlCategory).Select
    ActiveChart.Axes(xlCategory).MaximumScale = 1
End Sub


P.s. I first recorded a macro and viewed its code to get this

Creating boxplot in R

To create a boxplot pr box and whisker chart in R studio, we can use Excel csv file as the source of input data. We need two columns in the csv. In my case column1 contains precision and column2 contains the approach type.

The R code is as follows:
x <- read.csv("boxplotR2.csv",header=T, sep=",")
print (head(x))
boxplot(precision ~ approach, data = x, ylab = "Precision",
        xlab = "Related Function Recommendation Strategies")

and I get the boxplot

p-value and t-test statistical significance

To calculate the statistical significance, we use the t-test tool in Excel. It is available as part of the Data Analysis Add-Inn. You need to go to the Data tab and click the Analysis button. If the Analysis option does not show, you need to go to Excel Options in the Home menu and enable the Data Analysis add-in.

The following is taken from the Excel Help.

I need to compare the precision values reported for retrieved functions for two different strategies. The retrieved functions

t-Test: Two-Sample Assuming Unequal Variances
This analysis tool performs a two-sample student's t-Test. This t-Test form assumes that the two data sets came from distributions with unequal variances. It is referred to as a heteroscedastic t-Test. As with the preceding Equal Variances case, you can use this t-Test to determine whether the two samples are likely to have come from distributions with equal population means. Use this test when there are distinct subjects in the two samples.


references:

https://wallstreetmojo.com/p-value-in-excel/

How to display images in Latex side by side

I got the solution from https://tex.stackexchange.com/questions/186615/how-can-i-arrange-multiple-figures-in-rows-of-3-in-a-two-column-document?rq=1

\usepackage{lipsum,graphicx,multicol}
\begin{document}
%\abovecaptionskip=0pt
\begin{figure*}[t]
\begin{multicols}{3}
    \includegraphics[width=\linewidth]{example-image-a}\par\caption{caption}
    \includegraphics[width=\linewidth]{example-image-b}\par\caption{caption}
    \includegraphics[width=\linewidth]{example-image-c}\par\caption{caption}
\end{multicols}
\begin{multicols}{3}
    \includegraphics[width=\linewidth]{example-image-a}\par\caption{caption}
    \includegraphics[width=\linewidth]{example-image-b}\par\caption{caption}
    \includegraphics[width=\linewidth]{example-image-c}\par\caption{caption}
\end{multicols}
\end{figure*}
\lipsum[1-10]

Undefined control sequence error and can not find file error in includegraphics latex command

The solution was to update Miktex after installing it

I had issues with fixing a broken miktex installation

The proper way to install miktex is to Run As Administrator and Install for all users! And when the installation completes then immediately update MikTex.