Is it possible to Create excel chart ( normal distribution curve) based on the output of Descriptive statistics
For example : Would it be possible to create normal distribution curve in excel using following Descriptive statistics output
Mean 118247.4547
Standard Error 210.3114405
Median 117081.5
Mode 91374
Standard Deviation 19711.01832
Sample Variance 388524243.3
Kurtosis 0.097330952
Skewness 0.450270462
Range 112097
Minimum 76095
Maximum 188192
Sum 1038685642
Count 8784
Largest(1) 188192
Smallest(1) 76095
Confidence Level(95.0%) 412.2596498
thanks ,
Hi there, was wondering if you could help me with this one. Trying to keep it simple, I have a set of data of '+' signs and '-' signs and i would like to run some analysis on them. I m looking for results that may help me conclude particular questions. E.g. How many '+' signs are needed consecutively for a '-' sign to be recorded? what is the percentage probability that after (e.g) 4 '-' signs a '+' sign will be reported?
Can such analysis be run on excel, by using some kind of formula?
Thanks for your help.
Chris
Hi everybody!
Any idea how can I make a descriptive statistics to summarize the data?
want to make a macro to do a 'descriptive statistics data analysis' of column b and put the results in m1 to n18.
basically doing this but in a macro.
add in= tools /data analysis/ descriptive stats
I have recorded it doing this, but it for some reason can't do what it wrote.
Hello everyone,
I have a table with two coloumns, first is data and second is frequency, how to do descriptive statistics for this.
Please help me i am struck with this.
thanks
Using the averaging approach and descriptive statistics can anyone tell me how do i find outliers? i know how to do it using the 5-number summary but cant figure out how to do it this way
thanks.
I am using Excel 2007. I have a problem with specifying input range in Data Analysis/Descriptive Statistics if the file name of the Excel file contains hyphens.
This error occurs if (i) the name of the Excel file has hyphens in it and (ii) the data data in a separate sheet and the output of descriptive statistics is supposed to go into a specified range in an already existing worksheet. If I remove all the hyphens from the file name there is no problem.
The error I get when I run the Descriptive Statistics command, if the file name has hyphens, is "non-contiguous input range", if I start the Data Analysis command from the sheet where output needs to go. If I start the Data Analysis command from the sheet containing the data, the error I get is "output range must be valid range". In both cases, after the error, the filename with the cell range in R1C1 format appears in either in the input range box or output range box, as relevant.
None of this happens if I remove the hyphens from the file name. The easy solution is to remove the hyphens from all the files I have already created and working with, but I don't understand why hyphens are allowed when I name the files, but gives an error in this particular situation?
Any idea whether I can have the hyphens in the file names and still not get this error?
Thanks....
(This is a question relating to Excel 2007).
In 'Data Analysis > Descriptive Statistics' there is the option to output a confidence level for the mean (as a %). Does anyone know if the confidence interval is calculated using a t-distribution or does it assume a normal distribution (as with the CONFIDENCE function)?
Thanks in advance
Rob
Is it possible to graph a curve based on descriptive statistics in Excel?
For example:
mean: 8.147
standard deviation: 0.142
Assuming a normal curve, I am told that I can graph this, but I don't believe it's possible with Excel.
That is, I can do the following: generate a random number set with a normal distribution, then create a histogram.
What I'd like to do is create a continuous line curve of the kind you see in textbooks, to illustrate rejection regions and critical values, etc. I suspect I'll need to look into some other software package or browser-based statistical application but before I say good bye to Excel on this I thought I'd check here.
Cheers
ξ
(note - in anticipation of a statistics class next year where there will be a lot of hypothesis testing for the first section. I sort of blew it in the first half of the course by just drawing all my graphs by hand, much to my prof's "delight").
Hi,
I'm wondering if it's possible to keep the screen from updating when running descriptive statistics in VBA.
I have several calls to run descriptive statistics in a procedure, and when these get run, the screen always flips to the sheet it's running the statistics on and flickers with each statistical run.
Is there a way I can keep the screen static, without it flipping back and forth between sheets? I tried using Application.ScreenUpdating = False at the beginning of the procedure without the desired result.
Here's my descr stats call:
Application.Run "ATPVBAEN.XLA!Descr", Sheets(ForSheet).Range("$D$" & (KMVGAS_index + 1) & ":$D$" & RLNS_index), Sheets(ForSheet).Range("$" & ColumnLetter & "$" & RowNumber), "C", False, True
So is it at all possible to get the screen to stay static during these calls?
