Logarithm basa muExcle

Imwe yeiyo-inotsikisa masvomhu zviito mukugadzirisa kudzidziswa uye mabasa anoshanda ndeyekutsvaga logarithm kubva kune yakapihwa nhamba zvichibva pane hwaro. MuBudiki, pane basa rinokosha iro rinonzi Log kuti uite basa iri. Ngatitsvagei mune zvimwe zvakadzama kuti zvinogona kushandiswa sei mukuita.

Uchishandisa Log Operator

Chirevo chehuni chinoreva chikamu chemasvomhu mabasa. Basa rayo ndere kuverenga logarithm yenhamba yakatarwa pane yakatarwa chigadziko. Iyo syntax yeiyo yakataurwa opareta iri nyore kwazvo:

= Log (nhamba; [base])

Sezvatinoona, basa racho rinongova nemakirogiramu maviri chete.

Iyo "nhamba" nharo ndiyo nhamba kubva kune iyo logarithm inofanira kuverengerwa. Inogona kutora mhando yehuwandu kukosha uye kuve chinongedzo kuchitokisi, icho chiripo.

Iyo "base" nharo ndiyo hwaro hwunovaverengerwa neLogutithm. Izvo zvinogona zvakare kuve, sechitarisiko chehuwandu, uye kuita muchimiro chechinongedzo kuchitokisi. Uku kupopotedzana hakusi kwekumanikidzwa. Kana ikasiyiwa, inotendwa kuti chigadziko chinonzi zero.

Mukuwedzera, pane rimwe basa mukubudikidza, rinoita kuti iwe uverenge logarithms - Log10. Yayo inonyanya kureva kubva pane yakapfuura iyo inogona kuverenga logarithms chete yeiyo base 10, kureva chete logarithms. Yayo Syntax iri nyore zvakanyanya kupfuura iyo yaimbomiririrwa Operator:

= Log10 (nhamba)

Sezvatinoona, chete nharo yebasa iri ndiyo "nhamba", kureva kuti, kukosha kwenhamba kana chirevo cheiyo cell iyo. Kusiyana neiyo Log Operator, basa iri hariwanikwe zvachose, sezvo rinofungidzirwa kuti hwaro hwehunhu hunogadziriswa hwakaenzana negumi.

Nzira 1: Kushandisa kweiyo log basa

Zvino ngatitarisei kushandiswa kweiyo log opareta pamuenzaniso chaiwo. Tine chikamu chehuwandu hwehuwandu. Isu tinofanirwa kuverenga logarithm pavari pahwaro hwe5.

1. Isu tinoita kusarudzwa kwesero rekutanga risina chinhu pane pepa mune iyo chikamu chatinoronga kuburitsa mhedzisiro yekupedzisira. Tevere, tinya pane "isa basa" icon, iyo iri pedyo neiyo formula mutsara.



2. Iyo mabasa wizard window inotanga kumhanya. Isu tinoenda kuChikamu "masvomhu". Isu tinoburitsa zita re "Log" zita mune rondedzero yevashandi, tobva tadzvanya pane "ok" bhatani.



3. Iyo Log Inoshanda Kukakavara Window Inotanga. Sezvauri kuona, ine minda miviri inoenderana nekupokana kweiyi opareta.

   Mu "nhamba" munda, mune yedu nyaya, pinda iyo kero yechitokisi chekutanga chekamuri iyo iyo data inowanikwa. Izvi zvinogona kuitwa nekupinda mumusango,. Asi pane nzira iri nyore kwazvo. Isa iyo isai mumunda wakataurwa, wobva wadzvanya bhatani rekuruboshwe mbeva pane tafura sero rine huwandu hwehuwandu hwaunoda. Iwo marongero echitokisi ichi anokurumidza kuoneka mu "nhamba" munda.

   Mu "nheyo" munda, tinongo isa kukosha "5", sezvazvinenge zvichingofanana kune ese akagadziriswa nhamba yehuwandu.

   Mushure mechigadzirwa cheiyo yakadhindwa manipulations, tinya pane "OK" bhatani.



4. Mhedzisiro yekugadzirisa basa remubatanidzwa rinobva ratidzwa musero rakataurwa nesu mudanho rekutanga remurayiridzo uyu.



5. Asi isu tinongo zadza chitunha chechitokisi chekutanga. Kuitira kuti uzadze uye zvimwe, iwe unofanirwa kutevedzera formula. Isa iyo isaor kune iyo yepazasi kurudyi kona yechitokisi iine iyo. Mazecha anozadza anoonekwa, fungidzira muchikamu chemuchinjiko. Isu tinoita clamp yeiyo kuruboshwe bhatani bhatani uye kudhonza muchinjiro kusvika kumagumo kwekamuri.



6. Maitiro ari pamusoro akatungamira kuchokwadi chekuti masero ese eiyo logarithm column anozadzwa nemhedzisiro yekuverenga. Chokwadi ndechekuti chirevo chakataurwa mu "nhamba" munda. Kana uchifamba mumasero shanduko uye inoshanduka.

Chidzidzo: Master of mabasa muExcle

Nzira 2: Kushandisa kweiyo Log10 Basa

Zvino ngatimbokurukurai muenzaniso wekushandisa iyo Log10 Operator. Semuenzaniso, tora tafura neiyo yakafanana sosi data. Asi zvino, chokwadi ndechekuti kuverenga iyo logarithm yehuwandu inowanikwa mu "Denga data" chikamu chakavakirwa pagumi (decimal logarithm).

1. Isu tinoburitsa iyo yekutanga sero isina chinhu yeiyo logarithm column uye tinya pane "isa basa" icon.



2. Muwindo rekushanda reWizard mabasa, isu zvakare tinoita shanduko kune chikamu "masvomhu", asi panguva ino unomira pazita rekuti "Log10". Dzvanya pazasi pewindo pane iyo "OK" bhatani.



3. Iyo log10 inoshanda kupokana newindo rakagadziriswa. Sezvauri kuona, ine ndima imwe chete - "nhamba". Isu tinosuma kero yeiyo yekutanga cell ye "sosi data" ikhoramu, iyo nzira imwechete yatakashandisa mumuenzaniso wapfuura. Wobva wadzvanya pane "OK" bhatani pazasi pewindo.



4. Mhedzisiro yekugadzirisa data, kureva kuti iyo decimal logarithm yenhamba yakatarwa, inoratidzwa muchitokisi chakatsanangurwa.



5. Kuti uverenge kuverenga uye kune dzimwe nhamba dzese dzakatumirwa patafura, ita kopi yefomula kuburikidza neyekuzara mucherechedzo, nenzira imwecheteyo seyakawana nguva yapfuura. Sezvatinoona, mhedzisiro yekuverenga yematauro enhamba dzinobviswa mumasero, zvinoreva kuti basa racho rapedzwa.

Chidzidzo: Mamwe mabasa emasvomhu muExle

Iko kushandiswa kweiyo log basa kunoita kuti iwe uve nekukasira kuverenga iyo logarithm kubva pane yakatarwa nhamba pane yakatarwa nhamba. Mushandi mumwe chete anogona kuverenga iyo decimal logarithm, asi nekuda kwezvinangwa izvi, iyo log10 basa inonyanya kujeka.