Daya daga cikin mahimman abubuwan kowane bincike shine tabbatar da babban abin da ya faru. Samun waɗannan bayanan, zaku iya yin hasashen yanayin ci gaba na halin da ake ciki. Wannan ya bayyana a fili musamman a cikin misalin layin aiki akan ginshiƙi. Bari mu bincika yadda za a iya gina shi a Microsoft Excel.
Excel Trendline
Aikace-aikacen Excel yana ba da iko don gina layin da aka yi amfani da jadawali. Haka kuma, farkon bayanan don ƙirƙirar sa an karɓa daga tebur da aka riga aka shirya.
Shiryawa
Don ƙirƙirar jadawalin, kuna buƙatar samun tebur da aka shirya, akan abin da za'a kafa shi. A matsayin misali, muna ɗaukar bayanai akan darajar dala a cikin rubles na wani ɗan lokaci.
- Muna gina tebur inda a cikin lokaci ɗaya shafi (a yanayinmu, kwanakin) zai kasance, kuma a cikin wani - ƙimar wanda za'a nuna ƙarfin aikinsa a cikin zanen.
- Zaɓi wannan tebur. Je zuwa shafin Saka bayanai. A can akan kintinkiri a cikin akwatin kayan aiki Charts danna maballin Chart. Daga jerin da aka gabatar, zaɓi zaɓi na farko.
- Bayan haka, za a gina jadawalin, amma har yanzu yana buƙatar kammalawa. Muna yin taken ginshiƙi. Don yin wannan, danna kan sa. A cikin rukunin jerin shafuka "Aiki tare da ginshiƙi" je zuwa shafin "Layout". A cikin shi mun danna maballin Sunan Chart. Cikin jeri dake buɗe, zaɓi "Sama da ginshiƙi".
- A fagen da ke bayyana sama da ginshiƙi, shigar da sunan da muke ganin ya dace.
- Sannan muna sa hannu a kan gatari. A cikin wannan shafin "Layout" danna maballin akan kintinkiri Sunayen Axis. Zamu wuce maki "Sunan babban zangon kwance" da "Sunaye na karkashin axis".
- A fagen da ya bayyana, shigar da sunan madaidaicin kwance, gwargwadon yanayin bayanan da ke kanta.
- Domin sanya sunan shinge a tsaye mu ma muna amfani da shafin "Layout". Latsa maballin Sunan Axis. Mafi tsananin motsa ta cikin abubuwan menu "Sunan babban giciye a tsaye" da Sunan juyawa. Wannan nau'in tsari ne na sunan axis wanda zai fi dacewa da nau'in zane-zane.
- A sunan filin tsakiyar tsaye wanda ya bayyana, shigar da sunan da ake so.
Darasi: Yadda ake yin ginshiƙi a Excel
Irƙirar layin da ake yi
Yanzu kuna buƙatar ƙara layin Trend kai tsaye.
- Kasancewa a cikin shafin "Layout" danna maballin Layin Trendlocated a cikin toshe kayan aiki "Bincike". Daga jeri dake buɗe, zaɓi "Kimantawa kan kari" ko "Kimanin layi daya".
- Bayan wannan, ana ƙara layin Trend akan ginshiƙi. Ta hanyar tsoho, baƙar fata ne.
Saitin layin
Akwai yiwuwar ƙarin saitunan layin.
- Je zuwa shafin "Layout" akan abubuwan menu "Bincike", Layin Trend da "Additionalarin abubuwan lamuran cigaba ...".
- Taga sigogi yana buɗewa, ana iya yin saituna daban-daban. Misali, zaku iya canza nau'in kyakyawa da kimantawa ta zabi daya daga cikin abubuwa shida:
- Polynomial;
- Layi;
- Iko;
- Logarithmic
- Abun Neman;
- Tace mai layi.
Don sanin amincin samfurinmu, duba akwatin kusa da "Sanya kwatankwacin kwatancen kwatankwacin hoto akan zane". Don ganin sakamakon, danna maballin Rufe.
Idan wannan alamar ta kasance 1, to ƙirar tana da abin dogara kamar yadda zai yiwu. Mafi nisan matakin yana daga guda, ƙananan dogara.
Idan baku gamsu da matakin amincewa ba, to zaku iya komawa sigogi kuma ku sake canza yanayin murmushi da mai kusanci. Bayan haka, sai a sake samar da sauran su.
Hasashen
Babban aikin layin Trend shine ikon yin hasashen abubuwan ci gaba a kai.
- Sa'an nan, je zuwa sigogi. A cikin toshe saitin "Tsinkaya" a cikin madaidaitan filayen suna nuna adadin lokaci na gaba ko na baya kana buƙatar ci gaba da layin da aka tsara don hasashen. Latsa maballin Rufe.
- Bari mu matsa zuwa jadawalin kuma. Ya nuna cewa layi yana da elongated. Yanzu ana iya amfani dashi don tantance wane ƙididdigar alamomi da aka ƙaddara don takamaiman kwanan watan yayin riƙe yanayin da yake gudana.
Kamar yadda kake gani, a cikin Excel ba wuya a gina layin Trend. Shirin yana samar da kayan aikin ta yadda za'a iya daidaita shi don nuna alamun yadda yakamata. Dangane da zane mai hoto, zaku iya yin jigajancin wani takamaiman lokacin.
