**Question description:**

*This user has given permission to use the problem statement for this blog.*

regression problem have two x variables and do regression analysis but it says i can only have one row or column for data

Solved by T. J. in 10 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
27/03/2018 - 10:31

HI

Excelchat Expert
27/03/2018 - 10:31

Welcome to got it pro

User
27/03/2018 - 10:32

hey im just having an issue with multiple regression

User
27/03/2018 - 10:33

lets say the first row is my x

User
27/03/2018 - 10:33

and b and c are y

Excelchat Expert
27/03/2018 - 10:33

ok

User
27/03/2018 - 10:33

i want to do a data analysis but why i highlight two rows for y1 and y2 it says i can only have one row

User
27/03/2018 - 10:33

when*

User
27/03/2018 - 10:34

for regression

Excelchat Expert
27/03/2018 - 10:34

let me look into this

Excelchat Expert
27/03/2018 - 10:37

there?

User
27/03/2018 - 10:38

yup

Excelchat Expert
27/03/2018 - 10:38

are you using column A in x axis?

User
27/03/2018 - 10:38

yes

Excelchat Expert
27/03/2018 - 10:38

use column A in y axis

User
27/03/2018 - 10:38

and then for y i want to use b and c

User
27/03/2018 - 10:38

oh

Excelchat Expert
27/03/2018 - 10:38

and use column B to C in x axis

User
27/03/2018 - 10:38

let me try

Excelchat Expert
27/03/2018 - 10:38

try this

Excelchat Expert
27/03/2018 - 10:38

yes ure

Excelchat Expert
27/03/2018 - 10:38

sure

User
27/03/2018 - 10:40

it says that sample x and sample y must have the same number of rows (sample values) regardless of labels

Excelchat Expert
27/03/2018 - 10:40

no i did the same

User
27/03/2018 - 10:40

yeah sorry i messed up lol i got it

Excelchat Expert
27/03/2018 - 10:40

great

User
27/03/2018 - 10:40

so when i have two values should i just always put it in x?

Excelchat Expert
27/03/2018 - 10:40

yes

Excelchat Expert
27/03/2018 - 10:41

you can refer to below link

Excelchat Expert
27/03/2018 - 10:41

http://cameron.econ.ucdavis.edu/excel/ex61multipleregression.html

Excelchat Expert
27/03/2018 - 10:41

this will explain you better

Excelchat Expert
27/03/2018 - 10:41

please do give good rating

User
27/03/2018 - 10:41

alright thanks a ton ill check it out and for sure!

Excelchat Expert
27/03/2018 - 10:41

it really helps

Excelchat Expert
27/03/2018 - 10:41

welcome

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*