# Thread: Help with MS Excel

1. ## 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.

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))

2. ## Re: Help with MS Excel

You can also use "&"

=A4&"+/-"&B4

=<formula>&"text"&<other formula>&"other text"&<last formula>

3. ## Re: Help with MS Excel

Originally Posted by Lord Torath
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. ## Re: Help with MS Excel

Originally Posted by Lord Torath
You can also use "&"

=A4&"+/-"&B4

=<formula>&"text"&<other formula>&"other text"&<last formula>
Originally Posted by Khedrac
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.

5. ## 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.

#### Posting Permissions

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