Skip to main content
\(\require{cancel}\newcommand\degree[0]{^{\circ}} \newcommand\Ccancel[2][black]{\renewcommand\CancelColor{\color{#1}}\cancel{#2}} \newcommand{\alert}[1]{\boldsymbol{\color{magenta}{#1}}} \newcommand{\blert}[1]{\boldsymbol{\color{blue}{#1}}} \newcommand{\bluetext}[1]{\color{blue}{#1}} \delimitershortfall-1sp \newcommand\abs[1]{\left|#1\right|} \newcommand{\lt}{<} \newcommand{\gt}{>} \newcommand{\amp}{&} \)

Section2.4Chapter 2 Exercises

  1. Spreadsheet tutorial: In AppendixA you will find directions for and examples of using spreadsheet software to create bar graphs and find the mean and standard deviation of data sets. Read through them to understand the steps.

  2. The table below shows the chest sizes of a regiment of Scottish soldiers collected by the makers of their uniforms. The example spreadsheet your instructor gave you should be helpful here. When completing these problems, make sure to show all parts of the spreadsheet.

    1. Use a spreadsheet to create a bar graph for the data in the table below.
    2. Use a spreadsheet to compute the mean and standard deviation for this data.
Value 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
Count 3 19 81 189 409 753 1062 1082 935 646 313 168 50 18 3 1
Table2.27Scottish Soldier Uniform Chest-size Data