Yuav ua li cas xam Variance hauv Excel

2024 Tus sau: Abigail Brown | [email protected]. Kawg hloov kho: 2024-01-07 19:03

Yuav Paub

• Xaiv Variance: Hom =VAR. S( hauv xovtooj uas koj xav kom qhov sib txawv tshwm sim thiab nkag mus rau ntau lub hlwb kom suav nrog. Hom ).
• Xaiv Regression Analysis: Nruab Kev Ntsuam Xyuas TookPack Ntxiv-hauv. Mus rau Data tab thiab xaiv Data Analysis > Regression > OK.
• Nkag mus rau lub xovtooj ntawm tes nrog Y qhov sib txawv hauv Input Y Range teb. Nkag mus rau lub xov tooj ntawm tes ntawm X variables hauv Input X Range. Xaiv qhov chaw tso zis.

Kab lus no piav qhia yuav ua li cas xam Variance thiab khiav Regression Analysis hauv Excel rau Windows thiab Mac. Nws suav nrog cov ntaub ntawv hais txog kev khiav qhov kev ntsuas rov qab hauv Excel Online. Cov haujlwm sib txawv no ua haujlwm hauv Excel 2019, Excel 2016, thiab Excel 2010 ntawm Windows; Excel 2016 thiab Excel 2011 ntawm macOS; thiab Microsoft Excel ntawm Android thiab iOS nrog rau Microsoft 365.

Xaiv cov qauv lossis cov neeg sib txawv

Excel muab lub luag haujlwm los suav qhov sib txawv thiab txhawb nqa ntxiv-ins uas ua rau kev ntsuas kev rov qab los.

Variance qhia tias ntau npaum li cas cov lej sib txawv ntawm qhov nruab nrab ntawm cov lej. Thaum muab piv cov variance xam, qhov ntau dua qhov sib txawv, qhov dav dav yog cov lej hauv cov ntaub ntawv teev. Qhov sib txawv ntawm 0, piv txwv li, qhia tias txhua tus lej hauv cov ntaub ntawv xaiv tau zoo ib yam. (Txoj kev sib txawv yog lub hauv paus square ntawm qhov sib txawv thiab ntsuas yuav ua li cas nthuav tawm cov ntaub ntawv teeb tsa.) Koj tuaj yeem khiav qhov sib txawv ntawm txhua tus lej hauv Excel.

1. Nyob hauv xovtooj uas koj xav xam qhov txawv, ntaus: =VAR. S(

   Lub luag haujlwm VAR. S xav tias cov ntaub ntawv teev yog tus qauv, tsis yog tag nrho cov pejxeem.

2. Tom qab ntawd nkag mus rau ntau lub hlwb kom suav nrog, xws li B2:B11. (Yog tias koj xav tau, koj tuaj yeem nyem lossis coj mus rhaub kom xaiv lub xov tooj ntawm tes.)

3. Tam sim no ntaus: )

   

Qhov tshwm sim tshwm sim hauv lub xov tooj ntawm tes. Qhov sib npaug yuav tsum zoo li: =VAR. S($B$2:$B$11)

Yog tias koj paub tseeb tias koj tab tom ua haujlwm nrog cov ntaub ntawv pej xeem ua tiav, koj tuaj yeem hloov pauv siv VAR. P muaj nuj nqi. Qhov ntawd yuav zoo li: =VAR. P($B$2:$B$11)

Run a Regression Analysis hauv Excel ntawm Windows lossis macOS

Kev tshuaj ntsuam xyuas kev rov qab pab koj nkag siab txog kev sib raug zoo ntawm qhov sib txawv. Nws muab kev tsom xam uas qhia lej txheeb xyuas yog tias thiab qhov txawv txav cuam tshuam li cas rau lwm txoj hauv kev tseem ceeb. Txhawm rau khiav qhov regression hauv Excel, koj xav tau ob pawg ntawm tus lej, nrog rau ib pawg uas ua haujlwm raws li Y sib txawv thiab lwm yam li X sib txawv. Feem ntau, cov lej no tau nkag rau hauv ob kab uas nyob ib sab.

Txhawm rau khiav rov qab ntawm Windows lossis macOS systems, koj yuav tsum tau nruab qhov Kev Ntsuam Xyuas ToolPak ntxiv rau Excel. Lub ToolPak ua haujlwm ntawm Excel 2007 lossis tshiab dua ntawm Windows systems thiab ntawm Excel 2016 lossis tshiab dua ntawm macOS systems.

