MVCC Linear Algebra Programming Code Question

Any questions let me know. Assignment table is a csv file but it didn’t let me upload it so I turned it into an excel file, it can easily be converted back to .csv file

-1.07E+00
1.09E+00
-2.31E+00
-1.60E+00
-5.80E+00
-2.30E+00
-1.68E+00
-7.38E-01
-1.92E-01
-6.38E+00
-5.12E+00
-4.22E+00
-2.68E+00
-3.03E+00
-5.74E+00
-1.99E+00
-2.90E+00
-1.11E+00
-5.20E+00
-4.76E+00
-6.77E+00
-2.66E+00
-4.62E+00
-1.44E+00
-1.98E+00
-1.48E+00
-3.75E+00
-5.51E-01
-2.68E+00
-1.19E-01
7.09E-02
-6.03E+00
-6.44E+00
-7.91E-01
9.02E-02
-3.73E+00
-5.47E+00
-4.50E+00
-1.60E+00
-2.45E+00
-1.02E+00
9.24E+00
-6.95E+00
5.85E+00
8.45E+00
-3.78E+00
-4.66E+00
1.13E+01
-5.20E+00
-6.45E+00
-2.18E+00
-2.91E+00
9.05E+00
-2.33E+00
1.87E+00
-7.26E-01
4.29E+00
1.10E+01
1.03E+01
-1.60E+00
-1.97E+00
-3.57E+00
3.34E+00
1.06E+01
1.12E+01
9.73E+00
4.02E+00
9.16E+00
-2.20E+00
5.58E+00
1.05E+01
1.27E+01
-1.02E+00
1.19E-01
-5.63E+00
-4.25E+00
-2.41E+00
-1.29E+00
-1.30E+00
7.09E+00
6.36E+00
1.35E+01
-7.17E+00
-2.09E+00
-3.09E+00
-6.82E-01
1.64E+00
-1.81E+00
-1.22E-01
-1.65E+00
-4.19E+00
-1.11E+00
-7.63E+00
-3.07E-01
-1.24E+00
-1.86E-01
7.29E-01
-1.70E+00
-5.03E+00
-6.22E+00
-2.91E+00
-1.38E+00
-5.58E-01
-5.69E+00
-2.77E+00
-1.53E+00
-3.23E+00
9.87E-01
-4.43E+00
-3.17E+00
-4.75E+00
1.02E+00
-6.14E+00
-3.43E+00
1.28E+00
-3.16E+00
1.14E-02
-5.41E+00
4.61E-01
-2.41E+00
-3.78E-01
-6.11E+00
-4.88E-01
-3.68E+00
6.60E+00
6.22E+00
-4.83E+00
-3.30E+00
9.57E+00
6.51E+00
6.38E+00
8.94E+00
-4.84E+00
-4.61E+00
5.26E+00
8.36E+00
2.58E+00
6.07E+00
-2.88E+00
7.61E-01
-6.57E-01
5.28E+00
-5.50E+00
-2.70E+00
7.95E+00
-5.79E+00
-5.43E+00
9.45E+00
-7.31E+00
3.35E+00
1.10E+01
7.90E+00
-4.65E+00
-2.93E+00
7.64E+00
-6.30E+00
6.36E+00
5.46E+00
-2.69E+00
4.69E+00
4.66E+00
-5.75E+00
-5.98E+00
6.37E+00
-5.73E+00
-4.89E+00
-5.92E+00
-7.45E+00
-3.39E+00
2.48E-01
-3.10E+00
-5.15E+00
-4.29E-01
-4.28E+00
4.56E-02
-5.05E+00
-2.41E+00
-2.27E+00
-1.58E-01
-2.20E+00
-5.01E-01
-2.55E+00
-7.89E+00
-1.53E+00
-3.69E+00
-1.31E+00
-1.49E+00
2.25E+00
-2.94E+00
-2.46E+00
-9.37E+00
-1.85E+00
-4.56E-02
-4.81E+00
-2.84E+00
-3.25E+00
-5.78E+00
-1.35E+00
-2.55E+00
-1.84E+00
-3.57E+00
5.19E+00
1.27E+00
-3.64E+00
-1.55E+00
-1.81E+00
-2.96E+00
-1.39E+00
-1.82E+00
1.10E+01
-5.04E+00
1.09E+01
-4.13E+00
-4.25E+00
1.08E+01
-4.60E+00
4.28E+00
5.08E+00
-1.54E+00
-1.15E+01
4.52E+00
-3.67E+00
5.08E+00
-3.17E+00
-5.87E+00
2.88E+00
1.20E+01
7.45E+00
-6.37E+00
4.37E+00
-3.48E+00
-2.04E+00
1.15E+01
-5.78E+00
-4.29E+00
1.06E+01
8.58E+00
-3.22E+00
4.38E+00
1.23E+01
1.17E+01
3.98E+00
-3.86E+00
8.69E+00
7.24E+00
8.16E+00
-1.75E+00
4.22E+00
-1.02E+00
-3.10E+00
-2.76E+00
-1.70E+00
1.01E+00
-3.64E+00
1.06E+00
-5.21E-01
4.74E-01
-1.16E+00
7.73E-01
1.15E-01
-6.17E-01
-2.77E+00
-5.25E+00
-3.86E+00
-8.02E-01
-2.36E+00
-2.00E+00
-6.65E+00
-5.58E+00
1.20E+00
-3.25E+00
1.18E+00
-6.91E+00
-1.77E+00
-6.65E+00
-3.71E+00
-3.71E-01
1.12E-01
-2.33E+00
-6.97E-01
-7.68E-01
-6.89E-01
3.20E+00
-1.67E+00
-3.41E-01
-7.63E-01
-2.16E+00
1.02E+01
-7.82E+00
1.09E+01
9.04E+00
5.72E+00
7.60E+00
-5.97E+00
-4.02E+00
-2.84E+00
-5.36E+00
2.92E+00
9.30E+00
3.35E+00
-4.98E+00
1.04E+01
8.52E+00
-2.08E+00
9.54E+00
5.96E+00
6.82E+00
-3.85E+00
-3.93E+00
1.14E+01
-5.36E+00
5.38E+00
-7.98E+00
-4.45E+00
9.19E+00
-2.12E+00
6.74E+00
-4.99E+00
-6.59E+00
7.06E+00
1.00E+01
-5.70E+00
-9.55E+00
-3.70E+00
4.67E+00
5.72E+00
-2.76E+00
-7.56E+00
-5.11E+00
-4.57E+00
-4.87E+00
-1.42E+00
1.86E+00
-4.26E-01
-1.36E+00
9.42E-02
-6.96E+00
1.08E+00
3.14E-02
-2.85E+00
-4.36E+00
-3.48E-01
-2.71E+00
-3.78E+00
1.26E+00
-1.45E+00
-2.26E+00
-3.09E+00
-6.37E+00
-6.12E-01
-6.24E+00
-5.34E+00
1.14E+00
2.33E+00
-2.96E+00
-3.03E+00
-3.50E+00
-5.24E-01
1.10E+00
-1.10E+00
-3.99E+00
-3.30E+00
-3.76E+00
-7.10E-01
-4.59E+00
-7.16E-01
-2.19E+00
5.21E+00
-9.24E+00
-4.88E+00
-3.73E+00
-4.06E+00
-8.82E-01
5.82E+00
-5.38E+00
7.52E+00
-2.95E+00
-4.33E+00
1.06E+01
4.13E+00
-7.85E+00
3.76E+00
5.57E+00
9.38E+00
-5.30E-02
-3.24E+00
-2.20E+00
1.29E+01
4.35E+00
-7.53E+00
2.59E+00
3.53E+00
-8.75E-01
7.48E+00
-4.86E+00
1.10E+01
-1.98E+00
6.38E+00
-1.57E+00
1.19E+01
Assignment 6
Please write your code in a Jupyter Notebook file (ipynb) and submit it on Blackboard
• Make sure to label your answer of each question clearly and add comments to make it
readable.
• You are allowed to discuss with other students (up to three) or the instructor. Please put
all the names of students that you discussed with. However individual students must write
their own solutions
• Copying a program, or letting someone else copy your program, is a form of academic
dishonesty
• Maximally leverage Piazza to benefit other students by your questions and answers.
• Try to be updated by checking notifications in both Piazza and the class webpage.
Q1. Linear Algebra (40pts)
Bob invested $10,000 on two mutual funds one year ago. After one year, the overall yield rates
for these two mutual funds are +2% and +4%. His yearend account showed $10,250. How much
did he initially put onto two mutual funds?
Q2. K-means Clustering
Load the data from attached file “Assignment_table.csv”.
• Create a histogram for the first and second column respectively (20 points)
• Conduct a clustering algorithm on these two columns. Try out 3,4,5 clusters respectively.
What do you think is the right number of clusters for this dataset? (40 points)