software

Hello all, I am having a bit of difficulty with making a spreadsheet that
entails the use of calculating various statistical formulas. I have searched
the net on this topic and have only managed to find exactly what I have found
help on in the help section of Excel. OUt of the formulas I needed, the
following list as of now is what I do not know how to enter into excel. I do
know the formulas as how you would write them out on paper and that is
included with the statistical terms. If anyone knows of a website that can
explain in detail how to enter these as well as other formulas into excel, It
would be much appreciated. I will be needing to add more formulas on a weekly
basis starting next week when I deal with the introduction to probability in
statistics. Here are the formulas I need to know how to enter into excel:

gt;gt;quot;Midpointquot; which is (Lower class limit) (Upper class limit)/2

gt; gt; quot;Relative Frequencyquot; Which is Class Frequency/Sample Size (Also how to get the class frequency and sample size in excel would also be appreciated.)

gt; gt; quot;Weighted Meanquot; which is The sum of (x*w)/n

gt; gt; quot;Mean for Grouped Dataquot; which is the sum of (x*f)/n

gt;gt; quot;Sample Standard Deviation for Grouped Dataquot; which is the Square root of the
sum of (x-xbar)^2*f/n-1

gt; gt; quot;Chebychev's Theoremquot; which is The portion of any data set lying within K
standard Deviation (kgt;1) of the mean is at least :
(whole number 1) - 1/k^2 .

Thanks in advance to anyone that can help.


Hi Fonz,

Have you had a chance to take a look at the excel add-in called
Analysis ToolPack ...?
It seems to me it is packed with a great deal of functions ...

HTH
Cheers
Carim--
Carim
------------------------------------------------------------------------
Carim's Profile: www.excelforum.com/member.php...oamp;userid=33259
View this thread: www.excelforum.com/showthread...hreadid=531166This doesn't help because I will be using the sheet I create at multiple
locations and I can't install anything onto any other computer that isn't
mine. Any other suggestions?

quot;Carimquot; wrote:

gt;
gt; Hi Fonz,
gt;
gt; Have you had a chance to take a look at the excel add-in called
gt; Analysis ToolPack ...?
gt; It seems to me it is packed with a great deal of functions ...
gt;
gt; HTH
gt; Cheers
gt; Carim
gt;
gt;
gt; --
gt; Carim
gt; ------------------------------------------------------------------------
gt; Carim's Profile: www.excelforum.com/member.php...oamp;userid=33259
gt; View this thread: www.excelforum.com/showthread...hreadid=531166
gt;
gt;

It's part of Excel, it's on the same CD so anyone with a legal copy of
Excel/Office would also have the ATP
Regarding the formulas go here

groups.google.es/advanced_gro...=lang_enamp;hl=en

and search, there are plenty of math professor regulars who have answered
these type of questions many times, names to include in your search

Mike Middleton, Jerry W. Lewis, Dave Braden, Harlan Grove

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Fonzquot; gt; wrote in message
...
gt; This doesn't help because I will be using the sheet I create at multiple
gt; locations and I can't install anything onto any other computer that isn't
gt; mine. Any other suggestions?
gt;
gt; quot;Carimquot; wrote:
gt;
gt;gt;
gt;gt; Hi Fonz,
gt;gt;
gt;gt; Have you had a chance to take a look at the excel add-in called
gt;gt; Analysis ToolPack ...?
gt;gt; It seems to me it is packed with a great deal of functions ...
gt;gt;
gt;gt; HTH
gt;gt; Cheers
gt;gt; Carim
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Carim
gt;gt; ------------------------------------------------------------------------
gt;gt; Carim's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=33259
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=531166
gt;gt;
gt;gt;In article gt;,
quot;Peo Sjoblomquot; gt; wrote:

gt; It's part of Excel, it's on the same CD so anyone with a legal copy of
gt; Excel/Office would also have the ATP

But an awful lot of corporate users won't have the CD, either because
the company has a single site copy or because the CDs are sequestered
with the IT Dept. Often their IT Dept won't install ATP since it's not
on the approved configuration list. As far as they're concerned, it's
*not* part of XL.

