Excel Statistics 31: Histogram using Data Analysis Add-in

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

Please help...

I am trying to produce a histogram using "data analysis" tool. I want to specify my Bin Ranges, I highlight all of my data (all cells) and put that into the Input Range area, then my instructor told us to highlight the ending value of each bin cutoff, example I want 5 bins, my first bin should end at data up to and containg 10.66 and then my next bin range should be up to 10.69....etc...I am adding the 5 bin cells into Bin Range area and separating with ",". I select chart output and I keep getting odd ball #'s and a "more" bin at the end....

Do you know what I am doing wrong???

Thanks in advance

Hi,

I have a set of figures for production for the past 18months and I would like to do some sort of forecast and get an idea on what the future holds.

I have tried FORECAST and TREND and also used the TRENDLINE in the charts but the problem is I don't know what one I should be using and which is the best.

Can anyone give any advice or point me to a site that has a "daft but not an idiots guide to data analysis with excel ", long shot but worth a try.

Many Thanks

Mark

Hi,
I'm working on a statistics schoolproject where I have to use spss and excel.
I have a worksheet with 2 variables: gender and internet use.
(lots of rows with cases downwards).
Gender is a dummy-variable (0,1) and internet use is scale variable, counting hours spent each week.

so to the question:
Which data analysis test can I run to find out that a difference between genders concerning internet use is not because of chance alone (assume equal variances)?

I tried to make a statistics test called
t-Test: Two-Sample Assuming Equal Variances

The output I made is included as a file to this post.


I think the procedure is right, but how do I extract the information from this table to help me answer the question?
Is gender difference in relation to internet use because of chance?

(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

Hi, I am attempting to create a histogram using Analysis Toolpak in Excel 07. Every time I choose the option "chart output", it causes Excel to crash. Does anyone know why it's doing this?

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 have a collection of data points that look something like this:

0.123 5
0.235 7
0.245 3
0.456 6
1.109 4

Column 1 = label (load time)
Column 2 = frequency

I have up to 50,000 Rows of Data!

I'm able to do a generic Histogram chart, but what I am looking for is to obtain the standard statistical data set off of this data: mean, median, mode, standard deviation...etc.

The issue I'm having is that all the formulas want raw data (no frequency calculations). Is there an easy way to get the statistical analysis either by using the frequency numbers or by using some kind of VBA code or other function to convert the frequency back into the original data elements?

The report I receive is auto aggregated into frequency counts and I have no way of receiving the original raw data points.

Thanks for the help in advance!

I am creating a custom function that needs to refer to the Weeknum function
that is part of the analysis toolpak addin. How do I make a reference to it?

Thanks

Hi

wondering if anyone can help me?

I would like upon opening excel sheet, to automatically enable the analysis TOOLPAK VBA addin.

IS this possible?

Thanks

Andrew