Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-31-2018, 09:59 PM
Bob8887 Bob8887 is offline -2^-(-0.2) = -1.148698355 Windows 10 -2^-(-0.2) = -1.148698355 Office 2016
Novice
-2^-(-0.2) = -1.148698355
 
Join Date: Oct 2018
Posts: 1
Bob8887 is on a distinguished road
Default -2^-(-0.2) = -1.148698355


I found this rather strange result in the excel.

-2^-(-0.2) = -1.148698355

but

IMPOWER(-2&"+0i",-(-0.2)) = 0.9293+0.6751i

Why the different results?
Reply With Quote
  #2  
Old 11-01-2018, 12:43 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline -2^-(-0.2) = -1.148698355 Windows 7 64bit -2^-(-0.2) = -1.148698355 Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,770
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome
as this is the first post, you probably not are aware that :
- to get fast answers a meaningful title helps a lot
- on forums, common courtesy is expected, like "Hello" or "thank you"

Good luck
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 11-03-2018, 10:38 AM
joeu2004 joeu2004 is offline -2^-(-0.2) = -1.148698355 Windows 7 32bit -2^-(-0.2) = -1.148698355 Office 2007
Advanced Beginner
 
Join Date: Aug 2016
Posts: 32
joeu2004 is on a distinguished road
Default

I agree: the result from IMPOWER is inexplicable. -2+0i is the same as -2. So IMPOWER should give the same result as (-2)^0.2.

Arguably, (-2)^0.2 might result in a complex number (a + bi). What do you get on a TI calculator that does arithmetic with complex numbers?

You might also be surprised by the sign of the result of -2^0.2. Excel parses that as (-2)^0.2. Mathematically, 0.2 is the rational number 2/10. So arguably, (-2)^0.2 might be evaluated as ((-2)^2)^0.1, which is +1.14869835499704, not -1.14869835499704.

However, I'm sure that Excel is not clever enough to recognize 0.2 as 2/10. And technically, it is not, since the exact decimal equivalent of the binary representation is 0.200000000000000,01110223024625156540423631668090 8203125.

(I use period for the decimal point and comma to demarcate the first 15 significant digits, which is all that Excel will format, an arbitrary limitation.)

So Excel probably evaluates (-2)^0.2 like any other exponentiation by a fractional number (e.g. 0.12345). I don't know how Excel does that. And I cannot speculate because it has been too many decades since I studied that kind of math.

In any case, I suggest that you write -(2^0.2), if that is the evaluation that you intended. Unlike the language of math, unary minus has higher precedence in Excel than exponentiation.

Last edited by joeu2004; 11-03-2018 at 04:18 PM.
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 10:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft