Calculating the distributions of number, mass and luminosity of the stars with the help of MS Excel <jats:title>Abstract</jats:title> <jats:p>Astrophysical topics can be treated with the methods of different areas of physics, mathematics and other natural sciences. The integration of these topics into such areas could improve students’ motivation and strengthen the connections between different fields of the mentioned sciences. In this article, an example of the connection between the physics of the stars and that of their statistical distributions is given. The usage of Microsoft Excel simplifies the mathematical requirements and gives the possibility of seeing the changes of distribution with the growing age of the regarded population of stars. The changes are a direct consequence to the limited lifetime of the stars and the limited age of the considered population of stars.</jats:p> 42 1 IOP Publishing