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

    • 2 years ago
  2. JenniferSmart1 Group Title
    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?

    • 2 years ago
  3. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    @hartnn @CliffSedge

    • 2 years ago
  4. samtab Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    wait but what is the whole problem?

    • 2 years ago
  5. JenniferSmart1 Group Title
    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

    • 2 years ago
  6. helder_edwin Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    first did u order the inputs?

    • 2 years ago
  7. JenniferSmart1 Group Title
    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

    • 2 years ago
  8. helder_edwin Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

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

    • 2 years ago
  9. JenniferSmart1 Group Title
    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

    • 2 years ago
  10. helder_edwin Group Title
    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?

    • 2 years ago
  11. JenniferSmart1 Group Title
    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

    • 2 years ago
  12. helder_edwin Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    u have a set of 55 numbers. right?

    • 2 years ago
  13. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    sorry i lost internet connection

    • 2 years ago
  14. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    yep it's 55 numbers

    • 2 years ago
  15. helder_edwin Group Title
    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.

    • 2 years ago
  16. helder_edwin Group Title
    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 \]

    • 2 years ago
  17. helder_edwin Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    can be rounded up to 5.4

    • 2 years ago
  18. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    so let's say 5

    • 2 years ago
  19. helder_edwin Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    do u have to have integer class limits?

    • 2 years ago
  20. JenniferSmart1 Group Title
    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

    • 2 years ago
  21. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    I'm honestly not sure

    • 2 years ago
  22. JenniferSmart1 Group Title
    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.

    • 2 years ago
  23. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    this is what I had done manually

    • 2 years ago
  24. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    I just followed an example in the book

    • 2 years ago
  25. helder_edwin Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    it s great

    • 2 years ago
  26. JenniferSmart1 Group Title
    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

    • 2 years ago
  27. helder_edwin Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    by hand or with the computer

    • 2 years ago
  28. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    I'm trying to use excel

    • 2 years ago
  29. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    @hartnn

    • 2 years ago
  30. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    and what are bins?

    • 2 years ago
  31. helder_edwin Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    i don't know?

    • 2 years ago
  32. JenniferSmart1 Group Title
    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

    • 2 years ago
  33. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    @satellite73

    • 2 years ago
  34. helder_edwin Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    have u tried using excel's help?

    • 2 years ago
  35. hartnn Group Title
    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

    • 2 years ago
  36. JenniferSmart1 Group Title
    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

    • 2 years ago
  37. JenniferSmart1 Group Title
    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?

    • 2 years ago
  38. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    your bins does not have equal size....

    • 2 years ago
  39. hartnn Group Title
    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

    • 2 years ago
  40. JenniferSmart1 Group Title
    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

    • 2 years ago
  41. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    should I have them 5 sizes apart or six?

    • 2 years ago
  42. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • 2 years ago
  43. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    5th box from the top

    • 2 years ago
  44. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • 2 years ago
  45. JenniferSmart1 Group Title
    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"

    • 2 years ago
  46. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    and n=9 , whats n?

    • 2 years ago
  47. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    that one I can attach it again

    • 2 years ago
  48. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    why is n=9 where is n?

    • 2 years ago
  49. hartnn Group Title
    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 ?

    • 2 years ago
  50. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • 2 years ago
  51. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • 2 years ago
  52. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    ok

    • 2 years ago
  53. hartnn Group Title
    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

    • 2 years ago
  54. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    0-5.5*

    • 2 years ago
  55. JenniferSmart1 Group Title
    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...

    • 2 years ago
  56. hartnn Group Title
    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..

    • 2 years ago
  57. JenniferSmart1 Group Title
    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"

    • 2 years ago
  58. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    wikihow could be wrong though

    • 2 years ago
  59. hartnn Group Title
    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

    • 2 years ago
  60. hartnn Group Title
    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

    • 2 years ago
  61. JenniferSmart1 Group Title
    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

    • 2 years ago
  62. hartnn Group Title
    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

    • 2 years ago
  63. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    sure I will...then what's next

    • 2 years ago
  64. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    my excel doesn't even have data analysis button

    • 2 years ago
  65. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    is there another way to make the histogram?

    • 2 years ago
  66. JenniferSmart1 Group Title
    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

    • 2 years ago
  67. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    what popped up when u selected data analysis ?

    • 2 years ago
  68. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    was there an option of histogram ?

    • 2 years ago
  69. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • 2 years ago
  70. hartnn Group Title
    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

    • 2 years ago
  71. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • 2 years ago
  72. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    • 2 years ago
    1 Attachment
  73. hartnn Group Title
    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

    • 2 years ago
  74. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    I guess I don't have that

    • 2 years ago
  75. JenniferSmart1 Group Title
    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

    • 2 years ago
  76. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • 2 years ago
  77. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    I think I downloaded it !

    • 2 years ago
  78. hartnn Group Title
    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....

    • 2 years ago
  79. JenniferSmart1 Group Title
    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

    • 2 years ago
  80. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    that screenshot above is of the statplus instructions

    • 2 years ago
  81. hartnn Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

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

    • 2 years ago
  82. JenniferSmart1 Group Title
    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

    • 2 years ago
  83. JenniferSmart1 Group Title
    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)

    • 2 years ago
  84. JenniferSmart1 Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    oh my god look at that!

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