利用Excel进行统计分析-Chapter14-Introduction to Multiple Regression.ppt

《利用Excel进行统计分析-Chapter14-Introduction to Multiple Regression.ppt》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、StatisticsforManagersUsingMicrosoft®Excel5thEditionChapter14IntroductiontoMultipleRegressionChap14-1LearningObjectivesInthischapter,youlearn:HowtodevelopamultipleregressionmodelHowtointerprettheregressioncoefficientsHowtodeterminewhichindependentvariablestoincludeintheregressionmodelHo

2、wtodeterminewhichindependentvariablesaremostimportantinpredictingadependentvariableHowtousecategoricalvariablesinaregressionmodel2TheMultipleRegressionModelIdea:Examinethelinearrelationshipbetween1dependent(Y)&2ormoreindependentvariables(Xi).MultipleRegressionModelwithkIndependentVariabl

3、es:Y-interceptPopulationslopesRandomError3MultipleRegressionEquationThecoefficientsofthemultipleregressionmodelareestimatedusingsampledataEstimated(orpredicted)valueofYEstimatedslopecoefficientsMultipleregressionequationwithkindependentvariables:EstimatedinterceptInthischapterwewillalway

4、suseExceltoobtaintheregressionslopecoefficientsandotherregressionsummarymeasures.4MultipleRegressionEquationExamplewithtwoindependentvariablesYX1X2SlopeforvariableX1SlopeforvariableX25MultipleRegressionEquation2VariableExampleAdistributoroffrozendessertpieswantstoevaluatefactorsthoughtt

5、oinfluencedemandDependentvariable:Piesales(unitsperweek)Independentvariables:Price(in$)Advertising($100’s)Dataarecollectedfor15weeks6MultipleRegressionEquation2VariableExampleSales=b0+b1(Price)+b2(Advertising)Sales=b0+b1X1+b2X2WhereX1=PriceX2=AdvertisingWeekPieSalesPrice($)Advertising($

6、100s)13505.503.324607.503.333508.003.044308.004.553506.803.063807.504.074304.503.084706.403.794507.003.5104905.004.0113407.203.5123007.903.2134405.904.0144505.003.5153007.002.7Multipleregressionequation:7MultipleRegressionEquation2VariableExample,ExcelRegressionStatisticsMultipleR0.7221

7、3RSquare0.52148AdjustedRSquare0.44172StandardError47.46341Observations15ANOVAdfSSMSFSignificanceFRegression229460.02714730.0136.538610.01201Residual1227033.3062252.776Total1456493.333CoefficientsStandardErrortStatP-valueLower95%Upper95%Intercept306.52619114.253892.682850.