how to do self-defined regression in excel?

Hi, I want to do regression ananlysis in excel using a
sigmoid function, which is not offered in the general 6
functions in excel(by adding trendline). How can I do it?
Thanks.
0
6/9/2004 5:52:32 AM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
357 Views

Similar Articles

[PageSpeed] 38

The Analysis ToolPak - VBA addin has a regression function 
and probably everything else you want.

Tools  > AddIns then checkmark Analysis ToolPak - VBA 
Go back to Tools dropdown and it should be listed near the 
bottotm of the dropdown.


>-----Original Message-----
>Hi, I want to do regression ananlysis in excel using a
>sigmoid function, which is not offered in the general 6
>functions in excel(by adding trendline). How can I do it?
>Thanks.
>.
>
0
anonymous (74725)
6/9/2004 7:27:20 AM
You can use Solver to minimize the sum of squared deviations for a Least 
Squares fit.  There may be might specific approaches, if we knew your 
function.

Jerry

chuping wrote:

> Hi, I want to do regression ananlysis in excel using a
> sigmoid function, which is not offered in the general 6
> functions in excel(by adding trendline). How can I do it?
> Thanks.

0
post_a_reply (1395)
6/9/2004 11:37:10 AM
Reply:

Similar Artilces:

Self installing Drives
This is going to be a bit long. Last month I bought a new HP computer with Windows7 64 bits. I uninstalled the Norton antivirus that came with it, and used the Norton Removal Tool to clean any thing left over, if any. I have Microsoft Security Essentials and the Windows firewall ON. I have not installed any programs in the computer. I have 2 flash DRIVES (J and K) where I keep my files. Every thing has been working just fine until 4 days ago. I turned my computer on , clicked the J drive and a small screen came on telling me to insert the disk, but it was already inserted. I then...

Excel Cell Autocomplete
Is there any function, so we can use auto complete while entering similar entry in to cell, which saves lot's time when entering similar data. DEFAULT AUTO COMPLETE WORKS VERY LIMITED, WILL NOT WORK IF SEQUENCE WILL BREAK, ALSO FOR NUMBERS (A/C) IS NOT WORKING. I have tried with alt+down arrow, but it's giving entry which below of that cell...better if we have some thing to lookup which can shows us all entry in to that column( up & below). -- smd111 ------------------------------------------------------------------------ smd111's Profile: http://www.excelforum.com/member...

Embedded excel worksheets in word
Since Office v. X I have been unable to embed excel worksheets in word that contain more than five columns. Can anyone tell me that I have been doing something wrong OR tell me if 2004 fixes this problem? Thanks, Mike in article BCD52774.75C7%mcgetrick@lfoconnell.com, Mike McGetrick at mcgetrick@lfoconnell.com wrote on 22/05/04 21:51: > Since Office v. X I have been unable to embed excel worksheets in word that > contain more than five columns. Can anyone tell me that I have been doing > something wrong OR tell me if 2004 fixes this problem? > > Thanks, > Mike > A...

Importing web data to Excel 2003
I have built a flight planning program for aviation using Excel 2003. I am trying to find a function to import winds aloft from NavCanada's aviation weather site, to avoid manual entries. Is there a web site where raw text data from NavCanada's site to import, or a way to import it from their normal web display? Below there is a link to NavCanada's normal display of data. http://www.flightplanning.navcanada.ca/cgi-bin/Fore-obs/fd.cgi Any help would be appreciated. thanks I get an access denied on your URL................no permission. But have you tried Dat...

Why Excel 2007 not responding after saving
I have reinstalled Excel 2007 (Office Home & Student) but it is worse. Now having problems even opening files. If I click on a cell it pauses for ages and then says it is not responding. Try looking for help here: http://support.microsoft.com/?scid=ph;en-gb;8753#tab3 "Xandersmum" wrote: > I have reinstalled Excel 2007 (Office Home & Student) but it is worse. Now > having problems even opening files. If I click on a cell it pauses for ages > and then says it is not responding. ...

Importing from Excel
Hello, does Money have the ability to create invoices by importing from Excel? I don't think it does, perhaps I am missing something. Thanks in advance! ...

