If the most clocklike comets can be shown to have begun near Earth with a very high probability (>99%), one can also directly conclude with a high probability that:

If these conclusions are shocking to some individuals, here is their challenge: Find an error in the calculations outlined below, or seriously consider the mathematical conclusions. For more details, see **"When Was the Flood, the Exodus, and Creation?"** on pages 485–488.

**Step 1:** Download from the internet the two papers referenced in Endnote 5 on page 487.^{1} They are located at

http://adsabs.harvard.edu/full/1981MNRAS.197..633Y

and

http://adsabs.harvard.edu/full/1994MNRAS.266..305Y

After reading both papers, set up a workbook in Excel 2007 (or higher) with the following worksheets:

a. Most Clocklike Comets

b. True Deviations Squared

c. Random Deviations Squared

Data and calculations from worksheets a–b will feed into subsequent worksheets.

Set up a table in the “Most Clocklike Comets” worksheet similar to Table 104 and fill in all 49 rows. The yellow cells will require simple calculations. Select any Julian date converter on the internet and become comfortable converting from calendar dates to Julian dates and vice versa.

**Step 2:** Set up a table in the “True Deviations Squared” worksheet similar to Table 105. Designate a row in column B for each of the past 4,000–6,000 years. In column C, calculate the corresponding Julian dates. In columns D and E (for comets Halley and Swift-Tuttle, respectively), calculate the number of days until (or since) that comet’s nearest perihelion. Square that number, and place the sum of those two squared numbers in the corresponding row in column G. Place the minimum of the numbers in column G in cell G1 and the corresponding Julian date and calendar date in cells G2 and G3. That is the year in which the three bodies (Halley, Swift-Tuttle, and Earth) were closest to each other. However, the degree of closeness may not be statistically significant. That significance will be determined in Step 3. Plot column G vs. column B (time), as shown in Figure 173.

Excel spreadsheets have built in functions that can save you a great deal of time. Consider using the functions: SQRT (square root), STDEV (sample standard deviation), MIN (minimum), and RAND (random number). Also macros can repeat complex operations in milliseconds.

**Step 3:** In the “Random Deviations Squared” worksheet, repeat Step 2, but begin each comet’s backward march from a random point on its oldest known orbit instead of its perihelion. With a macro, repeat this process 1,000,000 times (for the time interval 4,000–6,000 years ago) and see what percent of those random trials produced a clustering at least as tight as you got in Step 2. Your answer should be only about 0.6 of 1%. Alternatively, if we began each comet’s backward projection from a random point on its oldest known orbit, we would have to search 333,333 years, on average, to find one clustering that was at least as tight. [2,000/(0.006)= 333,333]

**Step 4: ** Calculate the expected error for each comet individually. Those errors can be determined by three different methods: A, B, and C. All give the same answer. Method A, a simple, intuitive approach, will now be explained using comet Halley as an example.

**Method A: Geometric.** Visualize a timeline extending back in time from Halley’s oldest known perihelion in 1403.80 B.C. If we tick off exactly 27 69.86-year increments on that timeline, we will be at 3290 B.C.—our best estimate for the time of the flood, but an estimate with some uncertainty on either side of 3290 B.C. How large is that uncertainty?

Our best guess for all 27 time increments was the oldest known period (69.86 years), but there is an unknown error, x_{1}, in the first unknown orbital period. That first period, now with a known but slightly different length of 69.86 + x_{1}, becomes our best guess for all earlier periods, making the total error in our 3290 B.C. date for the flood, based just on the length of the first unknown period, 27 times x_{1} . (The random number, x_{1}, will be drawn from a normal distribution with a mean of zero and a standard deviation of 1.56 years.) With that first unknown period now known, we can repeat these steps for the next unknown period. That adds an error of 26 times x_{2}. Generalizing, the expected error for either comet becomes:

**Total Error =**

** N** **x****1**** + (N-1)** **x****2**** + (N-2)** **x****3**** **+ ...** + 3** **x****N-2**** + 2** **x****N-1**** + x****N**

