Qhov piv txwv no yuav qhia koj yuav ua li cas ntxiv cov kab sib txawv rau daim ntawv Excel.
- Txoj nyem rau ntawm cov ntaub ntawv series thiab nyob rau hauv cov ntsiab lus teb ntawv qhia zaub mov nyem Ntxiv cov kab sib txawv (Ntxiv Trendline).
- Nyem lub tab Trendline Options (Tshwj xeeb / Regression Hom) thiab xaiv Tawm (Linear).
- Qhia tus naj npawb ntawm lub sijhawm kom suav nrog hauv kev kwv yees - sau tus lej "3" hauv daim teb Xa mus rau (Tom ntej).
- Zuam cov kev xaiv Qhia qhov sib npaug ntawm daim duab (Display Equation on chart) thiab Muab tso rau ntawm daim duab qhia tus nqi ntawm qhov kwv yees kev ntseeg siab (Display R-squared tus nqi ntawm daim duab).
- Xovxwm Close (Kaw).
Tshwm sim:
Piav qhia:
- Excel siv qhov tsawg tshaj plaws squares txoj kev los nrhiav cov kab uas zoo tshaj plaws haum rau elevations.
- Tus nqi R-squared yog 0,9295 uas yog tus nqi zoo heev. Qhov ze nws yog 1, qhov zoo dua cov kab haum rau cov ntaub ntawv.
- Cov kab sib txawv muab lub tswv yim ntawm cov kev taw qhia uas qhov kev muag khoom mus. Thaum lub sij hawm 13 kev muag khoom tuaj yeem ncav cuag 120 (qhov no yog kev kwv yees). Qhov no tuaj yeem txheeb xyuas tau siv cov kab zauv hauv qab no:
y = 7,7515*13 + 18,267 = 119,0365