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:

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.

2. Apple Watch and the Airpods for helping me stick to a healthy routine. Just like the previous years.
3. A place: Southern France. A wonderful, sunny place, full of history. To be visited again in 2021.
4. 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!
5. 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 🙂
6. Philips Hue. For the long winter nights and because the lights influence the mood.
7. 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.
8. 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.
9. Reddit + Quora. The first one for keeping me informed, the other one for putting me to sleep 🙂
10. 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’.

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.