Excel - COLUMN Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.