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

There are starting dates and ending dates of when they became customers and when they quit. There are two different services (social media and blogging) and for each service, I have 3 different levels (starter, pro, and enterprise). I need someone to create an excel spreadsheet which will calculate the following: average customer length for social (starter, pro, and enterprise) average customer length for blogging (starter, pro, and enterprise) monthly churn rate for social (starter, pro, and enterprise) monthly churn rate for blogging (starter, pro, and enterprise) percentage of "never started". These are spam that we never did work on and shouldn't be counted toward the other numbers. total amount billed per month for each category
Solved by C. S. in 25 mins
I have 3 different levels (starter, pro, and enterprise). I need someone to create an excel spreadsheet which will calculate the following: average customer length for blogging (starter, pro, and enterprise) monthly churn rate for blogging (starter, pro, and enterprise) percentage of "never started". These are spam that we never did work on and shouldn't be counted toward the other numbers. total amount billed per month for each category
Solved by X. A. in 22 mins
I need to create an IF formula that looks for specific text on column D and if its a match, sums up column C but only if the average of column B is above 0.
Solved by E. L. in 22 mins
I need an excel formula that can solve this: A casino manager wants to introduce a fun game (that gives the customers an advantage). The Game: 1. A random colour machine displays either GREEN or RED. 2. Customer picks a colour and wins if their colour is displayed 3. A round involves 10 games. Of which GREEN is displayed 6 times on average (to give the customer an advantage) 4. Pay out is the stake x 0.7 (so if you select green and bet $1, your total return is $1.70 if green appears. But you lose $1 if red appears) (the customer still has a small advantage) QUESTION: What is the optimal betting strategy, to ensure that the customer wins $50 after every round (10 games) if the customer started with $100.
Solved by F. F. in 18 mins
I need help with this question: A casino manager wants to introduce a fun game (that gives the customers an advantage). The Game: 1. A random colour machine displays either GREEN or RED. 2. Customer picks a colour and wins if their colour is displayed 3. A round involves 10 games. Of which GREEN is displayed 6 times on average (to give the customer an advantage) 4. Pay out is the stake x 0.7 (so if you select green and bet $1, your total return is $1.70 if green appears. But you lose $1 if red appears) (the customer still has a small advantage) QUESTION: What is the optimal betting strategy, to ensure that the customer wins $50 after every round (10 games) if the customer started with $100. Please help me with this question.
Solved by D. B. in 29 mins
Hello, it is difficult to explain my problem without showing you a screenshot, but I am trying to calculate in my "I" column the average social media engagement of various publications appearing in my "F" column. I've created an AVERAGEIF formula (in French however, because my program is in French) based on the Microsoft tutorial on the subject, yet I still get an error message. I can't figure out what is wrong with my forumla. Help! Thank you.
Solved by Z. U. in 26 mins
I need to find the average value of the function for the rate of rows that have the same from date and start time in a spreadsheet. I would like to know if there is a formula that can be replicated over and over to do this for the entire spreadsheet. And then would like to use that formula again in the future for future spreadsheets.
Solved by V. A. in 12 mins
Find the average from SHEET RF and bring result on SHEET for upload - using formula vollokup and average function, or any other functions
Solved by Z. Y. in 28 mins
Hi there, I am trying to create an average. I have my range, my criteria and my counts but it returns zeros. I am trying to count the average unit per person My range a column including all those names, my count is a column counting each line with a number in and my criteria is the 7 names. I created a sumif formula and another formula. Will I be able to share the file with you? So many thanks. I have the felling that there is a filter on the file. Would this prevent the calculation to work? Many thanks
Solved by Z. C. in 25 mins
trying to design a spreadsheet that will configure the average points on a predetermined scale
Solved by Z. E. in 22 mins