Sunday, February 14, 2010

Maxine Cartoons On Parties

EPHEMERIDES 2

Here's an example of the analytical work of data collected in January-February
I used only data available Blog (not those of the poster in the classroom, but a couple of data that contains a registration error.
It starts from January 5th and arrive in mid-February. I calculated the length of day and night, turned up in numbers decimal. For example, for the lifting at 8:01 , because one minute is one sixtieth of time (1 / 60 = 0.0166 = about 0.02) I took the value 8.02 ; for Sunset 16:54 I figured 54/60 = 0.9 and then converted to decimal number is 16.9 and so on.
to do before I set the calculations in the spreadsheet.
Taking the difference between hours of sunset and the hour of rising, I found the time of day, and then removing this value to 24 the duration of the night.
to graph (in red the duration of the day, blue in the night) is:



What you see from the chart? points approaching ! What does it mean?
We must continue to record the values \u200b\u200bto complete the chart with the passage of time.
to prove themselves to organize and process data:



FORMULA IN E4:
= C4 + D4/60
FORMULA IN H4: = F4 + G4/60

FORMULA IN I4 :
=H4-E4
FORMULA IN J4:
=24-I4

0 comments:

Post a Comment