Ntawm cov qauv tshiab ntawm Microsoft Excel ntawm Windows, ntaus add-in hauv lub thawv tshawb hauv Excel thiab nias enter Tom qab ntawd xaiv lub tshwm sim nrog lub iav mus rau sab laug ntawm cov lus Add-in uas qhia. (Rau lwm cov ntawv Excel ntawm Windows, xaiv Cov Ntaub Ntawv > Kev Xaiv > Ntxiv-Ins Tom qab ntawd hauv lub Manage, xaiv Excel Ntxiv-ins thiab Go) Tom ntej no, xaiv lub thawv kos ib sab ntawm Tsev Kev Tshawb FawbPak, tom qab ntawd xaiv OK

Ntawm macOS versions ntawm Excel, xaiv Tools > Excel Ntxiv-ins. Tom qab ntawd xaiv lub thawv kos ib sab ntawm Analysis ToolPak, thiab xaiv OK.

Rau txoj hauv kev ntxiv rau nruab Kev Tshawb Fawb ToolPak, ua raws Microsoft's Load the Analysis ToolPak hauv Excel nplooj ntawv pab. Thaum nruab, ToolPak muab rau koj nkag mus rau cov ntaub ntawv txheeb xyuas cov cuab yeej.

1. Xaiv lub Data tab, tom qab ntawd nrhiav thaj chaw Tshawb Fawb thiab xaiv Data Analysis.

   

2. Xaiv Regression ntawm daim ntawv thiab tom qab ntawd xaiv OK.

   

3. In the Input Y Range teb, nkag mus (lossis xaiv) cov kab ntawm cov hlwb uas muaj qhov sib txawv ntawm Y. Piv txwv li, qhov no yuav yog $B$2:$B$10.

   

4. In the Input X Range teb, nkag mus (lossis xaiv) cov kab ntawm cov hlwb uas muaj X sib txawv. Piv txwv li, qhov no yuav yog $A$2:$A$10.

   

5. Optionally, xaiv lub thawv rau Labels lossis ua lwm yam kev hloov kho uas xav tau rau cov kev xaiv suav rov qab tso tawm.

6. Nyob rau hauv cov kev xaiv tso zis, xaiv qhov chaw tso zis. Feem ntau, koj yuav xav xaiv qhov Daim Ntawv Ua Haujlwm Tshiab Ply: khawm, thaum tseem tawm hauv lub thawv tsis tau ntim.

   

7. Choose OK.

Cov txiaj ntsig rov qab tau tshwm sim hauv daim ntawv tshiab.

Run a Regression Analysis hauv Excel Online

Hauv browser, suav nrog Safari browser ntawm lub iPad, koj tuaj yeem ua cov kab rov qab hauv Excel online nrog kev pab los ntawm kev ntxiv-on.

1. Qhib Excel spreadsheet nrog koj cov ntaub ntawv hauv browser siv Excel Online.

2. Xaiv Insert> Office Add-ins.

   

3. Nyob rau hauv lub thawv tshawb nrhiav uas qhia, ntaus “ XLMiner Analysis ToolPak” thiab nias nkag.

4. Xaiv Ntxiv ntawm XLMiner Analysis ToolPak npo ntxiv ntau cov ntaub ntawv muaj peev xwm ntawm sab xis ntawm lub vijtsam.

   

5. Xaiv Linear Regression hauv XLMiner Analysis ToolPak menu.

   

6. In the Input Y Range teb, nkag mus (lossis xaiv) cov kab ntawm cov hlwb uas muaj qhov sib txawv ntawm Y. Piv txwv li, qhov no yuav yog B2:B11.

   

7. In the Input X Range teb, nkag mus (lossis xaiv) cov kab ntawm cov hlwb uas muaj X sib txawv. Piv txwv li, qhov no yuav yog A2:A11.

   

8. Optionally, xaiv lub thawv rau Cov Ntawv Sau lossis ua lwm yam kev hloov kho uas xav tau rau cov kev xaiv suav rov qab tso tawm.

9. Rau Tso Tawm Ntau, xaiv qhov chaw ntawm tes deb txaus rau sab xis lossis hauv qab ntawm koj daim ntawv kom paub meej tias nws nyob sab nraud ntawm lwm cov ntaub ntawv hauv koj daim ntawv Excel. Piv txwv li, yog tias tag nrho koj cov ntaub ntawv nyob hauv kab A txog C, koj tuaj yeem nkag mus rau F2 hauv lub thawv tso zis ntau yam.

   

10. Choose OK.

Cov txiaj ntsig rov qab tso tawm hauv koj daim ntawv Excel, pib ntawm lub xov tooj ntawm tes koj xaiv.