Question

Anyone know how to create a histogram on Excel??

Answer 1

This is the data I want on the histogram. ^^^

Answer 2

Just select all the data and then go to Insert part...in this part you can choose what kind of graph you want to plot...

Answer 3

Yeah I know but I dont see anything that says "Histogram"

Answer 4

http://www.wikihow.com/Create-a-Histogram-in-Excel

Answer 5

So my 2 columns would be the show column (1-10) and my residuals column?

Answer 6

looks that way .. let me give it a shot

Answer 7

oy vey ... had to run thru hoops just to get the data analysis to show on the tool bar

Answer 8

do you have a data analysis tab in your data tab?

Answer 9

my notifs do not refresh on the main library computers

Answer 10

i think my teacher gave me some steps on adding it. lemme see....

Answer 11

Here the steps I have in my notes but it's not working for me...

Click File
Options
Add Analysis Pack (Through Addins I'm guessing)

Answer 12

Never mind I figured it out

Answer 13

This is what I get ^

Answer 14

file
info
options
add-ins
all the way at the bottom: manage "excel addins", GO

click analysis toolpak (top option on mine), and ok

Answer 15

yeah, i got it lol
i posted my result above

Answer 16

that doesnt quite look like a histogram. the first link i read thru the comments and people were complaining

Answer 17

what is a bin range?

Answer 18

bin numbers are the intervals you want excel to use ....

Answer 19

I dont know... but this question asks us to create a histogram using the residuals and then next one asks us if there is a problem with the histogram.... so the answer is probably yes since a histogram doesnt usually end up looking like that.

Answer 20

#3 Part C and D

Answer 21

No?

Answer 22

c looks fine, d i think is referring to the shape of the histogram. Not really if excel displayed it in a usual fashion

Answer 23

yeah thats what i mean...