Question
57 86 150 152 155 170 170 173 175 175 182 182 187 190 190 195 195 195 200 202 208 210 210 210 211
57 86 150 152 155 170 170 173 175 175 182 182 187 190 190 195 195 195 200 202 208 210 210 210 211 211 229 247 247 247 268 280 290 305 308 313 314 325 326 330 369 405 415 415 442 520 567 572 572 590 To create a 5-bin frequency distribution using Excels array formula {=FREQUENCY()}: a. Compute the minimun and maximun of the data using Excel functions = MIN and =MAX b. Compute the bin width equal to 1.05 x (max-min)/number of bins c. Compute the bin upper limits. The first bin upper limit = minimum + width. Bins must be equally spaced. d. Compute frequencies of you bins. Next to the bin values, select a range of cells on the same rows as the bin values. Type = FREQUENCY and finish the inputs, and type). Enter the array formula by typing CTRL + SHIFT + ENTER. The array formula will display with curly braces like {=frequency(your inputs)}. If you have completed each step correctly your bins and frequencies will be: Could you please include the formulas so I can do it in excel? Thanks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started