+ Reply to Thread
Results 1 to 5 of 5

How to calculate standard deviation of a product?

  1. #1
    Registered User
    Join Date
    10-22-2013
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to calculate standard deviation of a product?

    Hello, I need to find the stdev of a mathematical combination of two samples. To simplify, my problem is as follows..

    I have two samples , and have calculated the mean and stdev of those:

    sample A) mean +- Stdev (etc. 250+-2)
    Sample B) mean +- Stdev (12+-1)

    How do i find the Stdev of C, if C = A/B? (20,8)

    Would it be right just to use StdevA/Stdev B? (20,8+-2)


    And is it possible to do a t-test in Excel with only the mean and stdev? I need to compare different groups of "C's". (meaning i have A 1-4 and B 1-4, four groups to compare).

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,445

    Re: How to calculate standard deviation of a product?

    I'm not aware of any built in Excel formula for computing the standard deviation of a product or a quotient like that. For that matter, I cannot find any reference to a simple formula for combining standard deviations like that. If you believe there should be such a formula, I would suggest you peruse your favorite statistical reference or pose this question to a forum or group that is well-versed in statistics. We on this forum are quite good with Excel, but we don't seem to have any regular visitors who know the science of statistics inside and out. If you can give us the statistical formula, we can help you program it into Excel, but I don't know if anyone here will know the formula.

    That said, if there is no formula for this calculation, then you can always compute each product/quotient, then use the built in stdev() function on those columns to compute the standard deviation of each product/quotient.

    I'm sure it is possible to perform a t-test with only the mean and stdev. You will need to go to your statistics text and get the formula for the t-score, and then you can use the tdist() function to return the desired t-score.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,445

    Re: How to calculate standard deviation of a product?

    Did I misinterpret your question? Is your question really about propagation of error (where you are using the standard deviation as your measure of error)? http://chemwiki.ucdavis.edu/Analytic...ation_of_Error Does that describe the answer to your question?

  4. #4
    Registered User
    Join Date
    10-22-2013
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to calculate standard deviation of a product?

    Hello MrShorty, and thank you for the response.

    I really think my question is about propagation of error, where I want to use SD as my measurement of error in my graphs. The final anwer should be in a unit, consisting of combining different meaurements of my samples (mol/mg/time).

    I thus have a mean measurement of mol +/- SD and a mean measurement of mg +/-SD, which I need to combine to find the spesific unit.

    I think the link you refers to helps very much,and answer my question Im just a beginner in statistics, and more to come for my measter thesis..

    So there is no build-in formula in Excel to perform this?


    To perform comaprison between groups I used SPSS instead to perform the Tukeys multicomparisons test, or else I had to run several t-tests in Excel.

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,445

    Re: How to calculate standard deviation of a product?

    No there is not a built in Excel function for propagation of error. (I'm not even sure that dedicated statistics packages like Minitab include built in propagation of error functions.)

    As a beginner in statistics headed towards a masters degree, I would strongly encourage you to become proficient in statistics. As a chemist, I look back on my schooling and wish I had taken a couple of statistics classes. If you are in a position to do so, I would talk with your advisor about this. It is my opinion that, if you are going into a field where your master's thesis is asking you to do propagation of error and Tukey's tests, you would be well served by taking a couple of courses that will give you a solid understanding of at least basic statistics.

+ 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. Calculate Standard Deviation
    By goss in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2013, 05:11 AM
  2. Calculate one standard deviation from mean
    By missyreiber in forum Excel General
    Replies: 3
    Last Post: 09-08-2010, 11:40 AM
  3. VBA Function to calculate Mean and Standard Deviation
    By Divius in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2007, 07:04 AM
  4. how to calculate Standard deviation of product of numbers?
    By Mridull Putatunda in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2005, 05:05 PM
  5. [SOLVED] How to calculate 2 standard deviation?
    By Li in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2005, 05:06 PM

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