That's true, but one would expect that if this is something that is to the
benefit of the company on might expect that necessary strings could be
pulled to facilitate this. Some companies I have worked with have had it
installed already (although you have to check it under toolsgt;add-ins) and
other have made it possible although I am sure there are companies that
won't budge

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;JE McGimpseyquot; gt; wrote in message
...
gt; In article gt;,
gt; quot;Peo Sjoblomquot; gt; wrote:
gt;
gt;gt; It's part of Excel, it's on the same CD so anyone with a legal copy of
gt;gt; Excel/Office would also have the ATP
gt;
gt; But an awful lot of corporate users won't have the CD, either because
gt; the company has a single site copy or because the CDs are sequestered
gt; with the IT Dept. Often their IT Dept won't install ATP since it's not
gt; on the approved configuration list. As far as they're concerned, it's
gt; *not* part of XL.
hi!

what kind of help you expect from an excelforum to a person
who admits that he does not know how to enter into excel???!!!!

-via135

Fonz Wrote:
gt; Hello all, I am having a bit of difficulty with making a spreadsheet
gt; that
gt; entails the use of calculating various statistical formulas. I have
gt; searched
gt; the net on this topic and have only managed to find exactly what I have
gt; found
gt; help on in the help section of Excel. OUt of the formulas I needed,
gt; the
gt; following list as of now is what I do not know how to enter into excel.
gt; I do
gt; know the formulas as how you would write them out on paper and that is
gt; included with the statistical terms. If anyone knows of a website that
gt; can
gt; explain in detail how to enter these as well as other formulas into
gt; excel, It
gt; would be much appreciated. I will be needing to add more formulas on a
gt; weekly
gt; basis starting next week when I deal with the introduction to
gt; probability in
gt; statistics. Here are the formulas I need to know how to enter into
gt; excel:
gt;
gt; gt;gt;quot;Midpointquot; which is (Lower class limit) (Upper class limit)/2
gt;
gt; gt; gt; quot;Relative Frequencyquot; Which is Class Frequency/Sample Size (Also how
gt; to get the class frequency and sample size in excel would also be
gt; appreciated.)
gt;
gt; gt; gt; quot;Weighted Meanquot; which is The sum of (x*w)/n
gt;
gt; gt; gt; quot;Mean for Grouped Dataquot; which is the sum of (x*f)/n
gt;
gt; gt;gt; quot;Sample Standard Deviation for Grouped Dataquot; which is the Square
gt; root of the
gt; sum of (x-xbar)^2*f/n-1
gt;
gt; gt; gt; quot;Chebychev's Theoremquot; which is The portion of any data set lying
gt; within K
gt; standard Deviation (kgt;1) of the mean is at least :
gt; (whole number 1) - 1/k^2 .
gt;
gt; Thanks in advance to anyone that can help.--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=531166Contact me and I will give you some samples of the formulas. for things
like grouped data, you would be better off building a matrix of formulas
that calculate the parts of the formulas. That is why posting here wouldn't
be very easy to do.
Include your original post in your email.

--
Regards,
Tom Ogilvy

quot;Fonzquot; gt; wrote in message
...
gt; This doesn't help because I will be using the sheet I create at multiple
gt; locations and I can't install anything onto any other computer that isn't
gt; mine. Any other suggestions?
gt;
gt; quot;Carimquot; wrote:
gt;
gt; gt;
gt; gt; Hi Fonz,
gt; gt;
gt; gt; Have you had a chance to take a look at the excel add-in called
gt; gt; Analysis ToolPack ...?
gt; gt; It seems to me it is packed with a great deal of functions ...
gt; gt;
gt; gt; HTH
gt; gt; Cheers
gt; gt; Carim
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Carim
gt; gt; ------------------------------------------------------------------------
gt; gt; Carim's Profile:
www.excelforum.com/member.php...oamp;userid=33259
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=531166
gt; gt;
gt; gt;
In article gt;,
quot;Peo Sjoblomquot; gt; wrote:

gt; although I am sure there are companies that won't budge

Well, that includes most of my larger clients...lt;ggt;

quot;JE McGimpseyquot; gt; wrote in message
...
gt; In article gt;,
gt; quot;Peo Sjoblomquot; gt; wrote:
gt;
gt;gt; It's part of Excel, it's on the same CD so anyone with a legal copy of
gt;gt; Excel/Office would also have the ATP

gt; But an awful lot of corporate users won't have the CD, either because
gt; the company has a single site copy or because the CDs are sequestered
gt; with the IT Dept. Often their IT Dept won't install ATP since it's not
gt; on the approved configuration list. As far as they're concerned, it's
gt; *not* part of XL.

In my experience it is usually possible to include the Analysis ToolPak
without needing to use the installation CD. Just tick the relevant box
under Tools/ Add-Ins. This worked successfully under two iterations of my
company's installation, and at home.
--
David Biddulph