2 Open Excel
3 Scatter Plot Graph
4 Manipulate Markers
5 Select Variables
6 Line Graph
7 Move Axis
8 Select Columns
9 Move Axis
To change the size of the data markers place the cursor over the blue data and double click.
From the Colors and Lines tab, reduce the size of the markers to 2.
There is an empty area before and after the plotted data that does not need to be on the graph.
From the Format Data Series dialog box click on Axis.
In order to change the range of data on the chart a new minimum and maximum must be entered.
They should be:
Minimum - 36240
Maximum - 36440
(In Excel the date is calculated as a sequential number from Jan. 1st 1904 on a Macintosh, or from 1900 on a PC. When using a scatter graph the serial value, representing the number days from 1900, or 1904, needs to be changed.)
The completed chart should look like the one below. You may want to save your excel file and print a copy to answer the Introductory Lesson questions.
Question: Questions: Use the Albedo graph you have just created to answer the following questions.
Question 1. Why is the albedo higher in the month of April compared to the summer months?
Question 2. What is the approximate albedo from May 10th through July 10?
Question3. What is the approximate albedo from August to the beginning of October?
Question 4. At the end of October why do think the albedo increased?
Question5. What can the decrease in albedo have on the ground temperature?