Re: Help me!!

From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 03/02/04 

Date: Tue, 02 Mar 2004 17:31:17 GMT

As a first pass...

If the data are in a table (column 1 has batch #, col. 2 has the area,
col. 3 has the value field), create a PivotTable with the batch # as
the row field and the average of the value as the data field. Now, if
the batch number field also reflects a chronological sequence, check if
the computed average is trending down. 

-- 
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <575f01c40072$035c0310$a501280a@phx.gbl>, 
anonymous@discussions.microsoft.com says...
> Hi
> 
> I am using Excel 2000 and wish to know how I can graph 
> some data.
> 
> The data is car data, these arrive in batches - assigned 
> by a batch number.  The batches differ in size, one batch 
> could have 20 records, yet another could have 3.  The 
> values of the cars differ too.
> 
> The whole emphasis here is to find out how much (money-
> wise) cars have been issued in the batches, and find out 
> whether they are getting less and less.
> 
> I want to create normalised graphs and %'ages of total 
> amounts within the batch - as I feel that the cars we are 
> receiving are worthless compared to before.  What I mean 
> by this is that Batch 1-3 were high valued cars, such as 
> Mercedes, and now we are getting run-of-the-mill cheapies -
>  such as Fords that are 1/3 of the price of a Mercedes - 
> hence why this is affecting our profits - we make higher 
> profits on the bigger cars.
> 
> My Excel *** has these fields:
> 
> 1. Batch Number : e.g. 001
> 2. Area where vehicle came from : AB3
> 3. Value of the vehicle : £20,000
> 
> I have not got a batch count field - as I said earlier, 
> batches are of different sizes, they could be 20, 2, 43 
> etc...
> 
> What graphs can I make or additional mathematical formulae 
> to make my results look professional, as I know for a fact 
> that our supplier is now passing onto us rubbish cars.
> 
> I need some stats fields and normalised graphs etc... but 
> I do not know where to start - I need help!!
> 
> Please help.
> 
> skc
>