Question about Microsoft Excel for PC

1 Answer

How do I run a regression analysis in Excel

What is the tool/steps to plot a regression curve/line against a set of points in excel? I have used this functionality many years back, but cant remember it now...

Posted by on

  • Allen Gore
    Allen Gore May 11, 2010

    thats that fancy thing with pivot charts correct?

    im pretty sure i remember how to get the line, but ill have to check, its been a while since i took the course.

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 35 Answers

You probably want to use the LINEST function for straight lines or LOGEST for exponential curves.

In Excel 2007, there are a few tricks. One is to select a range of cells and enter your formula there. If you do not select a range of cells all the variables (coefficentis, R2, errors, etc) will not be dislayed.

The other tricks is one must hit Ctrl+Shift+Enter to display the results.

http://support.microsoft.com/kb/828533 is a link from Microsoft with a detailed explaination. Happy OLS regressing!

kpenguin

Posted on May 13, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. Please...


Excel file can be repaired manually if it is less corrupted but Open and Repair program doesn't work if highly damaged due to corruptions. I searched for solutions to repair corrupt Excel file and found one solution which is full of information and provides a guaranteed solution. I am sharing this solution with all the users -Excel Repair Toolbox. Follow the exact steps given in this programm and you will be able to access the data. Download Microsoft Excel Repair tool

May 24, 2015 | Microsoft Excel for PC

1 Answer

Reduce the size of excel file


Many businesses use Excel to track their data and expenses.
However, you can run into problems when files grow too big.
Try reducing the size of your Excel files in different ways to eliminate your storage problems.
Remove unnecessary graphics and fonts from the Excel file.
Simple report data doesn't need a lot of excess formatting to make it attractive.
If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
Reduce the number of pivot tables you allow in your data analysis.
Run your pivot table wizard when dealing with involved calculations.
When given options to format the file, choose those that allow the data to refresh instead of adding a new table.


Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
To do this, choose "XML Data" in the "Save as type" drop down box.
Change the name of your document as well, so you can tell the difference between the two files.

Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
Check into file compression software such as OzGrid.
These products exist because you cannot open a file once it gets too big.
Compress the XLS data by compelling the program to recalculate the cells used for your file.


Excel File Size Reduce Software 7.0
http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html

http://www.ozgrid.com/
or
Microsoft Excel files can contain thousands of cells filled with data.
When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

1. Click on any cell in the Excel file you want to reduce.
Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
2. Click the "Special" button on the "Go To" dialog box.
Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


3. Go to the very last cell containing data in the Excel file.
Select the entire row beneath this cell by clicking the number to the left of it.
Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
The file size will be listed on the "General" tab.



http://www.ozgrid.com/Excel/ExcelProblems.htm

Apr 22, 2013 | Microsoft Office Business & Productivity...

2 Answers

How we protect the excel sheet by password.


follow these steps to password-protect Excel file
Step 1: Save your *.xls Excel file Point to the File Menu, click save as and input the file name then the *.xls file is saved on your local disc. Point to "Tools" - "Options". When the "Options" multi-tabbed dialog box appears, click the "Security" tab.
Step 2: Choose the password protect type • If you don't wish other users to view your Excel workbook, enter a password in the "Password to open" box, and then click OK.
• If you agree other users to view your Excel workbook but don't want them make changes to the workbook, type a password in the "Password to modify" box.
• If you wish to use a different encryption settings type, click Advanced, choose an encryption setting type you want in the list, and then click OK. And you can also specify the number of characters in the Choose a key length box.
Step3: Confirm your password After type your password, a "Confirm Password" box will prompted, retype your passwords to confirm, then click OK.
Step4: Resave the Excel spreadsheet. After password protecting your Excel file, click Save. All the steps are finished.
read more: http://blog.recoverlostpassword.com/how-to-password-protect-microsoft-office-excel-2003.html

Dec 09, 2010 | Microsoft Office Standard 2007: Windows

8 Answers

I need the excel 2007 file password remover master code


Excel Password Recovery 5.0 is a free trial tool to help you recover lost or forgetten Excel workbook passwords. Although there is no guarantee that the Excel password will be recovered it is a much quicker method than the "brute force" methods that most paid password recovery tools use.
click here to learn how to unlock excel password

Jun 18, 2010 | Microsoft Office Excel 2007 Upgrade:...

3 Answers

I lost my password for the ms excel file that i created 2 months back. how should i open it now.


Hello,

While we do not give information for unlocking software due to copyright infringement, this is an altogether different matter. You have locked a document you previously created and forgot the password. There are fortunately quite a few programs to effectively retrieve your password for you, though I will provide you a link to one that I have used before, so you know it will work and is virus-free. You need to have Microsoft .net framework installed on your computer, though the .net (dot net) framework free download is software from Microsoft and is also quite safe. It is already installed on many computers for a variety of reasons. You can find the password retreiver here: http://www.freewordexcelpassword.com/downloads/FreeWordExcelpasswordrecoverywizard.zip

and it a compressed (zip) file. If you have any other questions, please dont hesitate to contact us again.

Thank you for using FixYa.

Jan 28, 2010 | Microsoft Word 2000 for PC

1 Answer

Can I get a free download of the Analysis Tool Pack for Excel 2007? Thanks.


Here's a link to help you with Analysis ToolPak for Excel 2007.

http://office.microsoft.com/en-us/excel/HP100215691033.aspx

Hope this helps you solve your problem.

Jul 10, 2009 | Microsoft Office Excel 2007

2 Answers

Steps in saving file in excel to database


severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft

Dec 11, 2008 | Microsoft Business & Productivity Software

3 Answers

I want to remove forgotten password of my only 3 exel files


Nowadays, with the development of the technology, you are able to remove excel password so as to access your files again safely and very easily with excel password reset programs. And Excel password recovery is a popular tool that can reset Excel password from Excel 97 to Excel 2007. Meanwhile, it can open your file again without any damage or data loss at all.
To recover your password, you can follow a step-by-step guide on how to recover Excel password for 2007 edition.
Step 1:Download Excel Password Recovery and install it.
Step 2:Click Open and select the file you need.
Step 3: Choose an attack type to recover Excel 2007 password.
Step 4: Attack settings.
Step 5: Click Start on the taskbar, and when the operation finished, you will recover the lost Excel 2007 password

Nov 26, 2008 | Microsoft Excel for PC

1 Answer

Work day


Hi Chinnu,

For this you will have to install an Add-in called Analysis Tool Pack.

Kindly follow the below instructions:

1. Open Excel Options (Menu-Excel Options)
2. Click on Add-Ins on the side pane of the Excel Options Window
3. Check to see if Analysis ToolPak is in Inactive application add-in list.
4. If is not, proceed to Step 7
5. If it is in the inactive application add in list, Select Excel Add-ins against Manage and click on "Go"
6. In the add-ins menu check Analysis ToolPak and Analysis ToolPak VBA and click OK
7. Use this formula to find the number of work days excluding Saturday & Sunday in a month

=NETWORKDAYS(start_date,end_date, [Holidays])

In your case give the start date as 1st July and end date as 10th July and Holidays as 0 or 1 (doesn't matter). The answer it will return will be 8 days.

Trust the above helped.

Jul 23, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Excel stops responding when i click on a graph data point to see its value


Step 1: Go to Msoft update and make sure you have all the latest Office service packs/issue fixes for Office 2007.

If that doesn't work, go on to:

Step 2: Are you using wizards to create the code to do this functionality and if so, what ones? Post here.

Mar 07, 2008 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Microsoft Excel for PC Logo

1,858 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...