Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 837
Default Will excel generate one-tailed confidence intervals for Poisso

Unfortunately, 12 minutes between your previous post and this one is not a
new record for impatience. The people who provide information in these
newsgroups are not paid and do have lives, so it is quite common for there to
be a lag between when you post a question and when a particular person may
read and respond to that question. Another aspect of us not being paid, is
that in effect you are asking us to do you a favor. Is this how you ask for
favors in the real world?

I'm sorry that you are having so much trouble figuring out how to use the
Smith library; most people don't.

Also, forgive me if I have over-estimated your level of understanding, but
if you dont ask specific questions, we have to make assumptions.

The simplest way to use the Smith library is to add worksheets to
Examples.xls, which you downloaded from Ian Smith's web page. The code is
already in that workbook, so you can simply use it on worksheets that you add
to that workbook.

If adding your workbooks into Examples.xls is not appropriate, you can use
Alt+F11 to start the VBA Editor. In the Project window, under Examples.xls
you will find a folder marked €śModules€ť. In that folder is a single module
page that contains all the VBA code for Smiths functions. For the workbook
that you want to add the code to, you can Insert|Module from the VBA Editor
menu, then copy the code from the Examples.xls module into the one you added
to the new workbook.

The resulting calculations would be slightly less accurate than in
Examples.xls, due to the MS decision to display no more than 15 figures on
floating point numbers. You can achieve the same precision as in
Examples.xls by pasting the code into a text editor. In that text editor,
wherever there is a code comment (preceded by a single quote) that contains a
numeric value to more figures than is shown in the actual code, then
copy/paste the commented value over the code value. When finished, copy all
the code from the text editor into the module that you added to the new
workbook. This is a lot of work and presumes a certain level of
understanding; hence my suggestion that the easiest approach is to add
worksheets to Examples.xls.

Jerry

"Dora Smith" wrote:

Umm, Jerry, I expect people to tell me how to use things I obviously don't
know how to use, if they are going to tell me to use them.

What is supposed to be the earthly point of telling someone to use something
and not tell her how to use it? Are you trying to help me, or merely show
off your knowledge and play up how much I don't know?

No - don't answer that. There are some people on this newsgroup who are
helpful, and others whose experience or whatever is truly unique. Maybe
it's called academic statistics; I don't know - people in that department
sure were a prize when I went to school! And yours isn't even the best of
the exasperating answers! Sorry. I know you wanted the prize for
creative rudeness. I don't still go to that school, and I'm not in
academia, and you aren't going to intelligibly answer my questions no matter
what I do or don't do, so I've no particular reason to be patient with your
rudeness. But you were too arrogant to think of all that.

--
Yours,
Dora Smith
Austin, TX


"Jerry W. Lewis" wrote in message
...
Perhaps your experience has been different, but I have generally found it
counterproductive to blame those I was seeking help from for my lack of
understanding, instead of simply asking for clarification.

Jerry




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Confidence Intervals waldoafit Excel Discussion (Misc queries) 2 January 10th 07 07:36 PM
Multiple Excel versions. Naveen Mukkelli Excel Discussion (Misc queries) 0 May 16th 06 12:55 AM
Generate 1-to-1 outputs for a list of inputs into a excel formula JBollinger1234 Excel Discussion (Misc queries) 1 May 11th 06 01:02 PM
Statistical Excel Function Question within Excel 2000... Drew H Excel Worksheet Functions 3 October 31st 04 06:55 PM


All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"