Excel Batanion kuwerengera

Mwa zizindikiro zambiri zomwe zimagwiritsidwa ntchito paziwerengero, ndikofunikira kusankha kuwerengera. Tiyenera kudziwa kuti kuwonongedwa kwapadera kwa kuwerengera kumeneku ndi ntchito yosavuta. Mwamwayi, ntchito yowonjezera imagwira ntchito yomwe imakupatsani mwayi kuti mugwiritse ntchito njira. Timapeza algorithm pogwira ntchito ndi zida izi.

Kuwerengera Kubalalika

Kubalalika ndi chizindikiro cha kusiyanasiyana, komwe ndi lalikulu la kupatuka kuchokera ku mathengo. Chifukwa chake, imafotokoza kuchuluka kwa manambala ndi mtengo wamba. Kuwerengera kobala kumatha kuchitika ndi anthu wamba komanso zitsanzo.

Njira 1: Kuwerengera ndi Ulimi Wamphumi

Kuti muwerenge chisonyezo ichi ku Excel, General General amagwiritsa ntchito ntchito ya chiwonetserochi. Syntax ya mawuyi ili ndi mawonekedwe awa:

= D.G (nambala1; nambala2; ...)

Chachinthu chokwanira 1 mpaka 255 chitha kugwiritsidwa ntchito. Ngati mkangano womwe amatha kukhala ngati manambala ndi mafotokozedwe a maselo omwe ali nawo.

Tiyeni tiwone momwe mungawerengere mtengo wake ndi kuchuluka kwa manambala.

1. Timapanga kusankha kwa selo papepala lomwe zotsatirapo za kuwerengetsa kuwonetsedwa. Dinani pa batani la "Ikani Ntchito", kuyikidwa kumanzere kwa chingwe.



2. Ntchito zomwe Mbuye amayamba. Mu "Statistical" kapena "Mndandanda Wathunthu Wathunthu", Timafunafuna kukangana ndi dzina "mwendo". Pambuyo papezeka, timagawa ndikudina batani la "OK".



3. Chiwonetsero cha chiwonetsero cha kuwonetsera ntchito chikuyenda. Ikani cholozera mu "nambala ya" nambala1 ". Timagawana maselo osiyanasiyana papepala, yomwe ili ndi mzere wa manambala. Ngati pali magulu angapo otere, ndiye kuti mutha kugwiritsanso ntchito zogwirizana mu "nambala2", "nambala3" Windord Wide, etc. Pambuyo pazonse zomwe zidapangidwa, dinani batani la "OK".



4. Monga mukuwonera, zitatha izi zitatha. Zotsatira za kuwerengetsa kukula kwa kusiyanasiyana ndi General Sext zimawonetsedwa mu selo lotsogola. Ichi ndi gawo lomwe munthawi yomwe gawo la nthambi ilipo.

Phunziro: Mwini ntchito ku Excel

Njira 2: Kuwerengera zitsanzo

Mosiyana ndi kuchuluka kwa mtengo molingana ndi mawonekedwe a General, pakuwerengera zitsanzo mu chipembedzo, osati manambala onse, koma pang'ono. Izi zimachitika kuti mukonze zolakwika. Excel imaganizira izi mu ntchito yapadera, yomwe imapangidwa kuti iwerengere mtundu uwu - dis.v. Syntax yake imayimiriridwa ndi njira yotsatirayi:

= D (nambala1; nambala2; ...)

Chiwerengero cha mikangano, monga kale ntchito yapitayi, amathanso kusinthanso kuyambira 1 mpaka 255.

1. Tikutsindika mu khungu komanso momwemonso nthawi yapitayo, timayambitsa ntchito za ntchitozo.



2. M'gulu la "mndandanda wathunthu" kapena "wowerengera" kufunafuna dzinalo "Dis.v.". Pambuyo pa formula ikapezeka, timagawa ndikudina pa batani la "OK".



3. Ntchito ya ntchito yomwe imapangidwira. Kenako, timachitanso chimodzimodzi, monganso kugwiritsa ntchito wogwiritsa ntchito: timakhazikitsa cholozera mu "nambala yotsutsana ndikusankha dera lomwe lili ndi mzere. Kenako dinani batani la "OK".



4. Zotsatira za kuwerengera zidzachotsedwa mu chipinda chosiyana.

Phunziro: Ntchito zina zowerengera

Monga mukuwonera, pulogalamu ya Excel imatha kuthandizira kwambiri kuwerengera kwa kubadwa. Mtengo wowerengeka ukhoza kuwerengedwa ndi pulogalamuyi, onse ndi anthu wamba komanso zitsanzo. Pankhaniyi, zochita zonse za ogwiritsa ntchito zimachepetsedwa pokhapokha pazidziwitso zosiyanasiyana za manambala, ndi ntchito yayikulu imachita zokha. Zachidziwikire, zimasunga nthawi yayikulu yogwiritsa ntchito.