Add Regression Line using Java and mysql

Question

I'm a beginner in Java. I would like to ask if is it possible to add a regression line in line chart using java and mysql? anyway this is my code:

try {

    String sql = "select YEAR(admission.admissiondate) as YEAR, count(admissionID) as StudNum from admission group by YEAR(admissiondate)";
    JDBCXYDataset dataset = new JDBCXYDataset(
            "jdbc:mysql://localhost/zoom", "com.mysql.jdbc.Driver", "root", "");
    dataset.executeQuery(sql);

    final JFreeChart chart = ChartFactory.createXYLineChart ("Number of Students Per Year","YEAR", "Number of Students",
            dataset,PlotOrientation.VERTICAL,true,true,false);
    XYPlot plot =null;
    ChartFrame frame = new ChartFrame("cchart", chart);
    frame.setVisible(true);
    frame.setSize(500, 500);

    chart.setBackgroundPaint(Color.white);

    XYPlot xyPlot = chart.getXYPlot();
    NumberAxis domainAxis = (NumberAxis) xyPlot.getDomainAxis();
    domainAxis.setTickUnit(new NumberTickUnit(1.0));
    domainAxis.setRange(2016,2030);
} catch(Exception e) {
    e.printStackTrace();
}

Answer 1

You can find a Regression Class in the JFree API which basically does what it sounds like.

A more detailed Example is shown here under

'Adding a Regression line to the Graph':

private void drawRegressionLine() {
    // Get the parameters 'a' and 'b' for an equation y = a + b * x,
    // fitted to the inputData using ordinary least squares regression.
    // a - regressionParameters[0], b - regressionParameters[1]
    double regressionParameters[] = Regression.getOLSRegression(inputData,
            0);

    // Prepare a line function using the found parameters
    LineFunction2D linefunction2d = new LineFunction2D(
            regressionParameters[0], regressionParameters[1]);

    // Creates a dataset by taking sample values from the line function
    XYDataset dataset = DatasetUtilities.sampleFunction2D(linefunction2d,
            0D, 300, 100, "Fitted Regression Line");

    // Draw the line dataset
    XYPlot xyplot = chart.getXYPlot();
    xyplot.setDataset(1, dataset);
    XYLineAndShapeRenderer xylineandshaperenderer = new XYLineAndShapeRenderer(
            true, false);
    xylineandshaperenderer.setSeriesPaint(0, Color.YELLOW);
    xyplot.setRenderer(1, xylineandshaperenderer);
}