Regression error

%3CLINGO-SUB%20id%3D%22lingo-sub-2397674%22%20slang%3D%22en-US%22%3ERegression%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2397674%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20an%20issue%20running%20my%20regression%20data.%26nbsp%3B%20I%20have%20inputted%20one%20column%20as%20my%20Y-axis%2C%20and%20another%20as%20my%20X-axis%2C%20but%20it%20keeps%20saying%20I%20have%20an%20error.%26nbsp%3B%20I%20am%20not%20sure%20what%20I%20am%20doing%20wrong.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Joy_I408_0-1622260575284.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F284806i04EC6DA23422DE12%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Joy_I408_0-1622260575284.png%22%20alt%3D%22Joy_I408_0-1622260575284.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Joy_I408_1-1622260635402.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F284807i36DC5D1F903E1CD1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Joy_I408_1-1622260635402.png%22%20alt%3D%22Joy_I408_1-1622260635402.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2397674%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2397774%22%20slang%3D%22en-US%22%3ERe%3A%20Regression%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2397774%22%20slang%3D%22en-US%22%3EI%20can%20reproduce%20this%20error%20message%20if%20at%20least%201%20of%20the%20X%20or%20Y%20values%20is%20missing.%20Of%20course%2C%20it's%20possible%20there%20are%20other%20scenarios%20that%20lead%20to%20this%20message.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2397815%22%20slang%3D%22en-US%22%3ERe%3A%20Regression%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2397815%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F891695%22%20target%3D%22_blank%22%3E%40tusharm10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20you%20were%20correct.%26nbsp%3B%20I%20figured%20I%20had%20to%20input%20data%20into%20the%20blank%20cells.%26nbsp%3B%20Once%20I%20did%20that%2C%20Excel%20was%20able%20to%20give%20me%20regression%20data.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.  

 

Joy_I408_0-1622260575284.png

Joy_I408_1-1622260635402.png

 

 

3 Replies
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.

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

Glad you got that sorted out.