Yin amfani da extrapolation a Microsoft Excel

Akwai lokuta idan kuna son sanin sakamakon yin ƙididdige ayyuka a waje da yankin da aka sani. Wannan batun ya fi dacewa da tsarin aikin hasashen yanayi. Akwai hanyoyi da yawa a cikin Excel waɗanda za a iya amfani da su don yin wannan aikin. Bari mu bincika su da takamaiman misalai.

Yin amfani da extrapolation

Ya bambanta da ma'amala, aikin shine don gano ƙimar aiki tsakanin muhawara biyu da aka sani, karin magana ya ƙunshi gano mafita a waje da yankin da aka sani. Abin da ya sa wannan hanyar ta kasance don buƙatar hasashen annabta.

A cikin Excel, ana iya amfani da extrapolation zuwa ga ƙimomin tabular da zane-zanen hoto.

Hanyar 1: extrapolation don bayanan shafin

Da farko, muna amfani da hanyar cirewa zuwa abubuwan da ke cikin kewayon tebur. Misali, dauki tebur wanda ake yawan yawan gardama (X) daga 5 a da 50 da jerin daidaitattun ayyuka na aiki (f (x)). Muna buƙatar gano ƙimar aikin don jayayya 55wannan yana waje da tsararren bayanai da aka ƙayyade. Don waɗannan dalilai muna amfani da aikin KYAUTA.

1. Zaɓi wayar wanda sakamakon lissafin zai bayyana. Danna alamar "Saka aikin", wanda aka sanya a layin tsari.



2. Window yana farawa Wizards na Aiki. Je zuwa rukuni "Na lissafi" ko "Cikakken jerin haruffa". A lissafin da ya buɗe, bincika sunan "KYAUTA". Samun samo shi, zaɓi, sannan danna maballin "Ok" a kasan taga.



3. Mun matsa zuwa taga muhawara na aikin da ke sama. Tana da hujjoji uku ne kawai da adadin filayen don shigowar su.

   A fagen "X" ya kamata mu nuna darajar gardamar, aikin da ya kamata mu lissafta. Zaka iya fitar da lambar da ake so daga maballin, ko zaka iya tantance daidaitawar kwayar idan an rubuta huɗan a takardar. Na biyu zaɓi ne ko da fin so. Idan muka sanya ajiya ta wannan hanyar, sannan don duba darajar aikin don wata muhawara, ba lallai ne mu canza dabarar ba, amma zai isa a sauya shigarwar a cikin tantanin da yake daidai. Don nuna alamun daidaitawar wannan tantanin, idan an zabi zabin na biyu, ya isa ya sanya siginan kwamfuta a cikin filin da ya dace kuma zaɓi wannan tantanin. Adireshinta zai bayyana nan da nan a cikin taga muhawara.

   A fagen Sanannan dabi'u dole ne a fayyace duk nau'in darajar abubuwan da muke da su. An nuna shi a cikin shafi. "f (x)". Sabili da haka, mun sanya siginan kwamfuta a cikin filin mai dacewa kuma zaɓi wannan takaddun kundin ba tare da sunan sa ba.

   A fagen Sanin x uesimar duk ka'idar muhawara ya kamata a nuna, wanda yayi dace da ƙimar aikin da muka gabatar a sama. Wannan bayanan yana cikin shafi. x. Haka kuma kamar lokacin da ya gabata, zaɓi ɓangaren da muke buƙata ta farko saita siginan kwamfuta a cikin filin muhawara.

   Bayan an shigar da dukkan bayanan, danna maɓallin "Ok".



4. Bayan waɗannan matakan, sakamakon lissafin ta hanyar karin abubuwa za a nuna a cikin tantanin halitta wanda aka alama a sakin farko na wannan umarnin kafin farawa. Wizards na Aiki. A wannan yanayin, darajar aikin don jayayya 55 daidai 338.



