What if analysis, can this be DONE??

Posted to microsoft.public.excel.worksheet.functions

Barbara Harris

Posts: n/a

What if analysis, can this be DONE??

Help me if anyone can!
I set up the function Trend(C1:C5).
From this the function returns the Linear regression value
for the latest data point C5. How can do a what if
analysis to find the value at C5 that equals the Linear regression value
i.e., solve for C5= Trend(C1:C5)?
Any way it can be done?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How do I configure Analysis Services for Excel 2003 users?	Robert Chapman	Excel Discussion (Misc queries)	1	February 8th 06 09:58 AM
Why does the Data Analysis Toolbar Disappear	Vinnie	Excel Discussion (Misc queries)	1	October 7th 05 07:04 PM
Recalculating a Regression Output in Data Analysis	karin	Excel Worksheet Functions	1	August 23rd 05 03:40 AM
Why " data analysis plus " override " data analysis " once instal.	Alfred H K Yip	Excel Worksheet Functions	1	March 20th 05 08:10 AM
Analysis ToolPak installed but no Data Analysis option	Eric Stephens	Excel Discussion (Misc queries)	3	February 2nd 05 09:17 PM

All times are GMT +1. The time now is 08:31 AM.

Menu

About Us