how do I scan the data in the other package and use it to compute the standard deviation and the correlation.

Objective To master working with File handlers and ArrayLists

Overview You are to read and parse the contents of the Stock_Data.txt. The Stock_Data.txt comma delimited file contains historical data on five stocks:

Date,X,GE,APPL,GOOG,F, 8/9/17,23.93,24.69,158.59,922.90,10.36, 8/10/17,23.69,24.29,153.54,907.24,10.22, 8/11/17,23.01,24.20,155.68,914.39,10.22, 8/14/17,23.18,24.35,158.02,922.67,10.35, 8/15/17,23.56,24.14,159.75,922.22,10.28, 8/16/17,24.48,24.10,159.11,926.96,10.25, 8/17/17,23.60,23.76,156.05,910.98,10.09, 8/18/17,23.55,23.57,155.70,910.67,10.02, 8/21/17,23.17,23.51,155.41,906.66,10.03, 8/22/17,24.10,23.62,157.95,924.69,10.10, 8/23/17,24.73,23.42,158.15,927.00,10.16, 8/24/17,24.65,23.33,157.45,921.28,10.16, 8/25/17,24.78,23.51,158.03,915.89,10.27, 8/28/17,25.14,23.49,159.62,913.81,10.24, 8/29/17,25.80,23.47,161.05,921.29,10.28, 8/30/17,26.68,23.31,161.48,929.57,10.38, 8/31/17,26.44,23.57,162.12,939.33,10.46, 9/1/17,26.82,24.14,162.17,937.34,10.77, 9/5/17,27.06,23.76,160.23,928.45,10.78, 9/6/17,27.34,23.93,160.06,927.81,10.91, 9/7/17,27.51,23.06,159.42,935.95,10.82, 9/8/17,26.79,22.87,156.82,926.50,10.78, 9/11/17,26.69,22.77,159.65,929.08,10.83, 9/12/17,26.49,22.96,159.02,932.07,11.00, 9/13/17,26.49,23.15,157.82,935.09,11.02, 9/14/17,25.45,23.29,156.47,925.11,10.97, 9/15/17,24.93,23.21,158.05,920.29,11.02, 9/18/17,25.37,23.72,156.85,915.00,11.03, 9/19/17,25.49,23.47,156.91,921.81,11.12, 9/20/17,25.63,23.58,154.28,931.58,11.11, 9/21/17,24.51,24.00,151.64,932.45,11.12, 9/22/17,23.68,24.12,150.15,928.53,11.23, 9/25/17,23.90,24.35,148.83,920.97,11.33, 9/26/17,24.21,24.18,151.39,924.86,11.32, 9/27/17,25.03,23.63,152.47,944.49,11.34, 9/28/17,25.28,23.51,151.53,949.50,11.35, 9/29/17,25.50,23.45,152.36,959.11,11.36, 10/2/17,25.97,23.83,152.05,953.27,11.47, 10/3/17,26.15,24.05,152.71,957.79,11.71, 10/4/17,26.29,23.74,151.72,951.68,11.67, 10/5/17,26.37,23.80,153.61,969.96,11.62, 10/6/17,25.89,23.65,153.52,978.89,11.68, 10/9/17,24.86,22.72,154.06,977.00,11.71, 10/10/17,24.82,22.65,154.12,972.60,11.76, 10/11/17,25.04,22.37,154.76,989.25,11.75, 10/12/17,25.40,22.35,154.22,987.83,11.50, 10/13/17,27.19,22.28,155.19,989.68,11.43, 10/16/17,26.50,22.65,158.05,992.00,11.50, 10/17/17,26.46,22.49,158.63,992.18,11.64, 10/18/17,27.08,22.42,157.93,992.81,11.57, 10/19/17,27.51,22.87,154.20,984.45,11.60, 10/20/17,28.25,23.11,154.46,988.20,11.62, 10/23/17,27.81,21.64,154.38,968.45,11.57, 10/24/17,28.51,21.23,155.30,970.54,11.71, 10/25/17,27.93,20.85,154.62,973.33,11.57, 10/26/17,27.52,20.67,155.61,972.56,11.79, 10/27/17,26.91,20.16,161.18,1019.27,11.58, 10/30/17,26.29,19.79,164.81,1017.11,11.62, 10/31/17,25.16,19.55,167.11,1016.64,11.79, 11/1/17,27.13,19.41,164.98,1025.50,11.86, 11/2/17,27.42,19.34,166.19,1025.58,11.93, 11/3/17,26.87,19.53,170.53,1032.48,11.87, 11/6/17,27.34,19.52,172.26,1025.90,11.84, 11/7/17,26.78,19.60,172.81,1033.33,11.68, 11/8/17,27.10,19.51,174.22,1039.85,11.58, 11/9/17,26.98,19.38,173.87,1031.26,11.57, 11/10/17,27.34,19.87,173.29,1028.07,11.54, 11/13/17,27.50,18.44,172.60,1025.75,11.68, 11/14/17,26.55,17.36,169.99,1026.00,11.55, 11/15/17,26.99,17.71,167.75,1020.91,11.53, 11/16/17,27.01,17.70,169.75,1032.50,11.57, 11/17/17,27.16,17.66,168.81,1019.09,11.54, 11/20/17,27.73,17.44,168.64,1018.38,11.65, 11/21/17,28.03,17.29,171.77,1034.49,11.64, 11/22/17,28.38,17.60,173.58,1035.96,11.59, 11/24/17,29.08,17.64,173.59,1040.61,11.62, 11/27/17,28.67,17.57,172.72,1054.21,11.63, 11/28/17,28.48,17.85,171.71,1047.41,11.73, 11/29/17,28.50,17.92,168.14,1021.66,12.06, 11/30/17,28.79,17.74,170.49,1021.41,12.03, 12/1/17,29.17,17.34,169.70,1010.17,12.08, 12/4/17,29.71,17.41,168.46,998.68,12.13, 12/5/17,29.70,17.22,168.30,1005.15,11.94, 12/6/17,30.97,17.24,167.68,1018.38,11.89, 12/7/17,31.71,17.29,167.98,1030.93,12.04, 12/8/17,33.08,17.29,168.03,1037.05,12.11, 12/11/17,33.27,17.23,171.31,1041.10,12.08, 12/12/17,32.85,17.49,170.35,1040.48,12.10, 12/13/17,32.69,17.34,170.91,1040.61,12.13, 12/14/17,31.59,17.22,170.86,1049.15,11.97, 12/15/17,31.71,17.40,172.60,1064.19,12.08, 12/18/17,33.28,17.34,175.03,1077.14,12.16, 12/19/17,33.69,17.17,173.16,1070.68,12.19, 12/20/17,34.22,17.04,172.98,1064.95,12.22, 12/21/17,35.51,17.06,173.63,1063.63,12.13, 12/22/17,34.95,17.09,173.63,1060.12,12.08, 12/26/17,35.19,17.13,169.22,1056.74,12.10, 12/27/17,34.86,17.09,169.25,1049.37,12.01, 12/28/17,35.58,17.07,169.73,1048.14,12.08, 12/29/17,35.03,17.15,167.90,1046.40,12.00, 1/2/18,37.25,17.68,170.90,1065.00,12.16, 1/3/18,37.32,17.84,170.87,1082.48,12.26, 1/4/18,37.70,18.22,171.67,1086.40,12.47, 1/5/18,38.32,18.23,173.62,1102.23,12.68, 1/8/18,39.24,17.97,172.98,1106.94,12.63, 1/9/18,38.24,18.25,172.96,1106.26,12.56, 1/10/18,39.03,18.61,172.92,1102.61,12.52, 1/11/18,39.34,18.70,173.90,1105.52,12.64, 1/12/18,38.97,18.44,175.69,1122.26,12.71, 1/16/18,38.50,17.90,174.80,1121.76,12.58, 1/17/18,39.13,17.06,177.69,1131.98,11.70, 1/18/18,38.86,16.49,177.85,1129.79,11.59, 1/19/18,38.60,15.98,177.05,1137.51,11.53, 1/22/18,39.13,15.90,175.60,1155.81,11.55, 1/23/18,39.88,16.60,175.64,1169.97,11.49, 1/24/18,39.81,16.16,172.85,1164.24,11.57, 1/25/18,40.09,15.91,169.76,1170.37,11.11, 1/26/18,40.77,15.86,170.16,1175.84,11.19, 1/29/18,40.97,16.00,166.64,1175.58,10.82, 1/30/18,38.44,15.68,165.65,1163.69,10.76, 1/31/18,37.24,15.90,166.11,1169.94,10.67, 2/1/18,36.45,15.75,166.46,1167.70,10.63, 2/2/18,34.43,15.38,159.23,1111.90,10.42, 2/5/18,33.87,14.66,155.26,1055.80,9.96, 2/6/18,35.15,15.01,161.74,1080.60,10.47, 2/7/18,35.17,14.99,158.28,1048.58,10.47, 2/8/18,33.85,14.21,153.93,1001.52,10.15, 2/9/18,34.14,14.69,155.81,1037.78,10.25, 2/12/18,36.11,14.57,162.08,1051.94,10.41, 2/13/18,36.69,14.42,163.71,1052.10,10.30, 2/14/18,38.57,14.65,166.73,1069.70,10.45, 2/15/18,38.87,14.60,172.33,1089.52,10.47, 2/16/18,44.61,14.80,171.77,1094.80,10.32, 2/20/18,44.69,14.49,171.19,1102.46,10.34, 2/21/18,42.73,14.24,170.41,1111.34,10.31, 2/22/18,42.85,14.37,171.84,1106.63,10.34, 2/23/18,43.39,14.36,174.83,1126.79,10.41, 2/26/18,44.23,14.52,178.28,1143.75,10.60, 2/27/18,43.87,14.37,177.70,1118.29,10.32, 2/28/18,43.38,13.99,177.44,1104.73,10.32, 3/1/18,45.87,13.90,174.33,1069.52,10.01, 3/2/18,45.25,14.00,175.53,1078.92,10.12, 3/5/18,44.61,14.29,176.14,1090.93,10.30, 3/6/18,44.39,14.51,175.99,1095.06,10.34, 3/7/18,45.55,14.38,174.36,1109.64,10.34, 3/8/18,44.22,14.39,176.26,1126.00,10.32, 3/9/18,43.56,14.81,179.29,1160.04,10.44, 3/12/18,43.44,14.97,181.02,1164.50,10.52, 3/13/18,40.12,14.30,179.28,1138.17,10.49, 3/14/18,38.26,14.14,177.75,1149.49,10.72, 3/15/18,38.31,14.23,177.96,1149.58,10.77, 3/16/18,39.84,14.18,177.34,1135.73,10.85, 3/19/18,38.94,13.95,174.63,1099.82,10.71, 3/20/18,38.40,13.52,174.57,1097.71,10.69, 3/21/18,38.64,13.76,170.61,1090.88,10.80, 3/22/18,34.39,13.23,168.20,1049.08,10.46, 3/23/18,33.84,12.96,164.31,1021.57,10.28, 3/26/18,35.29,12.78,172.11,1053.21,10.54, 3/27/18,33.57,13.32,167.69,1005.10,10.54, 3/28/18,33.44,13.56,165.84,1004.56,10.57, 3/29/18,35.08,13.36,167.14,1031.79,10.78, 4/2/18,34.12,13.00,166.04,1006.47,10.57, 4/3/18,34.89,13.01,167.74,1013.41,10.85, 4/4/18,34.88,13.16,170.95,1025.14,11.03, 4/5/18,36.50,13.31,172.14,1027.81,11.04, 4/6/18,34.39,12.95,167.73,1007.04,10.88, 4/9/18,34.68,12.72,169.40,1015.45,10.95, 4/10/18,35.77,12.94,172.58,1031.64,11.14, 4/11/18,34.63,12.86,171.78,1019.97,11.12, 4/12/18,35.77,13.06,173.47,1032.51,11.01, 4/13/18,35.40,13.37,174.06,1029.27,10.98, 4/16/18,35.64,13.21,175.14,1037.98,11.07, 4/17/18,36.25,13.67,177.56,1074.16,11.07, 4/18/18,37.39,13.54,177.16,1072.08,11.03, 4/19/18,37.23,13.87,172.14,1087.70,10.81, 4/20/18,36.54,14.41,165.08,1072.96,10.67, 4/23/18,36.42,14.39,164.61,1067.45,10.89, 4/24/18,36.36,14.55,162.31,1019.98,10.81, 4/25/18,36.94,13.93,163.02,1021.18,10.96, 4/26/18,37.59,14.25,163.59,1040.04,11.27, 4/27/18,32.27,14.25,161.70,1030.05,11.33, 4/30/18,33.73,13.95,164.63,1017.33,11.08, 5/1/18,32.09,13.93,168.45,1037.31,11.10, 5/2/18,32.15,14.06,175.89,1024.38,11.05, 5/3/18,32.81,13.81,176.21,1023.72,11.04, 5/4/18,34.41,13.98,183.12,1048.21,11.20, 5/7/18,34.40,13.95,184.45,1054.79,11.18, 5/8/18,34.49,14.14,185.34,1053.91,11.11, 5/9/18,34.90,14.49,186.64,1082.76,10.91, 5/10/18,35.84,14.56,189.31,1097.57,11.05, 5/11/18,35.70,14.47,188.59,1098.26,11.03, 5/14/18,36.24,14.58,188.15,1100.20,11.03, 5/15/18,35.80,14.58,186.44,1079.23,11.06, 5/16/18,37.45,14.90,188.18,1081.77,11.24, 5/17/18,37.48,14.90,186.99,1078.59,11.30, 5/18/18,36.40,14.84,186.31,1066.36,11.17, 5/21/18,35.00,15.13,187.63,1079.58,11.35, 5/22/18,35.75,15.16,187.16,1069.73,11.36, 5/23/18,35.38,14.06,188.36,1079.69,11.28, 5/24/18,35.71,14.47,188.15,1079.24,11.46, 5/25/18,35.33,14.50,188.58,1075.66,11.35, 5/29/18,35.16,14.06,187.90,1060.32,11.28, 5/30/18,36.19,14.05,187.50,1067.80,11.39, 5/31/18,36.81,13.96,186.87,1084.99,11.39, 6/1/18,37.63,13.98,190.24,1119.50,11.55, 6/4/18,37.21,13.59,191.83,1139.29,11.58, 6/5/18,36.80,13.68,193.31,1139.66,11.67, 6/6/18,37.49,13.52,193.98,1136.88,11.80, 6/7/18,36.76,13.66,193.46,1123.86,11.86, 6/8/18,37.10,13.81,191.70,1120.87,11.93, 6/11/18,37.02,13.86,191.23,1129.99,11.86, 6/12/18,37.52,13.86,192.28,1139.32,11.94, 6/13/18,37.32,13.77,190.70,1134.79,11.85, 6/14/18,37.56,13.52,190.80,1152.12,11.73, 6/15/18,35.99,13.30,188.84,1152.26,11.72, 6/18/18,36.06,13.20,188.74,1173.46,11.82, 6/19/18,35.09,12.95,185.69,1168.06,11.73, 6/20/18,35.67,12.88,186.50,1169.84,11.71, 6/21/18,35.34,12.76,185.46,1157.66,11.55, 6/22/18,36.85,13.05,184.92,1155.48,11.49, 6/25/18,34.46,12.75,182.17,1124.81,11.34, 6/26/18,35.27,13.74,184.43,1118.46,11.36, 6/27/18,34.41,13.96,184.16,1103.98,11.26, 6/28/18,34.59,13.83,185.50,1114.22,11.12, 6/29/18,34.69,13.61,185.11,1115.65,10.92, 7/2/18,35.07,13.37,187.18,1127.46,10.95, 7/3/18,33.88,13.37,183.92,1102.89,10.84, 7/5/18,34.92,13.43,185.40,1124.27,10.90, 7/6/18,35.28,13.85,187.97,1140.17,10.91, 7/9/18,35.47,13.95,190.58,1154.05,11.04, 7/10/18,36.47,14.17,190.35,1152.84,11.09, 7/11/18,36.22,13.99,187.88,1153.90,10.92, 7/12/18,35.88,13.99,191.03,1183.48,10.90, 7/13/18,36.15,13.89,191.33,1188.82,10.83, 7/16/18,35.87,13.90,190.91,1183.86,10.70, 7/17/18,36.35,13.69,191.45,1198.80,10.71, 7/18/18,37.71,13.75,190.40,1195.88,10.72, 7/19/18,36.87,13.73,191.88,1186.96,10.67, 7/20/18,37.07,13.12,191.44,1184.91,10.56, 7/23/18,37.38,12.99,191.61,1205.50,10.47, 7/24/18,37.81,13.12,193.00,1248.08,10.57, 7/25/18,38.20,13.11,194.82,1263.70,10.52, 7/26/18,37.18,13.15,194.21,1268.33,9.89, 7/27/18,36.94,13.06,190.98,1238.50,9.93, 7/30/18,36.75,13.16,189.91,1219.74,10.07, 7/31/18,36.37,13.63,190.29,1217.26,10.04, 8/1/18,35.75,13.24,201.50,1220.01,9.90, 8/2/18,32.08,13.17,207.39,1226.15,9.92, 8/3/18,32.25,13.14,207.99,1223.71,10.04, 8/6/18,31.44,13.10,209.07,1224.77,10.03, 8/7/18,31.18,13.16,207.11,1242.22,10.08, 8/8/18,30.77,13.05,207.25,1245.61,10.05,

