+ Reply to Thread
Results 1 to 1 of 1

Need help making a histogram

  1. #1
    Registered User
    Join Date
    09-03-2014
    Location
    Phoenix, AZ
    MS-Off Ver
    2013
    Posts
    1

    Need help making a histogram

    Here is my prompt followed by the data set. I am pretty sure that the numerical values go into column A for the Bin numbers but I am at a loss as to what goes into column B.

    Thanks for any help that anyone can give me. I think I know how to make the actual chart once I have the proper placement of the numbers.

    a) Present this data as a histogram.
    b) Find the 5-number summary.
    c) Find the mean and standard deviation.


    $45,768 IN
    $52,267 NE
    $52,472 SC
    $47,680 AK
    $66,254 IA
    $51,505 NV
    $51,722 SD
    $49,380 AZ
    $48,995 KA
    $53,541 NH
    $67,848 TN
    $47,530 AR
    $39,945 KE
    $43,953 NJ
    $73,973 TX
    $49,086 CA
    $58,327 LA
    $42,886 NM
    $42,240 UT
    $52,286 CO
    $58,849 ME
    $51,372 NY
    $56,556 VT
    $55,819 CN
    $73,458 MD
    $69,695 NC
    $47,112 VA
    $61,309 DE
    $60,352 MA
    $68,701 ND
    $51,020 WA
    $57,478 FL
    $49,461 MI
    $55,778 OH
    $51,966 WV
    $40,827 GA
    $49,745 MN
    $62,538 OK
    $44,508 WI
    $55,780 HI
    $63,813 MS
    $39,319 OR
    $51,011 WY
    $54,935 ID
    $46,586 MO
    $50,819 PN
    $53,680IL
    $60,387 MT
    $44,958 RI
    $58,978

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,159

    Re: Need help making a histogram

    This sounds like a homework question - check out the Forum Rules and FAQs at the top of the screen to discover the Forum's attitude to homework assignments.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. making a spreadsheet for student coursework making
    By spartan11chin in forum Excel General
    Replies: 17
    Last Post: 12-01-2009, 08:18 AM
  2. Superimposed histogram A on histogram B
    By firuz in forum Excel General
    Replies: 5
    Last Post: 05-26-2007, 09:10 PM
  3. [SOLVED] I was creating a histogram; now i have data but no histogram.
    By ShannonMills3 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-13-2006, 07:10 PM
  4. [SOLVED] How to Histogram w/o raw data but histogram Table on Excel
    By 2005 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-01-2006, 02:50 AM
  5. [SOLVED] How to make excel not round real numbers when making a histogram?
    By Leedawg in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-21-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1