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

I need to calculate average in excel between a set of years and percentages, like 4 years at 12% 5 years at 20% ect... I have to find the average number it would take between four years and am unsure how to calculate this

I need help with this question: A casino manager wants to introduce a Xmas 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.

I need help with this question: A casino manager wants to introduce a Xmas 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. Just give me an idea about how can I approach this particular problem.

A casino manager wants to introduce a Xmas 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

Trying to find average for excel but my range might have zeroes or blanks which shouldn't be counted. How can I do that?

Write formulas to count: 1. The number of average number of characters per word in each paragraph; 2.How many times the word "is" occurs.

Hello! There is a column with a certain number of rows in it. I need to calculate two averages: the average of every second row starting from the 1st one (aka the average of every odd-th cell) and the average of every second row starting from the 2nd one (aka the average of every even-th cell). I got tangled up with =OFFSET... Thanks!

I need help with this question: A casino manager wants to introduce a Xmas 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.

Sum and Average across multiple sheets. I'm quite adequate with excel but can't figures out how to do sumif and averageif across multiple sheets.

Someone from here named sudhans said to pay him in paypal then he will sent the solution to my mail but it has been 3 days and I haven't got it yet. FYI, I want to get the total number of cars sold, total amount sold and average discount for each manufacturer in summary sheet.