+ Reply to Thread
Results 1 to 2 of 2

mean- should be easy, but driving me bananas

  1. #1
    Registered User
    Join Date
    12-18-2016
    Location
    SYDNEY
    MS-Off Ver
    MS 2007
    Posts
    1

    mean- should be easy, but driving me bananas

    I am really hoping you can help as I have a deadline and tearing my hair out


    I have a data set and don't know where to start, there are 2 columns- SOPV and Parra with numbers of subjects grouped by decade of birth. I want to work out how to use excel to calculate the median and average decade of birth from each column and compare to check for significance,
    decade born Parra sopv
    ## 1920+ 0 1
    ## 1930+ 0 2
    ## 1940+ 2 5
    ## 1950+ 4 21
    ## 1960+ 15 16
    ## 1970+ 22 22
    ## 1980+ 45 15
    ## 1990+ 20 2
    ## 2000+ 0 0
    ## 2010+ 0 0
    ##
    can anyone help
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: mean- should be easy, but driving me bananas

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 13
    Last Post: 12-22-2015, 05:21 AM
  2. [SOLVED] Range search two conditions - Bananas and Oranges!
    By VBAtor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2015, 06:21 PM
  3. Formula is driving me mad
    By mlivsey in forum Excel General
    Replies: 4
    Last Post: 07-25-2012, 10:17 PM
  4. Replies: 6
    Last Post: 01-26-2012, 10:02 PM
  5. Apples, Bananas, Oranges -- Can Excel Spit Out the Highest?
    By AnnieHall25 in forum Excel General
    Replies: 2
    Last Post: 05-02-2007, 08:24 AM
  6. new user with easy question? not easy for me
    By speakeztruth in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-03-2005, 05:05 PM
  7. Help it's driving me mad
    By Ken W in forum Excel General
    Replies: 3
    Last Post: 03-01-2005, 04:44 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