Assistance with trend line equation
Hi.
I have the following equation derived from a exponential trend line fitted by Excel
y=1E-55e^0.064x
I have taken the formula to mean the following
y=(10^(-55)) * (e^0.064x) but when I take x as 2009 y= 6.92, but I should obtain an answer close to 22.0 Any ideas ? Is this the correct interpretation of the excel provided equation ? Thank you.
Solutions to the Problem Assistance with trend line equation
Download SmartPCFixer for Free Now
The most likely reason is that you have not used sufficient precision.
Right click the trendline equation on the chart, format it to show more decimal places
Better yet use LOGEST function to get the coefficients into cells.
See
http://people.stfx.ca/bliengme/ExcelTips/ExponentialTrendline&%20LOGEST.htm
Would you be able to post the file to a share site?
best wishes
How to use Skydrive
http://social.technet.microsoft.com/Forums/en-US/w7itproui/thread/4fc10639-02db-4665-993a-08d865088d65
Upload sites
Windows Live Skydrive: http://skydrive.live.com
MediaFire: http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
FileDropper: http://www.filedropper.com
RapidShare: http://www.rapidshare.com
Box.Net: http://www.box.net/files
- Access the files on your computer via MY COMPUTER
- Under the C: drive, access the WINDOWS folder
- Select the SOFTWARE DISTRIBUTION folder, followed by the DOWNLOAD folder.
- Delete any files within this download folder.
- If you are unable to delete these files, open the command prompt (CMD) as the administrator, and type "net stop wuauserv" into the CMD prompt window. Press ENTER. This should allow you to delete the files from step 4.
- Once the files are deleted, open and run the CMD as the administrator and type "wuauclt.exe /updatenow". Press ENTER.
Recommended Method to Repair the Problem: Assistance with trend line equation:
How to Fix Assistance with trend line equation with SmartPCFixer?
1. Download SmartPCFixer. Install it on your system.
2. After the scan is finished, you can see the errors and problems which need to be fixed.
3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.
Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Troubleshoot:Backup to network but not given the option?? Error,Tech Support: Atheros AR9485WB-EG Wireless Network Adapter adapter is experiencing driver- or hardware-related problems,How to Fix - Apps wont launch , explorer wont refresh?,How to Fix Error - Auto copy formulae...?,[Solution] Attachments in Outlook 2007,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?
댓글 없음:
댓글 쓰기