Visokio Forums

TomW · February 9, 2012 10:02AM

Hi,

I am trying to work out if there is anyway that I can calculate the equation of a straight line within an Omniscope datamanager, as I need to calculate the difference between certain points along the line and the line itself. I know I can attempt to find the equation by using the graph function but I have 10 different properties across 25ish demographic groups which means I would need to find 250 equations per time I have to do this process.

I have a way of doing it in excel and am trying to copy the formulae across but this process required the functions OFFSET, INTERCEPT, SLOPE and STEYX to do so. I am unable to find these in Omniscope but are there different ones that can be used or have they been renamed?

The reason I wish to do this in Omniscope is because the result is key to the dashboard and I would like to automate the process so I do not have to do it manually everytime I get a new set of data (at least 10 more times this year alone).

Any help would be much appreciated.

Thanks

michael · February 9, 2012 10:51AM

Hi Thomas,

For linear regression and for other statistical operations in Omniscope 2.7 we recently added integration with very powerful statistical package R-statistics.

To see how it works in Omniscope 2.7 go to http://www.visokio.com/video-tutorials and find following videos:
1) R-statistics operation;
2) R-statistics data.

You can find the installation of R-statistics at http://www.r-project.org .
After installation you'll be able to use it in DataManager in "Operations->R statistics operation" block.
It is also advisable to update to the latest 2.7 build.

If you have any questions regarding using R-statistics in Omniscope, please don't hesitate to ask them in the following forum thread:
http://forums.visokio.com/discussion/1281/r-integration .

Visokio Forums

Welcome!

Categories