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 apply a weight measurement in Excel of Stones and Ounces, cannot
work out how! thanks
I am using MS office 2002.Whenever I paste an object on Excel,I try to format
the size of the object,I notice that thers is only INCHE available.Wherelse
in Words I can choose between CM & INCHE.Someone please help to assist on how
to change between INCHE & CM in Excel.
Thank you
Regards,
Steven
Hi everyone ..I am new here...
I have some date in Excel sheet like below:
-------------------------------------------
Group
NO.
Result
A
1
PASS
A
2
PASS
A
3
Failed
A
4
PASS
A
5
PASS
B
6
Failed
B
7
PASS
B
8
PASS
B
9
PASS
B
10
PASS
A
1
PASS
A
2
PASS
A
3
Failed
A
4
PASS
A
5
PASS
B
6
PASS
B
7
PASS
B
8
PASS
B
9
Failed
B
10
PASS
A
1
PASS
A
2
PASS
A
3
Failed
A
4
Failed
A
5
PASS
B
6
Failed
B
7
PASS
B
8
PASS
B
9
PASS
B
10
PASS
A
1
PASS
A
2
Failed
A
3
PASS
A
4
PASS
A
5
PASS
B
6
PASS
B
7
PASS
B
8
PASS
B
9
PASS
B
10
PASS
------------------------------------------
How can I use VBA make those date become the table like below
in a userform (better) or in a sheet?
1. NO. - Every NO. that exits in the Data
2. Count - Count of each NO.
3. Failed _ Count of each NO. that is "Failed"
4. Failed Rate - (Failed / Count) %
5. Sort by "Failed Rate" Descending
6. The data in the table will change once there the data is changed
Group
NO.
Count
Failed
Failed Rate
A
3
4
3
75%
B
6
4
2
50%
A
2
4
1
25%
A
4
4
1
25%
B
9
4
1
25%
A
1
4
0
0%
A
5
4
0
0%
B
7
4
0
0%
B
8
4
0
0%
B
10
4
0
0%
Thanks for help
Andy
Hello,
I have data like this
P CA
P CB
F CC
F CC
F CA
B CC
B CA
B CB
What i want is a statistics like this
--- P F B
CA 1 1 1
CB 1 0 1
CC 0 2 1
How can realize this?
Is there tool or which function is OK for this?
Thanks!
Not Solved, but found a different way of doing it which I now need advice on, lol.
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
Morning All,
Does anyone know of a free tutorial that can explain how to get statistical data in Excel? - I have seen it done before (in excel) for 'Linear regression', I am wondering if the same can be done for "Polynomal"?
Rgs
Neville
Hi everyone, first thanks for the help.
I am trying to create a histogram and let me explain some of the data.
I have a list of data separated like so:
3.5
3.6
3.8
3.8
3.9
3.9
etc...
Now I need to calculate the frequencies of these like so:
3.5 (up to but not including) 4.0
4.0 (up to but not including) 4.5
I can count out the frequencies myself but i need to create a histogram (bar graph) with the y axis as the frequency and the x axis as the IMR(infant mortality rate: ie the 3.5 (up to but not including) 4.0).
I am having problems with calculating the frequencies because when setting the bin values because they include 4.0.
If this is confusing I can provide some more information, but cannot find a good tutorial that would create a histogram anywhere remotely close to the histogram i drew by hand.
