Kyle Dacones kyledacones

## linear_regression.sql
-- This code is based on my other Gist "Simple linear regression in Javascript" (https://gist.github.com/patrickpissurno/ea0dc4039f075fbaf398619761bd9044)
-- There might be a more efficient way to do this in SQL

-- This function is resposible for computing the weights for the ax + b equation
CREATE OR REPLACE FUNCTION linear_regression(x_array decimal(15,2)[], y_array decimal(15,2)[]) RETURNS decimal(15,2)[] AS $$
	DECLARE
		slope decimal(15,2);
		intercept decimal(15,2);

		n integer;

## Requirements-Document-Draft-1-1.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                kyledacones
                / Requirements-Document-Draft-1-1.md
            
            
              Created
              July 31, 2020 22:36
            
              
                This is the first draft of the basic requirements for the application
              
          
        
      
        
  
      
    Create the Requirements Document

Overview

Problem statement

Describe the problem you're trying to solve by doing this work.
Proposed work
	-- This code is based on my other Gist "Simple linear regression in Javascript" (https://gist.github.com/patrickpissurno/ea0dc4039f075fbaf398619761bd9044)
	-- There might be a more efficient way to do this in SQL

	-- This function is resposible for computing the weights for the ax + b equation
	CREATE OR REPLACE FUNCTION linear_regression(x_array decimal(15,2)[], y_array decimal(15,2)[]) RETURNS decimal(15,2)[] AS $$
	DECLARE
	slope decimal(15,2);
	intercept decimal(15,2);

	n integer;