## Statistical coefficients and Excel

Written on 11 January 2022, 10:32am

Tagged with: , , ,

Quick follow up to this post.

Here is how to use Excel in order to answer the question below:

The correlation coefficient is calculated in Excel using the `correl()` function: =CORREL(B4:B9;C4:C9)

The determination coefficient is calculated in Excel using the `rsq()` function: =RSQ(B4:B9;C4:C9)

Of course, the coefficient of determination (R^2) can also be calculated as (correlation coefficient) ^ 2

Note: instead of the correl() function, you can also use the formula as here. You will arrive at the same result.

The R-squared of the data set can be also shown by Excel if the data points are plotted in a chart and a linear trendline is added:

## 10 things that I liked in 2020

Written on 31 December 2020, 10:33am

Tagged with: , , , , , ,

Last hours of the year, so it’s time for the periodic roundup of things that I enjoyed over the past 12 months. 2020 has been a really strange year, but not everything was bad.

1. The scientific community for coming up with a vaccine in 2 days. You read that right, 2 days. Here’s for hope that this golden period of breakthroughs will have the same impact in the field of medicine as the Apollo moon landings had in the field of technology. Plus, after all this will be over, we will look back at 2020 and see it as a collective altitude training. Everything else will feel lighter and easier and we will be ready for bigger challenges.
1. Apple Watch and the Airpods for helping me stick to a healthy routine. Just like the previous years.
2. A place: Southern France. A wonderful, sunny place, full of history. To be visited again in 2021.
3. A series: Better Call Saul. I know, it made this list also in 2018. Some things don’t change. Plus, this year we got to see Lalo. Tell me again!
4. Liverpool FC for finally winning the Premier League. The first part of the year felt so good. So good that the rest of the year would not matter. But here we are still, with all the problems and top of the league again ðŸ™‚
5. Philips Hue. For the long winter nights and because the lights influence the mood.
6. A book: Andy Weir – Artemis. Quality stuff from the writer of The Martian. Had to take a day off to finish it. I loved the way it made me imagine humans living on the moon.
7. The Starship. If the humans will set foot on Mars this century, it will be in a Starship. Hopefully this will happen during our lifetime.
8. Reddit + Quora. The first one for keeping me informed, the other one for putting me to sleep ðŸ™‚
9. Working from home. Because it magically gave an extra hour to all my working days. Here’s for hope that the ‘new normal’ will be nothing like the ‘old normal’.

## Chris Hadfield on space movies

Written on 8 November 2020, 04:13pm

Tagged with: , ,

Apropos of this, here’s an actual astronaut and really cool space guy talking about the science of the space movies:

Bonus – the same guy talking to Andy Weir about The Martian.