philthepowerhouse
IS-IT--Management
Hi there!
Sorry if this is the wrong forum, I have tried to get the right one;
Simple question really, is it possible to perform calculations in Access such as having a list of companies and a list of figures from which I want to be able to find out the Lower, Median and Upper Quartiles of the data.
For this I will need to do a count of the number of companies and then on that figure I need to firstly multiply it by 0.25, 0.5 and then 0.75 to find the quartiles.
Is this possible?
Or is there another way?
Many Thanks for any advice
Powerhouse
Sorry if this is the wrong forum, I have tried to get the right one;
Simple question really, is it possible to perform calculations in Access such as having a list of companies and a list of figures from which I want to be able to find out the Lower, Median and Upper Quartiles of the data.
For this I will need to do a count of the number of companies and then on that figure I need to firstly multiply it by 0.25, 0.5 and then 0.75 to find the quartiles.
Is this possible?
Or is there another way?
Many Thanks for any advice
Powerhouse