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

1. create a bar chart that clearly shows the average revenue per economy car versus the quarter for 2015.
Solved by D. F. in 29 mins
create a bar chart that clearly shows the average revenue per economy car versus the quarter for 2015.
Solved by O. H. in 17 mins
how to take average in excel for an array of values?
Solved by A. A. in 21 mins
NEED TO STOP VALUE COMING UP IN TIME DIFFERENCE NEED TO BE A DAILY LOADING SHEET HOW TO STORE DATE BUT CHANGE DATE TOO NEED PIVOT TO CATCH AND STORE DATA ON ANY LOAD GOING OUT AS AN AVERAGE OVERTIME. THANKS
Solved by F. Y. in 23 mins
how to average a column in excel? I need to find the average of column K sorted by column E and H
Solved by F. C. in 18 mins
I need some help on a weighted average application in Excel. This is a follow-up to what was done earlier today. I need to get the correct formula for R4.
Solved by F. F. in 19 mins
I need help on a conditional weighted average. I was helped earlier today, but the solution is not quite what I need. The formula in R4 is not adjusting for when cell P4 and Q4 are blank.
Solved by A. D. in 13 mins
I have an excel workbook with 13 sheets in it. These sheets are populated with data on companies (see worksheet example posted). I want to create a master sheet at the end that extracts data from the rest of the workbook based on it meeting certain criteria. In each of the 13 sheets, there are anywhere between 1-30 rows of companies, with 21 pieces of data about them in the columns. 9 of these columns have rankings in them on a scale of 1-4, which are then averaged in the last column. If this average is above 2, I want the 9 ranking columns, as well as the column identifying the company to be extracted into the master sheet at the end. I am posting an example of what I mean on the sheet.
Solved by M. E. in 23 mins
You can see there is time stamps from 11:00 to 18:00. The excel hasy 4 key values, which is in colum D(Elsi Name). Now our tool generates this report hourly and sometimes some venue has 6 Elsi names, some have 10 elsi names. You can see that these 4 Elsi names are highlighted on each timestap from, group of 4 for 1100, group of 4 for 1200 etc. I want to see the average of all the values of these 4 Elsi names aggregated against every timestap and make pivot charts from that aggregated data of each 4 Else names. I want it to be i n a way so when in future when i create these charts populate automatically wether the timestamps are from 900 to 1500 or 1100 to 1800 and regardless of how many Elsi names there are.
Solved by B. J. in 21 mins
A formula to calculate the level of sales per day to reach 3 different levels of targets for each month . Dynamically changes the daily average sales required each day based on sales to date of each month.
Solved by T. A. in 22 mins