Yadda za a ƙayyade daidaitattun daidaituwa tare da Ayyukan STDEV na Excel

01 na 01

Tasirin Excel STDEV (Standard Deviation)

Bambanci daidai shine kayan aiki na ilimin lissafi wanda ya gaya muku yadda ya kamata, a matsakaita, kowane lamba a lissafin bayanan bayanai ya bambanta daga darajar ƙimar ko mahimmanci na ma'anar lissafin da kansa.

Misali, don lambobi 1, 2

• matsakaicin adadi shine 1.5 (ƙidaya ta ƙara lambobi biyu tare da rarraba ta 2: (1 + 2) / 2)
• daidaitattun daidaituwa ko nesa daga wannan ma'anar 1.5 don lambobi 1 da 2 shine 0.5 - tun da kowace lambar ta kasance ko ta fi girma ko mafi ƙanƙanta fiye da 1.5

Ayyukan STDEV, duk da haka, yana ba da kimantaccen daidaitattun daidaituwa. Ayyukan suna ɗauka cewa shigar da lambobi suna wakiltar ƙananan ƙananan yanki ko samfurin yawan yawan ana karatu.

A sakamakon haka, aikin STDEV bai dawo daidai daidai ba. Alal misali, don lambobi 1, 2 aikin STDEV a Excel ya dawo kimanin kimanin 0.71 maimakon daidaitattun daidaitattun daidai na 0.5.

Kayan aiki na Kayan aiki yana amfani

Kodayake kawai an kiyasta daidaitattun daidaituwa, aikin yana da amfani idan an gwada ƙananan ƙananan yawan yawan jama'a.

Alal misali, idan aka gwada gwaje-gwajen samfurori don daidaituwa ga ma'anar - don matakan da suka dace ko ƙarfin hali - ba kowane gwaji an gwada. Sai kawai an gwada wasu adadin kuma daga wannan kimantawa nawa kowanne ɗayan a cikin dukan jama'a ya bambanta daga ma'ana za a iya samun ta ta amfani da STDEV.

Don nuna yadda zafin sakamakon ga STDEV zai iya kasancewa ga daidaitattun daidaitattun ainihin, a cikin hoton da ke sama, ƙananan samfurin da aka yi amfani dashi don aikin ya kasa da kashi ɗaya bisa uku na yawan adadin bayanai duk da haka bambancin tsakanin daidaitattun daidaitattun daidaitattun kawai 0.02.

Harkokin aikin STDEV da jayayya

Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .

Haɗin da aka yi don aikin Haɓaka na Ƙasashen waje shine:

= STDEV (Number1, Number2, ... Number255)

Number1 - (da ake buƙata) - iya zama lambobi na ainihi, mai lakabi mai suna ko ƙididdigar sel zuwa wurin samo bayanai a cikin takardun aiki.
- idan aka yi amfani da nassin tantanin halitta, kulluka maras kyau, Maƙalafan haɓaka , bayanan rubutu, ko ƙididdiga ƙididdiga a cikin kewayon labaran labaran sun ƙi.

Number2, ... Number255 - (na zaɓi) - har zuwa 255 lambobin za a iya shigar

Misali Yin amfani da STLEV na Excel

A cikin hoton da ke sama, ana amfani da aikin STDEV don kimanta daidaitattun daidaituwa ga bayanai a cikin kwayoyin A1 zuwa D10.

Samfurin bayanan da aka yi amfani da shi don aikin aikin maganin yana cikin sel A5 zuwa D7.

Don dalilai na kwatanta, ƙayyadadden daidaituwa da matsakaici don cikakken jigon bayanan A1 zuwa D10 an haɗa su

Bayanan da ke ƙasa ya rufe matakan da ake amfani dashi don shigar da aikin STDEV a cikin tantanin halitta D12.

Shigar da aikin STDEV

Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:

1. Rubuta cikakken aikin: = STDEV (A5: D7) cikin cell D12
2. Zaɓin aikin da muhawarar ta amfani da akwatin maganganu na STDEV

Kodayake yana yiwuwa a rubuta aikin gaba ɗaya ta hannu, mutane da yawa sun fi sauƙi don amfani da akwatin maganganu don shigar da muhawarar aiki.

Lura, akwatin maganganun don wannan aikin ba a samuwa a cikin Excel 2010 da kuma wasu sigogi na wannan shirin ba. Don amfani da shi a cikin waɗannan nau'i, dole ne a shigar da aikin da hannu.

Matakan da ke ƙasa suna amfani da akwatin maganganun don shigar da STDEV da kuma muhawarar zuwa cell D12 ta amfani da Excel 2007.

Bayyana daidaitattun Ƙasa

1. Danna kan tantanin halitta D12 don sa shi tantanin halitta mai aiki - wurin da za a nuna sakamakon aikin STDEV
2. Danna kan shafukan Formulas .
3. Zaɓi Ƙari Ayyuka> Lissafi daga rubutun don buɗe jerin sauƙaƙe aikin.
4. Danna kan STDEV a cikin jerin don kawo akwatin maganganun aikin.
5. Sanya siffofin A5 zuwa D7 a cikin takardun aiki don shigar da kewayon cikin akwatin maganganu a matsayin Magana Number
6. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki .
7. Amsar 2.37 ya kamata ya gabatar a cell D12.
8. Wannan lambar tana wakiltar ƙayyadadden ƙayyadadden ƙidayar kowane lambar a cikin jerin daga ƙimar darajar 4.5
9. Lokacin da ka danna kan tantanin halitta E8 cikakken aikin = STDEV (A5: D7) ya bayyana a cikin maɓallin tsari a sama da takardun aiki

Dalili na Amfani da Hanya Tafiyar Cikin Hotuna Ya hada da:

1. Maganar maganganun tana kula da haɗin gwargwadon aikin - yana sa ya fi sauƙi don shigar da muhawarar aiki a lokaci daya ba tare da shigar da alamar daidai ba, ƙuƙwalwa, ko kalmomi waɗanda ke aiki a matsayin raba tsakanin gardama.
2. Za'a iya shigar da alamun salula ta hanyar yin amfani da ma'ana , wanda ya haɗa da danna kan zaɓuɓɓukan da aka zaɓa tare da linzamin kwamfuta maimakon buga su a cikin. Ba wai kawai yana nuna sauki ba, yana kuma taimaka wajen rage kurakurai a cikin maƙalaran da lalacewar ƙwayoyin cell ba daidai ba.