{"id":341580,"date":"2024-09-05T09:09:05","date_gmt":"2024-09-05T07:09:05","guid":{"rendered":"https:\/\/climatescience.press\/?p=341580"},"modified":"2024-09-05T09:09:07","modified_gmt":"2024-09-05T07:09:07","slug":"sea-levels-and-excel","status":"publish","type":"post","link":"https:\/\/climatescience.press\/?p=341580","title":{"rendered":"Sea Levels and Excel"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"723\" height=\"482\" data-attachment-id=\"341605\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341605\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?fit=2560%2C1707&amp;ssl=1\" data-orig-size=\"2560,1707\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;1&quot;}\" data-image-title=\"00COP28-scaled\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?fit=723%2C482&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?resize=723%2C482&#038;ssl=1\" alt=\"\" class=\"wp-image-341605\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?resize=1024%2C683&amp;ssl=1 1024w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?resize=768%2C512&amp;ssl=1 768w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?resize=1536%2C1024&amp;ssl=1 1536w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?resize=2048%2C1366&amp;ssl=1 2048w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?resize=1200%2C800&amp;ssl=1 1200w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?w=1446&amp;ssl=1 1446w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?w=2169&amp;ssl=1 2169w\" sizes=\"auto, (max-width: 723px) 100vw, 723px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">From <a href=\"https:\/\/wattsupwiththat.com\/2024\/09\/03\/sea-levels-and-excel\/\">Watts Up With That?<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By Dr. Alan Welch FBIS FRAS <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Having used Excel for the last 7 years to study Sea Levels I have discovered various pit falls, techniques and useful functions.&nbsp; I wish to share these with the wider WUWT community.&nbsp; To some it may be like teaching your Granny to suck eggs (as we say in the UK) but hopefully some may pick up a few useful facts or ideas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To illustrate findings, I have used the New York Battery data as recently discussed by Kip Hansen (1).&nbsp; These cover the period 1856 to 2024 but due to the hiatus in data between 1878 and 1893 only the period 1893 to 2023 will be considered as 131 continuous years.&nbsp; Note there were a few months missing in 1920, but this has little impact. &nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To reduce the quantity of data and remove any seasonal effects, each year will be averaged producing 131 yearly data values.&nbsp; Feeding these data into Excel and producing a standard presentation results in the graph shown in Figure 1.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"368\" data-attachment-id=\"341582\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341582\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-67.png?fit=600%2C368&amp;ssl=1\" data-orig-size=\"600,368\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-67.png?fit=600%2C368&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-67.png?resize=600%2C368&#038;ssl=1\" alt=\"\" class=\"wp-image-341582\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-67.png?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-67.png?resize=300%2C184&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 1<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong><u>Trend Line Equations<\/u><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As values the coefficients of the Trend Line Equations are accurate to the precision given and usable&nbsp; as such.&nbsp; The problem arises if the equations, especially the quadratic coefficients, are used in subsequent analyses such as graph plotting and, although not recommended, extrapolation.&nbsp; The problems in plotting are illustrated below where the trend line equations are subjected to \u201cTrend Line Formatting\u201d increasing the significant decimal places to 5 and 6 respectively.&nbsp; With the standard Excel presentation there is a consistent error of nearly 200 mm.&nbsp; This comes about because the date values are squared and when multiplied by a coefficient with only 4 decimal places result in the calculated sea levels becoming basically the difference between two large numbers.&nbsp; Even with 5 decimal places there is a general error of about 15 mm.&nbsp; It is only with 6 decimal places that the error reduces to less than 1 mm.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If Cubic or higher polynomial curves are involved this problem is further exacerbated.&nbsp;&nbsp; These higher polynomial curves are not generally recommended but, on some occasions, can point to other behaviour such as would occur with decadal oscillations although using a moving average trend line would probably be more suitable.&nbsp; Extrapolation of these higher polynomial curves is even a more \u201cno-no\u201d as the highest-powered term soon dominates the calculation.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"365\" data-attachment-id=\"341583\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341583\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/0Figure-2_600.webp?fit=600%2C365&amp;ssl=1\" data-orig-size=\"600,365\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"0Figure-2_600\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/0Figure-2_600.webp?fit=600%2C365&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/0Figure-2_600.webp?resize=600%2C365&#038;ssl=1\" alt=\"\" class=\"wp-image-341583\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/0Figure-2_600.webp?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/0Figure-2_600.webp?resize=300%2C183&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 2<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">There are several ways the above problem can be overcome in most cases.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. Reduce the date values by deducting a suitable figure such as 1900 so the dates now only vary from -7 to 123.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. Generally show more decimal places.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">3. The surest way is to make use of the \u201cLINEST\u201d function in EXCEL.&nbsp; This function is generally described as returning the parameters of a linear trend and has the form, assuming the year and sea level data are stored in columns&nbsp; A and B and rows 1 to 131<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a>= LINEST(A1:A131,B1:B131)<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The 2 coefficients will then appear in the cell where the function was entered and the adjacent &nbsp;cell.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It is not well known that the LINEST function can be extended to solve a much wider range of regression analyses including cubic, quartic etc curves.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To solve for a quadratic the function is entered as<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a>= LINEST(A1:A131,B1:B131^{1,2})<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">And for a cubic<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">= LINEST(A1:A131,B1:B131^{1,2,3})<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In these cases, the coefficients will appear in 3 or 4 adjacent cells.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Having obtained values for the 2, 3 or 4 coefficients they can be captured as named values in subsequent calculations by using the \u201cName Box\u201d and then use Formulas&gt;Defined Names&gt;Define Name.&nbsp; In my work I called the values LINEAR1 and LINEAR such that<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a>Sea Level = LINEAR1 * year +&nbsp; LINEAR<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a>or for quadratic curve<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sea Level = QUAD2 * year<sup>2<\/sup>&nbsp;+ QUAD1 * year + QUAD<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">or for cubic curve<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sea Level = CUBIC3 * year<sup>3<\/sup>&nbsp;+ CUBIC2 * year<sup>2<\/sup>&nbsp;+ CUBIC1 * year + CUBIC<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These formulae will then produce accurate values for the sea levels.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><u>Curve Fitting 1<\/u><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The quadratic curve may be one of many other equally well-fitting curves.&nbsp; In this instance another class of curve could be long term sinusoidal variation and the following shows how a series of sinusoidal curves can be generated and compared.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A general sinusoidal curve can take the form (in Excel Format)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">=CONST+AMP*SIN(((SHIFT+2*A1)\/PERIOD)*PI())<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">where CONST is a constant mean sea level (mm)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">AMP is a +\/- amplitude variation (mm)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SHIFT is a phase shift (years)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">And PERIOD is a period of a complete oscillation (years)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">How can these four values be derived.&nbsp; Not knowing any mathematical process to home in on the four values that give the \u201cbest fit\u201d the following method was used.&nbsp; The question of what constitutes a best fit is not clear at this stage so will be addressed as the process progresses.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Stage 1 was to choose PERIOD, say 1000 years.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Stage 2 was to set CONST at zero.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">That leaves AMP and SHIFT.&nbsp; Choose a value of AMP such as 1000mm and any value of SHIFT and plot the result of applying all 4 values over the total period covered by the data.&nbsp; It will probably be totally wrong so modify SHIFT until the portion of the sinusoidal curve roughly resembles the data\/quadratic curve in form.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Adjust SHIFT and AMP until the portion of the sinusoidal curve looks approximately \u201cparallel\u201d to the quadratic curve at which stage a value of CONST can be added to make the 2 curves roughly coincide.&nbsp; Final tuning of CONST, AMP and SHIFT can be carried out either visually or by introducing some \u201cbest fit\u201d criteria.&nbsp; In this instant the visual inspection was considered sufficient but later with a different case the question of best fit will be addressed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After much blood, sweat and toil the following parameters were homed in on.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONST = 223 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AMP = 600 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SHIFT = -300 years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERIOD = 1000 years<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A second curve based on a period of 1500 years was then more easily found giving<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONST = 695 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AMP = 1090 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SHIFT = -510 years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERIOD = 1500 years<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Using interpolation and some small fine tuning 3 other curves were found<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONST = 342 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AMP = 722 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SHIFT = -355 years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERIOD = 1125 years<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONST = 462 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AMP = 845 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SHIFT = -410 years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERIOD = 1250 years<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONST = 578 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AMP = 968 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SHIFT = -469 years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERIOD = 1175 years<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"246\" data-attachment-id=\"341585\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341585\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-68.png?fit=600%2C246&amp;ssl=1\" data-orig-size=\"600,246\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-68.png?fit=600%2C246&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-68.png?resize=600%2C246&#038;ssl=1\" alt=\"\" class=\"wp-image-341585\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-68.png?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-68.png?resize=300%2C123&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 3<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Figure 3 shows the Quadratic Curve and the 5 Sinusoidal Curves.&nbsp; They all lie within about 3 mm of each other which is minimal considering the range of the basic data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The following statement occurred to me, but I am not sure if it is profound or naive.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>\u201cThere is one Quadratic Curve and a multitude of Sinusoidal Curves.&nbsp; Why would Nature choose the Quadratic Curve?\u201d<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Figures 4 and 5 show the 1<sup>st<\/sup>&nbsp;and 2<sup>nd<\/sup>&nbsp;derivatives for the 6 curves.&nbsp; The 2<sup>nd<\/sup>&nbsp;derivatives all vary greatly from the Quadratic as would be expected as the time scale covered is a sizeable portion of the periods involved.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"366\" data-attachment-id=\"341587\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341587\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-70.png?fit=600%2C366&amp;ssl=1\" data-orig-size=\"600,366\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-70.png?fit=600%2C366&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-70.png?resize=600%2C366&#038;ssl=1\" alt=\"\" class=\"wp-image-341587\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-70.png?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-70.png?resize=300%2C183&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 4<\/strong><\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"369\" data-attachment-id=\"341590\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341590\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-72.png?fit=600%2C369&amp;ssl=1\" data-orig-size=\"600,369\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-72.png?fit=600%2C369&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-72.png?resize=600%2C369&#038;ssl=1\" alt=\"\" class=\"wp-image-341590\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-72.png?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-72.png?resize=300%2C185&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 5<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Figure 6 shows the 6 curves extrapolated over 2000 years.\u00a0 You pays your money and takes your choice.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"361\" data-attachment-id=\"341591\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341591\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-73.png?fit=600%2C361&amp;ssl=1\" data-orig-size=\"600,361\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-73.png?fit=600%2C361&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-73.png?resize=600%2C361&#038;ssl=1\" alt=\"\" class=\"wp-image-341591\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-73.png?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-73.png?resize=300%2C181&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 6<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong><u>Moving Averages<\/u><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Excel plots Moving Averages in a strange way when presenting engineering or scientific data.&nbsp; It plots the average curve right shifted whereas a more informative form would have the average values plotted a mid-point of the range used when averaging.&nbsp; It is very simple to produce your own averages and plot to be more useful.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Figure 7 shows the data plotted with both forms of presentation.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"221\" data-attachment-id=\"341594\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341594\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-75.png?fit=720%2C221&amp;ssl=1\" data-orig-size=\"720,221\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-75.png?fit=720%2C221&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-75.png?resize=720%2C221&#038;ssl=1\" alt=\"\" class=\"wp-image-341594\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-75.png?w=720&amp;ssl=1 720w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-75.png?resize=300%2C92&amp;ssl=1 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 7<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">As \u201cOl\u2019 Blue Eyes\u201d said I will continue to do it \u201cMy Way\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><u>Curve Fitting 2<\/u><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the previous section on Curve Fitting long term (around 1000 year) periods were considered but now short term (few decades) will be discussed these possibly occurring due to decadal oscillations in climate behaviour.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With the data being used this variation will first be found by estimating how much the fitted curve varies from the actual readings.&nbsp; Values calculated on the fitted curve are subtracted from the data and this set of values forms a set of residuals as shown in Figure 8.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"364\" data-attachment-id=\"341595\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341595\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-76.png?fit=600%2C364&amp;ssl=1\" data-orig-size=\"600,364\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-76.png?fit=600%2C364&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-76.png?resize=600%2C364&#038;ssl=1\" alt=\"\" class=\"wp-image-341595\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-76.png?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-76.png?resize=300%2C182&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 8<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">The target equation will have the same form as shown above but this method could be used more generally unless only a part of a cycle exists.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The 21 year moving averages were calculated as shown in Figure 9.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"359\" data-attachment-id=\"341598\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341598\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-78.png?fit=600%2C359&amp;ssl=1\" data-orig-size=\"600,359\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-78.png?fit=600%2C359&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-78.png?resize=600%2C359&#038;ssl=1\" alt=\"\" class=\"wp-image-341598\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-78.png?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-78.png?resize=300%2C180&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 9<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">A first estimation for the equation used<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a>CONST = 0 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AMP = 15 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SHIFT = 50 years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERIOD = 65 years<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Figure 10 shows the data with the fitted curve.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"366\" data-attachment-id=\"341599\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341599\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-79.png?fit=600%2C366&amp;ssl=1\" data-orig-size=\"600,366\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-79.png?fit=600%2C366&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-79.png?resize=600%2C366&#038;ssl=1\" alt=\"\" class=\"wp-image-341599\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-79.png?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-79.png?resize=300%2C183&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 10<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">The judgement criteria chosen, C, was the square root of the sum of the squares of the errors which for the starting estimation was 49.6.&nbsp; A convergence strategy involved recalculating the value of C using each of the parameters in turn changed by +1 and -1.&nbsp; The parameter change that reduced C the greatest was retained, and the process repeated until no further reduction in C occurred.&nbsp; This resulted in<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a>CONST = 1 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AMP = 13 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SHIFT = 54 years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERIOD = 67 years<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">with C reducing to 43.2.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A second convergence sequence was carried out with the parameters now changed by +0.5 and -0.5 resulting in<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp; CONST = 1 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AMP = 13.5 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SHIFT = 55.5 years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERIOD = 67.5 years<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">and a C value of 42.4.&nbsp; This final curve is shown in figure 11.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"364\" data-attachment-id=\"341601\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341601\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-80.png?fit=600%2C364&amp;ssl=1\" data-orig-size=\"600,364\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-80.png?fit=600%2C364&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-80.png?resize=600%2C364&#038;ssl=1\" alt=\"\" class=\"wp-image-341601\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-80.png?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-80.png?resize=300%2C182&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 11<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">In carrying out this convergence process it was very useful to make use of \u201cnamed\u201d variables for the parameters and the incremental changes in this form.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =CONST+AMP*SIN(((SHIFT+2*A13)\/PERIOD)*PI()) for the basic central value<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =(CONST-DCONST)+AMP*SIN(((SHIFT+2*A13)\/PERIOD)*PI())<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a>for the incremental reduction in CONST<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">And so on for the remaining 7 incremental changes up to<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =CONST+AMP*SIN(((SHIFT+2*A13)\/(PERIOD+DPERIOD))*PI())<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">for the incremental increase in PERIOD.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">From previous experience in using this technique in engineering the final solution is not guaranteed to be the true optimum as false minimums can be reached which the process is not capable of getting away from or the process can be stuck in a \u201cvalley\u201d.&nbsp; The existence of such dips and valleys is difficult to visualize with four variables as the results would form a 4-dimensional graph.&nbsp; An extra check may be to start with a completely different set of starting parameters.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Another technique was to change to diagonal increments which with 4 dimensions involves 16 combinations of changes followed by alternate use of both approaches. The process stops when both processes cease changes in the value of the judgement criteria, C.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This had little effect the final values being<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp; CONST = 1.5 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AMP = 14 mm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SHIFT = 57.5 years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERIOD = 68.5 years<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">and a value of C of 41.95 as shown in figure 12.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The final graph shows improvements but strangely the value of CONST=1.5mm is difficult to explain but averaged data only cover a range of 111 years which is only 1.62 periods .<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"363\" data-attachment-id=\"341602\" data-permalink=\"https:\/\/climatescience.press\/?attachment_id=341602\" data-orig-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-81.png?fit=600%2C363&amp;ssl=1\" data-orig-size=\"600,363\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-81.png?fit=600%2C363&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-81.png?resize=600%2C363&#038;ssl=1\" alt=\"\" class=\"wp-image-341602\" srcset=\"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-81.png?w=600&amp;ssl=1 600w, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/image-81.png?resize=300%2C182&amp;ssl=1 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><strong>Figure 12<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong><u>R Squared<\/u><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">R Squared was a term I was not familiar with but can appear along with the trend line equation as a measure of the fit.&nbsp; I tried to make use of it as a measure of the accuracy between 2 sets of numbers during the previous convergence process using the function as follows<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RSQ( a1:a131,b1;b131)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">but it is only measuring the \u201cthe proportion of variance in the dependent variable that can be explained by the independent variable\u201d and not the accuracy between 2 sets of numbers so I abandoned it.&nbsp; I.e. if the above function gave 0.8 and all b values were doubled or had 10 added the RSQ function would still give 0.8.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Googling R Squared does produce some negative remarks about it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In conclusion it is hoped that some of the above topics may be found useful.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In a comment to one of my previous papers I was called a \u201cCyclomaniac\u201d.&nbsp; Not sure if this was a&nbsp; compliment or a criticism.&nbsp; Interesting to see if this comment keeps getting repeated!!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><u>References<\/u><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1.&nbsp;&nbsp; <a href=\"https:\/\/wattsupwiththat.com\/2024\/08\/11\/variation-of-50-year-relative-sea-level-trends-northeast-united-states\/\" rel=\"nofollow\">https:\/\/wattsupwiththat.com\/2024\/08\/11\/variation-of-50-year-relative-sea-level-trends-northeast-united-states\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong># # # # #<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Note:&nbsp;<\/strong>As usual, I have facilitated Dr. Welch in preparing this essay for publication here at WUWT. The content and ideas expressed are entirely those of Dr. Welch. I do this in the spirit that all scientific opinions deserve an airing and that you, the readers, have the right to read and comment on these opinions. As I have said previously in reference to Dr. Welch\u2019s work, I am not a fan of curve fitting. That should not affect your view of his excellent work on sea level and the possibility that sea level is accelerating or has accelerated or your opinion on his insight in using MS Excel functions to analyze the data. He does good work. \u2014 Kip Hansen<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong># # # # #<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Having used Excel for the last 7 years to study Sea Levels I have discovered various pit falls, techniques and useful functions.  I wish to share these with the wider WUWT community.  To some it may be like teaching your Granny to suck eggs (as we say in the UK) but hopefully some may pick up a few useful facts or ideas.<\/p>\n","protected":false},"author":121246920,"featured_media":341605,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_crdt_document":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1],"tags":[691830471,691830472,691820093,691830470],"class_list":{"0":"post-341580","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-uncategorized","8":"tag-curve-fitting-1","9":"tag-moving-averages","10":"tag-sea-level","11":"tag-trend-line-equations","13":"fallback-thumbnail"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/09\/00COP28-scaled-1.jpg?fit=2560%2C1707&ssl=1","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paxLW1-1qRm","jetpack-related-posts":[{"id":426873,"url":"https:\/\/climatescience.press\/?p=426873","url_meta":{"origin":341580,"position":0},"title":"WUWT Leads The Way Again","author":"uwe.roland.gross","date":"18\/02\/2026","format":false,"excerpt":"So \u2026 can we put this question to bed?\u00a0 There is no evidence of acceleration in the actual tide gauge sea level data, and the apparent acceleration in the satellite data is merely an artifact of splicing disparate satellite records.","rel":"","context":"In \"Climate change\"","block_context":{"text":"Climate change","link":"https:\/\/climatescience.press\/?tag=climate-change"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2025\/02\/0-Sea-levels-town.jpeg?fit=1200%2C900&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2025\/02\/0-Sea-levels-town.jpeg?fit=1200%2C900&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2025\/02\/0-Sea-levels-town.jpeg?fit=1200%2C900&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2025\/02\/0-Sea-levels-town.jpeg?fit=1200%2C900&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2025\/02\/0-Sea-levels-town.jpeg?fit=1200%2C900&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":337287,"url":"https:\/\/climatescience.press\/?p=337287","url_meta":{"origin":341580,"position":1},"title":"Comparing UAH Temperatures , NASA Sea Levels and El Ni\u00f1o\/La Ni\u00f1a Data","author":"uwe.roland.gross","date":"23\/07\/2024","format":false,"excerpt":"LONG ESSAY WARNING:\u00a0 This essay is long and technical, 3300 words.\u00a0 Dr. Welch provides a summary for those less interested in the details of his analysis.","rel":"","context":"In \"El Ni\u00f1o\/La Ni\u00f1a Data\"","block_context":{"text":"El Ni\u00f1o\/La Ni\u00f1a Data","link":"https:\/\/climatescience.press\/?tag=el-nino-la-nina-data"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/07\/0Screenshot-2024-07-23-154853.png?fit=1182%2C612&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/07\/0Screenshot-2024-07-23-154853.png?fit=1182%2C612&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/07\/0Screenshot-2024-07-23-154853.png?fit=1182%2C612&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/07\/0Screenshot-2024-07-23-154853.png?fit=1182%2C612&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2024\/07\/0Screenshot-2024-07-23-154853.png?fit=1182%2C612&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":227499,"url":"https:\/\/climatescience.press\/?p=227499","url_meta":{"origin":341580,"position":2},"title":"Sea-level rise in the Mediterranean Sea branded \u2019staggering \u2018, due to scientists \u201ausing a vital new method \u2018","author":"uwe.roland.gross","date":"04\/11\/2022","format":false,"excerpt":"Vastly higher? Enormous? Staggering? \u2013 should we be shocked? No, because none of these words from the article below appear in the study itself","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2022\/11\/image-183.png?fit=1200%2C732&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2022\/11\/image-183.png?fit=1200%2C732&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2022\/11\/image-183.png?fit=1200%2C732&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2022\/11\/image-183.png?fit=1200%2C732&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2022\/11\/image-183.png?fit=1200%2C732&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":236772,"url":"https:\/\/climatescience.press\/?p=236772","url_meta":{"origin":341580,"position":3},"title":"Science Catches Up With WUWT","author":"uwe.roland.gross","date":"29\/12\/2022","format":false,"excerpt":"There\u2019s no evidence of any acceleration in the rate of sea-level rise in either the tide gauge or the shabbily-spliced satellite records.","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2022\/12\/0drop-shadow.webp?fit=1199%2C788&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2022\/12\/0drop-shadow.webp?fit=1199%2C788&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2022\/12\/0drop-shadow.webp?fit=1199%2C788&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2022\/12\/0drop-shadow.webp?fit=1199%2C788&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2022\/12\/0drop-shadow.webp?fit=1199%2C788&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":255812,"url":"https:\/\/climatescience.press\/?p=255812","url_meta":{"origin":341580,"position":4},"title":"30 Years of Measuring and Analysing Sea Levels using Satellites","author":"uwe.roland.gross","date":"03\/05\/2023","format":false,"excerpt":"I find Dr. Welch\u2019s analyses interesting and feel strongly that Dr. Welch\u2019s analyses deserve to be seen and discussed.","rel":"","context":"In \"NASA\"","block_context":{"text":"NASA","link":"https:\/\/climatescience.press\/?tag=nasa"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2023\/05\/0359500989.jpg?fit=1200%2C800&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2023\/05\/0359500989.jpg?fit=1200%2C800&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2023\/05\/0359500989.jpg?fit=1200%2C800&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2023\/05\/0359500989.jpg?fit=1200%2C800&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2023\/05\/0359500989.jpg?fit=1200%2C800&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":244764,"url":"https:\/\/climatescience.press\/?p=244764","url_meta":{"origin":341580,"position":5},"title":"Further Exploration of Historical Sea Level Rise Acceleration","author":"uwe.roland.gross","date":"21\/02\/2023","format":false,"excerpt":"The PMSL dataset that I had downloaded had site information for a total of 1548 tidal gauge sites, but only 1537 sites had local sea level data.","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2023\/02\/image-575.png?fit=1200%2C674&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2023\/02\/image-575.png?fit=1200%2C674&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2023\/02\/image-575.png?fit=1200%2C674&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2023\/02\/image-575.png?fit=1200%2C674&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/climatescience.press\/wp-content\/uploads\/2023\/02\/image-575.png?fit=1200%2C674&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/climatescience.press\/index.php?rest_route=\/wp\/v2\/posts\/341580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/climatescience.press\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/climatescience.press\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/climatescience.press\/index.php?rest_route=\/wp\/v2\/users\/121246920"}],"replies":[{"embeddable":true,"href":"https:\/\/climatescience.press\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=341580"}],"version-history":[{"count":10,"href":"https:\/\/climatescience.press\/index.php?rest_route=\/wp\/v2\/posts\/341580\/revisions"}],"predecessor-version":[{"id":341607,"href":"https:\/\/climatescience.press\/index.php?rest_route=\/wp\/v2\/posts\/341580\/revisions\/341607"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/climatescience.press\/index.php?rest_route=\/wp\/v2\/media\/341605"}],"wp:attachment":[{"href":"https:\/\/climatescience.press\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=341580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/climatescience.press\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=341580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/climatescience.press\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=341580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}