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!!
I want to install the data analysis add ins to excel 2003 (statistical
package) but it seems to have varied from the 2000 edition. Does anyone have
any info on this.
Thanking you in advance.
Could anyone show, in detail, the use of a data table?
I have some ideas on what it could be possibly used for--but am unable to figure out how to use it effectively.
Is there a website that details the use of the data table along with examples and how to effectively use this functionality?
I think it might be quite useful.
Please help.
-rbhu
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?
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
(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 trying to install XOCharts Point and Figure charting programme. I am running Windows 7 64bit OS and Excel 2007.
The add in is not showing in Excel Options / Add ins. The programme is installed in the directory C:/ and not C:/Program Filed(86).
I noticed their web site illustrates earlier versions of Excel.
Has anyone else had this challenge?
Regards,
Rob.
Operating system = Windows ME
512mg. of ram
Everytime I try to install a window pops up with an error. I know I need this........ACCORDING TO MICROSOFT webpage Microsoft Windows XP with Service Pack (SP) 2, Windows Server 2003 with SP1, or later operating system1
But is there anyway around this with me keeping my current Operating System of Windows ME?
