Aloha awakea
No ka manawa lōʻihi ʻaʻole wau i kākau i nā mea kākau ma ka Word a me Excel ma nā ʻaoʻao o ka blog. A i kēia manawa, loaʻa koke iaʻu kahi nīnau hoihoi i kekahi o nā mea heluhelu: "pehea e kau ai i ke kumu o ka nth degree mai kahi helu ma Excel." ʻOiaʻiʻo, kahi aʻu e hoʻomanaʻo ai, loaʻa iā Excel ka hana "ROOT", akā lawe wale ia i ka pakiaka ʻaoʻao, inā makemake ʻoe i kahi aa o kekahi kekelē?
A pēlā ...
Ma ke ala, e hana nā mea hoʻohālike ma lalo nei i ka Excel 2010-2013 (ʻaʻole au i nānā i kā lākou hana ma nā ʻano ʻē aʻe, a ʻaʻole hiki iaʻu ke ʻōlelo inā he hana ia).
E like me ka ʻike ʻana mai ka makemakika, ʻo ke kumu o kekahi pae n o kahi helu e like me ka hāpai ʻana i ka mana o ka helu like ʻana ma 1 / n. I mea e akakaʻa ai kēia rula, e hāʻawi wau i kahi kiʻi liʻiliʻi (e ʻike i lalo).
ʻO ke kumu ʻekolu o 27 he 3 (3 * 3 * 3 = 27).
Ma ka Excel, he mea maʻalahi ka haʻahaʻa o ka hana, no ka mea he hoʻohana ʻokoʻa kūikawā kēia ^ ("Uhi", maʻamau i loaʻa ia i kahi kuhi ma ke kaona "6" kī).
I.e. e hoʻoili i ke aʻa o ka nth degree mai kekahi helu (no ka laʻana, mai 27), pono ʻia e kākau ʻia nā mea hoʻohālike penei:
=27^(1/3)
kahi 27 ka helu kahi i kāʻili ʻia ai mākou i ke aʻa;
3 - kūloko.
ʻO kahi hiʻohiʻona o ka hana ma lalo i ka screenshot.
ʻO ke kumu o ka pae 4 i waho o 16 he 2 (2 * 2 * 2 * 2 = 16).
Ma ke ala, hiki ke palapala koke i hiki ke kākau koke ʻia i ke ʻano o ka helu helu. ʻO kahi laʻana, ma mua o ka 1/4, hiki iā ʻoe ke kākau i ka 0.25, e like nā hopena, akā e piʻi aʻe ka ʻike (kūpono no nā ʻōmole lōʻihi a me nā helu helu nui).
Pau kēlā, ka hana maikaʻi ma Excel ...
