Purchase Solution

Box Whisker Plot in EXCEL

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Solution Summary

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

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Normal Probability Plot and Box-and-Whisker Plot

    In this solution, step-by-step explanation of this complicated topic provides students with a clear perspective of Normal Probability Plot and Box-and-Whisker Plot in excel with its intepretation.

  • Box and Whisker Plot

    184144 Box and Whisker Plot Please see attachment for data to plot. Please see the attached file. Excel spreadsheet shows how to form a box and whisker plot for given data.

  • Descriptive Statistics and Probability Exercises

    /2007/01/box-plot-and-whisker-plots-in-excel.html#.UFfLeK6d6So An alternate option would be to use a box-and-whisker chart maker that can be found online: http://www.mathwarehouse.com/charts/box-and-whisker-plot-maker.php This would be a sample of

  • Describing the the Shape of a Distribution

    In other words, the right tail is longer. Please see attached excel spreadsheet for box and whisker plot. The solution gives and explains the shape of this five-number summary of the sample and attaches calculations in Excel.

  • Box and Whisker Plot and Interquartile Range

    Inter-quartile range = Q3 - Q1 = 12 - 9 = 3 Kap falls in the first quartile (in the first 25% of the scores) The solution contains the Box and Whisker plot and calculation of interquartile range.

  • Explanantion of box-and-whisker using Minitab

    377876 Box and Whisker Diagram to compare salaries of researchers by gender See the attached file for Box and Whisker Plot. With reference to the box-and-whisker diagrams, compare the salaries of the researchers selected in your sample, by gender.

  • Box and Whisker Plots

    A box and whisker plot is used to display data. Explain, by example, what box and whisker plots show us. Thanks. A box-and-whisker plot (often simply called a box plot) is a graphical way of showing data.

  • Descriptive Statistics: Box and Whisker Plot

    572582 Descriptive Statistics: Box and Whisker Plot The major shopping areas in the community of Springdale include Springdale Mall, West Mall, and the downtown area on Main Street.

  • Percentiles and Quartiles

    14 14 15 Make a box and whisker plot and find the interquartile range.

View More Related Solutions