[access-uk] Re: Excel Formulae
- From: "Michael Moore" <mikeis@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Fri, 31 May 2013 20:29:06 +0100
Hi,
You could simply put:
=average(a1:a12) to determine the average, or mean in the given cells.
Regards,
Mike
_____
From: access-uk-bounce@xxxxxxxxxxxxx [mailto:access-uk-bounce@xxxxxxxxxxxxx]
On Behalf Of Griffiths, Steve
Sent: 31 May 2013 11:25
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Excel Formulae
Steve,
All but mean are straightforward, because they have functions in Excel. So
assuming you have 12 numbers in cells A1 to A12, in the cell you want the
answer you would put:
=MEDIAN(A1:A12)
=MODE(A1:A12)
=STDEV(A1:A12)
To get the mean, you could put:
=SUM(A1:A12)/COUNT(A1:A12)
In other words, add up the cell contents and divide by the number of
non-blank cells
If you wanted, you could put the formulae in a sheet and use A100 instead of
A12. Then when you get a set of numbers, you just populate column A
somewhere between A1 and A100. Blank cells are counted in the formulae, so
you could have 20 numbers or 70, the formulae would still work.
Steve
From: access-uk-bounce@xxxxxxxxxxxxx [mailto:access-uk-bounce@xxxxxxxxxxxxx]
On Behalf Of Steve Hyde-Dryden
Sent: 31 May 2013 09:45
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Excel Formulae
Hi Guys,
Can Anyone tell me how to do mean, median, mode and standard deviation
formulae with jaws in excel?
Is there a good tutorial for excel 2010 available?
Thanks in advance
Steve
Click here <https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ==> to
report this email as spam.
--
For the first time, all our artefacts are open to the public for free in one
place. Find out more about RNIB Heritage Services' hidden gems:
http://rnib.in/17uWEWG
--
DISCLAIMER:
NOTICE: The information contained in this email and any attachments is
confidential and may be privileged. If you are not the intended recipient
you should not use, disclose, distribute or copy any of the content of it or
of any attachment; you are requested to notify the sender immediately of
your receipt of the email and then to delete it and any attachments from
your system.
RNIB endeavours to ensure that emails and any attachments generated by its
staff are free from viruses or other contaminants. However, it cannot
accept any responsibility for any such which are transmitted. We therefore
recommend you scan all attachments.
Please note that the statements and views expressed in this email and any
attachments are those of the author and do not necessarily represent those
of RNIB.
RNIB Registered Charity Number: 226227
Website: http://www.rnib.org.uk
This message has been scanned for viruses by Websense Hosted Security -
<http://www.websense.com/content/HostedEmailSecurity.aspx>
http://www.websense.com/content/HostedEmailSecurity.aspx
Other related posts:
