Momwe mungayambitsire kuwonjezera kwa Data Analysis mu Excel spreadsheet

Microsoft Excel yakhala ikufunidwa kwa nthawi yayitali chifukwa cha zida zambiri zogwirira ntchito zomwe zimathandizira kugwira ntchito ndi pulogalamuyi ndikufulumizitsa njira zosiyanasiyana. Pokhala ndi gawo lokwanira la zigawo za Excel, mutha kukhathamiritsa njira ndi ntchito zambiri. Chimodzi mwazinthu zothandiza ndi Kusanthula kwa Data.

Zofunika! Phukusili silinakhazikitsidwe pamakompyuta mwachisawawa, kotero kuyikako kuyenera kuchitidwa pamanja ngati kuli kofunikira.

Nkhaniyi ifotokoza njira yosavuta komanso yothandiza yoyambitsira phukusi la mapulogalamu ndi malangizo atsatane-tsatane. Mupezanso malangizo osavuta otsitsa ngati sichinayikidwe pakompyuta yanu.

Kodi ntchito iyi mu Excel ndi chiyani, ndipo chifukwa chiyani ikufunika

Ntchitoyi ndi yabwino komanso yothandiza pakakhala kufunikira kowerengera zovuta kapena kutsimikizira zomwe zalowa, nthawi zambiri zimatenga nthawi yayitali kapena sizingatheke kuchita pamanja nkomwe. Zikatero, mwayi wapadera wochokera ku Excel "Data Analysis" umabwera kudzapulumutsa. Zimakupatsani mwayi wofufuza mwachangu komanso mosavuta ndikulemba zambiri, kufewetsa ntchito zanu ndikukupulumutsani nthawi yambiri. Mukatha kugwiritsa ntchito ntchitoyi, tchati chidzawonetsedwa papepala ndi zotsatira za cheke ndi kugawanika m'magulu.

Ndikofunika kulingalira! Ngati kuli kofunikira kusanthula mapepala angapo, tikulimbikitsidwa kuti mupereke lamulo pa pepala lirilonse padera kuti mukhale ndi lipoti lake la aliyense wa iwo.

Ngati phukusi lofunika lakhazikitsidwa kale pakompyuta kuti mugwiritse ntchito ntchitoyi, ndiye kuti muyenera kupita ku tabu "Data", kenako ku tabu "Analysis" ndikusankha "Kusanthula deta". Mukadina, pulogalamuyo imayamba ndipo posakhalitsa imapereka zotsatira zomwe mukufuna mutatha kukonza zolowetsa zonse. Ngati ntchitoyi palibe, muyenera kukopera "Analysis Phukusi". Ichi ndi phukusi la data la Excel lapamwamba lomwe limapereka zambiri komanso magwiridwe antchito kuti mugwire nawo ntchito.

Momwe mungayambitsire kuwonjezera kwa Data Analysis mu Excel spreadsheet
Komwe mungapeze batani la "Data Analysis".

Momwe mungayambitsire kuwonjezera mu Excel

Malangizo othandizira kuwonjezera kwa Data Analysis:

  • Pitani ku tabu "Fayilo".
  • Sankhani Mungasankhe.
  • Sankhani "Zowonjezera" njira.
  • Pitani ku tabu "Zowonjezera za Excel".
  • Chongani bokosi pafupi ndi "Analysis Toolkit" njira.
  • Tsimikizirani kusankha kwanu podina Chabwino.
Momwe mungayambitsire kuwonjezera kwa Data Analysis mu Excel spreadsheet
Momwe mungalumikizire ntchito mwachangu

Ngati njira yomwe mukufuna sinapezeke, tsatirani malangizo omwe ali pansipa:

  • Pitani ku menyu "Zowonjezera zomwe zilipo".
  • Sankhani "Sakatulani" njira.
  • Ngati uthenga "Data Analysis ToolPak sichinayikidwe", dinani Inde.
  • Njira yoyika phukusi la data la pulogalamu yayamba.
  • Yembekezerani kuti kuyika kumalize ndipo phukusi likhala lokonzeka kugwiritsidwa ntchito.

Kodi pali kusiyana kotani pakati pa kutsegula phukusi mu Excel 2010, 2013 ndi 2007

Njira yotsegulira yowonjezerayi imakhala yofanana ndi mitundu yonse itatu, ndikusiyana pang'ono kumayambiriro kwa pulogalamu yoyambitsa. M'matembenuzidwe atsopano, muyenera kupita ku tabu "Fayilo" kuti mutsegule, ndipo mu 2007 palibe tabu yotere. Kuti mutsegule phukusili, muyenera kupita ku menyu ya Microsoft Office pakona yakumanzere yakumanzere, yomwe ikuwonetsedwa ndi bwalo lokhala ndi mitundu inayi. Kutsegulira kwinanso ndi kukhazikitsa kumakhala kofanana kwa mitundu yonse yatsopano ya Windows ndi akale.

Zida zowunikira za Excel

Mukakhazikitsa ndikuyendetsa phukusi la "Data Analysis", zotsatirazi zitha kupezeka kuti mugwiritse ntchito:

  • zitsanzo;
  • kupanga histograms;
  • kupanga nambala mwachisawawa;
  • Kutha kuchita masanjidwe (peresenti ndi ordinal);
  • mitundu yonse ya kusanthula - kubwereranso, kubalalitsidwa, kulumikizana, covariance ndi ena;
  • gwiritsani ntchito kusintha kwa Fourier;
  • ndi ntchito zina zothandiza powerengera, kukonza ma graph ndi kukonza deta m'njira zambiri.
Momwe mungayambitsire kuwonjezera kwa Data Analysis mu Excel spreadsheet
Zida Zopezeka

Ndi malangizo awa pang'onopang'ono, mutha kulumikiza mwachangu phukusi lowunikira mu Excel, zimathandizira kuti ntchito yowunikira ikhale yosavuta komanso yosavuta yosinthira ngakhale kuchuluka kwa data ndi kuchuluka. Kuyika ndi kuyambitsa phukusili ndikosavuta ndipo sikutenga nthawi yochuluka, ngakhale wogwiritsa ntchito novice amatha kugwira ntchitoyi.

Siyani Mumakonda