Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Dividend Policy On Share Price Volatility In Indian Stock Market

Authors: Vijay Deswal

1st Edition

3841859623, 978-3841859624

More Books

Students also viewed these Finance questions