I'm making use of a histogram to visualize my data. The only problem is that 90% of the data has a value which lies close to eachother but 10% is very different.
I'm trying to make a histogram with the data analysis tool. The problem is that whenever I make a chart it doesnt show my intervals correctly. It puts them under the bars instead of between them.
I have been searching to see if it's possible to create a histogram with non-numerical data and it doesn't seem like it's possible. Is there something similar where I can. Count number of occurrences of a string and organize them from most frequent to less frequent? There are about 60 possible strings.
e.g. ABCDEFGHIJ 1ddhykygghd 2jlqqwertya 3ukhghjklzx 4tukyuuiioa 5xypyjkkadh
Then output the counts of each of the strings (letters in this case) present. I was thinking of just putting them in the same row or column and manually counting, but it doesn't seem like it would be that difficult have it automated.
I am writing a macro that finds the prime numbers between to numbers chosen by the user. I want to create a histogram showing the distribution of the primes. I was going to use the Histogram tool in the Data Analysis add-in. My problem is in setting the input range. I do not know how many entries there will be in the input range. How can I write the argument so that it can be "dynamic" I can determine how many entries there are after I determine the prime numbers but I am not sure how to put that info into the Histogram argument.
I'm trying to use the 2007 histogram tool (or frequency) to show me the frequency of data, but my data is in a different form than required for either of these tools. Let me use the following simple case -- to show the frequency of student grades both tools assume I have a list of student's test grades. What if I instead have more than one column, e.g., "grade" and "number students with that grade"??
My application is actually different, but it's still 2 columns, a numeric property and a weighting factor (e.g., fraction of the total).
On Histogram, is it possible to plot Bin averages?
In my data there are two columns, 1) File Size 2) Months and then I have created Bin(months) like 0,6,12,18,24
I want to plot average file size in those Bins. For example I would like to plot what was the average file size in past 6 months, past 6-12 months so on.
I've been trying to make this work with Chart Wizard and can't. I gave out 331 surveys and the data in each column is the answer selections for each question on the survey - A,B,C,D,E. I'd like to do a histogram for each column simply with the percentage of people that chose each answer selection.
I have a large table (20,000 plus entries) and I need a way to pull out data that matches criteria in buckets.
For example: April data (column B) that is from 0 to 30 (column C) April data (column B) that is from 31 to 45 (column C) ... 46 to 60 ... 61 to 75 ... 75 to infiniti
Then do it again for May, June, July, etc. I have used DCOUNTs to pull this type of data, but it's a bit cumbersome. Any other ways to pull this type of data from the table?
I am looking for an formula to calculate the bin width for a histogram chart.
I am thinking of creating 50 bins for the chart. The range (max - min) of the data can be from £10 to £5,000,000.
A straighforward formula will be (max - min)/ 50. But I don't want decimal point in the bin numbers.
I am thinking of using Floor/Ceiling function, to round the bin-width to whole numbers, but 10/50, 100/50, 1000/50,..., 1000000/50 all need to round up/down to different scales! for example, I want 100/50 round to 5, 1000/50 round to 50 etc.....I was wondering is there a formula I can use to calculate the bin-width based on the criteria above or similar?
Those "False, False, False, False" parameters to run a histogram, whatever do they mean? Application.Run "ATPVBAEN.XLAM!Histogram", Range("Inputs"), Hist.Offset(0, 3), Worksheets("OutputSheet").Range("Outputs"), False, False, False, False
Through recorded code, I've seen that to create a histogram, the third False is a "True"... but let's say I've already got the blank histogram created. I'm running a simulation (where the inputs range is being updated with every run), and I want the histogram to be filled in at the end of all the runs. What do these parameters have to do with it? Having them all as false, like I've been told, isn't working.
We were working on a set of stock returns using histogram option from the analysis tools. We have not been able to figure out why we have produced two different sets of frequencies over same set of data and one predefined bin range.
Only a few classes present different counts. Can this be due to two different versions of excel were used?
I'm trying to come up with a histogram chart that adjusts Bin Size based on user input. I've come up with the formulas for Bins and Frequency, but am struggling when it comes to charting the data to dynamically update when the user changes Bin Size. How to make the x-axis dynamically adjust with the number of Bins.
i m given 12 max value of my 292 cells. now im asked to find number of cells that falls within each of these max values?? im asked t use histogram. how will i do it?
I am trying to write a macro for transposing one row into multiple columns where the starting point for each column will be 15 cells starting from B4. I want to replicate the transpose for 200 rows.
and so on till Next_Datexx is greater than End_date
I need a VBA code to fill the adjacent columns ie Next_date1 to Next_Date99 ( till the end_date), only if the Status is "DONE". If the Status is blank then the relevant colums must not fill.
I can do it with formulas, but need the VBA code.
Also the number of rows can be increased to 99 rows
I'm trying to determine how much time our agents are spending for their lunch/breaks during 30 minute intervals. Range A8:A200 lists the agent's names, Range B8:B200 lists their lunch/break start times, Range C8:C200 lists their lunch/break end times, and Column E lists the times (8:00, 8:30, 9:00, etc.). If an agent starts their break at 10:57 (Column B) and ends at 11:10 (Column C), the value next to 10:30 (Column E) would have 0:03:00 and the value next to 11:00 would have 0:10:00. But would need to sum all the agents which took a break/lunch between 10:30-11:00, and 11:00-11:30.
I think I've had enough of using excel generated macro's as an excuse for decent code. I need to turn this:
Small procedure, function, what have you that will continue this pattern until I hit some kind of indicator to tell it to stop. This just clears the contents from 7 rows, hops down 9 rows and does it again.
I have posted earlier thread on similar problem but i did not get much response.I am really having a tough time to record a macro, where my columns will be selected with an interval and then will be pasted in to another sheet....
I would like to write a formula to average cells F27 - F11007 in a spreadsheet for every 96 values. That is, I want the average of F27:F122, F123:F218, F219:F314 and so on up to F10912:F11007. Ideally I would be able to pull down the fill handle and perpetuate the formula since this is a lot of data.
I've been trying to use INDIRECT and OFFSET formulas but I get a #REF! or #VALUE error.
I am trying to do is calculate (sum) results data for time intervals. For example, between 0500-0559hrs then 0600-0659hrs and so on. Data is collected at 1 minute intervals and may have a result of 0 or anywhere up to 30.
Column A has all time data e.g. 0500,0501,0502 etc Column B has sum of instances e.g. 0,1,2,3 etc
I want to create 15 minute time intervals from the data. I attached the file for reference. I would like to sum the data column that corresponds to each interval. I created an example using the formulas and I want to be able to do that automatically either using VBA or the formulas.
I want to set something up so the following text, is repeated at set intervals down the sheet, a number of times defined by an integer input box at the top of the sheet. Next to each new text array, I'd like to define a dynamic name range, calling each an increment above the one before. So:
Question Title Question no. Assessment Target Level No. of Marks
With name ranges being, (for e.g.) P1QT, P2QT, P3QT. For three sets of papers for the "Question Title" range.
