Y
Yonadav Tsuna
I am doing an analysis between two variables, X- the number of
milestones one of our partner reaches a month and Y- the amount of
money the partner gets from us every month. The data thus far is in a
list with headers of the year, the month, the partner name, milestones
reached, and total payment. I wanted to do a linear regression of each
partner and see how they are performing. For my information so far for
my report, I copied the data of each partner onto its own spreadsheet
and then made a scatter plot, fitted it with a line and got the R
Squared value.
What I now want is to be able to add to the master list every month
and have the new data point for each partner update its respective
chart. Do I even need the separated spreadsheets? Is there a way to
have the master list make charts for each partner as I enter in new
data every month for every partner?
Thanks!! Any help appreciated!!
milestones one of our partner reaches a month and Y- the amount of
money the partner gets from us every month. The data thus far is in a
list with headers of the year, the month, the partner name, milestones
reached, and total payment. I wanted to do a linear regression of each
partner and see how they are performing. For my information so far for
my report, I copied the data of each partner onto its own spreadsheet
and then made a scatter plot, fitted it with a line and got the R
Squared value.
What I now want is to be able to add to the master list every month
and have the new data point for each partner update its respective
chart. Do I even need the separated spreadsheets? Is there a way to
have the master list make charts for each partner as I enter in new
data every month for every partner?
Thanks!! Any help appreciated!!