I'm new to OFFICE IN MAC

Discussion in 'MacBook Pro' started by Jorgellanos85, Feb 3, 2010.

  1. Jorgellanos85 macrumors newbie

    Joined:
    Feb 3, 2010
    #1
    Hello
    I got some problems with office for mac, It's different than the Windows and I have some problems with EXCEL, for making graphics and formulas:

    for example for Estadistics I can't do the PORCENTUAL neither the QUARTILE formulas right, i'm doing it to the letter on how it's supposed to be done, but I just get this formula error...no one knows whY??

    best regards
     
  2. GoCubsGo macrumors Nehalem

    GoCubsGo

    Joined:
    Feb 19, 2005
    #2
    You should not be having issues. Excel for the Mac will allow both formulas, that is assuming PORCENTUAL is actually PERCENTILE (please clarify that for me).

    Here is a shot on how you can use the QUARTILE formula:
    This results in the quartile being 17.25.
    Screen shot 2010-02-03 at 1.55.16 PM.png

    PERCENTILE is the same in theory except where you choose your array, after that you must tell it what percentile you're seeking. If I use .25 then the answer is the same; clearly. .30 results in the answer being 18.2 and so on (using the same dataset).

    What you need to realize is that the functions show up on the side menu instead of some dialog box like you may be used to in Excel for Windows. Either way the functions are still the same.
     

Share This Page