An amateur astronomer is researching statistical properties ofknown stars using a variety of databases. They collect the colorindex, or B?V index, and distance (in light years) from Earth for30 stars. The color index of a star is the difference in the lightabsorption measured from the star using two different light filters(a B and a V filter). This then allows the scientist to know thestar's temperature and a negative value means a hot blue star. Alight year is the distance light can travel in 1 year, which isapproximately 5.9 trillion miles. The data is provided below. UseExcel to calculate the correlation coefficient r between the twodata sets, rounding to two decimal places.
B-V index Distance (ly)
1.1 1380
0.4 556
1.0 771
0.5 304
1.4 532
1.0 751
0.5 267
0.8 229
0.5 552
0.2 896
1.5 1819
0.5 381
0.5 257
1.1 541
0.7 133
0.5 300
0.0 985
0.4 525
1.0 408
1.1 1367
1.07 2848
1.1 128.9
1.12 1766.2
0.64 186.5
0.87 8269.2
0.19 828.9
1.03 153
0.55 223.6
1.39 963.9
0.89 91.7
R=
