Daya daga cikin manyan alamomin da ke nuna jerin lambobi shine yaduwar bambancin. Don neme shi, an yi ƙididdigar lissafi mai wuya. Kayan aikin Microsoft Excel yana ba da sauƙin sauƙaƙe ga mai amfani.
Lissafi na coefficient na bambancin
Wannan alamar tana wakiltar rabo daga daidaitaccen karkatawa zuwa ma'anar ilimin lissafi. An bayyana sakamakon kamar kashi.
A Excel babu wani kebabben aikin don yin lissafin wannan manuniya, amma akwai dabaru don yin lissafin daidaituwa karkatacciyar hanya da ma'anar lissafi na lambobi, watau ana amfani dasu don nemo ma'anar rarrabuwa.
Mataki na 1: lissafa karkatacciyar karkacewa
Daidaitaccen karkatarwa, ko, kamar yadda ake kira shi da wasu kalmomin, daidaitaccen karkatacciyar hanyar, ita ce tushen canjin bambanci. Don ƙididdige daidaitattun daidaituwa, yi amfani da aikin STD. Farawa daga sigar Excel 2010, ta rarrabu, ya danganta da ƙididdigar yawan jama'a ko zaɓaɓɓu, cikin zaɓuɓɓuka biyu daban: STANDOTLON.G da STANDOTLON.V.
Ma’anonin ayyukan wadannan ayyuka sune kamar haka:
= STD (Number1; Number2; ...)
= STD.G (Number1; Number2; ...)
= STD B (Lambar1; lamba2; ...)
- Don yin ƙididdigar daidaitattun daidaituwa, zaɓi kowane tantanin halitta kyauta akan takaddun da ya dace da kai don nuna sakamakon ƙididdigar a ciki. Latsa maballin "Saka aikin". Yana da bayyanar gunki kuma yana gefen hagu na layin tsari.
- Kunna cigaba Wizards na Aiki, wanda zai fara azaman taga daban tare da jerin abubuwan muhawara. Je zuwa rukuni "Na lissafi" ko "Cikakken jerin haruffa". Zaɓi suna STANDOTKLON.G ko STANDOTKLON.V, ya dogara da yawan jimlar ko samfurin ya kamata a lissafta. Latsa maballin "Ok".
- Za a buɗe taga gardamar wannan aikin. Zai iya samun daga 1 zuwa 255 filayen, wanda zai iya ƙunsar takamaiman lambobi da nassoshi zuwa sel ko jeri. Sanya siginan kwamfuta a cikin filin "Lambar1". Yin amfani da linzamin kwamfuta, zaɓi kewayon dabi'u da za a sarrafa a takardar. Idan akwai wurare da yawa kuma ba su kasance kusa da juna ba, to, ana nuna ayyukan daidaitawa na gaba a fagen. "Lambar2" da sauransu Lokacin da aka shigar da dukkan mahimman bayanan, danna maɓallin "Ok"
- Tantanin halitta da aka riga aka zaɓa yana nuna sakamakon lissafin nau'in zaɓin ɓataccen ɗabi'a.
Darasi: Tsarin daidaitaccen daidaitaccen tsari
Mataki na 2: lissafa ma'anar ilmin lissafi
Arithmetic ma'ana shine rabo daga jimlar adadin duk adadin jerin lambobin zuwa lambar su. Hakanan akwai aikin daban don lissafin wannan alamar - KYAUTA. Mun lissafta ƙimarta ta amfani da takamaiman misali.
- Zaɓi sel a kan takardar aikace-aikacen don nuna sakamakon. Danna maballin da muka riga muka sani "Saka aikin".
- A cikin nau'in ƙididdiga na Wizard Function, muna neman suna SRZNACH. Bayan zabar shi, danna kan maɓallin "Ok".
- Farkon Tsararren Window KYAUTA. Hujjojin suna daidai da na wadanda ke aiki a kungiyar. STD. Wannan shine, a cikin ingancin su na iya aiki azaman lambobin ƙididdiga na mutum, da hanyoyin haɗin kai. Sanya siginan kwamfuta a cikin filin "Lambar1". Kamar dai yadda yake a cikin bayanan da suka gabata, mun zabi tsarin sel da ake buƙata akan takardar. Bayan an shigar da masu gudanar da ayyukansu a cikin filin muhawara, danna maɓallin "Ok".
- Sakamakon yin lissafin ma'anar ilmin lissafi an nuna shi a cikin tantanin da aka zaɓi kafin buɗewa Wizards na Aiki.
Darasi: Yadda za'a kirkiri matsakaicin darajar a Excel
Mataki na 3: nemo ma'anar rarrabuwa
Yanzu muna da dukkan mahimman bayanai don yin lissafin ma'anar bambancin kai tsaye.
- Zaɓi tantanin da za'a nuna sakamakon shi. Da farko dai, kuna buƙatar la'akari da cewa bambancin bambancin shine darajar kashi. A wannan batun, ya kamata ku canza tsarin tantanin halitta zuwa wanda ya dace. Za'a iya yin wannan bayan zabar shi, kasancewar a cikin shafin "Gida". Danna filin da aka zazzage a kan kintinkiri a cikin toshe kayan aiki "Lambar". Daga jerin zaɓuka-zaɓi na zaɓa, zaɓi "Sha'awa". Bayan waɗannan ayyuka, tsarin sashin zai dace.
- Har yanzu, komawa zuwa tantanin don nuna sakamakon. Muna kunna ta ta danna maɓallin linzamin kwamfuta na hagu. Mun sanya alama a ciki "=". Zaɓi kashi wanda sakamakon ƙididdigar yawan daidaituwa ya kasance. Latsa maɓallin "tsaga" (/) a kan keyboard. Na gaba, zaɓi tantanin halitta wanda matsakaicin ilimin lissafi ke cikin jerin lambobin da aka bayar. Domin yin lissafi da nuna darajar, danna maballin Shigar a kan keyboard.
- Kamar yadda kake gani, sakamakon lissafin yana bayyana akan allon.
Don haka, mun lissafta da ikon rarrabuwa, yana nufin sel wanda aka daidaita lissafin ma'auni da ma'anar lissafi. Amma mutum na iya ci gaba ta wata hanya dabam, ba tare da yin lissafin waɗannan abubuwan ba.
- Mun zabi satin da aka tsara a baya don tsaran tsari, wanda a ciki ne za'a nuna sakamakon. Mun rubuta shi dabara ta kowane:
= STDB.V (darajar_range) / AVERAGE (darajar_range)Madadin suna Range mai daraja mun sanya ainihin masu kula da yankin wanda aka samo jerin lambobi masu bincike. Ana iya yin wannan ta hanyar nuna alama kawai. Madadin mai aiki STANDOTLON.Vidan mai amfani ya ga ya zama dole, zaku iya amfani da aikin STANDOTLON.G.
- Bayan haka, don ƙididdige ƙimar kuma nuna sakamakon a allon mai saka idanu, danna maɓallin Shigar.
Akwai ƙaurar sharaɗi. An yi imanin cewa idan ma'anar coefficient ta bambanta ya kasa da kashi 33%, to saitin lambobin ya yi daidai. A akasarin haka, al'ada ce don ɗauka shi azaman heterogeneous.
Kamar yadda kake gani, shirin na Excel yana ba ka damar sauƙaƙe ƙididdigar lissafin irin wannan ƙididdigar lissafi kamar bincike don daidaitawa na rarrabuwa. Abin takaici, aikace-aikacen bai riga ya sami aikin da zai lissafta wannan mai nuna alama a cikin aiki ɗaya ba, amma ta amfani da masu aiki STD da KYAUTA Wannan aiki yana sauƙaƙa sauƙaƙe. Don haka, a cikin Excel, ana iya yin shi koda da mutumin da ba shi da babban matakin ilimi da ke da alaƙa da dokokin ƙididdiga.
