英文商务统计学ppt课件第十三章.ppt

《英文商务统计学ppt课件第十三章.ppt》由会员上传分享，免费在线阅读，更多相关内容在PPT专区-天天文库。

1、Chapter13MultipleRegressionBusinessStatistics:AFirstCourseFifthEditionChap13-1BusinessStatistics:AFirstCourse,5e©2009Prentice-Hall,Inc.LearningObjectivesInthischapter,youlearn:HowtodevelopamultipleregressionmodelHowtointerprettheregressioncoefficientsHowtodeterminewhich

2、independentvariablestoincludeintheregressionmodelHowtodeterminewhichindependentvariablesaremoreimportantinpredictingadependentvariableHowtousecategoricalvariablesinaregressionmodelTheMultipleRegressionModelIdea:Examinethelinearrelationshipbetween1dependent(Y)&2ormoreind

3、ependentvariables(Xi)MultipleRegressionModelwithkIndependentVariables:Y-interceptPopulationslopesRandomErrorMultipleRegressionEquationThecoefficientsofthemultipleregressionmodelareestimatedusingsampledataEstimated(orpredicted)valueofYEstimatedslopecoefficientsMultiplere

4、gressionequationwithkindependentvariables:EstimatedinterceptInthischapterwewilluseExcelorMinitabtoobtaintheregressionslopecoefficientsandotherregressionsummarymeasures.TwovariablemodelYX1X2SlopeforvariableX1SlopeforvariableX2MultipleRegressionEquation(continued)Example:

5、2IndependentVariablesAdistributoroffrozendessertpieswantstoevaluatefactorsthoughttoinfluencedemandDependentvariable:Piesales(unitsperweek)Independentvariables:Price(in$)Advertising($100’s)Dataarecollectedfor15weeksPieSalesExampleSales=b0+b1(Price)+b2(Advertising)WeekPi

6、eSalesPrice($)Advertising($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:ExcelMultipleRegressionOutputRegressionS

7、tatisticsMultipleR0.72213RSquare0.52148AdjustedRSquare0.44172StandardError47.46341Observations15ANOVAdfSSMSFSignificanceFRegression229460.02714730.0136.538610.01201Residual1227033.3062252.776Total1456493.333CoefficientsStandardErrortStatP-valueLower95%Upper95%Intercept3

8、06.52619114.253892.682850.0199357.58835555.46404Price-24.9750910.83213-2.305650.03979-48.57626-1.37392Advertis