How to Run Regression Analysis in Microsoft Excel
Make Sure Regression Analysis Is Supported On Your Excel
If your version of Excel displays theribbon(Home, Insert, Page Layout, Formulas…)
- Click on theOffice Buttonat the top left of the page and go toExcel Options.
- Click onAdd-Inson the left side of the page.
- FindAnalysis tool pack. If it’s on your list of active add-ins, you’re set.
- If it’s on your list of inactive add-ins, look at the bottom of the window for the drop-down list next toManage, make sureExcel Add-Insis selected, and hitGo. In the next window that pops up, make sureAnalysis tool packis checked and hitOKto activate. Allow it to install if necessary.
If your version of Excel displays thetraditional toolbar(File, Edit, View, Insert…)
- Go toTools>Add-Ins.
- FindAnalysis tool pack. (If you don’t see it, look for it using theBrowsefunction.)
- If it’s in theAdd-Ins Availablebox, make sureAnalysis tool packis checked and hitOKto activate. Allow it to install if necessary.
Excel for Mac 2011 and higher do not include the analysis tool pack.You can't do it without a different piece of software. This was by design since Microsoft does not like Apple.
Run Regression Analysis
Enter the data into the spreadsheet that you are evaluating.You should have at least two columns of numbers that will be representing your Input Y Range and your Input X Range. Input Y represents the dependent variable while Input X is your independent variable.
Open the Regression Analysis tool.
- If your version of Excel displays theribbon, go toData, find theAnalysissection, hitData Analysis, and chooseRegressionfrom the list of tools.
- If your version of Excel displays thetraditional toolbar, go toTools>Data Analysisand chooseRegressionfrom the list of tools.
Define your Input Y Range.In the Regression Analysis box, click inside theInput Y Rangebox. Then, click and drag your cursor in the Input Y Range field to select all the numbers you want to analyze. You will see a formula that has been entered into the Input Y Range spot.
Repeat the previous step for the Input X Range.
Modify your settings if desired.Choose whether or not to display labels, residuals, residual plots, etc. by checking the desired boxes.
Designate where the output will appear.You can either select a particular output range or send the data to a new workbook or worksheet.
ClickOK.The summary of your regression output will appear where designated.
Sample Regression Analyses
QuestionWhat is the slope in a simple regression data?wikiHow ContributorCommunity AnswerThe slope is the Beta variable B1 that is a coefficient of the independent variable X. Bo is a constant and the "intercept". Example, Y = Bo + B1X.Thanks!
QuestionHow do I calculate standard error?wikiHow ContributorCommunity AnswerStep 1: Calculate the mean (Total of all samples divided by the number of samples). Step 2: Calculate each measurement's deviation from the mean (Mean minus the individual measurement). Step 3: Square each deviation from mean. Squared negatives become positive.Thanks!
I get error message "Linest() returns an error, check input values again." What could be wrong?
When I did the regression analysis, the result I got from the Significance F Value was #NUM! But is there a way I can fix it? What does it mean?
How do you plot the efficient frontier line?
How do I get a regression analysis graph?
What is the estimated intercept?
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
||A detailed guide to regression analysis in Excel|
In other languages:
Español: , Deutsch: , Italiano: , Português: , 中文: , Русский: , Nederlands: , ไทย: , Bahasa Indonesia: , Français:
Thanks to all authors for creating a page that has been read 1,209,578 times.
Video: Excel - Simple Linear Regression
How to Get a Marketing Job without a Marketing Degree
How to Understand Speed Networking
Redbook Reads: QA with Jane Green
Advice on Doing Yoga When Youre Sick
20 Coffee Drinks with More Sugar Than a Can of Coke
Tips to Lose Weight as a Vegetarian
How to Choose Cold Weather Fitness Clothing
This New Study Offers a Good Excuse Not to Straighten Up That Messy Room
How to Write a Study Abroad Blog
6 Makeup Primers Thatll Get You Ready For Your Close-Up
Date: 12.12.2018, 04:54 / Views: 44575