In order to demonstrate my competence I have published on screen a presentation of mathematical expressions and graphical material using HTML. I applied Microsoft Excel to display an annotated graph of a data set, which was generated by performing mathematical calculations on data read from a disk file.
|
I have shown a relationship between the distance and the error in distance of the 1000 closest Hipparcos stars. The first step was to aquire the Parallax of the 1000 closest Hipparcos stars out of the Hipparcos Catalog. Next I inputed the data file into a Microsoft spreadsheet. I then used the equations below to transform the data for graphing. Once the data was transformed I used Microsoft Excel's plotting function to plot the data. I put a title on the graph and labeled it's axes, also with Microsoft Excel.
|
|
The Parallax (Plx) in arcseconds is equal to the inverse of the distance (D) in parsecs. One parsec is equal to about 3.2616 Light Years (LY). The Hipparcos Parallax (Plx) data is in milliarcseconds (mas). Thus the folowing equations are used to calculate stellar distance and distance error in Light Years.
|
