How to perform a Regression Analysis on Microsoft Excel 2016 on a Mac



How to Run Regression Analysis in Microsoft Excel

Steps

Make Sure Regression Analysis Is Supported On Your Excel

  1. 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.
  2. 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.
  3. 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

  1. 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.
  2. 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.
  3. 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.
  4. Repeat the previous step for the Input X Range.
  5. Modify your settings if desired.Choose whether or not to display labels, residuals, residual plots, etc. by checking the desired boxes.
  6. Designate where the output will appear.You can either select a particular output range or send the data to a new workbook or worksheet.
  7. ClickOK.The summary of your regression output will appear where designated.

Sample Regression Analyses

Community Q&A

Search
  • Question
    What is the slope in a simple regression data?
    wikiHow Contributor
    Community Answer
    The 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!
  • Question
    How do I calculate standard error?
    wikiHow Contributor
    Community Answer
    Step 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!
Unanswered Questions
  • 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.

Video


A detailed guide to regression analysis in Excel

Related wikiHows

Article Info

Categories:

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 Run Regression Analysis in Microsoft Excel
How to Run Regression Analysis in Microsoft Excel images

2019 year
2019 year - How to Run Regression Analysis in Microsoft Excel pictures

How to Run Regression Analysis in Microsoft Excel recommend
How to Run Regression Analysis in Microsoft Excel advise photo

How to Run Regression Analysis in Microsoft Excel photo
How to Run Regression Analysis in Microsoft Excel images

How to Run Regression Analysis in Microsoft Excel How to Run Regression Analysis in Microsoft Excel new picture
How to Run Regression Analysis in Microsoft Excel new pictures

pictures How to Run Regression Analysis in Microsoft Excel
picture How to Run Regression Analysis in Microsoft Excel

Watch How to Run Regression Analysis in Microsoft Excel video
Watch How to Run Regression Analysis in Microsoft Excel video

Communication on this topic: How to Run Regression Analysis in Microsoft , how-to-run-regression-analysis-in-microsoft/
Discussion on this topic: How to Run Regression Analysis in Microsoft , how-to-run-regression-analysis-in-microsoft/ , how-to-run-regression-analysis-in-microsoft/

Related News


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