where N, the number of periods a comet must take in going from its oldest known perihelion back to the best estimate for the time of the flood. For comet Halley, N=27.000. For comet Swift-Tuttle, N=20.000. Because the Total Error above is the sum of N independent random variables, such as N x_{1} and (N-1) x_{2},** **the standard deviation of the Total Error is

For comets Halley and Swift-Tuttle, these values are 130 years and 159 years, respectively.

Figure 173: Comet Clustering. The tight clustering of comets Halley and Swift-Tuttle with Earth in 3290 B.C. (as shown above) does not mean that was the year of the flood. It simply means that 3290 B.C. is the most likely year of the flood, based on these calculations. As shown by the red normal distribution, the flood could have occurred within a hundred or so years of that date. The depth of this downward spike in 3290 B.C., however, is quite unusual. Had the backward projection of Halley and Swift-Tuttle started at a random point on their oldest known orbits instead of at their perihelions, it would take, on average, 333,333 years before a similar tightness of clustering of these three bodies (Earth and comets Halley and Swift-Tuttle) would be found. Is it merely a coincidence that we found a one-in-333,333-year event very near the time of the historical global flood—after a backward search of only 1290 years?

Also, basic physics tells us that gravitational perturbations are as likely to increase a comet’s period as to decrease a comet’s period; that is, a gravitational body, such as a planet, is as likely to pass in front of an orbiting comet at a certain distance as to pass behind it at that distance. While we may not know how the unknown periods changed, the statistical mean of those changes will be zero; therefore, the mean of the possible dates for the flood is 3290 B.C.

**Method B: Algebraic.** For a particular comet:

t_{0}: the Julian date for the oldest known perihelion

t_{i} : an estimate of the Julian date for the i^{th} unknown perihelion

P_{0}: the oldest known period

P_{i}: an estimate for the i^{th} unknown period

x _{i }: the i^{th} random variable from a [0, s ] normal distribution of the changes in successive orbital periods of a comet

t_{1} = t_{0} - P_{0 } + x_{1} P_{1} = t_{0}-t_{1} = P_{0}- x_{1}

t_{2} = t_{1} - P_{1}+ x_{2} = (t_{0} - P_{0}+ x_{1}) - (P_{0}- x_{1}) + x_{2} = t_{0} - 2P_{0 }+ 2x_{1} + x_{2} P_{2} = t_{1}-t_{2} = P_{1}-x_{2} = (P_{0}- x_{1}) - x_{2} = P_{0}-x_{1} - x_{2}

t_{3 }= t_{2} - P_{2}+ x_{3} = (t_{0} - 2P_{0 }+ 2x_{1} + x_{2}) - (P_{0}-x_{1} - x_{2}) +x_{3} = t_{0} - 3P_{0 }+ 3x_{1} +2x_{2} + x_{3} P_{3} = t_{2}-t_{3} = P_{2}-x_{3} = (P_{0}-x_{1} - x_{2}) - x_{3} = P_{0}-x_{1} - x_{2} -x_{3}

**...**** **

**t****N**** = t****0**** - NP****0**** + **Nx**1**** + (N-1)x****2**** + (N-2)x****3**** **+ ...** + 3x****N-2**** + 2x****N-1**** + x****N**** **

Methods A and B produce identical results and have probability distributions that depends on only s and N.

**Method C: Simulation.** Instead of working with the long summations in Method B, a computer can generate each x_{i }as a random number from a [0, s ] normal distribution and substitute them in the equations:

t_{1} = t_{0} - P_{0 } + x_{1 } P_{1} = t_{0} - t_{1}

t_{2} = t_{1} - P_{1 }+ x_{2} P_{2} = t_{1} - t_{2}t_{3} = t_{2} - P_{2 }+ x_{3} P_{3} = t_{2} - t_{3} ...

t_{N} = t_{N-1} - P_{N-1}+ x_{N}

Each sequence of N random numbers (x_{1}, x_{2}, ..., x_{N} ) will give one simulated date for the flood, which will, in general, differ from 3290 B.C. Thousands of those simulated dates will give us the error estimates for each comet individually (of 130 and 159 years) that were found exactly in Methods A and B. Adding the additional information that both comets formed at about the same time—based on the statistical significance of >99%—allows the combined error estimate for the date of the flood to be reduced to ± 100 years.