Maitiro ekuverenga midzi muExice

Kubvisa mudzi kubva pakati peiyo yakajairika masvomhu mathematical chiito. Izvo zvinoshanda kune dzakasiyana siyana kuverenga mumatafura. Microsoft Excel ine nzira dzinoverengeka dzekuverengera kukosha uku. Ngationgororei zvakadzama izvo zvakasiyana-siyana zvekuverengera kwakadaro muchirongwa ichi.

Nzira Dzinowedzera

Pane nzira mbiri dzekutanga dzekuverenga ichi chiratidzo. Imwe yacho yakakodzera chete yekuverenga midzi mamaira, uye yechipiri inogona kushandiswa kuverenga kukosha kweimwe nhanho.

Nzira 1: Basa rekushandisa

Kuti ubvise midzi mamaira, basa rinoshandiswa, iro rinonzi mudzi. Yayo syntax inotaridzika seiyi:

= Midzi (nhamba)

Kuti ushandise iyi sarudzo, zvakaringana kunyora kuchitokisi kana muchirongwa chechirongwa chechirongwa ichi chirevo, chitsiva izwi rekuti "nhamba" kune imwe nhamba kana yekodhi kero iyo iripo.

Kuita kuverenga uye kubudiswa kwemhedzisiro pachiratidziro, tinya bhatani rePeturu.

Mukuwedzera, iwe unogona kuisa iyi formula kuburikidza neTenzi wemabasa.

1. Dzvanya pane sero pane pepa apo mhedzisiro yekuverenga icharatidzwa. Enda kuburikidza nebhatani "Paste basa", rakaiswa padhuze nemutsara wemabasa.



2. Mune iyo rondedzero inovhura, sarudza iyo midzi chinhu. Dzvanya pane "OK" bhatani.



3. Iyo hwindo rekupokana rinovhura. Mumunda wega wehwindo rino, iwe unofanirwa kupinda chero kukosha kwakananga kubva kuRinozobviswa kana kurongeka kwesero kwainowanikwa. Zvakwana kudzvanya pachiteshi ichi kuitira kuti kero yayo yapinda mumunda. Mushure mekupinda iyo data, tinya iyo "OK" bhatani.

Nekuda kweizvozvo, mhedzisiro yekuverenga icharatidzwa muchitokisi chakataurwa.

Zvakare, basa racho rinogona kunzi kuburikidza ne "formula" tab.

1. Sarudza iyo sero kuratidza mhedzisiro yekuverenga. Enda kune "mafomu" tab.



2. Mu "basa raibhurari" Toolbar pane tepi tinya pane "mathematical" bhatani. Mune rondedzero inoratidzika, sarudza kukosha "mudzi".



3. Iyo hwindo rekupokana rinovhura. Zvese zvinoitika zviito chaizvo zvakafanana nekuita chiitiko kuburikidza ne "paste basa" bhatani.

Nzira 2: Kuiswa

Kuverenga midzi ye cubic uchishandisa sarudzo iri pamusoro hadzibatsire. Mune ino kesi, hukuru hunofanirwa kuvakwa muyero yehukama. Iyo General Type yeFomula yekuverenga ndeye:

= (nhamba) ^ 1/3

Ndokunge, hazvisi kunyange kubviswa, asi kuvakwa kwekukosha kwe1 / 3. Asi uyu degree uye is cubic midzi, saka, ichi chiito muExcel chinoshandiswa kuchigamuchira. Panzvimbo yenhamba yakatarwa, zvinokwanisika kuti uise iwo marongero emasero ane nhamba yehuwandu. Iyo rekodhi inogadzirwa mune chero nzvimbo yepepa kana mufomula mutsara.

Izvo hazvifanirwe kufungidzirwa kuti nzira iyi inogona kushandiswa chete kubvisa iyo cubic mudzi kubva pakati. Nenzira imwecheteyo, iyo mraba uye chero imwe mudzi inogona kuverengerwa. Asi mune iyi nyaya ichafanirwa kushandisa iyo inotevera formula:

= (nhamba) ^ 1 / n

n ndiyo mwero wekutarisa.

Nekudaro, iyi sarudzo ndeyekuwanda kupfuura kushandisa nzira yekutanga.

Sezvatinoona, kunyangwe paine chokwadi chekuti hapana basa repamusoro muExcel kuti ubvise midzi yeCubic, iyi kuverenga kunogona kuitwa nekushandisa dhigirii yehukama, kureva 1/3. Kuti ubvise midzi mativi, unogona kushandisa basa rakakosha, asi kunewo mukana wekuita izvi nekuvakisa nhamba. Ino nguva iwe uchafanira kuvakwa kusvika 1/2. Mushandisi iye amene anofanira kuona kuti ndeipi nzira yekuverenga yakanyanya nyore.