A community for students.
Here's the question you clicked on:
 0 viewing
JenniferSmart1
 3 years ago
Statistics:
I'm trying to find what my "bins" are. (what are bins?)
I'm having trouble with solver.
see attachments and comments below.
JenniferSmart1
 3 years ago
Statistics: I'm trying to find what my "bins" are. (what are bins?) I'm having trouble with solver. see attachments and comments below.

This Question is Closed

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1I'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?

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1@hartnn @CliffSedge

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

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

helder_edwin
 3 years ago
Best ResponseYou've already chosen the best response.0first did u order the inputs?

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

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

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1I'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

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

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

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

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1sorry i lost internet connection

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1yep it's 55 numbers

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

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

helder_edwin
 3 years ago
Best ResponseYou've already chosen the best response.0can be rounded up to 5.4

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

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.15.4 works too by classes do you mean the...what do we mean by class

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1I'm honestly not sure

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

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

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

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

helder_edwin
 3 years ago
Best ResponseYou've already chosen the best response.0by hand or with the computer

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1I'm trying to use excel

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1and what are bins?

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

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

hartnn
 3 years ago
Best ResponseYou've already chosen the best response.1bins 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

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

JenniferSmart1
 3 years ago
Best 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?

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

hartnn
 3 years ago
Best ResponseYou've already chosen the best response.105.5 >5.5 5.511.5>6 all others are 6

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

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

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

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.15th box from the top

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

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

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

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

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

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

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

hartnn
 3 years ago
Best ResponseYou've already chosen the best response.10 to 43 = 44 so 44/8 = 5.5 like this ?

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

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.143/8=5.375 so I rounded it ...yes that's what I did...

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

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1is 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"

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1wikihow could be wrong though

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

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

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1ok 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

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

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

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

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

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

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

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

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

hartnn
 3 years ago
Best ResponseYou've already chosen the best response.1strange, 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

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

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

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1I guess I don't have that

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1solver 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
 3 years ago
Best ResponseYou've already chosen the best response.1then u need to install the addin : Analysis Toolpack

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1I think I downloaded it !

hartnn
 3 years ago
Best ResponseYou've already chosen the best response.1idk 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....

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

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

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

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

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

JenniferSmart1
 3 years ago
Best ResponseYou've already chosen the best response.1oh my god look at that!
Ask your own question
Sign UpFind more explanations on OpenStudy
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.