This preview shows pages 1–2. Sign up to view the full content.
Homework 9
(due Tue. 10/6/09)
(1) Textbook:
2.98:
Answer all of the questions asked in the textbook. (Do not use Excel to answer any of these questions;
you may use your calculator; you do not need to show each step of the calculation; be sure to give 3
decimal places of accuracy in all your answers.)
In part (a): Make your scatterplot by hand. Be sure to clearly label and scale both axes. Scale the xaxis from
15 to 23 with labels at each whole number. Scale the yaxis from 3.00 to 3.60, with labels at
3.00, 3.10, 3.20,
etc.
In part (d): Make your residualplot by hand. Be sure to clearly label and scale both axes. Scale the xaxis
from 15 to 23 with labels at each whole number. Scale the vertical axis from .015 to +.015, with
tickmarks at .014, .013, .012, etc., and with labels at .015, .010, .005, .000, .005, .010, .015.
2.132,
2.147
(2)
Excel Work
(Only turn in templates):
(2A)
Read the Excel Manual pages 42 – 45 (correlation and regression …).
On a new worksheet, enter the dataset for Textbook Exercise 2.96 (file ex02_096 uploaded to the Bb site).
You will use Excel to answer all the questions in the textbook exercise:
(a) Make a scatterplot of the data, with the labels "Isotope" and "Silicon" on the appropriate axes; remove the
legend and the gridlines from the chart; the title of the scatterplot should be "Chemical Evidence of Climate
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview. Sign up
to
access the rest of the document.
 Fall '08
 AndrewB.Nobel

Click to edit the document details