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

i want to plot 130 points (get numbers) with a mean of 1500, with a deviation of plus minus 200 in Excel. Kindly help
Solved by F. F. in 26 mins
There is a 62​% chance that X is above what​ value? if n =25 mean = 100 STD =25
Solved by T. J. in 18 mins
Hi, I want to make two sheets which will SYNC simultaneously with each other. I mean if someone will edit in sheet 1 it must sync that column with sheet 2 and if someone will edit in sheet 2 it must sync with sheet 1. It will be same column and rows. NOTE# I know about Importrange and it works only in one sheet to another so please give me another solution, THank you
Solved by G. L. in 22 mins
I need to create a check box that'll make data in a given row applicable to tax or not. I have a table and can show you what I mean.
Solved by O. B. in 25 mins
I have a project for school in which I am supposed to take some government statistics on homicide and calculate the following. For death rate - mean, median, mode and standard deviation for crude death rates. Create histogram (line chart) for Metro death rates all years Interpret the data for metro versus non-metro and justify your inferences with results. I have no idea how to use excel.
Solved by E. C. in 12 mins
Im trying to copy an excel sheet onto word but it says I need to do it as a Picture (U) Whats this mean?
Solved by F. J. in 15 mins
I need to add mean x,y preference lines on a scatter chart to form a quadrant analysis
Solved by G. A. in 25 mins
I need descriptive statistics, mean, median, mode, and standard deviation of Column L in this excel workbook. Specifically, I need that data on both Males and Females which are noted as F and M in Column A.
Solved by G. E. in 23 mins
Yes mean a number in different cells and No means (0) Need a formula to add the percent. Example: G4 has a yes that means 3% G5 has a No that means 0% G6 has a Yes That means 10% I want to get a total in G8. Is there a formula I can us for this. The same cells can have either a yes or no.
Solved by X. A. in 14 mins
I am using the NORM.DIST function in excel for a normal probability problem is there any way I can make it to where the Z value is rounded to 2 decimal places instead of 3? The question is find P(X<3.5) with the mean of 4 and Standard deviation of 0.8. I am inputting it as =NORM.DIST(3.5,4,0.8,1) and it equals 0.2659 but that is not the right answer. The correct answer is 0.2643. I have rooted the problem that it is because in the Norm.Dist formula, the Z value is that is used is 3 decimal places (-0.625) but it needs to be 2 decimal places (-0.63).
Solved by S. H. in 15 mins