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.