Histograms summary data
Download
1 / 31

Histograms Summary Data - PowerPoint PPT Presentation


  • 545 Views
  • Updated On :

Histograms & Summary Data. Histograms & Summary Data. Summarizing large of amounts of data in two ways: Histograms: graphs give a pictorial representation of the data Numerical summaries: gives snapshot of the data overall: “Average”, “Mode”, “Median”, etc. Histograms & Summary Data.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Histograms Summary Data' - Anita


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Histograms summary data2 l.jpg
Histograms & Summary Data

  • Summarizing large of amounts of data in two ways:

    • Histograms: graphs give a pictorial representation of the data

    • Numerical summaries: gives snapshot of the data overall:

      • “Average”, “Mode”, “Median”, etc


Histograms summary data3 l.jpg
Histograms & Summary Data

  • Microsoft Excel has several tools that allows to summarize data:

    • sorting

    • Maximum

    • Minimum

    • range (difference between max and min)

    • mean (average)

    • grouping data

    • plotting a histogram


Histograms summary data4 l.jpg
Histograms & Summary Data

  • Sorting in Excel

Click on “Data”

Click on “Sort”


Histograms summary data5 l.jpg
Histograms & Summary Data

  • Sorting in Excel

Store the data to be sorted in a list by columns

Click to sort the column from low to high and vice versa

Click “OK”


Histograms summary data6 l.jpg
Histograms & Summary Data

  • Sorting in Excel

  • Ex: On the class webpage, go to the file NBAPlayerHeights.xls

  • File contains data for the top ten player heights (in inches) by team during the 1990-91 season


Histograms summary data7 l.jpg
Histograms & Summary Data

  • Use the Sort tool in Excel to list all the player heights from smallest to largest

First, highlight the data you wish to sort

Go to “Data” and click “Sort”

Click “Ascending”, then click “OK”


Histograms summary data8 l.jpg
Histograms & Summary Data

  • What is the smallest height?

    • Answer: 67 inches

  • What is the largest height?

    • Answer: 91 inches


Histograms summary data9 l.jpg
Histograms & Summary Data

  • MIN and MAX functions find the minimum value(s) and maximum value(s) in a list

  • The range is the maximum minus the minimum

  • AVERAGE function finds the average or mean

  • SUM function adds numbers in a list


Histograms summary data10 l.jpg
Histograms & Summary Data

  • Excel also has a Histogram tool

  • This function separates data into bins

  • The function counts how much data lies within each bin

  • You can (and should) define the size of the bin prior to opening the function


Histograms summary data11 l.jpg
Histograms & Summary Data

  • A histogram organizes data into groups by counting how much data is in each group

    • The groups are sometimes called “bins”

    • The number of observations in each “bin” is called the frequency


Histograms summary data12 l.jpg
Histograms & Summary Data

  • Installing the Histogram feature:

Click on “Tools” and then on “Add-Ins”


Histograms summary data13 l.jpg
Histograms & Summary Data

  • Installing the Histogram feature:

Click on these boxes

Hit “OK” to install. It will take a few moments for these packs to install


Histograms summary data14 l.jpg
Histograms & Summary Data

  • Creating a Histogram

Click on “Tools”

Click “Data Analysis”


Histograms summary data15 l.jpg
Histograms & Summary Data

  • Creating a Histogram

Click on “Histogram”

Click “OK”


Histograms summary data16 l.jpg
Histograms & Summary Data

  • Creating a Histogram:

Cells where your data is stored goes here

Your Bin Limits or Bin Widths go here. You need to type these beforehand in your worksheet

Choose the cell you want the frequencies of your bins to be displayed in Excel


Histograms summary data17 l.jpg
Histograms & Summary Data

  • Using NBAPlayerHeights.xls, create a histogram with bin widths of 5 starting at 65 inches


Histograms summary data18 l.jpg
Histograms & Summary Data

  • Create Bin Limits in Excel

Create a cell called “Bins”

Enter your Bins. Since we want bin to be width 5 there is only a difference of 5 between consecutive cells.


Histograms summary data19 l.jpg
Histograms & Summary Data

Cell Range of Data Goes Here

  • Create Histogram

Bin range you created goes here

The cell where you want the frequencies to be displayed


Histograms summary data20 l.jpg
Histograms & Summary Data

  • And the Results . . .

This is the number of uncounted player heights that were less than or equal to 70 inches


Histograms summary l.jpg
Histograms & Summary

  • Make a column called “Labels”

  • This will used to label your x-axis


Histograms summary data22 l.jpg
Histograms & Summary Data

  • Plotting Our Results:

  • Click on Chart Wizard


Histograms summary data23 l.jpg
Histograms & Summary Data

  • Select Chart Type

Click “Column”


Histograms summary data24 l.jpg
Histograms & Summary Data

  • Plotting

Choose “Columns”

Cell Range of your Histograms Frequencies goes here

Click “Next”


Histograms summary data25 l.jpg
Histograms & Summary Data

  • Plotting:

Click on “Series” tab from previous slide

Use #’s in “Labels” column

Click on “Next”


Histograms summary data26 l.jpg
Histograms & Summary Data

Give an informative title that clearly describes the graph

Clearly label each axis. Don’t forget units!

Click “Finish”


Histograms summary data27 l.jpg
Histograms & Summary Data

  • And the results:


Histograms summary data28 l.jpg
Histograms & Summary Data

  • One last thing . . .

  • Left-click on one of the bars:


Histograms summary data29 l.jpg
Histograms & Summary Data

  • Then Right-click on one of the selected bars

  • You’ll get this menu:

Click here


Histograms summary data30 l.jpg
Histograms & Summary Data

Change this to zero

Click this tab


Histograms summary data31 l.jpg
Histograms & Summary Data

  • And now the final results (really!)


ad