NavList:

A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding

HOME

Re: Need help writing a slope-fit excel sheet
From: Andrés Ruiz
Date: 2014 Jan 28, 08:30 +0100

Greg said:

Very nice spreadsheets, but how do you slide the Hc line over the Hs data?
(At least that was what I figured had to be done) I see no controls to do that.
Thanks,
~Greg

hi Greg, no controls,

In "Average celestial sights.xls" I have included the regression: compare the two slopes and see if R2 is near 1.

Or just use "Average observations.xlt" to see how good the observations are.

regards,

--
Andrés Ruiz
Navigational Algorithms
http://sites.google.com/site/navigationalalgorithms/

File: 126736.average-celestial-sights.xls

Subject:
Author:
Start date:	(yyyymm dd)
End date:	(yyyymm dd)

NavList:

A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding

Compose Your Message

NavList

What is NavList?

Get a NavList ID Code

Retrieve a NavList ID Code

Email Settings

Custom Index

Add Images & Files
Name or NavList Code:	Email:

Name:
	(please, no nicknames or handles)
Email:

NavList ID Code: