Linear regression

6.71K viewsFormulas and Functions
0

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

0

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.

Steve

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

Latest Questions

Qloud Losing Formatting 4 Answers | 0 Votes
Meditation on timelines 3 Answers | 0 Votes