My professor gave us this assignment but I am lost... can anyone help point me in the right direction - I have the data in a drop down menu?
Build a Table that Shows the Satisfaction Scores by Age Distribution
Include row and column totals in your table
Age Distribution Boxes 25-49 50-74 75-99
Satis. Score Boxes 50-65 66-80 81-95
note: The "by" variable, in this case Age, is listed across the top; the "show" variable is listed down the left side.
1 Delete the "note" and the instructions above
2 Fill in the mean, median, etc. below left.
3 Make the table
I want to classify Cell values H2:H46 as "Satisfied" if the value are 3 and more, and "Not satisfied" if the value is 2 or less, under two categories, M, F. What is the formula of "SUMPRODUCT for it.
I want to classify Cell values J2:J46 in two categories, "Satisfied" and "Not satisfied" under three salary categories: Less 10000, Between 10001-30000, and 30001 and above.
Please help me with formulas.
Is it possible to do a cross tab pivot table in Excel 2007?
I was able to easily create one in 98 or 2003 I believe. If it is possible in 2007 how do I create one? If not, is there a way to include text as the result in the Values field of the pivot table?
Thanks in advance
All,
I have a data sheet of which I make a pivot table. The pivot groups the data for different customers for different months. The months are in the column fields of the pivot table and the customers in the row fields of the pivot table. For each customer I have four different rows with data.
Now I want to draw graphs from this data showing per customers the four different rows of data per month. For this graph I made a small data file in which I copy the data manually. There should be an easier way but I don't know how. You have any ideas? There should be a formula I guess. An reference only wouldn't work because the pivot table will change over time.
Hope I am being clear enough.
Thanks!!
ps I am using Excel 2003
It's amazing how one can take pivot table data -- double-click
in the data section and it "converts" the PT format to a data-table format
(fit for a database environment, say access)...
Well any way, I receive files that are in a sort of a crosstab format,
which I'd love to be able to get to respond to (the creation) of a Pivot
table.
Is there a way to make this "conversion"?
Thanks in advance for any direction offered..
Hello,
This is my first post on this forum, I hope I will not be too confusing. Don't hesitate to ask me if things are not clear.
I have attached an example so it will be easier to follow what I am trying to explain.
I work in genetics and I do analysis reports of different fragments for a gene. Each fragments can have 0, 1, or several variations.
I would like to have a macro to automatically generate a statistics table (on the "statistics" tab) with the 5 following fields:
Fragment names / # samples / # of failed samples / % of success / # of variations in the fragment (SNP)
At the bottom of this table, I would like to have a cell with the average % of success for all fragments.
The data to generate these statistics are on the "gene name" tab (please note that this name will change every time I will work on a new gene). To make things easier, I think the macro should be run from this tab.
1. The Fragment names are displayed in row #5. I use one column per variation per fragment. If one fragment has 3 variations, there will be three columns and I will merge together the fragment name cells. The fact that some cells are merged can be a problem when copy-paste to the stats table (as I would like to get rid of the merging).
2. # of samples corresponds to the number of cells in blue in column A. The number of samples can change from one report to another but is always constant in the same report.
3. # of failed sequences. In the table, I type "Failed Sequence" (if the analysis has failed) and "Missing Sequence" (if the analysis has not been done). When a sample is failed or missing, it is for the who fragment, no matter how many variation there is in the fragment, so I usually merge the cells of all variations for this failed sample.
4. % of success: this is quite easy #sample/#of failed+missing sequence for this fragment
5. # of variation is equal to the number of variations for this fragment (can be 0, 1, 2, etc.). When there is no variation in a fragment, I put '-- in all cells of the corresponding fragment on the "gene name" tab. Fragment 3 on my file is an example of 0 variation.
The points I have to consider for this macro is that the number of fragments and number of samples change from one analysis to another, so it would be nice if the macro would be able to count that automatically. It would also be nice if the generated statistics table could have the same formatting as I use on the "statistics" table.
My excel document already includes some automated calculations and statistics that I programmed myself, but I really have no idea on how to do what I explained above. I know it is probably a lot of VBA encoding, so I thank you in advance for your help.
Sincerely
David
p.s. This is not an emergency, as I am of course able to do the statistics manually, but it would definitely be nice and time-saving. Once again, thanks a lot.
Hi,
I have created a graph from pivot table (see example attached), I would like to get a legend beside it with statistics data such as mean std dev etc.
Can it be done in excel ?
Thanks
Hi,
I have a pivot table A created in Excel 2003 with the data source linked to another pivot table B. How do I change the data source of pivot table A link to a new pivot table C in Excel 2007? Can Excel 2007 create/change pivot table with data source link to another pivot table? I can't seem to find any function for that under Excel 2007 Pivot table commands. How do I resolve this? Please help.
Thanks!!
Hi,
I have a pivot table A created in Excel 2003 with the data source linked to another pivot table B. How do I change the data source of pivot table A link to a new pivot table C in Excel 2007? Can Excel 2007 create/change pivot table with data source link to another pivot table? I can't seem to find any function for that under Excel 2007 Pivot table commands. How do I resolve this? Please help.
Thanks!!
