Poisson distribution transformation I'm quite new to biostatistics so I apologize if my question is too dumb.
I'm studying data transformation in biostatistics to fit my data to the normal distribution.
I started with the Poisson distribution (which is quite common in the biostatistics: daily admissions, prevalence of rare disease etc) It is recommended to use the square root to fit data to normal distribution.
I used stata and this free dataset ( https://www.kaggle.com/datasets/martj42/international-football-results-from-1872-to-2017?resource=download ) with the results of a huge amount of football matches.
I have created a new variable for this dataset, made by the whole amount of goals scored by both teams in each match. You will find that as the independent variable distributed as following:

We can see that the distribution quite approximate the Poisson's one, as confirmed by the values of mean and std deviation.

Then, I've created a new variable with the square root of this variable and the distribution is the following (blue line is how the normal distrib with the same mean and std deviation looks like):

As you can see It's quite far from a normal distribution of my data, as proven by normality tests, but also easily visible from the q-q plot:

So, my question is, why sqrt didn't work? What can I do to transform my dataset to fit the normal distribution?

By applying square-root transformation, we try to make distribution normal-like. Poisson's distribution is right-skewed, and square-root transformation compresses higher values so that lower values become more spread out.
Resultantly, when we apply square-root transform to Poisson distribution, it becomes a normal-like distribution.

But, the point to note down is that the newly created normal-like distribution should not be compared with normal distribution with mean & varaince of previous Poisson's distribution. Instead, find new mean & variance after applying transformation and then plot the corresponding normal distribution for comparing how far the results are from normal distribution.
Additionally, If you are still unsatisfied with the results of square-root transformation, you can try $2\sqrt{{X+}\frac{3}{8}}$ (Anscombe transformation) or $\sqrt{X}+\sqrt{X+1}$ (Freeman-Tukey Transformation).
