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.