Trends in Geomagnetic Activity
import the AA index data into Excel:
- Go to the following
- Open the file AA_Year
- Select all
the data and Copy to the clipboard.
- Open the Excel workbook
you have the sunspot data in.
- On sheet2, select
columns A and Paste the data.
- You will need to insert
a row at the top of the sheet in order to label the columns YEAR
and AA INDEX
2: Comparing Sunspots and Geomagnetic Data
On sheet 3 of your Excel workbook, copy
and paste the columns containing the years 1900-1997, sunspot numbers,
and AA index. Put the years
in column A, sunspot numbers in column B, and AA indices in column C.
| To create
a combination graph of two data sets:
- Select the columns containing both data sets and
the column containing the independent variable data (if
- Click on the ChartWizard then click in the
spreadsheet at the point where you want your graph to appear.
The first pop-up window shows all the different types of
graphs that Excel can create. Choose the Combination
icon and click on Next.
- The next window asks you to further decide how
you want the graph to look.
Choose option 2
to display one data series in a bar graph and one as a line.
Notice that this graph has a
primary and secondary
y-axis, one for each data series.
Click on Next.
- Step four in the process displays a picture of
your graph. The
Data Series selection should be
columns since your data is entered in columns.
If you have a column of data selected as the independent
variable, the first column should be used as the X data.
Once you are satisfied with how the graph looks, click on
Next to proceed to the final step.
- In the final step, you should title the graph and
click on Finish.
- Format the graph so that the sunspot numbers are
in an area plot instead of a column graph. Also change the scale on
the secondary axis so that the AA Index data ranges from 0 to 60.
change the style of plot in an existing graph:
- Double click on the
graph for editing.
- Under the Format
menu, choose the group you wish to change (in this case, we
want to change the Column Group)
- When the pop-up window
appears, click on the Chart Type... button.
- Select the icon representing
the type of chart you want. (For this graph choose the area plot.)
Do the peaks and lows occur simultaneously?
close together? or perhaps opposite (one peaks while the other
is at a low)? Discuss
possible reasons for any trends you observe.
Discuss the geomagnetic disturbances during the
declining phase of a solar cycle.
What trends do you notice?
For a further discussion of this, go to the following web page:
Graph of AA index
and Sunspot Numbers
Create a graph in Excel that looks exactly
like this one.)
Can you think of any other phenomenon that might
be related to solar activity? The
home page of the NGDC
provides links to lots of scientific data.
Conjecture a possible phenomenon and its relationship to
sunspot numbers. Find the
data of interest, import it into a spreadsheet and compare it with the