# Creating an HR diagram from tabulated stellar data

I teach statistics and study Astronomy. I'd like to create an activity for my statistics students using star data. They could enter the data into Excel and create an HR diagram. We are currently studying Correlation & Regression. I wanted to show them that a scatter-plot can be VERY interesting.

Where can I get stellar data that is already in a format that my students can use excel to create a scatter-plot? Unbeknownst to them, they will create an HR diagram.

• Have a look at this. If you are interested I can give you the spreadsheet. This will need to be updated later this year to use the new Gaia results. iopscience.iop.org/article/10.1088/0143-0807/24/2/303 Feb 17, 2018 at 17:42
• @RobJeffries I'm probably missing something, but isn't that for near-Sol stars only? I mean, I realize you wrote it, but the title is "The local stellar population"?
– user21
Feb 18, 2018 at 19:10
• @barrycarter What's your point? Are you claiming that the local population can't be used to create an HR diagram? Feb 18, 2018 at 19:51
• @RobJeffries Actually, rethinking it, local stars are probably better, since using a larger catalog like Tycho (or even GAIA) would bias towards brighter stars, since we can't see dimmer stars far away. My concern would be: how many "local" stars are there? The diagram might end up a bit "stringy".
– user21
Feb 19, 2018 at 16:20
• @barrycarter The incomplete spreadsheet I refer to above contains 1000 stars. You can construct even more incomplete larger samples. As I understood the question, the aim was to produce something that looks interesting and non-random and that is astrophysically significant. Feb 19, 2018 at 17:23

The data can be accessed in the search tab, where you can specify the columns you want to display (phot_bp_mean_mag and phot_rp_mean_mag). There is a button at the bottom to export the results to a file on your computer. You can then plot one of the columns as a function of the difference between the other two.