Ɗaya daga cikin muhimman abubuwan da aka tsara na kowane bincike shine don sanin ainihin yanayin abubuwan da suka faru. Samun wadannan bayanan, zaka iya yin bayanin yadda za a ci gaba da bunkasa halin da ake ciki. Wannan shi ne mafi mahimmanci a cikin misali na layi mai layi akan ginshiƙi. Bari mu ga yadda za'a gina shi a cikin Microsoft Excel.
Trendline a Excel
Aikace-aikacen Excel yana samar da damar gina tsarin layi ta amfani da jadawalin. A lokaci guda kuma, an samo bayanan farko da aka samo shi daga wani tebur da aka riga aka shirya.
Sanya
Domin gina hoto, kana buƙatar samun tebur mai tushe, bisa abin da za'a kafa shi. Alal misali, ɗauki bayanai game da darajan dollar a rubles na wani lokaci.
- Mun gina teburin, inda a cikin shafi daya akwai lokuta na lokaci (a cikin yanayin mu, kwanakin), da kuma a cikin sauran - darajar, wanda za'a iya nunawa a cikin hoto.
- Zaɓi wannan tebur. Jeka shafin "Saka". Akwai a kan tef a cikin asalin kayan aiki "Sharuɗɗa" danna maballin "Jadawalin". Daga jerin da aka gabatar, zaɓi zaɓi na farko.
- Bayan wannan, za a gina jadawalin, amma yana bukatar ci gaba. Yi lakabi na ginshiƙi. Don yin wannan, danna kan shi. A cikin rukunin kungiyar wanda ya bayyana "Yin aiki tare da Sharuɗan" je shafin "Layout". A cikinsa mun danna kan maballin. "Sunan Shafin". A cikin jerin da ya buɗe, zaɓi abu "A saman ginshiƙi".
- A cikin filin da yake bayyana a sama da jadawali, shigar da sunan da muke ganin ya dace.
- Sa'an nan kuma mu shiga alamomi. A cikin wannan shafin "Layout" danna kan maɓallin rubutun "Sunaye Axis". Hakanan zamu je kan maki "Sunan babban maƙalari mai faɗi" kuma "Matsayi a ƙarƙashin axis".
- A cikin filin da ya bayyana, shigar da sunan filin tsaye, bisa ga mahallin bayanan da aka samo shi.
- Domin sanya sunan filin tsaye yana kuma amfani da shafin "Layout". Danna maballin "Sunan Axis". Hanyoyin kewaya ta hanyar abubuwan da aka saɓa. "Sunan maɗaukakiyar tsaye" kuma "Juya take". Irin wannan matsayi na sunan mai suna zai fi dacewa da irin nauyin zane-zane.
- A filin filin sunan tsaye wanda ya bayyana, shigar da sunan da ake so.
Darasi: Yadda ake yin jadawali a Excel
Ƙirƙirar layi
Yanzu kana buƙatar ka ƙara yawan layi.
- Da yake cikin shafin "Layout" danna maballin "Layin layi"wanda aka samo a cikin kayan aiki "Analysis". Daga jerin da ke buɗewa, zaɓi abu "Alamar tsinkaye" ko "Kimanin linzami".
- Bayan haka, ana kara layin layi a cikin sigin. By tsoho, baƙar fata ne.
Saitin layi na yau da kullum
Akwai yiwuwar ƙarin saitunan layi.
- Yi nasara zuwa shafin "Layout" a kan abubuwa na menu "Analysis", "Layin layi" kuma "Zaɓuɓɓukan Yanayin Yanayin Ra'ayin Girma ...".
- Maballin sigogi yana buɗe, zaka iya yin saituna daban-daban. Alal misali, za ka iya canza nau'in smoothing da kimantawa ta zaɓar ɗaya daga cikin maki shida:
- Tsarin mulki;
- Layin;
- Power;
- Logarithmic;
- Musamman;
- Daidaita layin layi.
Domin sanin ƙayyadadden samfurinmu, sanya alamar kusa da abu "Sanya a kan zane muhimmancin daidaito na kimantawa". Don ganin sakamakon, danna kan maballin. "Kusa".
Idan wannan alama alama ce 1, to, samfurin ya dogara ne sosai. Ƙarshen matakin daga naúrar, ƙananan amincewa.
Idan ba ka gamsu da matakin amincewa ba, zaka iya komawa cikin sigogi kuma canza irin smoothing da kimantawa. Sa'an nan kuma, sake gina mahaɗin.
Magana
Babban aiki na layi na yau da kullum shine ikon yin hangen nesa don kara ci gaba.
- Bugu da kari, je zuwa sigogi. A cikin akwatin saitunan "Hasashe" a cikin sharuɗɗa masu dacewa, zamu nuna tsawon lokaci na gaba ko baya da muke bukata don ci gaba da layi na layi. Muna danna maɓallin "Kusa".
- Bugu da kari, je zuwa jadawalin. Ya nuna cewa layin yana elongated. Yanzu ana iya amfani dashi don sanin wane alamar kusanci yana annabta don kwanan wata yayin riƙe da halin yanzu.
Kamar yadda kake gani, a cikin Excel ba wuya a gina layi ba. Shirin yana samar da kayayyakin aikin don a iya saita ta don nuna alamun daidai yadda ya kamata. Bisa ga jadawalin, zaku iya yin bita don wani lokaci.
