Purchase Solution

# Box Whisker Plot in EXCEL

Not what you're looking for?

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.

##### Solution Summary

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

##### 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.