Q&A for How to Run a Multiple Regression in Excel

Return to Full Article

Search
Add New Question
  • Question
    what is output range
    Kyle Smith
    wikiHow Technology Writer
    Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.
    wikiHow Technology Writer
    Expert Answer
    The output range in the regression window is where the results of the analysis will appear. This can be in an existing sheet, a new sheet, or an entirely new workbook file.
  • Question
    getting #NUM error p- values. What does it mean?
    Kyle Smith
    wikiHow Technology Writer
    Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.
    wikiHow Technology Writer
    Expert Answer
    This could indicate that you don't have enough observations to compute the significance of the model or its parameters. Try adding additional observations if this is the case.
  • Question
    What is the formula of multiple regression used by Excel in the background?
    Kyle Smith
    wikiHow Technology Writer
    Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.
    wikiHow Technology Writer
    Expert Answer
    Excel is using the linear regression formula y = m1x1 + m2x2 + ... + b. It calculates the values using the least squares method.
  • Question
    How do I report the results of a multiple regression analysis?
    Community Answer
    The Y axis can only support one column while the x axis supports multiple and will display a multiple regression.
  • Question
    What does it mean if my input range contains non-numeric data?
    Community Answer
    It is possible that one or more of your columns has numbers formatted as text, or there is actual text in those columns.
  • Question
    My significance F value is 6.07596E-31. What does that mean?
    Community Answer
    If you switch the cell format to numerical instead of general, that will fix this problem. This notation of this number is basically saying move the decimal to the left 31 times so it will be a very small number. Since this number is so small I would recommend checking you entered everything in properly but since I have no idea what your data looks like, it could be correct.
Ask a Question

      Return to Full Article