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.

Editing the marker size of charts in excel using VB code based macro

Sub sizechangemarker()
Dim Count As Integer
For Count = 1 To 5
Worksheets(8).ChartObjects(4).Chart _
 .SeriesCollection(Count).MarkerSize = 4
Next Count
End Sub

There were 5 lines on the fourth chart in the eighth worksheet. The for loops repeats the marker size setting for each series or line.

when you make a calculated column in mysql and it can not be used in a where clause

This can easily be done using a  nested query as shown in the following snippet taken from https://stackoverflow.com/questions/16068662/calculated-column-in-where-clause-performance

SELECT a,b,c,d FROM 
(SELECT a,b,c,(a*b+c) AS d) AS tmp
WHERE d > n