Microsoft Office Tutorials and References

In Depth Information

Fig. 6.31
Worksheet Data for Chapter 6: Practice Problem #2

(a) create an
XY scatterplot
of these two sets of data such that:

top title: RELATIONSHIP BETWEEN BODY WEIGHT AND GILL

WEIGHT IN
Pachygrapsus marmoratus

x-axis title: BODY WEIGHT IN GRAMS (g)

y-axis title: GILL WEIGHT IN MILLIGRAMS (mg)

re-size the chart so that it is 7 columns wide and 25 rows long

delete the legend

delete the gridlines

move the chart below the table

(b) Create the
least-squares regression line
for these data on the scatterplot.

(c)) Use Excel to run the regression statistics to ﬁnd the
equation for the

leastsquares regression line
for these data and display the results below the chart

on your spreadsheet. Use number format (two decimal places) for the

correlation, r, and for both the y-intercept and the slope of the line.

(d)) Print the input data and the chart so that this information ﬁts onto one page.

(e) Then, print out the regression output table so that this information ﬁts onto a

separate page.

By hand:

(1a) Circle and label the value of the
y-intercept
and the
slope
of the

regression line onto that separate page.

(2b) Read from the graph the gill weight you would predict for a body

weight of 20 grams and write your answer in the space immediately

below:

_____________________

Search JabSto ::

Custom Search