Excel & Statistics 43: Data Analysis Add-in Descriptive Statistics

(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

I recorded a macro to produce descriptive statistics for a column of numbers. I added the analysis.xla to my VBA references. I get the desired results at the end of the recording process, but I do not get the desired results when I run the macro. Nothing happens unless I add a select cell code at the end. That tells me that the macro was activated, but it does not produce any descriptive statistics. After repeated tries at recording my own code, I copied code from discussion boards. They did not work. I can produce essentially identical results by constructing a longer macro that calculates the statistics individually, but I would like to use the data analysis/descriptive statistics route. I would appreciate any guidance.

I am looking to run certain statistics in Excel and I was wondering if this was possible:
I want to calculate a certain number of people in a category on a spreadsheet by age and race and I wanted to know if it could be done in Excel. We do not have a specific program here to calculate statistics like SPSS.
I have a spreadsheet of patients with their information such as age, telephone number, Date of birth, race, location of cancer screen, date of cancer screen, and results of cancer screenings.
I have a lot of information and I was interested to know if I could select only certain columns (age, race, cancer result) to run the statistics. I need to make charts containing the number of people who screened for cancer and out of those people, how many were which race and how many were in each age group.
If this kind of data is possible to obtain in Excel, how do I go about doing that?
Thank you!!

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

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

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

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.