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!!
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
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.
Hi,
I currently have a pivot table that returns min(date) and max(date) for each by-group 'Name.' So it looks something like this:
Name Min of Date Max of Date
John 1/1/2000 9/1/2000
Mary 4/1/1999 3/1/2000
Chris 2/1/2000 6/1/2006
Now I would like to create a new field that returns the difference between these two dates for each name. However Min of Date and Max of Date do not show up under Field List when I go into Calculated Field. How could I do it and still stay within the pivot table (i.e. not create a formula outside it)?
Thank you in advance for your help.
Hi all,
Does it can sorting in ascending order by the "%" field?
Very appreicate for you all can fix my trouble.
Jack, fr HK
資料
CODE
地方
數量
金額
%
BD
孟加拉
1,090,486.03
21,614,238.96
5.13%
CA
加拿大
20,184.95
529,507.40
0.13%
CN
中國
941,058.85
20,157,058.90
4.79%
HK
香港
5,072,129.66
107,074,968.25
25.43%
ID
印尼
239,416.03
4,897,143.80
1.16%
IN
印度
106,774.42
2,193,435.79
0.52%
KR
韓國
4,907,954.46
105,778,446.17
25.12%
LK
斯里蘭卡
329,936.36
6,548,288.33
1.56%
MO
澳門
317,400.37
8,150,085.00
1.94%
MY
馬來西亞
38,937.27
874,563.15
0.21%
PH
菲律賓
260.00
4,710.69
0.00%
RU
俄羅斯
196,358.66
4,632,092.54
1.10%
SG
新加坡
2,102,473.55
45,356,764.79
10.77%
TH
泰國
30.86
801.48
0.00%
TW
台灣
2,702,467.50
61,062,836.33
14.50%
US
美國
132,031.09
2,946,328.27
0.70%
VN
越南
1,476,633.99
29,269,760.74
6.95%
ZA
非洲
882.91
20,515.62
0.00%
總計
19,675,416.96
421,111,546.21
100.00%
I have a spreadsheet that lists all of our sales for the past four years. The data points are
Sales rep
customer
Amount
Fiscal year
Product sold
I have a great view by customer of the total sold for the entire 4 year period. The fiscal years are listed in the column headings.
What I need to provide to our sales staff is a list of customers who had an amount in FY 2006 but did not have anything in FY 2007, 2008 or 2009.
Then I would want to do the same for 2007 and 2008.
I cannot figure out how to get this sort without a ton of work.
Thanks for any help you can give me.
I have Excel2000 and would like to be able to sort the data elements in the
Row section of the pivot table in the order I choose. For example, if I have
3 elements such as Apple, Orange, Cranberry and want them to show in the
pivot in this order I have to name them in the dataset as A. Apple, B.
Orange, C. Cranberry and sort them ascending. Is there a way to do this
without having to stick the A, B, C in front of the data item?
Thx
I've got a pivot table with three columns (general, general, currency) on a row next to two fields of normal data (currency, general). When I sort the table, three of the columns sort correctly with the first normal field but the final text field does not sort with them. How can I sort all five fields at once?
