Excel Statistics 17: Categorical Cross Tabulation with Formulas

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.

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 am drawing a series of chart with x-axis as time and y-axis as deformation (say of a slab). Chart type is x-y line. I got a chart with x axis as equal division of time. Now I want a secondary x axis which gives the categorical value, the days position (provided in the input) on which the deformation measeured.
In short, I want a secondary x axis which shows the categorical value on the primary value axis??

Any one have the answer, plz post.

Raj

I want to apologize in advance - I know it sucks to have to field newb questions, but trust me it sucks even worse to have to ask them.

I have created my first workbook - I want to refer some heading cells on each of the different sheets to a single form so that I can change the information [job number, Location, ect] on a single place and have it replicate on all sheets in the workbook.

My guess is that this is simple, but I have scratched at it for a couple hours and nobody here seems to have ever done that. Any help would be greatly appreciated.

Hi all
I am new to the forums here and desperately need some help. I am somewhat of a novice with excel but seem to be able to get by for most things. I have been asked to come up with a spreadsheet at work to calculate schedule compliance I just cant get a few things to cross link. I basically need it to take what ever person I copy from 'actual log in log out'(purely just data to use for testing), paste it to 'log in log out', hit calculate. it auto generates time out at that point so i'm good there. I just also need it to cross reference that person with the schedules tab in case they are out of compliance on sign in, break,lunch etc. and for totals to be on compliance sheet. Any help would be awesome as I have been pullin my hair out for three days

I want to create cross checks for the formulas in the cells whether if all formulas are all the same in a given column even though the outcome by the formulas vary. However excel treats the cells as figures and doesnt check the formulas in the cells. I would be grateful if someone would help me on that.

My source data looks like this:
On the <i>Changes</i> sheet I have information in Columns C through H.
C and D contain the two objects to cross reference in the chart (think
of a mileage chart, such as this one
http://www.hm-usa.com/distance/usa.html ).
Column E Contains the current value, F the minimum value, G the Max
value, and H the mean value.

Data starts in row 2.

I want to reference the data in a chart on a new sheet

A B C D
1 Min(1) Current(1) Min(3) Current(3)
2 Max(1) Average(1) Max(3) Average(3)
3 Min(2) Current(2) Min(4) Current(4)
4 Max(2) Average(2) Max(4) Average(4)

Whe
Min1 refers to Cell $F2
Min2 refers to Cell $F3

Max1 refers to $G2
Max2 refers to $G3

etc...

The chart will be rather large (I've got several hundred data points).
However, I can't drag the formula, because if I type int he formulas
for A1:B2 (The full data set for my frist cross reference) and drag it
down to A3:B4 it will have Min2 refer to cell F4, rather than F3.
Likewise, if I drag it across to C1:D2, it will have Min3 refer to F2,
rather than F4.

Any way to easily copy a formula like this, or am i stuck handcoding?

I have created a price sheet with optional equipment listed in consecutive rows. One of the common columns in those rows is where you can input the quantity. Currently I have it set to tabulate the total price at the bottom based on the quantity. The formula I used is pretty extensive and I was wondering if there was an easier and much shorter formula that will do the same job.

I have attached the sheet. Columns E, F, G, & H are the ones that I need to automatically tabulate at the bottom according to the quantity input in column D.

Thanks in advance for the help!

Hi,

I have a worksheet with 8 columns. column 5-6-7-8 are optional so the user can enter data only in column 1-2-3-4 and I allow this. But the user need to copy/past his worksheet into another application that absolutly need 8 column (So empty column should be represented by a tabulation with nothing in it). I would like to FORCE that tabulation during copy/past because I found that sometime it juste stop after le last column of the line withouth completing with tabulations.

Thanks

jonat

I am wondering if there is a way to concatenate a symbol or function into an Excel cell which other programs will interpret as hitting the Tab key. This will allow me to plan ahead for tab-delimited things. For example, I'd like to be able to create full email envelope, with email address, CC:, subject, and body all concatenated into the same cell, so I could create a full email just by hitting Ctrl-V.

Is there such a thing? The Tab key in Excel takes me to the next cell to the left, but when I paste a pair of cells (say, A1 and B1) into the To field of an Outlook email, B1 isn't in the CC field where I want it to be.