Forum Discussion

Joy_I408's avatar
Joy_I408
Copper Contributor
May 29, 2021

Regression error

I am having an issue running my regression data.  I have inputted one column as my Y-axis, and another as my X-axis, but it keeps saying I have an error.  I am not sure what I am doing wrong.     ...
BI & Data Analysis
excel
tusharm10's avatar
tusharm10
Brass Contributor
May 29, 2021
I can reproduce this error message if at least 1 of the X or Y values is missing. Of course, it's possible there are other scenarios that lead to this message.
  • Joy_I408's avatar
    Joy_I408
    Copper Contributor
    May 29, 2021

    tusharm10 

     

    Thank you, you were correct.  I figured I had to input data into the blank cells.  Once I did that, Excel was able to give me regression data.  

    • tusharm10's avatar
      tusharm10
      Brass Contributor
      Jun 01, 2021
      Glad you got that sorted out. 🙂

Resources