Saturday, February 6, 2010

A Fix For Climate Scientist Starter Kit Normalized Sunspot Group Numbers

There's a bug in the normalized Sunspot Group Numbers for version 1.5 of the Climate Scientist Starter Kit. The numbers weren't normalized correctly. This'll be fixed in version 2.0. In the meantime, you can generate correct normalized values yourself for the regular Sunspot Group Numbers by following these steps:
  1. Create a new empty column on the table that has the regular sunspot group number data.
  2. In the top cell of the new column, enter the formula =(ORIGINAL_COLUMN_ROW - MIN(ORIGINAL_COLUMN)) / (MAX(ORIGINAL_COLUMN) - MIN(ORIGINAL_COLUMN))
  3. The parenthesis in that formula are very import. Don’t forget them or rearrange them.
  4. Copy the formula to the rest of the new column.

ORIGINAL_COLUMN stands for the column letter that contains the data you want to normalize, the sunspot group number data. ORIGINAL_COLUMN_ROW stands for the row number in ORIGINAL_COLUMN that’s the same row number you’re entering this formula into on the new empty column.

An example is =(C2 - MIN(C)) / (MAX(C) - MIN(C)).

My apologies for this error.

No comments:

Post a Comment