querying excel spreadsheets like database
I'm making a payroll journal, it has a column for the names, and the the cheque amt, cheque no., and some other stuff. In a separate sheet I need to pull up individual information pe employee and total. Eg. Payroll Journal: Name: cheque amt: cheque no: date: jane doe 2000.00 0001 01/01/01 john doe 1500.00 0002 01/01/01 jane doe 1800.00 0003 15/01/01 Employee Details: Name: cheque amt: cheque no: date: jane doe 2000.00 0001 0...

How to work with CSV files in Excel without warnings?
We work with a lot of CSV files in Excel and would like to turn off the warning that the file "may contain features that are incompatible..". Is it possible to allow saving a CSV file without warnings? Thanks, Sam ------------------------------------------------------------ We're hiring! B-Line Medical is seeking .NET Developers for exciting positions in medical product development in MD/DC. Work with a variety of technologies in a relaxed team environment. See ads on Dice.com. Sam, You could use a macro: Sub TryNow() Dim myFName As String myFName = Application.GetSaveA...

Problem launching excel
All of a sudden each time when I now try to launch excel or an excel file a dialogue box appears stating "'C:Program~1\micro~2\office10\library\mobiledb.xla' could not be found." After clicking "OK" it searches for Windows installer ultimately requesting me to insert my CD. Any help on this appreciated. Kind regards...Steve Try following: Go to Tools menu & Select Add-ins and uncheck mobilebd or alternatively in directory "'C:Program~1\micro~2\office10\library\mobiledb.xla' delete file named mobiledb.xla. Start your Excel and hopefully error...

export excell into outlook calender
Does anyone know how to export or insert an Excell 2002 spreadsheet (representing a calender) into outlook 2002 calender? Much appreciated. ...

Were did the name excel come from?
With a capital "E", Microsoft <g> Bill "Dave Brownewell" wrote: > Why was the name "Excel" chosen for the products name? "Dave Brownewell" <Dave Brownewell@discussions.microsoft.com> wrote in message news:0A516823-5B63-4420-B7B4-18B34D08AC7B@microsoft.com... > I don't know who came up with the name Excel but I distinctly remember that I have read that MS had come up with many names for their version of the spreadsheet. One of them was "Mr Speadsheet". It's the same with Widows. The original name was "...

Dictionary or Spelling in Excel 2003
We are trying to enter the initials CNA as text in a spreadsheet cell, but Excel keeps changing it to CAN no matter what we do. We have tried a different cell, a new spreadsheet. Nothing has worked so far. Any ideas? Spell check and dictionary keep referring back to CAN. Hi gtownrailroad! It's an auto correction. Tools > AutoCorrect Options Scroll down to "cna" and select Delete -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "g...

The self permission
I am running exchange 2003 sp1. My DC's are 2k sp 4. I need to give my helpdesk the ablility to add the External Assoiciated Account to Self.(for disabled accounts) I gave the helpdesk Exchange view only through the ESM on the Admin group level, But thet still cannot add that permission to self what am I missing? "Rick" <Rick@discussions.microsoft.com> wrote: >I am running exchange 2003 sp1. My DC's are 2k sp 4. >I need to give my helpdesk the ablility to add the External Assoiciated >Account to Self.(for disabled accounts) I gave the helpdesk Exchange vi...

allow text over a non-blank cell in Excel
How do I allow the text from A1 and text from B1 to display one over the other at the same time Hi! Try this: =A1&CHAR(10)&B1 Format the cell to wrap text. Biff "Island" <Island@discussions.microsoft.com> wrote in message news:0FA73692-F12F-47B8-9062-4B7FB4E88631@microsoft.com... > How do I allow the text from A1 and text from B1 to display one over the > other at the same time You cannot allow this unless you take a picture of one of the cells and place it over the other cell. SHIFT + Edit>Copy Picture This makes it hard to read either of the st...

How can I print the username or computername from excel?
How do I do, when I print an excel file, to have the username or the computer name of the person/computer that is printing it? Thanks. ...

Colours in user-defined charts
I have one more question about user-defined charts: Is it possible to define the colours to be used? I can change the colours in usrgal.xls but when I apply the user-defined chart, the colurs revert to those in the current workbook. Any way around this? The users can not be expected to import the colours for every book and they have a lot of old books in wich they are going to use the new colour-set. -- Fredrik E. Nilsen Hi Fredrik, As you have discovered the you can change the user defined colors for any workbook but the pallete is workbook specific. If all the colors you want to use...

