Quantcast

Got Homework?

Connect with other students for help. It's a free community.

  • across
    MIT Grad Student
    Online now
  • laura*
    Helped 1,000 students
    Online now
  • Hero
    College Math Guru
    Online now

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

JenniferSmart1

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
  1. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    • one year ago
  2. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    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?

    • one year ago
  3. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    @hartnn @CliffSedge

    • one year ago
  4. samtab
    Best Response
    You've already chosen the best response.
    Medals 0

    wait but what is the whole problem?

    • one year ago
  5. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  6. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

    first did u order the inputs?

    • one year ago
  7. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  8. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

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

    • one year ago
  9. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 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/50785d74e4b0ed1dac50e148-jennifersmart1-1350065660892-screenshot20121012at1.10.44pm.png

    • one year ago
  10. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

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

    • one year ago
  11. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 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
  12. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

    u have a set of 55 numbers. right?

    • one year ago
  13. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    sorry i lost internet connection

    • one year ago
  14. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    yep it's 55 numbers

    • one year ago
  15. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

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

    • one year ago
  16. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

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

    • one year ago
  17. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

    can be rounded up to 5.4

    • one year ago
  18. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    so let's say 5

    • one year ago
  19. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

    do u have to have integer class limits?

    • one year ago
  20. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  21. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    I'm honestly not sure

    • one year ago
  22. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 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
  23. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    this is what I had done manually

    • one year ago
  24. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    I just followed an example in the book

    • one year ago
  25. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

    it s great

    • one year ago
  26. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  27. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

    by hand or with the computer

    • one year ago
  28. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    I'm trying to use excel

    • one year ago
  29. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    @hartnn

    • one year ago
  30. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    and what are bins?

    • one year ago
  31. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

    i don't know?

    • one year ago
  32. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  33. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    @satellite73

    • one year ago
  34. helder_edwin
    Best Response
    You've already chosen the best response.
    Medals 0

    have u tried using excel's help?

    • one year ago
  35. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

    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

    • one year ago
  36. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  37. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 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
  38. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

    your bins does not have equal size....

    • one year ago
  39. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  40. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 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
  41. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    should I have them 5 sizes apart or six?

    • one year ago
  42. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  43. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    5th box from the top

    • one year ago
  44. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  45. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  46. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

    and n=9 , whats n?

    • one year ago
  47. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    that one I can attach it again

    • one year ago
  48. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    why is n=9 where is n?

    • one year ago
  49. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  50. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  51. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  52. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

    ok

    • one year ago
  53. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  54. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

    0-5.5*

    • one year ago
  55. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  56. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  57. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 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
  58. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    wikihow could be wrong though

    • one year ago
  59. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  60. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  61. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 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/50785d74e4b0ed1dac50e148-jennifersmart1-1350065660892-screenshot20121012at1.10.44pm.png

    • one year ago
  62. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  63. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    sure I will...then what's next

    • one year ago
  64. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

    my excel doesn't even have data analysis button

    • one year ago
  65. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    is there another way to make the histogram?

    • one year ago
  66. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 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
  67. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

    what popped up when u selected data analysis ?

    • one year ago
  68. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

    was there an option of histogram ?

    • one year ago
  69. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  70. hartnn
    Best Response
    You've already chosen the best response.
    Medals 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
  71. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  72. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

    • one year ago
    1 Attachment
  73. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  74. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    I guess I don't have that

    • one year ago
  75. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 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
  76. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  77. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    I think I downloaded it !

    • one year ago
  78. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

    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....

    • one year ago
  79. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 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
  80. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    that screenshot above is of the statplus instructions

    • one year ago
  81. hartnn
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  82. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  83. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • one year ago
  84. JenniferSmart1
    Best Response
    You've already chosen the best response.
    Medals 1

    oh my god look at that!

    • one year ago
    • Attachments:

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
  • 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.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.