//============================================================================= // Solution Code //============================================================================= //============================================================================= // PROGRAMMER: // PANTHER ID: // // CLASS: // SECTION: // SEMESTER: // CLASSTIME: // // Project: #1 // DUE: // // CERTIFICATION: I certify that this work is my own and that // none of it is the work of any other person. //=============================================================================

package project1;

//-------------------------------------------------- // Imports //-------------------------------------------------- import java.io.*; import java.util.*;

public class Project1 {

public static void main(String[] args) { // The name of the file to open. // notice that the StockPrice_X_Data.txt is in the data package String fileName = "src/data/Stock_Data.txt";

// This will reference one line at a time String line = null; try { // FileReader reads text files in the default encoding. FileReader fileReader = new FileReader(fileName);

// Always wrap FileReader in BufferedReader. BufferedReader bufferedReader = new BufferedReader(fileReader); //PUT CODE HERE

// Always close files. bufferedReader.close();

//------------------------------------------------------------------ // Doing some calculations //------------------------------------------------------------------ //PUT CODE HERE // handle errors if they arise } catch(FileNotFoundException ex) { System.out.println( "Unable to open file '" + fileName + "'"); } catch(IOException ex) { System.out.println( "Error reading file '" + fileName + "'"); }//end try

}// end main() //------------------------------------------------------------------------------ // helper functions/ //------------------------------------------------------------------------------ public static double findAverage(ArrayList prices){ double average = 0.0; //PUT CODE HERE return average; }//end findAverage() //-------------------------------------------------------------------------- public static double findStandardDeviation(ArrayList prices){ double stdDev = 0.0; //PUT CODE HERE return stdDev; }

//-------------------------------------------------------------------------- public static double findCorrelation(ArrayList firstPrices, ArrayList secondPrices ){ double correlation = 0.0 ; //PUT CODE HERE return correlation; }//end findCorrelation() }

desired output:

Output Projectl (run) run: 1 0.1%-0.11 [1:0, -0.19, [-0.79, 1., -0.75, -0.78, 0.151 0.57, -0.75, 1.0, 0.84,-0.051 [0.75, -0.78, 0.84, 1.0, -0.07] [-0.1, 0.15, -0.05, -0.07, 1.0 BUILD SUCCESSFUL (total time: 0 seconds) 0.57