Get instant live Excel expert help to learn how to create a statistical function in Excel?

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a file in which I need to somehow use a conditional formatting for the same names of the data available, or if there is any other way to calculate the frequency of one particular name appearing.
Solved by K. F. in 17 mins
Need Total Monthly hours output with conditions (nested) If frequency = Monthly and duration =3 , then multiply duration times 1, etc
Solved by M. A. in 21 mins
I need to show a frequency distribution and a histogram for a set of 200 data. all ranging from 43-116. I have sorted it from smallest to largest and would like to class the data from 40-49,50-59,60-69,70-79,80-89,90-99,100-109, 109-110, and 110-119. How do I create the frequency distribution and histogram with this data?
Solved by O. F. in 28 mins
I have 2 tabs on a spreadsheet. One of them (named "Customer Report A") has a list of customers each identified by a unique reference along with their name and status. On the other tab (named "Detail Report B"), there is also a list of customers (some of whom are listed in the 1st tab) with their unique references, along with additional columns detailing amounts, start dates and frequency. I need to combine the data, so that the amounts, start dates and frequency columns from the 2nd tab can be matched up to the correct customers in the first tab. But this should only be done for the customers who are listed in tab 1.
Solved by K. L. in 18 mins
I need to find the frequency of auditor within a certain particular date. I will provide the data in more details.
Solved by V. Y. in 20 mins
Create a histogram for the duration data using the frequency table excel and use the "Frequency" results, not the relative frequencies. Labeled with meaningful axis titles and a chart title.
Solved by V. Q. in 18 mins
I created a chart in Excel but the frequency range came out in duplicates ex. 1 , 1,2,2,3,3,4,4,5. When it was done automatically the range was fine but there were fraction ex 1, 1.5 2. 2.5. I changed numbers to have whole numbers only and got the whole numbers with duplication.
Solved by D. E. in 11 mins
I'm trying to group my frequency distribition table excel by the number of customers who purchased a specific number of items at their visit to the store. My row groups need to be 1, 2,3,4,5,6,7> So how can I group all the 7 purchase and higher visits in 1 row?
Solved by M. H. in 25 mins
I'm trying to make a frequency chart. There are 5 different value options, if that makes sense, and 4737 values (as in, each of these values is 1, 2, 3, 4, or 5). Every time I try to make a chart it puts the 12345 and the 4737 on the wrong axes- 12345 should be x and the frequency of each of those values should be the y, and I can't figure out how to fix this because every time I go to 'select data' it has 'series 1' under legend entries and under horizontal axis labels it just has a bunch of numbers selected- I can see 1-50 and then there's an ellipses at the bottom, but I don't know what any of those numbers are meant to represent.
Solved by B. B. in 15 mins
I am trying to calculate cumulative frequency on a 2013 Excel document, but when I put in =FREQUENCY(A1:A25,F5) it is not giving me the right answer, what should I do?
Solved by T. J. in 24 mins