turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- BI
- /
- Visual Analytics
- /
- Visualising multiple (linear) regression lines in ...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-12-2016 06:37 AM - edited 10-12-2016 06:38 AM

Hello,

I have a dataset that I would like to visualize in VA in the following way:

I want a regression line per block of data (by chemical compound and by experiment number).

My regression is: Concentration=Intercept+Slope*Area.

What I need is a big graph that will be split into little squares and every square should contain a linear regression per block of data.

Here is an approximate image of what it should look like (please ignore values and names in the graphs):

COMPOUND 1 COMPOUND 2

Experiment 1 Experiment 2 Experiment 1 Experiment 2

Is it possible to do something like this in VA? I would also like to know how to automatically print the regression equation on each graph (or underneath it).

Accepted Solutions

Solution

02-24-2017
09:01 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

11-09-2016 03:02 PM

Elle, this may be possible to build in custom graph builder. Looks like you would have to start with a scatter plot and add a line plot and a band plot. The difficult thing is that you will have to have the upper and lower confidence bands and the equation value calculated and part of the data before starting.

Having the equation in the graph would require you to have a column called 'Equation' with the text "y=mx+b" for each applicable row., but it could be done.

Having the equation in the graph would require you to have a column called 'Equation' with the text "y=mx+b" for each applicable row., but it could be done.

All Replies

Solution

02-24-2017
09:01 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

11-09-2016 03:02 PM

Having the equation in the graph would require you to have a column called 'Equation' with the text "y=mx+b" for each applicable row., but it could be done.