Microsoft Office Tutorials and References
In Depth Information
Fig. 6.32
Worksheet data for Chap. 6: practice problem #3
Create an Excel spreadsheet and enter the data using body length as the
independent variable (predictor) and the forewing length as the dependent variable
(criterion). Underneath the table, use Excel’s = correl function to find the
correlation between these two variables. Label the correlation and place it underneath
the table; then round off the correlation to two decimal places.
(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 find 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 figures, including the coefficients.
(d) Print just the input data and the chart so that this information fits onto one
page. Then, print the regression output table on a separate page so that it fits onto
that separate page.
(e) save the file as: BODY3
Answer the following questions using your Excel printout:
1. What is the correlation between Body Length and Forewing Length?
Search JabSto ::




Custom Search