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

Return to Full Article

Coming soon

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.

Kyle Smith

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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 1
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.

Kyle Smith

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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 1
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.

Kyle Smith

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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 3
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 37 Helpful 82
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 15 Helpful 18
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 4 Helpful 1