% Path to the mksqlite package
addpath('/home/rasmus/installed_drivers/mksqlite-2.0/');

% Connects to our database
mksqlite('open','small_path/max_square.db');

query_three_g = fileread('database_queries/query_rss.sql');

max_square = mksqlite(query_three_g);

mydata = [[max_square.cell_signal_strength_dbm]; [max_square.device_position_accuracy]];
max_square_all=mydata';
max_square_rss=max_square_all(:,1);

mksqlite('close');
mksqlite('open','small_path/high_square.db');
high_square = mksqlite(query_three_g);

mydata = [[high_square.cell_signal_strength_dbm]; [high_square.device_position_accuracy]];
high_square_all=mydata';
high_square_rss=high_square_all(:,1);


mksqlite('close');

min_square_rss=[-91; -91; -93; -93];

sample = cell_max_rss;%(1:281);
sample2 = cell_min_rss;
sample3 = cell_high_rss;

[rof,pof] = corrcoef(max_square_rss,sample);
[r,p] = corr(max_square_rss,sample);

[rof2,pof2] = corrcoef(min_square_rss,sample2);
[r2,p2] = corr(min_square_rss,sample2);


[rof3,pof3] = corrcoef(high_square_rss(1:54),sample3);
[r3,p3] = corr(high_square_rss(1:54),sample3);