Loan ID	Balance	FICO
1	$6,700	796
2	$14,700	627
3	$3,600	648
4	$14,000	617
5	$2,700	843
6	$13,500	563
7	$8,000	644
8	$10,400	836
9	$3,100	784
10	$9,800	692
11	$7,500	741
12	$6,700	599
13	$12,700	675
14	$13,300	628
15	$13,400	644
16	$9,600	789
17	$8,900	707
18	$5,300	762
19	$14,600	590
20	$6,400	688
21	$7,300	732
22	$8,300	648
23	$5,100	669
24	$11,900	751
25	$6,200	626
26	$2,800	645
27	$10,100	760
28	$14,700	777
29	$5,900	739
30	$12,300	695
31	$3,300	674
32	$12,800	573
33	$11,900	617
34	$2,800	613
35	$8,500	575
36	$14,000	645
37	$3,800	610
38	$6,200	594
39	$14,200	790
40	$12,000	733
41	$3,000	619
42	$11,800	657
43	$10,000	612
44	$4,000	586
45	$12,900	634
46	$2,200	628
47	$4,500	713
48	$7,600	764
49	$10,900	767
50	$11,300	814
51	$9,300	676
52	$12,800	595
53	$10,000	717
54	$3,400	625
55	$7,400	840
56	$9,300	657
57	$4,900	774
58	$13,200	613
59	$7,600	684
60	$12,700	801
61	$2,900	749
62	$13,600	754
63	$2,600	561
64	$5,000	552
65	$4,500	787
66	$13,500	578
67	$2,500	640
68	$10,600	557
69	$10,400	771
70	$13,600	696
71	$13,500	557
72	$6,400	774
73	$10,300	749
74	$7,900	818
75	$13,500	808
76	$7,200	607
77	$15,000	830
78	$11,500	798
79	$13,700	659
80	$13,600	844
81	$12,200	640
82	$11,700	594
83	$6,800	818
84	$3,700	601
85	$12,700	844
86	$9,400	819
87	$5,600	799
88	$14,200	649
89	$14,300	575
90	$7,900	686
91	$4,400	745
92	$15,000	588
93	$13,700	808
94	$8,100	626
95	$13,100	674
96	$5,200	704
97	$8,800	742
98	$9,000	791
99	$5,500	585
100	$4,700	838

FIRST 100 DATE FROM EXCEL, apply the equations just for the first 100

Task: Using the "Sample Loan Data" dataset, write formulas to find the average interest rate for the 1000 loans in the portfolio. The loan rates are determined based on the FICO scores based on the following table: FICO Range 801 - 850 751 - 800 701 - 750 651 - 700 550 - 650 Interest Rate 3.20% 3.50% 4.00% 5.00% 7.50% Use approximate matching techniques to join the interest rates to the loan data. Deliverable: On a blank piece of paper, write your name, the date and the following values: 1. The (simple) average interest rate for the 1000 loans 2. The weighted average interest rate (based on loan balance) for the 1000 loans Complete this assignment using the Sample Loan Data in excel and submit your excel file. Use the VLOOKUP function to match Fico Scores and Interest rates. Use AVERAGE, SUM and SUMPRODUCT functions to calculate average and weighted averages