Yuav ua li cas xam cov Standardized Residuals hauv Excel
- Ib qho seem yog qhov sib txawv ntawm tus nqi pom thiab tus nqi kwv yees hauv tus qauv regression.
- Nws raug xam raws li:
- Residual=Observed value – Predicted value.
Vim li cas peb thiaj suav cov Standardized residuals?
Qhov zoo ntawm cov txheej txheem seem yog lawv txheeb xyuas qhov loj npaum li cas cov seem nyob hauv cov qauv sib txawv, thiab yog li siv tau yooj yim los txheeb xyuas cov neeg tawm: Kev soj ntsuam nrog tus qauv residual uas loj dua 3 (nyob rau hauv tus nqi kiag li) yog xam los ntawm ib co los ua ib tug outlier.
Yuav ua li cas yog cov mis rau xam cov seem?
Yog li, txhawm rau nrhiav qhov seem kuv yuav rho tawm tus nqi kwv yees los ntawm tus nqi ntsuas yog li rau x-tus nqi 1 qhov seem yuav yog 2 - 2.6=-0.6. Mentor: Yog lawm! Qhov seem ntawm qhov hloov pauv ywj pheej x=1 yog -0.6.
Koj ua li cas xam cov txheej txheem seem hauv Excel?
- Xaiv cov cuab yeej, Kev Ntsuam Xyuas Cov Ntaub Ntawv, Regression.
- Hloov rau kab uas muaj Y, tom qab ntawd kab uas muaj X, tom qab ntawv xaiv cov ntawv tsim nyog.
- Nias rau qhov seem seem thiab cov txheej txheem seem.
- Click OK.
- Cov seem yuav tshwm rau ntawm daim ntawv ua haujlwm hauv qab ntawm ANOVA cov lus thiab qhov ntsuas ntsuas.
Yuav ua li cas yog tus qauv seem nyob rau hauv regression?
Residual standard deviation is the standard deviation of the residual values, los yog qhov txawv ntawm ib pawg ntawm kev soj ntsuam thiab kwv yees qhov tseem ceeb. Tus qauv sib txawv ntawm cov seem seem suav ntau npaum li cas cov ntaub ntawv cov ntsiab lus nthuav dav nyob ib ncig ntawm kab rov qab.
