Ɗaya daga cikin manyan alamun kididdigar lissafin lambobi shi ne mahaɗin bambancin. Don samo shi, an yi lissafin rikitarwa. Ayyuka na Microsoft Excel sun sauƙaƙe don mai amfani.
Ana kirga mahaɗin haɓakawa
Wannan alamar shine rabo daga daidaitattun daidaituwa zuwa mahimmanci. An bayyana sakamakon a matsayin kashi.
A Excel, babu wani aiki dabam don ƙididdige wannan alamar, amma akwai samfurori don ƙididdige daidaitattun daidaituwa da ma'anar ƙididdiga na jerin lambobi, wato, ana amfani da su don samun maɓallin tasiri.
Mataki na 1: Ya kirga daidaitattun Ƙasa
Daidaitaccen daidaitattun, ko, kamar yadda ake kira daban, daidaitattun daidaitattun, shine tushen tushen bambancin. Ana amfani da aikin don lissafin daidaitattun daidaituwa. STANDOWCLONE. Farawa tare da fasali na Excel 2010, an rarraba, dangane da ko, bisa ga yawan yawan jama'a, lissafi yana faruwa ko samfurin, a cikin zaɓi biyu: STANDOCLON.G kuma STANDOWCLON.V.
Haɗin waɗannan ayyukan shine kamar haka:
= STDEV (Number1; Number2; ...)
= STDEV.G (Number1; Number2; ...)
= STDEV.V (Number1; Number2; ...)
- Don ƙididdige daidaitattun daidaitattun, zaɓi kowane cell salula a kan takardar, wanda ya dace don ku nuna a cikinsa sakamakon sakamakon lissafi. Danna maballin "Saka aiki". Yana da bayyanar gunki kuma yana tsaye a gefen hagu na tsari.
- An fara aiki a ci gaba Ma'aikata masu aikiwanda ke gudana a matsayin ɓangaren raba tare da jerin muhawara. Je zuwa category "Labarin lissafi" ko "Jerin jerin jerin sunayen". Zaɓi sunan "STANDOTKLON.G" ko "STANDOTKLON.V", dangane da ko yawan jama'a ko samfurin ya kamata a lasafta su. Muna danna maɓallin "Ok".
- Maganin gardama na aikin ya buɗe. Zai iya samun daga filayen 1 zuwa 255, wanda zai iya ƙunsar lambobi da lambobi masu mahimmanci da kuma nassoshi akan jinsunan ko jeri. Sa siginan kwamfuta a filin "Number1". Maganin ya zaɓi a kan takarda iyakar dabi'un da ake buƙata a sarrafa. Idan akwai wurare da yawa kuma ba su da alaka da juna, to, ana nuna alamun na gaba daya a filin "Number2" da sauransu Lokacin da aka shigar da cikakken bayanai, danna kan maballin "Ok"
- Sakamakon da aka zaɓa ya nuna sakamakon sakamakon kirkirar da aka zaɓa na daidaitattun tsari.
Darasi: Excel Standard Deviation Formula
Mataki na 2: Yi Ƙididdigar Ƙididdiga
Matsakaicin ilmin lissafi shine rabo daga jimlar jimillar dukkan dabi'u na jerin lambobi zuwa lambar su. Don ƙididdige wannan alamar, akwai aikin dabam - GABAWA. Muna lissafin darajarta akan wani misali.
- Zaɓi tantanin halitta akan takardar don nuna sakamakon. Muna danna kan maballin da ya saba da mu. "Saka aiki".
- A cikin nau'in lissafi na aikin masters muna neman sunan. "SRZNACH". Bayan zaɓar shi, danna kan maballin. "Ok".
- Maganar gardama ta fara. GABAWA. Tambayoyin sun kasance daidai da wadanda suke aiki. STANDOWCLONE. Wato, duka lambobin lambobi da kuma nassoshi zasu iya aiki kamar su. Saita siginan kwamfuta a filin "Number1". Kamar dai yadda a cikin akwati na baya, za mu zaɓi a kan takaddun jerin sassan da muke bukata. Bayan an shigar da su a cikin filin gwagwarmaya, danna maballin "Ok".
- Sakamakon yin lissafin matsakaiciyar lissafi an nuna a cikin tantanin da aka zaba kafin buɗewa Ma'aikata masu aiki.
Darasi: Yadda za a tantance ƙimar adadin a Excel
Mataki na 3: gano mahaɗin bambancin
Yanzu muna da dukkan bayanan da suka dace don lissafta lissafi na bambancin kanta.
- Zaɓi tantanin halitta wanda za'a nuna sakamakon. Da farko, kuna buƙatar la'akari da cewa yawancin bambancin yana da darajan kashi. A wannan yanayin, ya kamata ka canja tsarin tantanin halitta zuwa wanda ya dace. Ana iya yin wannan bayan zaɓan shi, kasancewa cikin shafin "Gida". Danna maɓallin tsari akan rubutun a cikin akwatin kayan aiki "Lambar". Daga jerin zaɓuɓɓuka, zabi "Shawarwari". Bayan wadannan ayyukan, tsarin da kashi zai dace.
- Koma zuwa tantanin halitta don nuna sakamakon. Kunna ta ta hanyar danna sau biyu a maɓallin linzamin hagu. Mun sanya a cikin alamarta "=". Zaɓi sashi wanda sakamakon sakamakon lissafi na daidaitattun daidaitattu. Danna maɓallin "raba" (/) a kan keyboard. Na gaba, zaɓi tantanin halitta wanda aka samo asalin lissafi na lissafin lambobin da aka ƙayyade. Don lissafta kuma nuna darajar, danna maballin Shigar a kan keyboard.
- Kamar yadda kake gani, ana nuna sakamakon sakamakon lissafi akan allon.
Saboda haka, mun ƙididdige maɗaukakiyar bambancin, yana nufin ɓangaren da aka ƙayyade daidaitattun daidaituwa da ƙididdigar lissafi. Amma zaka iya yin dan kadan, ba tare da ƙididdige waɗannan dabi'u ba.
- Zaɓi tsarin tantanin tantanin halitta wanda aka riga aka tsara don ƙimar girma wanda za'a nuna sakamakon. Mun rubuta a cikin shi wata takarda ta hanyar bugawa:
= STDEV.V (lambobi masu daraja) / GABATARWA (lambobin dabi'u)Maimakon sunan "Range mai daraja" saka ainihin ainihin yanki na yankin da aka ƙunshi jerin lambobi. Ana iya yin haka ta hanyar nuna wannan tashar. Maimakon sadarwa STANDOWCLON.Vidan mai amfani ya ɗauki ya zama dole, zaka iya amfani da aikin STANDOCLON.G.
- Bayan haka, don lissafin darajar kuma nuna sakamakon a kan allon allo, danna maballin Shigar.
Akwai bambancin yanayin. An yi imanin cewa idan mahaɗin bambancin ya kasance ƙasa da 33%, to, cikakkiyar lambobi suna kama. A cikin akwati, al'ada ne da za a iya kwatanta shi a matsayin mahaukaci.
Kamar yadda kake gani, shirin na Excel ya ba ka damar ƙara sauƙaƙe lissafi irin wannan lissafi na ƙididdigar rikice-rikice a matsayin bincike don maɓallin bambanci. Abin takaici, aikace-aikacen ba shi da aikin da zai lissafta wannan alamar a cikin wani mataki, amma tare da taimakon masu aiki STANDOWCLONE kuma GABAWA Wannan aikin yana da sauƙi. Saboda haka, a cikin Excel za'a iya yin shi har ma da mutumin da ba shi da babban ilimin ilimin da ya danganci alamu na lissafi.
