Question
Hello. I need assistance setting up the following problem in excel: 4.Frequency Distribution According to Zillow.com, here is a list of the prices of the
Hello. I need assistance setting up the following problem in excel:
4.Frequency Distribution
According to Zillow.com, here is a list of the prices of the property sold (in thousands) in Phoenix, AZ November 9 - 13, 2017.Use Excel's capability (=FREQUENCY()) to make a frequency distribution using 5 bins.
247
190
210
211
415
567
195
187
150
313
280
305
202
326
170
572
182
195
325
290
86
182
229
405
442
210
152
155
308
314
520
195
200
572
170
173
208
330
369
590
57
268
247
175
175
180
265
244
490
290
Hint: To score the full points for this question, set it up so that Excel calculate the bins for you. This way if you change the data the bins are changed automatically.
The "Hint" portion is giving me the most trouble.
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
Introduction to Finance Markets, Investments and Financial Management
Authors: Ronald W. Melicher, Edgar A. Norton
16th edition
1119398282, 978-1-119-3211, 1119321115, 978-1119398288
