## Project: Sun Spot Lab

For this project, you will determine how the number of sunspots has changed over time. You will look for patterns and predict future sunspot activity.

Sunspot Data - source data.pdf

The data above tells the mean total sunspots each year from 1960-2014. Transfer this data to a 2-column spreadsheet in Google Sheets. If you are unfamiliar with Google sheets, you can find tutorials here.

- Open Google Sheets
- Give your document a title
- In your top row, label column A "Year" and column B "Number of Spots"
- Fill in the years 1960 to 2014 in column "A". You can use a formula to avoid having to type each year.
- Type 1960 n cell A2
- In cell A3, type =A2+1
- Copy and paste the formula in the column for all the years (up to 2014)

- Use the data above to enter the number of spots for each year in column B

Now you will make a line graph from the data.

- Click and drag to highlight all your data
- From menu, click "Insert" and "Chart"
- Select the line graph
- Click "Customization"
- Change Major Gridlines to 10 and Minor Gridlines to 4
- Click "Insert"

Enlarge your chart so you can see the data clearly. Do you see any patterns in the Sunspot data?

Evaluate the data and answer the following questions.

**Do you notice anything strange about the data after 2008?** Write your observation in the discussion below.

## 24 comments