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

3 Replies

  • 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.  

Resources