anonymous
  • anonymous
Statistics: I'm trying to find what my "bins" are. (what are bins?) I'm having trouble with solver. see attachments and comments below.
Mathematics
  • Stacey Warren - Expert brainly.com
Hey! We 've verified this expert answer for you, click below to unlock the details :)
SOLVED
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.
chestercat
  • chestercat
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
anonymous
  • anonymous
anonymous
  • 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
  • anonymous
@hartnn @CliffSedge

Looking for something else?

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

More answers

anonymous
  • anonymous
wait but what is the whole problem?
anonymous
  • anonymous
oh I'll attach it. I completed a and b already. c is the problem child
helder_edwin
  • helder_edwin
first did u order the inputs?
anonymous
  • anonymous
are inputs my data values? I'm kinda new to the terminology. They're in column A
helder_edwin
  • helder_edwin
yes. sorry. then finde the difference between x_max-x_min=range
anonymous
  • 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
  • helder_edwin
from the date u r given it looks like x_max=43 and x_min=0 am i right?
anonymous
  • anonymous
the right hand side is just a random example. The values are not specific to the problem that i'm doing
helder_edwin
  • helder_edwin
u have a set of 55 numbers. right?
anonymous
  • anonymous
sorry i lost internet connection
anonymous
  • anonymous
yep it's 55 numbers
helder_edwin
  • helder_edwin
well the idea is that class range is x_max-x-min divided by the number of classes.
helder_edwin
  • helder_edwin
u get a class with equal to \[ \large \frac{43-0}{8}=5.375 \]
helder_edwin
  • helder_edwin
can be rounded up to 5.4
anonymous
  • anonymous
so let's say 5
helder_edwin
  • helder_edwin
do u have to have integer class limits?
anonymous
  • anonymous
5.4 works too by classes do you mean the...what do we mean by class
anonymous
  • anonymous
I'm honestly not sure
anonymous
  • 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
  • anonymous
this is what I had done manually
anonymous
  • anonymous
I just followed an example in the book
helder_edwin
  • helder_edwin
it s great
anonymous
  • anonymous
but how do I make a histogram though that's where I'm having trouble
helder_edwin
  • helder_edwin
by hand or with the computer
anonymous
  • anonymous
I'm trying to use excel
anonymous
  • anonymous
@hartnn
anonymous
  • anonymous
and what are bins?
helder_edwin
  • helder_edwin
i don't know?
anonymous
  • anonymous
I tried using this website but I can't really follow it http://www.wikihow.com/Create-a-Histogram-in-Excel
anonymous
  • anonymous
@satellite73
helder_edwin
  • helder_edwin
have u tried using excel's help?
hartnn
  • 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
  • anonymous
so my bins would be my class boundaries. I labeled the upper and lower bounds
anonymous
  • anonymous
http://assets.openstudy.com/updates/attachments/50785d74e4b0ed1dac50e148-jennifersmart1-1350065660892-screenshot20121012at1.10.44pm.png
anonymous
  • 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
  • hartnn
your bins does not have equal size....
hartnn
  • hartnn
0-5.5 --->5.5 5.5-11.5--->6 all others are 6
anonymous
  • 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
  • anonymous
should I have them 5 sizes apart or six?
hartnn
  • hartnn
where is the original question ? is it above 'Excel 2007' ??
anonymous
  • anonymous
5th box from the top
hartnn
  • hartnn
the one with min=20.5 and max<30.5 ??
anonymous
  • anonymous
"oh I'll attach it. I completed a and b already. c is the problem child"
hartnn
  • hartnn
and n=9 , whats n?
anonymous
  • anonymous
that one I can attach it again
anonymous
  • 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
  • anonymous
why is n=9 where is n?
hartnn
  • hartnn
i am going though it, so u have 8 classes. how did u find class width ?
anonymous
  • anonymous
\[\frac{\text{Largest data value-smallest data value}}{\text{Desired number of classes}}\]
hartnn
  • hartnn
0 to 43 = 44 so 44/8 = 5.5 like this ?
hartnn
  • hartnn
ok
hartnn
  • hartnn
so the bins are : 0/5.5 5.5 -11 11=16.5 and so on
hartnn
  • hartnn
0-5.5*
anonymous
  • anonymous
43/8=5.375 so I rounded it ...yes that's what I did...
hartnn
  • hartnn
so u need to change your bins to 0-5.5, 5.5-11 , and so on..
anonymous
  • 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
  • anonymous
wikihow could be wrong though
hartnn
  • hartnn
a bin is an interval : 1st bin: 0-5.5 2nd bin: 5.5-11 so bin is range
hartnn
  • hartnn
bin is not a number bin size or width is a number = class width
anonymous
  • 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
  • hartnn
but u need to change bins , right to 0-5.5, 5.5-11 , 11-16.5 , and so on
anonymous
  • anonymous
sure I will...then what's next
hartnn
  • hartnn
my excel doesn't even have data analysis button
anonymous
  • anonymous
is there another way to make the histogram?
anonymous
  • anonymous
I honestly don't know. I'm just googling histogram and excel because i've never done this before in excel
hartnn
  • hartnn
what popped up when u selected data analysis ?
hartnn
  • hartnn
was there an option of histogram ?
anonymous
  • anonymous
that "solver" window It reads "solver parameter" in the attachment
hartnn
  • 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
  • anonymous
sorry I lost internet connection...but I'm back
hartnn
  • hartnn
1 Attachment
hartnn
  • hartnn
i don't know where u clicked, but u should get that^ when u click data analysis tab
anonymous
  • anonymous
I guess I don't have that
anonymous
  • 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
  • hartnn
then u need to install the add-in : Analysis Toolpack
anonymous
  • anonymous
I think I downloaded it !
hartnn
  • 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
  • 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
  • anonymous
that screenshot above is of the statplus instructions
hartnn
  • hartnn
try this reference http://support.microsoft.com/kb/914208
anonymous
  • anonymous
I think I have what I need. I just need to be able to follow the instructions I guess
anonymous
  • anonymous
I'm starting to hate this MAC....(not really ;P , but it's really annoying because everything is soo different)
anonymous
  • anonymous
oh my god look at that!

Looking for something else?

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