Years	Bald Eagle Pairs	1. Create a Scrapbook with 5 scatter Plots & Prediction Equations.
3	2500	On page 300 in your textbook you will see the following data.
5	3000	Type the data into an EXCEL spreadsheet and create a scatter
7	3700	plot for each set. Add a trendline which represents the best-fit line.
9	4500	Also format the best-fit line to include the equation. You will use
11	5000	the equation to find the missing value in the table. Write your
14	5800	answer in a complete sentence.
13			Steps to create Scatter Plot
		1. Highlight only the data for one scatter plot at a time.
Air Temperature	Body Temperature	2. Click on the chart icon.
25.7	27	3. Select the scatter plot icon.
30.4	31.5	4. Click the next button twice.
28.7	28.9	5. A dialog box appears to type in the chart titles, label for x and
21.2	31	y-axis.
31.5	31.5	6. At the top of the dialog box, click on the Gridline tab. Check
26.2	25.6	major guidelines for x and y-axis.
30.1	28.4	7. Click the Legend Tab and remove the check for Show Legend.
31.5	31.7	8. Click on next and Save Chart AS NEW SHEET.
18.2	18.7	9. Remove the gray background. Double click on background
40.2		and under AREA click on none.
		10. Change Title, x & Y axis to at least 16 points.
Carbon Atoms	Boiling Point	11. Change the size and shape of scatter plot dots to 10 points.
2	-89	12. Right click on scatter plot dots and add a trend line.
3	-42	13. Format Trend line by adding an equation.
4	-1	14. Drag equation and place under title. Change size to 16 points.
6	69	15. Right click on trend line and format color.
8	126	16. Return to your spreadsheet to repeat these steps to create
	98.4	the next scatter plot. Remember to SAVE AS NEW SHEET
		17. Your spreadsheet document will have 5 charts. Save your
Year	Spending	EXCEL document on your P-Drive as SCATTER PLOT
1980	4.5	18. Each Scatter Plot should be printed to be place in your
1985	6.6	Scrapbook.
1990	11.6
1995	12.6		PROJECT REQUIREMENTS
1996	12.7	1. Create a scrapbook with 5 scatterplots & 5 prediction equations
1997	13.1	2. Print out each scatter plot. Make sure your axis and titles
1998	12.9	are labeled correct.
1999	12.4	3. Print out your spreadsheet values. Format the cells to include
2005		lines by selecting cells, and selecting outside,inside borders.
		4. Complete your prediction equation sheets. Find the missing
Rainfall	Acres	value by using your prediction equation and the computer's trend
17.5	194	line equation. You will compare the two answers.
12	645	5. Create an inviting cover sheet with the name PROJECT
14	250	SCATTER PLOT and your name. Your cover sheet must have
30.1	87	a picture.
16	83	6. Turn in project by November 9, 2007
19.6	80
18.1	180
16.3	46
20.4	94
18.5	146
22.2	507
12.7	340
8.25