Get instant live Excel expert help with AVERAGE Function

“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

Solved by G. Y. in 12 mins
I need to analyse 3 CSV worksheets with data from an outbound call centre to encourage people to sign up. for a loan: leads.csv is a list of contact details that were fed into the call centre's systems for agents to call calls.csv is a list of calls made by the call centre to leads. There may be no calls or multiple calls to some leads. Each call is given an outcome i.e 'interested' (leads with an interested call does not necessarily mean they signed up and one lead may have multiple 'interested' calls). signups.csv is a list of leads who actually signed up (this may or may not have been after an 'interested' call). Each signup was risk assessed and either approved or rejected for a loan. I need to figure out: Signups from which region are most likely to be approved? What proportion get approved?
Solved by C. D. in 27 mins
what does =IF(ISBLANK(B278),"",H278-I278+J278) formula mean?
Solved by X. J. in 25 mins
In excel, I want to create a list based on a single column from another sheet, without the rows that are empty for that column. The attachment shows what I mean. Sheet 1 is my original data entry, sheet 2 is my derived list.
Solved by A. J. in 11 mins
The amount of mayonnaise dispensed from a machine at The Fast Food Factory is normally distributed with a mean of 0.85 g and a standard deviation of 0.1 g. If the machine is used 800 times, approximately how many times will it be expected to dispense 1 or more grams of mayonnaise.
Solved by E. E. in 18 mins
My session ended and the techician did not complete what he was suppose to do said system was slow everytime I asked him if he was still there I never got a reply, now im finding that I cannot alter amounts in individual entry sheet?? If I do they will not appear in Pivot Table? Also WHY does a pop up keep appearing saying “Cannot open Pivot table” I need for this pop up to be removed as when Im done with this spreadsheet I need to email it to my Client. Please open up my spreadsheet so you can see what I mean? Also in individual entry sheet, I need Grand totals to show up automatically at the bottom of each amount coloum also reinstate coloum M has it hidden and coloum N has data that I cannot remove. Every move I make the pop up comes up on screen I cannot have this Pls help Thanks!
Solved by Z. A. in 21 mins
I want to create timeline for products, i have made 50% data (I mean I have completed template) I want you to fill it using formulas. I think vlookup can do this, still I am not sure Thank you
Solved by V. B. in 19 mins
I need to sortout my data in excel. I mean I have a data as a paragraph and I need it in table in perfect row.
Solved by F. L. in 27 mins
Hypothesis testing that returns of a company are greater than returns to the market using Data Analysis: t-test: 2 small assuming unequal variances what mean difference should I define?
Solved by B. S. in 16 mins
Use the RANDBETWEEN function in Microsoft Excel to select three simple random samples of 10, 50 and 500 days from the population. Using just your samples, calculate the mean, median, standard deviations and mode if applicable for each random sample. [10%]. Compare these outcome figures. How do the mean and SD change with sample size? [10%].
Solved by G. Q. in 15 mins