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

I need help with frequency distribution graphs.

Solved by Z. Y. in 28 mins

In google sheets my frequency isn't giving a vertical range size one larger than the classes.
The first one it gives is correct but with the 2nd it goes off the rails

Solved by C. W. in 12 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

Guys - Please help. I need to complete a dynamic reverse IRR, preferred return. and MIRR calculator that models a fund's capital calls and distribution waterfalls. Then use the total proceeds to calc total fees

Solved by T. Y. in 30 mins

I have created a formula with true and false however would like it to be $0 if the cells are blank.
=IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)

Solved by O. E. in 12 mins