Given the following set of numbers, find the average and sample standard deviation in excel. Important Once you have completed your calculation, report your numbers in a separate cell and obey the rounding requirement from last pre-lab: Data 1 1.25 1.33 1.5 1.552 1.347 1.9 1.1 1.67 1.32 1 1.5

Question

Given the following set of numbers, find the average and sample standard deviation in excel. Important Once you have completed your calculation, report your numbers in a separate cell and obey the rounding requirement from last pre-lab:                    Data                            1                            1.25                            1.33                            1.5                            1.552                            1.347                            1.9                            1.1                            1.67                            1.32                            1                            1.5

nuramaaji2000fh · Accepted Answer

Step 1No. of samples = 12      average    mean    =            (      1      +      1.25      +      1.33      +      1.5      +      1.552      +      1.347      +      1.9      +      1.1      +      1.67      +      1.32      +      1      +      1.5      )        12      =      16.469    12    =  1.372416667  ≃  1.37242Sample standard deviation   =  σ  =                    ∑        (        x        −                              x            ¯                                    )          2                    η                  x      ¯        =      mean    average of samples    ;     x  =  sample    η  =  no. of samples    ⇒  σ  =                                          (            1            −            1.37242                          )              2                        +            (            1.25            −            1.37242                          )              2                        +            (            1.33            −            1.37242                          )              2                                                            +            (            1.5            −            1.37242                          )              2                        +            (            1.552            −            1.37242                          )              2                        +            (            1.347            −            1.37242                          )              2                                                            +            (            1.9            −            1.37242                          )              2                        +            (            1.1            −            1.37242                          )              2                        +            (            1.67            −            1.37242                          )              2                                                            +            (            1.32            −            1.37242                          )              2                        +            (            1            −            1.37242                          )              2                        +            (            1.5            −            1.37242                          )              2                                                  12        −        1                ⇒  σ  =            0.803485      11        =  0.27027    ∴  Standard deviation  =  0.27027

Given the following set of numbers, find the average and sample standard deviation in excel. Important Once you have completed your calculation, report your numbers in a separate cell and obey the rounding requirement from last pre-lab:

Answered question

Answer & Explanation

New Questions in Pre-Algebra