Lissafin ma'aunin Student a cikin Excel

Ma'auni na ɗalibi shine gamammen suna don ƙungiyar gwaje-gwajen ƙididdiga (yawanci, ana ƙara harafin Latin "t" kafin kalmar "ma'auni"). Ana amfani da shi sau da yawa don bincika idan hanyoyin samfurori guda biyu daidai suke. Bari mu ga yadda ake lissafin wannan ma'auni a cikin Excel ta amfani da aiki na musamman.

Lissafin t-gwajin ɗalibi

Domin yin lissafin da ya dace, muna buƙatar aiki "JJJABAN DALIBAN", a cikin sigar farko na Excel (2007 da tsofaffi) - "TTEST", wanda kuma yana cikin bugu na zamani don kiyaye dacewa da tsofaffin takardu.

Ana iya amfani da aikin ta hanyoyi daban-daban. Bari mu bincika kowane zaɓi daban ta amfani da misalin tebur mai layuka biyu-ginshiƙan ƙimar ƙididdigewa.

Hanyar 1: Amfani da Wizard Aiki

Wannan hanya tana da kyau saboda ba kwa buƙatar tunawa da tsarin aikin (jerin hujjojinsa). Don haka, algorithm na ayyuka shine kamar haka:

1. Muna tsaye a kowane tantanin halitta kyauta, sannan danna gunkin "Saka aikin" zuwa hagu na mashayin dabara.
2. A cikin taga bude Mayukan Ayyuka zabi nau'i "Cikakken jerin haruffa", a cikin jerin da ke ƙasa mun sami mai aiki "JJJABAN DALIBAN", yi alama kuma danna OK.
3. Wani taga zai bayyana akan allon da muka cika muhawarar aikin, bayan haka zamu danna OK:
   • "Masifi1"Kuma "Mai girma2" – ƙayyade jeri na sel masu ɗauke da jerin lambobi (a cikin yanayinmu, wannan shine "A2: A7" и "B2:B7"). Za mu iya yin haka da hannu ta shigar da masu daidaitawa daga maballin madannai, ko kuma kawai zaɓi abubuwan da ake so a cikin teburin kanta.
   • "Tails" – Ina rubuta lamba "1"idan kuna son yin lissafin rarraba ta hanya ɗaya, ko "2" – don fuska biyu.
   • "Tip" - a cikin wannan filin nuna: "1" - idan samfurin ya ƙunshi masu canji masu dogara; "2" - daga masu zaman kansu; "3" - daga dabi'u masu zaman kansu tare da rashin daidaituwa.
4. A sakamakon haka, ƙimar ƙididdiga na ma'aunin zai bayyana a cikin tantanin halitta tare da aikin.

Hanyar 2: Saka aiki ta hanyar "Formulas"

1. Canja zuwa shafin "Formulas", wanda kuma yana da maɓalli "Saka aikin", wanda shine abin da muke bukata.
2. A sakamakon haka, zai bude Mayen aiki, ƙarin ayyuka waɗanda suke kama da waɗanda aka bayyana a sama.

Ta tab "Formulas" aiki "JJJABAN DALIBAN" za a iya gudu daban-daban:

1. A cikin rukunin kayan aiki "Labarun Ayyuka" danna kan icon “Sauran Fasali”, bayan haka jerin za su buɗe, inda za mu zaɓi wani sashe "Kididdiga". Ta gungurawa cikin lissafin da aka tsara, za mu iya nemo ma'aikacin da muke buƙata.
2. Allon zai nuna taga don cika muhawarar, wanda muka riga mun hadu a baya.

Hanyar 3: Shigar da dabarar da hannu

Masu amfani da ƙwarewa za su iya yin ba tare da Mayukan Ayyuka kuma a cikin tantanin halitta da ake buƙata nan da nan shigar da dabara tare da hanyoyin haɗi zuwa jeri na bayanan da ake so da sauran sigogi. Haɗin aikin gaba ɗaya yayi kama da haka:

= DALIBAI.JARABAWA(Array1; Array2; wutsiya; Nau'i)

Mun yi nazarin kowace hujja a cikin sashe na farko na littafin. Duk abin da ya rage a yi bayan buga dabarar shine danna Shigar don yin lissafin.

Kammalawa

Don haka, zaku iya lissafin t-test ɗin ɗalibi a cikin Excel ta amfani da aiki na musamman wanda za'a iya ƙaddamar da shi ta hanyoyi daban-daban. Har ila yau, mai amfani yana da damar da za a shigar da tsarin aiki nan da nan a cikin tantanin halitta da ake so, duk da haka, a cikin wannan yanayin, dole ne ku tuna da ma'anarsa, wanda zai iya zama matsala saboda gaskiyar cewa ba a yi amfani da shi sau da yawa.