Explore BrainMass

Explore BrainMass

    Box Whisker Plot in EXCEL

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Please refer to the attached file for data.

    Please produce a single, labelled graph with 2 separate box and whisker plots of the height data for male and female students. Write a short paragraph that describes what the graph shows. An example is provided below.

    All scientists, in any of the many disciplines, spend a great deal of their time collecting data and/or information. Usually this data will often be in mathematical form, i.e. it will consist of numbers.

    The reason why scientists like to have data in numeric form is that it can then be analysed in detail. Scientists do this in order to make meaningful comments about the data they have collected. In scientific terminology we call this statistical analysis.

    In this first week of the course we will spend our time reviewing some of the simplest statistical terms that we are most likely to come across. These terms are as follows:

    MEAN,
    MEDIAN,
    MODE,
    RANGE,
    MINIMUM,
    MAXIMUM,
    SUM,
    COUNT.

    Data Analysis Terminology

    Do you know what all of these terms mean? On the pages that follow you will be asked to calculate theses terms for a set of data. To help you however we will first collect some data.

    We will collect information on the height of everyone in the class.

    Please complete the table on the next page:

    QUESTION

    Please produce a single, labelled graph with 2 separate box and whisker plots of the height data for male and female students. Write a short paragraph that describes what the graph shows. An example is provided below.

    © BrainMass Inc. brainmass.com June 4, 2020, 12:50 am ad1c9bdddf
    https://brainmass.com/statistics/box-plot/box-whisker-plot-excel-363543

    Attachments

    Solution Summary

    This solution helps produce a box and whisker plot in Excel. A short paragraph describing the graph is also included.

    $2.19

    ADVERTISEMENT