Home /
Expert Answers /
Earth Sciences /
calculating-luminosity-how-should-this-formula-be-entered-in-a-spreadsheet-if-the-first-luminosity-pa458
(Solved):
Calculating Luminosity How should this formula be entered in a spreadsheet if the first luminosity ...
Calculating Luminosity How should this formula be entered in a spreadsheet if the first luminosity input value is in column A, row 2 and the first distance value is in column B, row 2? F = L 4nd² Tips and Sample Calculation What is the flux for a planet orbiting at 4.5 au around a 8.4 Ls star? Convert 4.5 au to meters: 4.5 au x 1.496 x 10¹¹ m = 6.73 x 10¹¹ m Convert 8.4 Ls to watts: 8.4 Ls x 3.827 x 1026 W = 3.215 x 10²7 W Flux: 3.215 x 10²7 W/(4 x ?x (6.73 x 10¹¹ m)²) = 564.9 W/m² Spreadsheet tips: • Place numbers and reference cell IDs in the same order in which they appear in the formula. These conversion formulas should already be in your spreadsheet so make use of them. Start the formula with= Use for multiplication. Use / for division. Enclose the entire denominator in (). • Use reference cell IDs for the location (column and first row) of the luminosity and distance input values. Spreadsheets do not have a symbol for pi, you have to spell it out. The spreadsheet will add () after the word pi so it will look like this: pi(). You don't need to enter anything between the (). Use^ to denote that the distance is squared. While the entire denominator should be in (), only distance is squared so nothing that comes before the ^2 should be grouped together in (). • Make sure your formula functions like you expect by plugging the input values from the sample calculation above into your spreadsheet. X