Excel Statistics and Data Analysis

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

"Statistics" is a very broad term for a wide range of data analyses.

Excel has several statistical functions. First you need to determine what type of statistics you want to derive from the data.

Here are a few "descriptive" statistics functions:

Mean (average)
Median
Mode
Min
Max
Standard Deviation
Percentile
Var (variance)

To see the full range of statistical functions press the Shift + F3 keys to activate the Insert Function dialog, then choose Statistical under the Category drop down.

SPSS is fairly costly, but for a decent SPC package at low cost and which proved pretty good range of additional analysis tools, see: QI Macros for Excel

Hello KWelchel,

One way to accomplish what you are looking for is with a pivot table. This is the easiest way to stratify your data. To do this, highlight your entire spreadsheet, then go Insert>Tables>PivotTable. You can then select either to put the table in the same sheet or a new sheet. From there you can select the data you want in the table and generate your charts. Try this, and if you have trouble let me know.

I hope this helps.

highlight your entire spreadsheet

Better: create a dynamic named range for the data, or select the current region using Ctrl+A

You can then select either to put the table in the same sheet or a new sheet

Pivot Tables should always be in their own sheet and never on the same sheet as the raw data. You will avoid headaches by keeping it separate.

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.

OK - I honed in on "statistics". What you seem to want is a percentage by category, for which a Pivot Table / Pivot Chart should work quite well. If this is all you're wanting then Excel has all of the functionality you need.

Post a sample workbook if you need help with the pivot tables.

Excel Chi-squared test - error p-value
I’ve built a model on excel to calculate chi-squared on each of my 8 questions within questionnaire. i'm using chi-squared to understand relationship between scores provided and organisation.

I'm getting an calc. error (#DIV/0) for the p-value because no one from either category scored a zero "0" or a five "5".
Excel is throwing an error in the total expected value which is throwing the =CHISQ.TEST (p-value) calc. into error.

For the =CHISQ.TEST calc. do i therefore need to discount zero and five as categories and reduce my degrees of freedom by 2?
Is that an acceptable method?