Got Homework?
Connect with other students for help. It's a free community.
Here's the question you clicked on:
 0 viewing
JenniferSmart1
Group Title
Statistics:
I'm trying to find what my "bins" are. (what are bins?)
I'm having trouble with solver.
see attachments and comments below.
 2 years ago
 2 years ago
JenniferSmart1 Group Title
Statistics: I'm trying to find what my "bins" are. (what are bins?) I'm having trouble with solver. see attachments and comments below.
 2 years ago
 2 years ago

This Question is Closed

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I'm trying to make a histogram and according to this link I have to have bins http://www.wikihow.com/CreateaHistograminExcel how would I do that? I know what my lower and upper bounds are. Are those my bins?
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
@hartnn @CliffSedge
 2 years ago

samtab Group TitleBest ResponseYou've already chosen the best response.0
wait but what is the whole problem?
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
oh I'll attach it. I completed a and b already. c is the problem child
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
first did u order the inputs?
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
are inputs my data values? I'm kinda new to the terminology. They're in column A
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
yes. sorry. then finde the difference between x_maxx_min=range
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
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/50785d74e4b0ed1dac50e148jennifersmart11350065660892screenshot20121012at1.10.44pm.png
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
from the date u r given it looks like x_max=43 and x_min=0 am i right?
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
the right hand side is just a random example. The values are not specific to the problem that i'm doing
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
u have a set of 55 numbers. right?
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
sorry i lost internet connection
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
yep it's 55 numbers
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
well the idea is that class range is x_maxxmin divided by the number of classes.
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
u get a class with equal to \[ \large \frac{430}{8}=5.375 \]
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
can be rounded up to 5.4
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
so let's say 5
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
do u have to have integer class limits?
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
5.4 works too by classes do you mean the...what do we mean by class
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I'm honestly not sure
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
it's just intro to stats and it's algebra based. I don't think they want us to do anything too fancy.
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
this is what I had done manually
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I just followed an example in the book
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
it s great
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
but how do I make a histogram though that's where I'm having trouble
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
by hand or with the computer
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I'm trying to use excel
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
@hartnn
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
and what are bins?
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
i don't know?
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I tried using this website but I can't really follow it http://www.wikihow.com/CreateaHistograminExcel
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
@satellite73
 2 years ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
have u tried using excel's help?
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
bins are just ranges of xaxis, 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 05.5, 5.511.5....... and u have 8 bins in total
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
so my bins would be my class boundaries. I labeled the upper and lower bounds
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
" 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?
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
your bins does not have equal size....
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
05.5 >5.5 5.511.5>6 all others are 6
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I don't know anymore. I thought they have to be separated by 5...ooops I thought I had them spaced equally :S
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
should I have them 5 sizes apart or six?
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
where is the original question ? is it above 'Excel 2007' ??
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
5th box from the top
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
the one with min=20.5 and max<30.5 ??
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
"oh I'll attach it. I completed a and b already. c is the problem child"
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
and n=9 , whats n?
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
that one I can attach it again
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
http://assets.openstudy.com/updates/attachments/50785d74e4b0ed1dac50e148jennifersmart11350073889192screenshot20121012at3.30.01pm.png http://assets.openstudy.com/updates/attachments/50785d74e4b0ed1dac50e148jennifersmart11350073888766screenshot20121012at3.29.47pm.png
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
why is n=9 where is n?
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
i am going though it, so u have 8 classes. how did u find class width ?
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
\[\frac{\text{Largest data valuesmallest data value}}{\text{Desired number of classes}}\]
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
0 to 43 = 44 so 44/8 = 5.5 like this ?
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
so the bins are : 0/5.5 5.5 11 11=16.5 and so on
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
43/8=5.375 so I rounded it ...yes that's what I did...
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
so u need to change your bins to 05.5, 5.511 , and so on..
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
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"
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
wikihow could be wrong though
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
a bin is an interval : 1st bin: 05.5 2nd bin: 5.511 so bin is range
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
bin is not a number bin size or width is a number = class width
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
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/50785d74e4b0ed1dac50e148jennifersmart11350065660892screenshot20121012at1.10.44pm.png
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
but u need to change bins , right to 05.5, 5.511 , 1116.5 , and so on
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
sure I will...then what's next
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
my excel doesn't even have data analysis button
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
is there another way to make the histogram?
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I honestly don't know. I'm just googling histogram and excel because i've never done this before in excel
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
what popped up when u selected data analysis ?
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
was there an option of histogram ?
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
that "solver" window It reads "solver parameter" in the attachment
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
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
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
sorry I lost internet connection...but I'm back
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
i don't know where u clicked, but u should get that^ when u click data analysis tab
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I guess I don't have that
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
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
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
then u need to install the addin : Analysis Toolpack
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I think I downloaded it !
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
idk anything about MAC. try to Find 'Excel Options' and there u get Addin tab, which has Analysis Toolbox option. maybe its will be in the dropdown list of settings besides ^ on upper right....
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I just need to follow the instructions in the above attachment. (two boxes up) which I don't seem to be able to do
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
that screenshot above is of the statplus instructions
 2 years ago

hartnn Group TitleBest ResponseYou've already chosen the best response.1
try this reference http://support.microsoft.com/kb/914208
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I think I have what I need. I just need to be able to follow the instructions I guess
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I'm starting to hate this MAC....(not really ;P , but it's really annoying because everything is soo different)
 2 years ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
oh my god look at that!
 2 years ago
See more questions >>>
Your question is ready. Sign up for free to start getting answers.
spraguer
(Moderator)
5
→ View Detailed Profile
is replying to Can someone tell me what button the professor is hitting...
23
 Teamwork 19 Teammate
 Problem Solving 19 Hero
 Engagement 19 Mad Hatter
 You have blocked this person.
 ✔ You're a fan Checking fan status...
Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.