5. Idan, duk da haka, an zaɓi zaɓi tare da ƙari da hanyar haɗi zuwa tantanin halitta wanda ya ƙunshi ra'ayi da ake buƙata, to zamu iya canza shi da sauri kuma duba darajar aikin don kowane lambar. Misali, darajar bincike kan hujja 85 zama daidai 518.

Darasi: Wizard ɗin Aiki a cikin Excel

Hanyar 2: karin bayani don zane

Kuna iya aiwatar da tsarin cirewa don zane ta hanyar tsara layin da ake yi.

1. Da farko dai, muna gina jadawalin kanta. Don yin wannan, tare da siginan kwamfuta wanda aka riƙe ta maɓallin linzamin kwamfuta na hagu, zaɓi duk yankin teburin, gami da muhawara da ƙimar aikin. To, matsar da shafin Saka bayanaidanna maballin Chart. Wannan gunkin yana a cikin katangar. Charts akan kintinkiri na kayan aiki. Lissafin samammen zaɓin zane yana bayyana. Mun zabi mafi dacewa daga gare su a yayin da muke so.



2. Bayan an gina jadawalin, cire ƙarin layin gardamar daga gare ta, nuna alama da danna maɓallin Share akan maballin kwamfuta.



3. Na gaba, muna buƙatar canza rarrabuwa a sararin sama, tunda ba ya nuna mahimmancin mahawara, kamar yadda muke buƙata. Don yin wannan, danna sauƙin dama akan ginshiƙi kuma a jerin waɗanda ke bayyana, tsayawa a "Zaɓi bayanai".



4. A cikin taga da ke buɗe, zaɓi tushen bayanan, danna maballin "Canza" a cikin toshe don shirya sa hannu na a kwance.



5. Wurin sanya hannu alamar taga yana buɗewa. Sanya siginan kwamfuta a cikin wannan taga, sannan ka zaɓa duk bayanan shafi "X" ba tare da sunanta ba. Saika danna maballin "Ok".



6. Bayan an dawo zuwa taga zaɓi na data, sake maimaita aiki iri ɗaya, wato, danna maballin "Ok".



7. Yanzu an shirya zane namu kuma zaku iya, kai tsaye, fara gina layin da ke faruwa. Mun danna jadawalin, bayan wannan ana kunna ƙarin saitin shafuka akan kintinkiri - "Aiki tare da ginshiƙi". Matsa zuwa shafin "Layout" kuma danna maballin Layin Trend a toshe "Bincike". Danna kan kayan "Kimanin layi daya" ko "Kimantawa kan kari".



8. An kara layin da ake yi, amma gaba daya yana ƙarƙashin layin da kanta, tunda ba mu nuna ƙimar gardamar da ya kamata ya nufa ba. Don sake yin wannan, danna maɓallin a jere Layin Trendamma yanzu zaɓi "Additionalarin abubuwan lamuran layin".



9. Tsarin layi na tsari yana farawa. A sashen Layi Tsarin Layi akwai toshe saiti "Tsinkaya". Kamar yadda yake a hanyar da ta gabata, bari mu dauki hujja don bayyanawa 55. Kamar yadda kake gani, ya zuwa yanzu jadaren yana da tsawon har zuwa jayayya 50 gaba daya. Sai dai itace cewa muna buƙatar kara shi don wani 5 raka'a. A kan layi na kwance ana ganin raka'a 5 daidai yake da rabo ɗaya. To wannan shine lokaci daya. A fagen "Ci gaba zuwa" shigar da darajar "1". Latsa maballin Rufe a cikin ƙananan kusurwar dama na taga.



10. Kamar yadda kake gani, an shimfiɗa ginshiƙi ta hanyar ƙayyadadden lokaci ta amfani da layin Trend.

Darasi: Yadda za a gina layin Trend a Excel

Don haka, mun bincika mafi sauki misalai na extrapolation ga tebur da zane-zane. A yanayin farko, ana amfani da aikin KYAUTA, kuma a na biyu - layin Trend. Amma bisa waɗannan misalai, za a iya magance matsalolin rikice-rikice masu rikitarwa da yawa.