Download ArticleDownload ArticleX
How.com.vn is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 20 people, some anonymous, worked to edit and improve it over time.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 1,327,984 times.
Learn more...
Regression analysis can be very helpful for analyzing large amounts of data and making forecasts and predictions. To run regression analysis in Microsoft Excel, follow these instructions.
Steps
If your version of Excel displays the ribbon (Home, Insert, Page Layout, Formulas…)- Click on the Office Button at the top left of the page and go to Excel Options.
- Click on Add-Ins on the left side of the page.
- Find Analysis 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 to Manage, make sure Excel Add-Ins is selected, and hit Go. In the next window that pops up, make sure Analysis tool pack is checked and hit OK to activate. Allow it to install if necessary.
If your version of Excel displays the traditional toolbar (File, Edit, View, Insert…)- Go to Tools > Add-Ins.
- Find Analysis tool pack. (If you don’t see it, look for it using the Browse function.)
- If it’s in the Add-Ins Available box, make sure Analysis tool pack is checked and hit OK to activate. Allow it to install if necessary.
Advertisement
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.
Advertisement
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 the ribbon, go to Data, find the Analysis section, hit Data Analysis, and choose Regression from the list of tools.
- If your version of Excel displays the traditional toolbar, go to Tools > Data Analysis and choose Regression from the list of tools.
Define your Input Y Range. In the Regression Analysis box, click inside the Input Y Range box. 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.
Click OK. The summary of your regression output will appear where designated.
Advertisement
Sample Regression Analyses
Community Q&A
Search
- QuestionWhat is the slope in a simple regression data?
Community 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. - QuestionHow do I calculate standard error?
Community 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. - QuestionHow can I calculate the equation of a line in regression in Excel?Community AnswerOne quick way to do this is to arrange your X and Y variables in adjacent columns (X on the left), then select the two-column range and use the Insert/Scatterchart command to insert an X-Y scatterchart. Then right-click on the chart, choose Add Trendline from the drop-down menu, and then check the box for Display-Equation-on-Chart. Or, you could use some good software to fit the whole regression model. Try RegressIt, a free add-in (available at regressit-dot-com), It gives very detailed and well-designed output, and among other things it will show the equation for any number of independent variables. Just click the "Show All" button after fitting a model.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
SubmitAdvertisement
Video
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
About This Article
Thanks to all authors for creating a page that has been read 1,327,984 times.
Reader Success Stories
"I have activated Excel on my laptop using the step-by-step procedures given, and am able to do analysis now."
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
Advertisement
