Kugadziriswa kweData reStatistical Uchishandisa Excel
Microsoft Excel yagara iri chishandiso chakakosha munyika yekuongorora manhamba nedata. Nezvinhu zvinokwanisa kugadzirisa data rakawanda, Excel inopa mabhenefiti akasiyana-siyana anogona kushandiswa pakuongorora manhamba. Chinyorwa chino chichatsanangura maitiro ekugadzirisa data redata uchishandisa Excel, kubva pazvinhu zvepakutanga kusvika kune matekiniki ekuongorora epamusoro.
1. Nhanganyaya kuMicrosoft Excel
Excel isoftware yespreadsheet yakagadzirwa neMicrosoft. Inoshandiswa zvakanyanya mumaindasitiri akasiyana-siyana, kubva kudzidzo kusvika kumabhizinesi, nekuda kwesimba rayo rekuongorora data. Excel inopa mabasa akasiyana-siyana uye mafomula, magirafu, uye kugona kubata data rakawanda zviri nyore.
2. Kutanga neExcel
Danho rekutanga mukushandisa Excel pakuongorora nhamba nderekunzwisisa mashandisirwo ayo uye maficha ayo ekutanga. Heano matanho ekutanga:
a. Vhura Excel Wogadzira Bhuku Rebasa Idzva
Mushure mekuvhura Microsoft Excel, unogona kugadzira bhuku idzva rebasa nekudzvanya 'New Workbook'. Bhuku rebasa ifaira reExcel rine rimwe kana akawanda mapepa ebasa.
b. Kuisa Data
Data rinogona kuiswa mumasero mupepa rebasa. Sero rega rega rine kero yaro yakasiyana, semuenzaniso, A1, B2, C3, nezvimwewo. Data rinogona kuva nhamba, rugwaro, kana musanganiswa wezvose zviri zviviri.
c. Kushandisa Mafomula neMabasa
Chimwe chezvakanakira zvikuru zveExcel kugona kwayo kushandisa maformula nemafunctions. Fomura ishoko rinoverenga kukosha kubva kudata riri musero rimwe chete kana akawanda. Mafunctions akavakirwa mukati maExcel mafomula anoita macalculations chaiwo nekukurumidza uye nemazvo. Mamwe mabasa ekutanga anoshandiswa kakawanda mukuongorora nhamba ndeaya:
– SUM: Inowedzera seti yenhamba.
"`excel
=SUM(A1:A10)
``
– AVERAGESI: Inoverenga avhareji yenhamba dzakanyorwa.
"`excel
=AVERAGE(B1:B10)
``
– KUVERENGA: Kuverenga huwandu hwemasero ane nhamba.
"`excel
=KUVERENGA(C1:C10)
``
– MAX neMIN: Inowana huwandu hwepamusoro nehwepasi munhamba dzakasiyana.
"`excel
=MAX(D1:D10)
=MIN(E1:E10)
``
3. Kuongorora Nhamba Yekutanga
Kana wangonzwisisa zvinhu zvekutanga zvekupinda data uye kuverenga kuri nyore, unogona kuenderera mberi nekuongorora nhamba. Heano mamwe matanho aunogona kutora:
a. Kuverenga Nhamba Dzinotsanangura
Nhamba dzinotsanangura dzinopa ruzivo rwese rwedata. Izvi zvinosanganisira kuverenga mean, median, mode, variance, uye standard deviation. Excel ine mabasa akati wandei akavakirwa mukati ayo anorerutsa kuverenga uku:
– KUREVA (Avhareji):
"`excel
=Avhareji(F1:F10)
``
– MEDIAN (Kukosha kwepakati):
"`excel
=PAMHEDZI(G1:G10)
``
– MODE (Kukosha kunowanzoitika):
"`excel
=MODE(H1:H10)
``
– KUSIYANA (Kusiyana):
"`excel
=VAR.P(I1:I10)
``
– KUTSAUKA KWEMAHARA (Kutsauka kwemuitiro):
"`excel
=STDEV.P(J1:J10)
``
b. Magirafu neKuona Data
Kuona data kunobatsira kunzwisisa mafambiro nemapatani museti yedata. Excel inopa mhando dzakasiyana dzemachati dzinogona kushandiswa kuratidza data nemaziso, kusanganisira machati emabha, machati emitsara, mahistogram, uye machati emapai. Kuti ugadzire chati, ingosarudza data raunoda kuona nemaziso, wobva wasarudza rudzi rwechati rwaunoda kubva pamenyu ye'Insert'.
4. Ongororo Yepamusoro Yehuwandu Hwehuwandu
Kuti uwane rumwe ruzivo rwakadzama nezvekuongorora nhamba, Excel inopawo maturusi epamusoro-soro. Chimwe chezvizvi iAnalysis ToolPak, chinhu chinowedzerwa chinopa mabasa akasiyana-siyana epamusoro-soro ekuongorora nhamba. Heano mamwe matekiniki aunogona kushandisa uchishandisa Analysis ToolPak:
a. Kudzoserwa kwemitsara
Kudzoreredzwa kwemutsara inzira yekuongorora nhamba inoshandiswa kunzwisisa hukama huripo pakati pezvinhu zviviri zvinoenderera mberi. NeAnalysis ToolPak, unogona kuita kuverenga kwemutsara wemutsara zviri nyore. Matanho acho ndeaya:
1. Shandisa Analysis ToolPak:
– Enda ku 'Faira' tab > 'Sarudzo' > 'Add-ins'.
– Sarudza 'Ongororo yeToolPak' wobva wadzvanya 'Enda'.
– Tarisa bhokisi rekuti 'Analysis ToolPak' wobva wadzvanya 'OK'.
2. Ita Kudzoreredza Kwemutsetse:
– Kana Analysis ToolPak yangovhurwa, enda ku 'Data' tab wobva wadzvanya 'Data Analysis'.
– Sarudza 'Regression' wobva wadzvanya 'OK'.
– Isa huwandu hweY (dependent variable) uye X (independent variable).
– Dzvanya 'OK' kuti uwane mhinduro dzekudzoka.
b. Kuongororwa kweMusiyano (ANOVA)
ANOVA inoshandiswa kuenzanisa nzira dzemapoka matatu kana anopfuura uye kuona kana paine musiyano mukuru pakati pavo. Unogona kushandisa ANOVA kuburikidza neAnalysis ToolPak nenzira yakafanana ne linear regression. Sarudza 'ANOVA' kubva kumenyu ye'Data Analysis' woisa data range yako.
c. Kuedzwa kweFungidziro
Excel inogonawo kushandiswa kuita bvunzo dzakasiyana-siyana dzekufungidzira, dzakadai sebvunzo dze-t uye bvunzo dze-chi-square. Mabasa aya anowanzo kuwanikwa muAnalysis ToolPak, zvichiita kuti kuverenga kuve nyore pasina chikonzero chemafomula akaomarara.
5. Muenzaniso weNyaya
Kuti tinzwisise zviri nani mashandiro anoita Excel mukugadzirisa data rehuwandu, ngatitarisei muenzaniso wenyaya unotevera:
Nyaya: Kuongorora Kutengeswa Kwechigadzirwa
Ngatitii une ruzivo rwekutengesa zvigadzirwa zviviri zvakasiyana zuva nezuva kwemwedzi wese uye unoda kunzwisisa maitiro ekutengesa uye kuenzanisa mashandiro ezvigadzirwa zviviri izvi.
1. Isa Data: Isa data rekutengesa kwezuva nezuva rezvigadzirwa zvese mukoramu A neB.
2. Kuverenga Kutsauka Kwepakati Nekwemupimo:
– Shandisa mabasa ekuti `AVERAGE` uye `STDEV.P` pachigadzirwa chimwe nechimwe.
- Muenzaniso wefomura:
"`excel
=AVERAGE(A2:A31) // Avhareji yechigadzirwa 1
=STDEV.P(A2:A31) // Kutsauka kwakajairika kwechigadzirwa 1
=AVERAGE(B2:B31) // Avhareji yechigadzirwa 2
=STDEV.P(B2:B31) // Kutsauka kwakajairika kwechigadzirwa 2
``
3. Kuona Data: Gadzira girafu yemitsara kuti uone mafambiro ekutengesa kwezuva nezuva.
- Sarudza data mukoramu A naB.
– Dzvanya 'Insert' > 'Line Chart' kuti ugadzire line chart.
4. Kudzoreredzwa Kwemari: Shandisa kudzoreredzwa kwemari kuti uone kana paine kukwira kana kudzikira kwemitengo yekutengesa.
- Tevedzera matanho ari pamusoro apa kuti uite linear regression uchishandisa Analysis ToolPak.
5. t-Test kuti Uenzanise Zvinoreva: Shandisa t-test iri muAnalysis ToolPak kuti uone kana paine musiyano mukuru muavhareji yekutengesa pakati pezvigadzirwa zviviri.
Mhedziso
Microsoft Excel chishandiso chine simba chekugadzirisa data remasvomhu. Kubva pamafomula ari nyore kusvika pakuongorora kwehuwandu hwemasvomhu, Excel inogona kugadzirisa zvakawanda zvinodiwa pakuongorora. Nekunzwisisa kwakanaka kwezvinhu zvepakutanga uye kugona kushandisa maturusi epamusoro seAnalysis ToolPak, unogona kuita ongororo dzakasiyana-siyana dzehuwandu hwemasvomhu zvinobudirira uye zvinobudirira.
