I have come up with a direct relationship that I have never read about any where before. I calculated the distances between the Sun and Jupiter with Alcyone Ephemeris 3.2. and exported the data to a spreadsheet. I used a step setting of 30d 10:30 for those of you that have this software. This gave me records that were approximately 1 month apart.
Then I added the monthly sunspot numbers data from 1749 to the present to the distances raw data spreadsheet. I have 3110 records. Everything was then sorted by Jupiter’s distance from the Sun. Next I calculated the average number of sunspots per 8 month period—steps of .028281 in distance. This is what I came up with. What do you think?
I’m posting this here because I understand that Jupiter influencing sunspots is definitely against the mainstream thinking. However, this is an amazingly high r^2.