Microsoft Office Tutorials and References

In Depth Information

Fig. 6.31 Worksheet data

for Chap. 6: practice

problem #2

Create an Excel spreadsheet and enter the data using body weight (in grams) as

the

independent

variable

(predictor)

and

gill

weight

(in

milligrams)

as

the

dependent variable (criterion).

(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.

Search JabSto ::

Custom Search