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.
 one year ago
 one year 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.
 one year ago
 one year 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?
 one year ago

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

samtab Group TitleBest ResponseYou've already chosen the best response.0
wait but what is the whole problem?
 one year 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
 one year ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
first did u order the inputs?
 one year 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
 one year ago

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
yes. sorry. then finde the difference between x_maxx_min=range
 one year 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
 one year 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?
 one year 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
 one year ago

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

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

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
yep it's 55 numbers
 one year 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.
 one year 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 \]
 one year ago

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

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

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
do u have to have integer class limits?
 one year 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
 one year ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I'm honestly not sure
 one year 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.
 one year ago

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

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

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
it s great
 one year 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
 one year ago

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

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

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

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

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
i don't know?
 one year 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
 one year ago

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

helder_edwin Group TitleBest ResponseYou've already chosen the best response.0
have u tried using excel's help?
 one year 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
 one year 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
 one year 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?
 one year ago

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

hartnn Group TitleBest ResponseYou've already chosen the best response.1
05.5 >5.5 5.511.5>6 all others are 6
 one year 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
 one year ago

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

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

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

hartnn Group TitleBest ResponseYou've already chosen the best response.1
the one with min=20.5 and max<30.5 ??
 one year 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"
 one year ago

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

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
that one I can attach it again
 one year 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
 one year ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
why is n=9 where is n?
 one year 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 ?
 one year ago

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

hartnn Group TitleBest ResponseYou've already chosen the best response.1
0 to 43 = 44 so 44/8 = 5.5 like this ?
 one year 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
 one year 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...
 one year 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..
 one year 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"
 one year ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
wikihow could be wrong though
 one year 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
 one year 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
 one year 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
 one year 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
 one year ago

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

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

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
is there another way to make the histogram?
 one year 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
 one year ago

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

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

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
that "solver" window It reads "solver parameter" in the attachment
 one year 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
 one year ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
sorry I lost internet connection...but I'm back
 one year 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
 one year ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I guess I don't have that
 one year 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
 one year ago

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

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
I think I downloaded it !
 one year 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....
 one year 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
 one year ago

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

hartnn Group TitleBest ResponseYou've already chosen the best response.1
try this reference http://support.microsoft.com/kb/914208
 one year 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
 one year 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)
 one year ago

JenniferSmart1 Group TitleBest ResponseYou've already chosen the best response.1
oh my god look at that!
 one year 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.