EXCEL TROUBLESHOOTING
Hi there, I have an Excel file (2000 format) that conatins ADO links to 9 tables on a mainframe, and a fairly large number of lookups, and other calculations. I recently made a number of changes to various parts of the file, at the one time. Now when I open the file, the Windows task manager shows the CPU at 100%, and I cant do anything in the excel file - unless I set excel to manual calculation before opening the file. Obviously, there is something wrong within the file !! However, how does one find the cause of the problem ? Thanks in advance. ...

Excel 2002 can not open earlier verion of excel?
Hi, I just install excel 2002 and have a hard time open the older verion of excel. If any one know how to fix this please help me. Thank you in advanced. Myphuong When you say the "older version of excel", do you mean a file created in an older version or do you mean xl97 or xl2000 or something else? -- Don Guillett SalesAid Software donaldb@281.com "myphuong" <myphuong@ATLglobal.com> wrote in message news:064201c3b082$0ee6f540$a101280a@phx.gbl... > Hi, > I just install excel 2002 and have a hard time open the > older verion of excel. If any one know ho...

i want to send multiple emails through outlook using an excel macr
Hi, I want to send multiple emails through outlook using an excel macro. And for each receipient (message) I get a window saying 'A program trying to send an email on your behalf........................with options Yes, No....' How can do without this message and send these emails without interruption? "Raj Devarajah" <Raj Devarajah@discussions.microsoft.com> wrote in message news:752C12C4-4C9C-4BE6-99F3-9220B8054093@microsoft.com... > I want to send multiple emails through outlook using an excel macro. And > for each receipient (message) ...

excel asp.net problem
Hi, I have to make a upload application which is to run on a webserve which does not has excel application loaded in it. My input source is a excel file. I will have to selectively take dat from the excel sheets and upload it into a database. I was able to d this through vb with excel application installed in the system. i there a way in asp.net through which i would be able to do the same o a webserve -- Message posted from http://www.ExcelForum.com ...

Lotus had buttons (icons) for first & last cell does excell?
Lotus used to have two icons, one that took you to the first cell of the sheet and the second that took you to the last used cell of the sheet. ARe there icons in excel for this? Marty No Icon, but Ctrl+Home, Ctrl+End is the same thing -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "Marty" <Marty@discussions.microsoft.com> wrote in message news:B04CA6C8-16EF-4759-9B4A-A22794A979B4@microsoft.com... > Lotus used to have two icons, one that took you to the first cell of the > sheet and the se...

How do I create a frequency polygon in Excel?
I am trying to create a frequency polygon using mid-point values for the horizontal axis, and heights from a source. Put your midpoint values in a column, and the corresponding heights in the next column. Select this data and create an XY chart, using one of the options with connecting lines between points. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Benny" <Benny@discussions.microsoft.com> wrote in message news:EF4276D7-2EAA-4274-9261-0E3BBF4D9062@microsoft.com... >I...

How do open each excel file in its own window
I used to be able to open each excel file in its own window that could be minimized and maximized on its own. Now all files are opening in one window. I do not want to arrange the files in that window- I want all files in their own windows. All file names appear in the taskbar- but they still all open in the same window when clicked. Strangely enough my MS Word files on the same computer are still opening in their own windows . . . . any advice? Thanks I have the same trouble... anyone knows??? "pearcemi" wrote: > I used to be able to open each excel file in its own w...

Excel Sheet to Outlook Form?
Is there a way to convert an excel spread sheet to a outlook form? Similar to when you create a new email (you have that form) I am looking for a button to push that says timesheet, and then i opens a new form (simliar to the new email) and you can fill out you time sheet and fill it of -- Message posted from http://www.ExcelForum.com ...

send self junk mail
I scan virus on workstation. It does not find anything! I have created a rule that all junk mail move to SPAM folder. Is that possible that rule cause problem! Or there is warm or virus to f/1pe problem! Jimmy Jimmy <anonymous@discussions.microsoft.com> wrote: > I scan virus on workstation. It does not find anything! > I have created a rule that all junk mail move to SPAM > folder. > Is that possible that rule cause problem! > Or there is warm or virus to f/1pe problem! What is the problem that you're seeing? -- Brian Tillman Smiths Aerospace 3290 Pat...