Linear regression

7.00K viewsFormulas and Functions

In advance I admit my statistical amateur status, but I still have numbers to crunch and a job to do so…

I have considered the sample model that uses linear regression on stock prices, etc. That model uses dates as the independent variable, x.

I am trying to do linear regression where x is not based on time but on throughput, hits on a web server, for example. The dependent variable would be- for instance- a measurement of CPU.

The other complication is that the contents of cells are dynamic, being fed by linked matrices, which are in turn fed by a datalink. I know that i am probably over-complicating the linkages, but I am just trying to tackle one obstacle at a time. Bottom line is: no cell value can be static.

So, taking one issue at a time, I have calculated linear regression but the independent value (x) is an item cell with the dependent value (y). X needs to be on the chart as the x axis, and y on the y axis. But with them both being in the same item group(?) I cannot chart them like that.

How do I rectify that?



Vince, I would think you would be able to calculate a y for any x since you have the interecept and slop. So it would be do-able.


You are viewing 1 out of 9 answers, click here to view all answers.

Latest Questions