Name_______________ Assignment of Chapter 6
Part One: Consider the data in Exercise 6-46, use Excel to assist you in multiple linear
regression, and answer the following questions. They account for 50 points of this assignment.
1. Which of these six regressors will be kept in your final regression equation? Why? P-
value = 0.10
2. Find the regression coefficients for each regressor in your final equation.
3. Give the overall multiple R for your final equation.
4. Give the adjusted R square
5. Out print your residual plots for your final regression equation and comment about your
plots.
Part Two: Multiple choice questions (2 points each)
1. Which one of the following is not appropriate for studying the relationship between two quantitative variables?
A. Scatterplot
B. Bar chart
C. Correlation
D. Regression
2. A scatterplot is a
A. one-dimensional graph of randomly scattered data.
B. two-dimensional graph of a straight line.
C. two-dimensional graph of a curved line.
D. two-dimensional graph of data values.
3. Two variables have a positive association when
A. the values of one variable tend to increase as the values of the other variable increase.
B. the values of one variable tend to decrease as the values of the other variable increase.
4. A scatterplot of geographic latitude (x axis) and average January temperature (y axis) for 20 cities in the United
States is given below. Is there a positive association or a negative association? Explain what such an
association means in the context of this situation.
5. Which of the following can not be answered from a regression equation?
A. Predict the value of y at a particular value of x.
B. Estimate the slope between y and x.
C. Estimate whether the linear association is positive or negative.
D. Estimate whether the association is linear or non-linear
Questions 6 to 7: The simple linear regression equation can be written as
6. In the simple linear regression equation, the symbol represents the
A. predicted response.
B. estimated intercept.
C. estimated slope.
D. explanatory variable.