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

6. Enter a formula in cell G2 to calculate the exam average earned for the student in cell A2 after dropping the lowest exam score. Your formula must:Use a reference for the total points earned that does not use a hard-wired number Use a denominator calculated using a function that counts ((number of exams taken)-1)Automatically update if an exam score changes
Solved by G. J. in 12 mins
I need help with finding a formula to calculate "What is the average daily rate by month by city?"
Solved by A. H. in 26 mins
I need to find the average excel for price
Solved by A. W. in 26 mins
Follow up: i need to find the average price for each year
Solved by K. F. in 23 mins
Trying to figure out how to do a dynamic year to date average
Solved by B. E. in 27 mins
I am not sure this formulas can even be written but here goes.... I need a formula that searches for a specific text in a column on another sheet. When it finds those that text in cells I need it to take the numerical value of another cell in the row(s) where that text was found and average all the occurrences together of those cells with the numerical values.
Solved by S. C. in 25 mins
could you please help me find the 5-hour period with highest demand in order to calculate the level of earnings to offer a driver during those 5 hours. Finished Rides have average value of €10 (commission is 20%).
Solved by E. Y. in 30 mins
You will use the Billionaires list shown below. Your goal is to create a column chart by pivoting that shows the average networth of billionaires for each country in the list.
Solved by K. Y. in 30 mins
finding out the average math to calculate the price of when a certain amount is purchased
Solved by G. H. in 29 mins
hello, i was able to solve some of the answers, but i have issues with the my weighted average excel
Solved by G. H. in 24 mins