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).