Support the GITP forums on Patreon
Help support GITP's forums (and ongoing server maintenance) via Patreon
Results 1 to 5 of 5
  1. - Top - End - #1
    Barbarian in the Playground
     
    NecromancerGuy

    Join Date
    Apr 2010
    Location
    Night Vale
    Gender
    Male

    Default Help with MS Excel

    I'm trying to display summary statistics for columns of data in the form of mean SD. I can get the mean and SD trivially enough in separate cells with =AVERAGE() and =STDEV.S(), but cant find a way to display them both in one cell. Anyone know how I can do this?

    I'm working with a data set of ~300 columns, so I can do it manually if I have to, but would really like to not need to do that much data entry by hand.

    Thanks in advance,
    Astral

    Edit: Just hit on the right keywords in my googling to find the TEXTJOIN function, problem is solved.
    =TEXTJOIN(" ",TRUE,ROUND(A19:A20,2))
    Last edited by Astral Avenger; 2021-05-20 at 10:11 AM.
    Avatar by TheGiant
    Long-form Sig

  2. - Top - End - #2
    Troll in the Playground
     
    Lord Torath's Avatar

    Join Date
    Aug 2011
    Location
    Sharangar's Revenge
    Gender
    Male

    Default Re: Help with MS Excel

    You can also use "&"

    =A4&"+/-"&B4

    =<formula>&"text"&<other formula>&"other text"&<last formula>
    Warhammer 40,000 Campaign Skirmish Game: Warpstrike
    My Spelljammer stuff (including an orbit tracker), 2E AD&D spreadsheet, and Vault of the Drow maps are available in my Dropbox. Feel free to use or not use it as you see fit!
    Thri-Kreen Ranger/Psionicist by me, based off of Rich's A Monster for Every Season

  3. - Top - End - #3
    Troll in the Playground
     
    PaladinGuy

    Join Date
    Mar 2012
    Location
    UK
    Gender
    Male

    Default Re: Help with MS Excel

    Quote Originally Posted by Lord Torath View Post
    You can also use "&"

    =A4&"+/-"&B4

    =<formula>&"text"&<other formula>&"other text"&<last formula>
    I would extend this to format the mean and the SD how you want, e.g.:

    =text(A4,"#,##0.00"&)"+/-"&text(B4,"0.00")

    This way the mean and SD will both be shown to 2d.p. at all times.

  4. - Top - End - #4
    Barbarian in the Playground
     
    NecromancerGuy

    Join Date
    Apr 2010
    Location
    Night Vale
    Gender
    Male

    Default Re: Help with MS Excel

    Quote Originally Posted by Lord Torath View Post
    You can also use "&"

    =A4&"+/-"&B4

    =<formula>&"text"&<other formula>&"other text"&<last formula>
    Quote Originally Posted by Khedrac View Post
    I would extend this to format the mean and the SD how you want, e.g.:

    =text(A4,"#,##0.00"&)"+/-"&text(B4,"0.00")

    This way the mean and SD will both be shown to 2d.p. at all times.
    Thanks for the info, I love this form, it's just a little corner of generally polite and helpful people.

    The number of decimal places isn't fixed, depending on the column I need anywhere between 0 and 3 digits after the decimal. The round function is actually pointed at a reference cell that says how many places are needed. I apparently copied the text of the cell I was using for experimentation.
    Avatar by TheGiant
    Long-form Sig

  5. - Top - End - #5
    Ogre in the Playground
     
    ElfRangerGuy

    Join Date
    Jun 2018
    Location
    Belgium
    Gender
    Male

    Default Re: Help with MS Excel

    A very common way of showing results (at least in reports for new drugs) is the mean with the same amount of decimals as the numbers your deriving it from (for instance a lab test result) and the SD with one decimal more.
    Clacks-Overhead: GNU Terry Pratchett

    "Magic can turn a frog into a prince. Science can turn a frog into a Ph.D. and you still have the frog you started with." Terry Pratchett
    "I will not yield to evil, unless she's cute."

Posting Permissions

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