Microsoft Office Tutorials and References

In Depth Information

Fig. 6.32
Worksheet Data for Chapter 6: Practice Problem #3

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

top title: RELATIONSHIP BETWEEN BODY LENGTH (mm) AND

FOREWING LENGTH (mm) IN MAYFLIES

x-axis title: Body Length (mm)

y-axis title: Forewing Length (mm)

move the chart below the table

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

delete the legend

delete the gridlines

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

add the regression equation to the chart.

(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 (2 decimal places) for the correlation and

three decimal places for all other decimal ﬁgures, including the coefﬁcients.

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

Then, print the regression output table on a separate page so that it ﬁts onto that

separate page.

(e) save the ﬁle as: BODY3

Answer the following questions using your Excel printout:

1. What is the correlation between Body Length and Forewing Length?

2. What is the y-intercept?

Search JabSto ::

Custom Search