Results 1 to 9 of 9

Need help with Statistical Functions

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2014
    Location
    ct
    MS-Off Ver
    2013
    Posts
    26

    Need help with Statistical Functions

    Hey everyone I am having trouble with step 11 & 12.
    Step 11:Enter a function in cell I20 to calculate the minimum Quartile value in the list of salaries.
    Step 12:Use the fill handle to complete the remaining quartile values in cell range I21:I24. Be sure to include the appropriate absolute or mixed cell references before copying the functions.

    I think I'm in the right path by using =QUARTILE.EXC function(there is also a =QUARTILE.INC but I haven't tried that or know the different)
    My formula is =QUARTILE.EXC(D$4:D$53,H21)
    QUARTILE SALARY
    0 #NUM!(don't understand why)
    1 35116.25
    2 45955
    3 69573
    4 #NUM!(???)

    Can someone please help me figure out what I am doing wrong for 0 & 4.
    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with statistical functions
    By jsparrow in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2013, 11:11 AM
  2. [SOLVED] Statistical functions query
    By Tom in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  3. [SOLVED] Statistical functions query
    By Tom in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  4. statistical functions
    By agenda9533 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2005, 05:06 PM
  5. [SOLVED] Statistical functions
    By David in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-13-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1