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!”
Here are some problems that our users have asked and received explanations on
I'm trying to find the mean,range,mode and standard deviation of a sample. Basic statistics in Excel
Solved by B. W. in 25 mins
Hi I have a column which gives me daily temperatures since 1975 till 2017. I am trying to calculate the cumulative deviation of temperature and trigger a payout if the cumulative is greater than 150 degrees celcius or 250 degrees. The deviation is based on 'triggers' so if the daily max temp is 30 and the trigger is 31 then the cumulative deviation is -1 and so on. I have a set of 6 triggers - 31, 33 35.5 38 39.5 and 39. How can I calculate this on excel?
Solved by O. C. in 13 mins
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
Hi! I'm making a diagram for my thesis. I would like to have a different standard deviation per bar, but I don't know how to do that. I figured out how to change standard deviation for all bars, but not how to change each bar separately.
Solved by F. H. in 20 mins
I have a sheet of raw customer data. And I want to calculate standard deviation of Pip of winning trade for each customer.
Solved by B. Y. in 22 mins
how to use average function in excel? I would like to create a formula that creates an average and standard deviation based on two criteria (the name of the client and the role group).So I need to figure out how to analyze averageifs, countifs based on two criteria.
Solved by E. Q. in 22 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
I need help to create an excel sheet where standard deviation is shown for my data.
Solved by Z. F. in 27 mins
I need to create a template whereby I can calculate the standard deviation for multiple questions in a data set that contains two categories that need to be controlled for ( District name and Experience Level).
Solved by G. D. in 30 mins
I need a formula for standard deviation for everything in red color on the overall rating chart.
Solved by F. J. in 17 mins