![(1.34)-PowerPoint Ch 13商務(wù)統(tǒng)計(jì)課件_第1頁(yè)](http://file4.renrendoc.com/view/278f108c2c1ab45f3977bd74672287a5/278f108c2c1ab45f3977bd74672287a51.gif)
![(1.34)-PowerPoint Ch 13商務(wù)統(tǒng)計(jì)課件_第2頁(yè)](http://file4.renrendoc.com/view/278f108c2c1ab45f3977bd74672287a5/278f108c2c1ab45f3977bd74672287a52.gif)
![(1.34)-PowerPoint Ch 13商務(wù)統(tǒng)計(jì)課件_第3頁(yè)](http://file4.renrendoc.com/view/278f108c2c1ab45f3977bd74672287a5/278f108c2c1ab45f3977bd74672287a53.gif)
![(1.34)-PowerPoint Ch 13商務(wù)統(tǒng)計(jì)課件_第4頁(yè)](http://file4.renrendoc.com/view/278f108c2c1ab45f3977bd74672287a5/278f108c2c1ab45f3977bd74672287a54.gif)
![(1.34)-PowerPoint Ch 13商務(wù)統(tǒng)計(jì)課件_第5頁(yè)](http://file4.renrendoc.com/view/278f108c2c1ab45f3977bd74672287a5/278f108c2c1ab45f3977bd74672287a55.gif)
版權(quán)說(shuō)明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)
文檔簡(jiǎn)介
Chapter13
MultipleRegressionMultipleRegressionModelLeastSquaresMethodMultipleCoefficientofDeterminationModelAssumptionsTestingforSignificanceUsingtheEstimatedRegressionEquation forEstimationandPredictionCategoricalIndependentVariables Theequationthatdescribeshowthedependentvariableyisrelatedtotheindependentvariablesx1,x2,...xpandanerrortermis:MultipleRegressionModely=b0+b1x1+b2x2+
...+bpxp+ewhere: b0,b1,b2,...,bparetheparameters,and eisarandomvariablecalledtheerrortermMultipleRegressionModel Theequationthatdescribeshowthemeanvalueofyisrelatedtox1,x2,...xpis:MultipleRegressionEquationE(y)=
0+
1x1+
2x2+...+
pxpMultipleRegressionEquation Asimplerandomsampleisusedtocomputesamplestatisticsb0,b1,b2,...,bpthatareusedasthepointestimatorsoftheparametersb0,b1,b2,...,bp.EstimatedMultipleRegressionEquation^y=b0+b1x1+b2x2+...+bpxpEstimatedMultipleRegressionEquationEstimationProcessMultipleRegressionModelE(y)=
0+
1x1+
2x2+...+
pxp+eMultipleRegressionEquationE(y)=
0+
1x1+
2x2+...+
pxp
Unknownparametersareb0,b1,b2,...,bpSampleData:x1x2...xpy........
EstimatedMultipleRegressionEquation
Samplestatisticsareb0,b1,b2,...,bpb0,b1,b2,...,bpprovideestimatesofb0,b1,b2,...,bpLeastSquaresMethodLeastSquaresCriterionComputationofCoefficientValuesTheformulasfortheregressioncoefficientsb0,b1,b2,...bpinvolvetheuseofmatrixalgebra.Wewillrelyoncomputersoftwarepackagestoperformthecalculations. Theyearsofexperience,scoreontheaptitudetesttest,andcorrespondingannualsalary($1000s)forasampleof20programmersisshownonthenextslide.Example:ProgrammerSalarySurveyMultipleRegressionModelAsoftwarefirmcollecteddataforasampleof20computerprogrammers.Asuggestionwasmadethatregressionanalysiscouldbeusedtodetermineifsalarywasrelatedtotheyearsofexperienceandthescoreonthefirm’sprogrammeraptitudetest.47158100166921056846337810086828684758083918873758174877994708924.043.023.734.335.838.022.223.130.033.038.026.636.231.629.034.030.133.928.230.0Exper.(Yrs.)TestScoreTestScoreExper.(Yrs.)Salary($000s)Salary($000s)MultipleRegressionModel Supposewebelievethatsalary(y)isrelatedtotheyearsofexperience(x1)andthescoreontheprogrammeraptitudetest(x2)bythefollowingregressionmodel: MultipleRegressionModelwhere
y=annualsalary($000) x1=yearsofexperience
x2=scoreonprogrammeraptitudetesty=
0+
1x1+
2x2+
SolvingfortheEstimatesof
0,
1,
2
InputDataLeastSquaresOutputx1
x2
y47824710043......38930ComputerPackageforSolvingMultipleRegressionProblemsb0=b1=b2=R2=etc.Excel’sRegressionEquationOutputNote:ColumnsF-Iarenotshown.SolvingfortheEstimatesof
0,
1,
2EstimatedRegressionEquationSALARY=3.174+1.404(EXPER)+0.251(SCORE)Note:Predictedsalarywillbeinthousandsofdollars.InterpretingtheCoefficients Inmultipleregressionanalysis,weinterpreteachregressioncoefficientasfollows:birepresentsanestimateofthechangeinycorrespondingtoa1-unitincreaseinxiwhenallotherindependentvariablesareheldconstant. Salaryisexpectedtoincreaseby$1,404for eachadditionalyearofexperience(whenthevariable
scoreonprogrammerattitudetestisheldconstant).b1=1.404InterpretingtheCoefficients Salaryisexpectedtoincreaseby$251foreach additionalpointscoredontheprogrammeraptitude test(whenthevariableyearsofexperienceisheld constant).b2=0.251InterpretingtheCoefficientsMultipleCoefficientofDeterminationRelationshipAmongSST,SSR,SSEwhere:
SST=totalsumofsquares
SSR=sumofsquaresduetoregression
SSE=sumofsquaresduetoerrorSST=SSR+SSE=+Excel’sANOVAOutputMultipleCoefficientofDeterminationSSRSSTMultipleCoefficientofDeterminationR2=500.3285/599.7855=.83418R2=SSR/SSTAdjustedMultipleCoefficientofDeterminationThevarianceof
,denotedby
2,isthesameforallvaluesoftheindependentvariables.Theerror
isanormallydistributedrandomvariablereflectingthedeviationbetweentheyvalueandtheexpectedvalueofygivenby
0+
1x1+
2x2+..+
pxp.AssumptionsAbouttheErrorTerm
Theerror
isarandomvariablewithmeanofzero.Thevaluesof
areindependent.Insimplelinearregression,theFandttestsprovidethesameconclusion.TestingforSignificanceInmultipleregression,theFandttestshavedifferentpurposes.TestingforSignificance:FTestTheFtestisreferredtoasthetestforoverall
significance.TheFtestisusedtodeterminewhetherasignificantrelationshipexistsbetweenthedependentvariableandthesetofalltheindependentvariables.Aseparatettestisconductedforeachoftheindependentvariablesinthemodel.IftheFtestshowsanoverallsignificance,thettestisusedtodeterminewhethereachoftheindividualindependentvariablesissignificant.TestingforSignificance:tTestWerefertoeachofthesettestsasatestforindividual
significance.TestingforSignificance:FTestHypothesesRejectionRuleTestStatisticsH0:
1=
2=...=
p=0Ha:Oneormoreoftheparametersisnotequaltozero.F=MSR/MSERejectH0ifp-value<
aorifF>F
,whereF
isbasedonanFdistributionwithpd.f.inthenumeratorandn-p-1d.f.inthedenominator.FTestforOverallSignificanceHypothesesH0:
1=
2=0Ha:Oneorbothoftheparametersisnotequaltozero.RejectionRuleFor
=.05andd.f.=2,17;F.05=3.59RejectH0ifp-value<.05orF
>3.59Excel’sANOVAOutputFTestforOverallSignificancep-valueusedtotestforoverallsignificanceFTestforOverallSignificanceTestStatisticsF=MSR/MSE=250.16/5.85=42.76Conclusionp-value<.05,sowecanrejectH0.(Also,F=42.76>3.59)TestingforSignificance:tTestHypothesesRejectionRuleTestStatisticsRejectH0ifp-value<
aorift
<-t
ort
>
t
wheret
isbasedonatdistributionwithn-p-1degreesoffreedom.tTestforSignificanceofIndividualParametersHypothesesRejectionRuleFor
=.05andd.f.=17,t.025=2.11RejectH0ifp-value<.05,orift
<-2.11ort
>2.11Excel’sRegressionEquationOutputNote:ColumnsF-Iarenotshown.tTestforSignificanceofIndividualParameterststatisticandp-valueusedtotestfortheindividualsignificanceof“Experience”Excel’sRegressionEquationOutputNote:ColumnsF-Iarenotshown.tTestforSignificanceofIndividualParameterststatisticandp-valueusedtotestfortheindividualsignificanceof“TestScore”tTestforSignificanceofIndividualParametersTestStatisticsConclusionsRejectboth
H0:
1=0andH0:
2=0.Bothindependentvariablesaresignificant.TestingforSignificance:MulticollinearityThetermmulticollinearityreferstothecorrelationamongtheindependentvariables.Whentheindependentvariablesarehighlycorrelated(say,|r|>.7),itisnotpossibletodeterminetheseparateeffectofanyparticularindependentvariableonthedependentvariable.TestingforSignificance:MulticollinearityEveryattemptshouldbemadetoavoidincludingindependentvariablesthatarehighlycorrelated.Iftheestimatedregressionequationistobeusedonlyforpredictivepurposes,multicollinearityisusuallynotaseriousproblem.UsingtheEstimatedRegressionEquation
forEstimationandPredictionTheproceduresforestimatingthemeanvalueofyandpredictinganindividualvalueofyinmultipleregressionaresimilartothoseinsimpleregression.Wesubstitutethegivenvaluesofx1,x2,...,xpintotheestimatedregressionequationandusethecorrespondingvalueofyasthepointestimate.UsingtheEstimatedRegressionEquation
forEstimationandPredictionSoftwarepackagesformultipleregressionwilloftenprovidetheseintervalestimates.Theformulasrequiredtodevelopintervalestimatesforthemeanvalueofy
andforanindividualvalueofyarebeyondthescopeofthetextbook.^Inmanysituationswemustworkwithcategorical
independentvariables
suchasgender(male,female),methodofpayment(cash,check,creditcard),etc.Forexample,x2mightrepresentgenderwherex2=0indicatesmaleandx2=1indicatesfemale.CategoricalIndependentVariablesInthiscase,x2iscalledadummyorindicatorvariable. Theyearsofexperience,thescoreontheprogrammeraptitudetest,whethertheindividualhasarelevantgraduatedegree,andtheannualsalary($000)foreachofthesampled20programmersareshownonthenextslide.CategoricalIndependentVariablesExample:ProgrammerSalarySurvey Asanextensionoftheprobleminvolvingthecomputerprogrammersalarysurvey,supposethatmanagementalsobelievesthattheannualsalaryisrelatedtowhethertheindividualhasagraduatedegreeincomputerscienceorinformationsystems.47158100166921056846337810086828684758083918873758174877994708924.043.023.734.335.838.022.223.130.033.038.026.636.231.629.034.030.133.928.230.0Exper.(Yrs.)TestScoreTestScoreExper.(Yrs.)Salary($000s)Salary($000s)Degr.NoYesNoYesYesYesNoNoNoYesDegr.YesNoYesNoNoYesNoYesNoNoCategoricalIndependentVariablesEstimatedRegressionEquation^where:
y=annualsalary($1000)
x1=yearsofexperience
x2=scoreonprogrammerapt
溫馨提示
- 1. 本站所有資源如無(wú)特殊說(shuō)明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒(méi)有圖紙預(yù)覽就沒(méi)有圖紙。
- 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
- 5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
- 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
- 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。
最新文檔
- 5《七律 長(zhǎng)征》 說(shuō)課稿-2024-2025學(xué)年語(yǔ)文六年級(jí)上冊(cè)統(tǒng)編版001
- 2024年四年級(jí)英語(yǔ)下冊(cè) Unit 7 What's the matter第4課時(shí)說(shuō)課稿 譯林牛津版001
- 18《慈母情深》說(shuō)課稿-2024-2025學(xué)年統(tǒng)編版語(yǔ)文五年級(jí)上冊(cè)001
- 2025門窗工程承包合同
- 2025市場(chǎng)咨詢服務(wù)合同范本
- 2025嫁接種苗技術(shù)服務(wù)合同書
- 2024-2025學(xué)年高中歷史 第2單元 西方人文精神的起源及其發(fā)展 第7課 啟蒙運(yùn)動(dòng)說(shuō)課稿 新人教版必修3
- 信息平臺(tái)建設(shè)合同范本
- 7 《我在這里長(zhǎng)大》第一課時(shí)(說(shuō)課稿)2023-2024學(xué)年統(tǒng)編版道德與法治三年級(jí)下冊(cè)
- 書推廣合同范例
- 藥劑科合理用藥課件
- 專題23平拋運(yùn)動(dòng)臨界問(wèn)題相遇問(wèn)題類平拋運(yùn)和斜拋運(yùn)動(dòng)
- 超聲科醫(yī)德醫(yī)風(fēng)制度內(nèi)容
- 高三開(kāi)學(xué)收心班會(huì)課件
- 蒸汽換算計(jì)算表
- 四年級(jí)計(jì)算題大全(列豎式計(jì)算,可打印)
- 科技計(jì)劃項(xiàng)目申報(bào)培訓(xùn)
- 591食堂不合格食品處置制度
- 國(guó)際金融課件(完整版)
- 220t鍋爐課程設(shè)計(jì) 李學(xué)玉
- 全英文劇本 《劇院魅影》
評(píng)論
0/150
提交評(píng)論