# 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

Can you tell me how to have cell AH47 working out the average for the cells which have already started based on their start date in column "W"
Solved by A. D. in 14 mins
I'm having a problem with cell AH237 on the "Design CTR". It is meant to show an average % for all tasks which have started in accordance to the start date; however if highlight the cells within row AH between cells 137:236 for only the cells greater than 0 it gives you a result of 93%. This value is what I would expect to see in AH237 but it's showing 100%. The formula seems to work in the sections above, i.e. cells AH113 or AH91 or AH69
Solved by F. J. in 26 mins
A conditional function is used to calculate the average satisfaction of service for store 251. Results are formatted with the number format and 2 decimal places. A conditional function is used to calculate the number of survey responses in which restaurant 251 received a 2 or less in wait time and service. Results are formatted with the number format and 2 decimal places.
Solved by D. J. in 22 mins
Use average in excel formula to find the average salary by Location.
Solved by D. D. in 17 mins
I would like to have a rolling average process for my workbook. What I do is I have sheets with numerous columns and each column is dated. The data is collected and computed in another column called 60 day average. What I like to have one is a process where data is entered in a new column, excel can recognize data 60 days past each time a new column is used and computer a 60 day rolling average.
Solved by M. L. in 22 mins
I would like to be able to have a 60 day rolling average tabulated. Right ow my sheet has numerous columns of data and it need compute 60 day average. I need to have the 60 day average computed automatically rather than to have to delete the 61 day's data and be able to compute the average every time I enter a new day's data
Solved by C. H. in 17 mins
A 555-mile, 5-hour plane trip was flown at two speeds. For the first part of the trip, the average speed was 105 mph. Then the tailwind picked up, and the remainder of the trip was flown at an average speed of 115 mph. For how long did the plane fly at each speed?
Solved by F. F. in 26 mins
Hello, I'm trying to graph an average value against non average values. I am struggling because I have only one x value for my average data point and multiple x values for the other data points.
Solved by O. U. in 23 mins
I am trying to find the weighted average excel with a group of date.
Solved by I. J. in 16 mins
Play with different values for the Average Annual Return and see how a small change in the rate can have a big effect on your return. Over 30 years, the average inflation-adjusted returns for the S&P 500 have been between 5–8%. Use a lower percentage to be more conservative in your calculations. This would move you toward over-saving rather than over-estimating and being caught short at retirement.
Solved by F. L. in 13 mins