利用Excel进行统计分析-Chapter13-Simple Linear Regression.pptVIP

Statistics for ManagersUsing Microsoft? Excel 5th Edition Chapter 13 Simple Linear Regression Learning Objectives In this chapter, you learn: To use regression analysis to predict the value of a dependent variable based on an independent variable The meaning of the regression coefficients b0 and b1 To evaluate the assumptions of regression analysis and know what to do if the assumptions are violated To make inferences about the slope and correlation coefficient To estimate mean values and predict individual values Correlation vs. Regression A scatter plot (or scatter diagram) can be used to show the relationship between two numerical variables Correlation analysis is used to measure strength of the association (linear relationship) between two variables Correlation is only concerned with strength of the relationship No causal effect is implied with correlation Correlation was first presented in Chapter 3 Regression Analysis Regression analysis is used to: Predict the value of a dependent variable based on the value of at least one independent variable Explain the impact of changes in an independent variable on the dependent variable Dependent variable: the variable you wish to explain Independent variable: the variable used to explain the dependent variable Simple Linear Regression Model Only one independent variable, X Relationship between X and Y is described by a linear function Changes in Y are related to changes in X Types of Relationships Types of Relationships Types of Relationships The Linear Regression Model The Linear Regression Model Linear Regression Equation The Least Squares Method b0 and b1 are obtained by finding the values of b0 and b1 that minimize the sum of the squared differences between Y and : Finding the Least Squares Equation The coefficients b0 and b1 , and other regression results in this chapter, will be found using Excel Interpretation of the Intercept and the Slope b0 is the estimated mean value of Y when