Statistics:
I'm trying to find what my "bins" are. (what are bins?)
I'm having trouble with solver.
see attachments and comments below.

- anonymous

- Stacey Warren - Expert brainly.com

Hey! We 've verified this expert answer for you, click below to unlock the details :)

- schrodinger

I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!

- anonymous

##### 1 Attachment

- anonymous

I'm trying to make a histogram and according to this link I have to have bins
http://www.wikihow.com/Create-a-Histogram-in-Excel
how would I do that? I know what my lower and upper bounds are. Are those my bins?

- anonymous

@hartnn
@CliffSedge

Looking for something else?

Not the answer you are looking for? Search for more explanations.

## More answers

- anonymous

wait but what is the whole problem?

- anonymous

oh I'll attach it.
I completed a and b already.
c is the problem child

- helder_edwin

first did u order the inputs?

- anonymous

are inputs my data values? I'm kinda new to the terminology. They're in column A

- helder_edwin

yes. sorry.
then finde the difference between x_max-x_min=range

- anonymous

I'm not sure what my xmax and xmins are do you mean the difference between my lower and upper bounds?
http://assets.openstudy.com/updates/attachments/50785d74e4b0ed1dac50e148-jennifersmart1-1350065660892-screenshot20121012at1.10.44pm.png

- helder_edwin

from the date u r given it looks like x_max=43 and x_min=0
am i right?

- anonymous

the right hand side is just a random example. The values are not specific to the problem that i'm doing

- helder_edwin

u have a set of 55 numbers.
right?

- anonymous

sorry i lost internet connection

- anonymous

yep it's 55 numbers

- helder_edwin

well the idea is that class range is x_max-x-min divided by the number of classes.

- helder_edwin

u get a class with equal to
\[ \large \frac{43-0}{8}=5.375 \]

- helder_edwin

can be rounded up to 5.4

- anonymous

so let's say 5

- helder_edwin

do u have to have integer class limits?

- anonymous

5.4 works too by classes do you mean the...what do we mean by class

- anonymous

I'm honestly not sure

- anonymous

it's just intro to stats and it's algebra based. I don't think they want us to do anything too fancy.

- anonymous

this is what I had done manually

##### 1 Attachment

- anonymous

I just followed an example in the book

- helder_edwin

it s great

- anonymous

but how do I make a histogram though that's where I'm having trouble

- helder_edwin

by hand or with the computer

- anonymous

I'm trying to use excel

- anonymous

@hartnn

- anonymous

and what are bins?

- helder_edwin

i don't know?

- anonymous

I tried using this website but I can't really follow it
http://www.wikihow.com/Create-a-Histogram-in-Excel

- anonymous

@satellite73

- helder_edwin

have u tried using excel's help?

- hartnn

bins are just ranges of x-axis, like to construct a histogram from a continuous variable you first need to split the data into intervals, called bins.
so here your bins are 0-5.5, 5.5-11.5.......
and u have 8 bins in total

- anonymous

so my bins would be my class boundaries. I labeled the upper and lower bounds

- anonymous

http://assets.openstudy.com/updates/attachments/50785d74e4b0ed1dac50e148-jennifersmart1-1350065660892-screenshot20121012at1.10.44pm.png

- anonymous

" if you want to separate grades based on a 10 point scale 60, 70, 80, 90, 100 would be the bins"
So I guess I'm using a 5 point scale and my bins would be....0, 5.5, 11.5...no?

- hartnn

your bins does not have equal size....

- hartnn

0-5.5 --->5.5
5.5-11.5--->6
all others are 6

- anonymous

I don't know anymore. I thought they have to be separated by 5...ooops I thought I had them spaced equally :S

- anonymous

should I have them 5 sizes apart or six?

- hartnn

where is the original question ? is it above 'Excel 2007' ??

- anonymous

5th box from the top

- hartnn

the one with min=20.5 and max<30.5 ??

- anonymous

"oh I'll attach it.
I completed a and b already.
c is the problem child"

- hartnn

and n=9 , whats n?

- anonymous

that one I can attach it again

- anonymous

http://assets.openstudy.com/updates/attachments/50785d74e4b0ed1dac50e148-jennifersmart1-1350073889192-screenshot20121012at3.30.01pm.png
http://assets.openstudy.com/updates/attachments/50785d74e4b0ed1dac50e148-jennifersmart1-1350073888766-screenshot20121012at3.29.47pm.png

- anonymous

why is n=9 where is n?

- hartnn

i am going though it, so u have 8 classes. how did u find class width ?

- anonymous

\[\frac{\text{Largest data value-smallest data value}}{\text{Desired number of classes}}\]

- hartnn

0 to 43 = 44
so 44/8 = 5.5
like this ?

- hartnn

ok

- hartnn

so the bins are :
0/5.5
5.5 -11
11=16.5
and so on

- hartnn

0-5.5*

- anonymous

43/8=5.375 so I rounded it ...yes that's what I did...

- hartnn

so u need to change your bins to
0-5.5, 5.5-11 , and so on..

- anonymous

is a bin a range or a specific number?
From the way they've written it's kinda confusing "if you want to separate grades based on a 10 point scale 60, 70, 80, 90, 100 would be the bins"

- anonymous

wikihow could be wrong though

- hartnn

a bin is an interval :
1st bin: 0-5.5
2nd bin: 5.5-11
so bin is range

- hartnn

bin is not a number
bin size or width is a number = class width

- anonymous

ok so how do we proceed...the data analysis toolbox is confusing, I don't even know where to start
http://assets.openstudy.com/updates/attachments/50785d74e4b0ed1dac50e148-jennifersmart1-1350065660892-screenshot20121012at1.10.44pm.png

- hartnn

but u need to change bins , right
to 0-5.5, 5.5-11 , 11-16.5 , and so on

- anonymous

sure I will...then what's next

- hartnn

my excel doesn't even have data analysis button

- anonymous

is there another way to make the histogram?

- anonymous

I honestly don't know. I'm just googling histogram and excel because i've never done this before in excel

- hartnn

what popped up when u selected data analysis ?

- hartnn

was there an option of histogram ?

- anonymous

that "solver" window It reads "solver parameter" in the attachment

- hartnn

strange, u shouldn't get solver window .......
u should get options like input range, bin range...
http://www.math.kent.edu/~honli/teaching/statistics/Chapter2/Excell_Histogram.html

- anonymous

sorry I lost internet connection...but I'm back

- hartnn

##### 1 Attachment

- hartnn

i don't know where u clicked, but u should get that^ when u click data analysis tab

- anonymous

I guess I don't have that

- anonymous

solver is a different add on. I guess I have to find this correct one. For whatever reason the mac 2011 version doesn't have that

- hartnn

then u need to install the add-in : Analysis Toolpack

- anonymous

I think I downloaded it !

##### 1 Attachment

- hartnn

idk anything about MAC.
try to Find 'Excel Options' and there u get Add-in tab, which has Analysis Toolbox option.
maybe its will be in the dropdown list of settings besides ^ on upper right....

- anonymous

I just need to follow the instructions in the above attachment. (two boxes up) which I don't seem to be able to do

- anonymous

that screenshot above is of the statplus instructions

- hartnn

try this reference
http://support.microsoft.com/kb/914208

- anonymous

I think I have what I need. I just need to be able to follow the instructions I guess

##### 1 Attachment

- anonymous

I'm starting to hate this MAC....(not really ;P , but it's really annoying because everything is soo different)

- anonymous

oh my god look at that!

##### 1 Attachment

Looking for something else?

Not the answer you are looking for? Search for more explanations.