Statistics for Managers Using Microsoft Excel 7E - Levine - SM levine_smume7_ism_ols_09

《Statistics for Managers Using Microsoft Excel 7E - Levine - SM levine_smume7_ism_ols_09》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、SolutionstotheMountainStatesPotatoCompanyCase1401TheMountainStatesPotatoCompanyCaseTheindependentvariablesinvolvedarethepHofthefiltercake(PH),thepressureinthevacuumlinebelowthefluidlineontherotatingdrum(LOWER),thepressureofthevacuumlineabovethefluidlineo

2、ntherotatingdrum(UPPER),cakethicknessmeasuredonthedrum(THICK),settingusedtocontrolthedrumspeed(VARIDRIV),andthespeedatwhichthedrumwasrotatedwhencollectingfiltercake(DRUMSPD).ThesedataarecontainedinthePOTATOfile.Webeginouranalysisofthepotatoprocessingdata

3、byfirstmeasuringtheamountofcollinearitythatexistsbetweentheexplanatoryvariablesthroughtheuseofthevarianceinflationaryfactor.ThefollowingfigurerepresentspartialPHStatoutputforamultiplelinearregressionmodelinwhichthepercentofsolidsispredictedfromthesixexpl

4、anatoryvariables.WeobservethatfouroftheVIFareabove5.0,rangingfrom9.9forVaridrivto8.4forUpper.Thus,basedonthecriteriadevelopedbySnee,thereisevidenceofcollinearityamongatleastsomeoftheexplanatoryvariables.Areasonablestrategyistoremovetheindependentvariable

5、withthelargestVIFabove5,anddeterminewhateffectthishasontheVIFoftheremainingindependentvariables.RegressionAnalysisRegressionAnalysisPHandallotherXLowerPressureandallotherXRegressionStatisticsRegressionStatisticsMultipleR0.561502MultipleR0.939267RSquare0.

6、315284RSquare0.882222AdjustedRSquare0.243959AdjustedRSquare0.869954StandardError0.232255StandardError0.716466Observations54Observations54VIF1.460459VIF8.490574RegressionAnalysisRegressionAnalysisUpperPressureandallotherXCakeThicknessandallotherXRegressio

7、nStatisticsRegressionStatisticsMultipleR0.93823MultipleR0.616598RSquare0.880276RSquare0.380193AdjustedRSquare0.867805AdjustedRSquare0.31563StandardError0.766658StandardError0.108131Observations54Observations54VIF8.352558VIF1.613407RegressionAnalysisRegre

8、ssionAnalysisVaridrivspeedandallotherXDrumspeedsettingandallotherXRegressionStatisticsRegressionStatisticsMultipleR0.948243MultipleR0.946259RSquare0.899165RSquare0.895406AdjustedRSquare0.888661AdjustedRSquare0.884511Standa