Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hi! i am looking for help on questions 2&3. you dont techincally have to solve them, just help me figure out how to solve them

hi! i am looking for help on questions 2&3. you dont techincally have to solve them, just help me figure out how to solve them snd i can input it into excel! im confused on what formulasumbers i should be using
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
This SA Onde ending ding the periode 2014 Dec re mend you can visby 1 Caterie how 1 sty Sorry w SPY OD 13 andando 110 income of Powity maddedewer. PLACE GARI 3. Tay Howie SPY (15 pinay the SP and ODI U them wpis CALent to the bed above. Cep which you CAL, the people Welt in SPY WeinGO PLACE GRAPHER Date SPY EEM LOD 1/1/2014 156.1304 33.20625 93.21604 2/1/2014 163.2367 34.32789 94.00126 3/1/2014 163,8676 35.65823 93.97791 4/1/2014 165.735 35.93648 95.23116 5/1/2014 169.5811 36.99727 96.67294 6/1/2014 172.2568 37.58852 96.68765 7/1/2014 170.7563 38.4029296.38443 8/1/2014 177.495 39.48964 98 30694 9/1/2014 174.2318 36.42231 96.65926 10/1/2014 179.1687 36.93937 97.84923 11/1/2014 184,0909 35.36972 98.74403 12/1/2014 182.616 34,43293 98.46129 1/1/2015 178.1832 34.68817 102.7194 2/1/2015 188. 1979 36.21723 100.9865 3/1/2015 184,419 35.67494 101.1855 4/1/2015 187.0638 38.11966 99.98241 5/1/2015 189.4687 36.55504 98.85751 6/1/2015 184.7217 35.22156 96.99291 7/1/2015 189,813233.24466 97.79305 8/1/2015 179.5877 30.30709 96.98533 9/1/2015 172.7977 29.35776 98.1319 10/1/2015 189.3407 31.22956 98.6982 11/1/2015 189.1595 30.44144 98.54937 12/1/2015 184.7905 28.82936 97.21034 1/1/2016 176.6355 27.80514 97.882 2/1/2016 175.4895 27.57775 98.61945 3/1/2016 187.3948 31.15231 102 1882 4/1/2016 189.1037 31.27965 103.7891 5/1/2016 192.3206 30.12451 103.2669 6/1/2016 191.9907 31.25236 106.452 7/1/2016 200.0276 33.19382 107.8378 8/1/2016 200,2672 33.48717 108.0422 9/1/2016 199.2722 34.33053 107.7036 10/1/2016 196.8066 34.04635 106.0539 11/1/2016 204.0566 32.54296 102.6931 12/1/2016 206.9733 32.09377 103.2634 1/1/2017 211.9188 34.62107 103.9785 2/1/2017 220.2454 35.22374 105.0683 3/1/2017 219.5655 36.5218 104.7567 4/1/2017 222.7096 37.14301 106.0032 5/1/2017 225.8527 38.20001 107.4154 2/1/2016 176.4895 27.57775 98.61945 3/1/2016 187.3948 31.15231 102.1882 4/1/2016 189.1037 31.27965 103.7891 5/1/2016 192.3206 30.12451 103.2669 6/1/2016 191.9907 31.25236 106.452 7/1/2016 200.0276 33.19382 107.8378 8/1/2016 200.2672 33.48717 108.0422 9/1/2016 199.2722 34.33053 107.7036 10/1/2016 196.8066 34.04635 106.0539 11/1/2016 204.0566 32.54296 102.6931 12/1/2016 206.9733 32.09377 103.2634 1/1/2017 211.9188 34.62107 103.9785 2/1/2017 220.2454 35.22374 105.0683 3/1/2017 219.5655 36.5218 104.7567 4/1/2017 222.7096 37.14301 106.0032 5/1/2017 225.8527 38.20001 107.4154 6/1/2017 226.1894 38.37617 107.9398 7/1/2017 231.964340.79885 108.763 8/1/2017 232.6411 41.75828 109.5027 9/1/2017 236.1567 41.73965 109.448 10/1/2017 242.9211 43.10892 109.6552 11/1/2017 250.3462 42.94125 109.1948 12/1/2017 252.0938 43.89137 110.6225 1/1/2018 267.6628 48.2538 109.7904 2/1/2018 257.9305 45.40755 107.0472 3/1/2018 249.8598 45.6534 107.6275 4/1/2018 252.157 44.3674 105.9366 5/1/2018 258.2867 43.20431 106.4906 6/1/2018 258.6108 40.97271 105.9448 7/1/2018 269.3957 42.69659 107.379 8/1/2018 277.9948 41.08809 107.4056 9/1/2018 278.3874 40.85015 107.2489 10/1/2018 260.3228 37.27148 105.046 11/1/2018 265.1516 39.09889 104.6458 12/1/2018 240.4015 37.1763 106.272 SPY EEM LQD Date 1/1/2014 156.1304 33.20625 93.21604 2/1/2014 163.2367 34.32789 94.00126 3/1/2014 163.8676 35.65823 93.97791 4/1/2014 165.735 35.93648 95.23116 5/1/2014 169.5811 36.99727 96.67294 6/1/2014 172.2568 37.58852 96.68765 7/1/2014 170.7563 38.40292 96.38443 8/1/2014 177.495 39.48964 98.30694 9/1/2014 174.2318 36.42231 96.65926 10/1/2014 179.1687 36.93937 97.84923 11/1/2014 184.090936.36972 98.74403 12/1/2014 182.616 34.43293 98.46129 1/1/2015 178.1832 34.68817 102.7194 2/1/2015 188.1979 36.21723 100.9865 3/1/2015 184.419 35.67494 101.1855 4/1/2015 187,0638 38.11966 99.98241 5/1/2015 189.4687 36.55504 98.85751 6/1/2015 184.7217 35.22156 96.99291 7/1/2015 189.813233.24466 97.79305 8/1/2015 179.5877 30.30709 96.98533 9/1/2015 172.7977 29.35776 98.1319 10/1/2015 189.3407 31.22956 98.6982 11/1/2015 189.1595 30.44144 98.54937 12/1/2015 184.7905 28.82936 97.21034 1/1/2016 176.6355 27.80514 97.882 2/1/2016 176.4895 27.57775 98.61945 3/1/2016 187.3948 31.15231 102.1882 4/1/2016 189.1037 31.27965 103.7891 5/1/2016 192.3206 30.12451 103.2669 6/1/2016 191.9907 31.25236 106.452 6/1/2016 191.9907 31.25236 106.452 7/1/2016 200.0276 33.19382 107.8378 8/1/2016 200.2672 33.48717 108.0422 9/1/2016 199.2722 34.33053 107.7036 10/1/2016 196.8066 34.04635 106.0539 11/1/2016 204.0566 32.54296 102.6931 12/1/2016 206.9733 32.09377 103.2634 1/1/2017 211.9188 34.62107 103.9785 2/1/2017 220.2454 35.22374 105.0683 3/1/2017 219.5655 36.5218 104.7567 4/1/2017 222.7096 37.14301 106.0032 5/1/2017 225.8527 38.20001 107.4154 6/1/2017 226.1894 38.37617 107.9398 7/1/2017 231.964340.79885 108.763 8/1/2017 232.6411 41.75828 109.5027 9/1/2017 236.1567 41.73965 109.448 10/1/2017 242.9211 43.10892 109.6552 11/1/2017 250.3462 42.94125 109.1948 12/1/2017 252.0938 43.89137 110.6225 1/1/2018 267.6628 48.2538 109.7904 2/1/2018 257.9305 45.40755 107.0472 3/1/2018 249.8598 45.6534 107.6275 4/1/2018 252.157 44.3674 105.9366 5/1/2018 258.2867 43.20431 106.4906 6/1/2018 258.6108 40.97271 105.9448 7/1/2018 269.3957 42.69659 107.379 8/1/2018 277.9948 4108809 107.4056 9/1/2018 278.3874 40.85015 107.2489 10/1/2018 260.3228 37.27148 105.046 11/1/2018 265.1516 39.09889 104.6458 12/1/2018 240.4015 37.1763 106.272 This projects that forenky SPY (SAP 500 ETT LOD wenigde boods FM More for the hearing the prim 2014 through 2018 spreml Projects. Cha Tales and you did this by 13 the myride televide Beers Care/printstoly me the expected them the color och we 2. Opp Setary and IOC del POD V 110 Powe wum aldri. 10, IRACE Terwyl COLOD CAL CAL die This SA Onde ending ding the periode 2014 Dec re mend you can visby 1 Caterie how 1 sty Sorry w SPY OD 13 andando 110 income of Powity maddedewer. PLACE GARI 3. Tay Howie SPY (15 pinay the SP and ODI U them wpis CALent to the bed above. Cep which you CAL, the people Welt in SPY WeinGO PLACE GRAPHER Date SPY EEM LOD 1/1/2014 156.1304 33.20625 93.21604 2/1/2014 163.2367 34.32789 94.00126 3/1/2014 163,8676 35.65823 93.97791 4/1/2014 165.735 35.93648 95.23116 5/1/2014 169.5811 36.99727 96.67294 6/1/2014 172.2568 37.58852 96.68765 7/1/2014 170.7563 38.4029296.38443 8/1/2014 177.495 39.48964 98 30694 9/1/2014 174.2318 36.42231 96.65926 10/1/2014 179.1687 36.93937 97.84923 11/1/2014 184,0909 35.36972 98.74403 12/1/2014 182.616 34,43293 98.46129 1/1/2015 178.1832 34.68817 102.7194 2/1/2015 188. 1979 36.21723 100.9865 3/1/2015 184,419 35.67494 101.1855 4/1/2015 187.0638 38.11966 99.98241 5/1/2015 189.4687 36.55504 98.85751 6/1/2015 184.7217 35.22156 96.99291 7/1/2015 189,813233.24466 97.79305 8/1/2015 179.5877 30.30709 96.98533 9/1/2015 172.7977 29.35776 98.1319 10/1/2015 189.3407 31.22956 98.6982 11/1/2015 189.1595 30.44144 98.54937 12/1/2015 184.7905 28.82936 97.21034 1/1/2016 176.6355 27.80514 97.882 2/1/2016 175.4895 27.57775 98.61945 3/1/2016 187.3948 31.15231 102 1882 4/1/2016 189.1037 31.27965 103.7891 5/1/2016 192.3206 30.12451 103.2669 6/1/2016 191.9907 31.25236 106.452 7/1/2016 200.0276 33.19382 107.8378 8/1/2016 200,2672 33.48717 108.0422 9/1/2016 199.2722 34.33053 107.7036 10/1/2016 196.8066 34.04635 106.0539 11/1/2016 204.0566 32.54296 102.6931 12/1/2016 206.9733 32.09377 103.2634 1/1/2017 211.9188 34.62107 103.9785 2/1/2017 220.2454 35.22374 105.0683 3/1/2017 219.5655 36.5218 104.7567 4/1/2017 222.7096 37.14301 106.0032 5/1/2017 225.8527 38.20001 107.4154 2/1/2016 176.4895 27.57775 98.61945 3/1/2016 187.3948 31.15231 102.1882 4/1/2016 189.1037 31.27965 103.7891 5/1/2016 192.3206 30.12451 103.2669 6/1/2016 191.9907 31.25236 106.452 7/1/2016 200.0276 33.19382 107.8378 8/1/2016 200.2672 33.48717 108.0422 9/1/2016 199.2722 34.33053 107.7036 10/1/2016 196.8066 34.04635 106.0539 11/1/2016 204.0566 32.54296 102.6931 12/1/2016 206.9733 32.09377 103.2634 1/1/2017 211.9188 34.62107 103.9785 2/1/2017 220.2454 35.22374 105.0683 3/1/2017 219.5655 36.5218 104.7567 4/1/2017 222.7096 37.14301 106.0032 5/1/2017 225.8527 38.20001 107.4154 6/1/2017 226.1894 38.37617 107.9398 7/1/2017 231.964340.79885 108.763 8/1/2017 232.6411 41.75828 109.5027 9/1/2017 236.1567 41.73965 109.448 10/1/2017 242.9211 43.10892 109.6552 11/1/2017 250.3462 42.94125 109.1948 12/1/2017 252.0938 43.89137 110.6225 1/1/2018 267.6628 48.2538 109.7904 2/1/2018 257.9305 45.40755 107.0472 3/1/2018 249.8598 45.6534 107.6275 4/1/2018 252.157 44.3674 105.9366 5/1/2018 258.2867 43.20431 106.4906 6/1/2018 258.6108 40.97271 105.9448 7/1/2018 269.3957 42.69659 107.379 8/1/2018 277.9948 41.08809 107.4056 9/1/2018 278.3874 40.85015 107.2489 10/1/2018 260.3228 37.27148 105.046 11/1/2018 265.1516 39.09889 104.6458 12/1/2018 240.4015 37.1763 106.272 SPY EEM LQD Date 1/1/2014 156.1304 33.20625 93.21604 2/1/2014 163.2367 34.32789 94.00126 3/1/2014 163.8676 35.65823 93.97791 4/1/2014 165.735 35.93648 95.23116 5/1/2014 169.5811 36.99727 96.67294 6/1/2014 172.2568 37.58852 96.68765 7/1/2014 170.7563 38.40292 96.38443 8/1/2014 177.495 39.48964 98.30694 9/1/2014 174.2318 36.42231 96.65926 10/1/2014 179.1687 36.93937 97.84923 11/1/2014 184.090936.36972 98.74403 12/1/2014 182.616 34.43293 98.46129 1/1/2015 178.1832 34.68817 102.7194 2/1/2015 188.1979 36.21723 100.9865 3/1/2015 184.419 35.67494 101.1855 4/1/2015 187,0638 38.11966 99.98241 5/1/2015 189.4687 36.55504 98.85751 6/1/2015 184.7217 35.22156 96.99291 7/1/2015 189.813233.24466 97.79305 8/1/2015 179.5877 30.30709 96.98533 9/1/2015 172.7977 29.35776 98.1319 10/1/2015 189.3407 31.22956 98.6982 11/1/2015 189.1595 30.44144 98.54937 12/1/2015 184.7905 28.82936 97.21034 1/1/2016 176.6355 27.80514 97.882 2/1/2016 176.4895 27.57775 98.61945 3/1/2016 187.3948 31.15231 102.1882 4/1/2016 189.1037 31.27965 103.7891 5/1/2016 192.3206 30.12451 103.2669 6/1/2016 191.9907 31.25236 106.452 6/1/2016 191.9907 31.25236 106.452 7/1/2016 200.0276 33.19382 107.8378 8/1/2016 200.2672 33.48717 108.0422 9/1/2016 199.2722 34.33053 107.7036 10/1/2016 196.8066 34.04635 106.0539 11/1/2016 204.0566 32.54296 102.6931 12/1/2016 206.9733 32.09377 103.2634 1/1/2017 211.9188 34.62107 103.9785 2/1/2017 220.2454 35.22374 105.0683 3/1/2017 219.5655 36.5218 104.7567 4/1/2017 222.7096 37.14301 106.0032 5/1/2017 225.8527 38.20001 107.4154 6/1/2017 226.1894 38.37617 107.9398 7/1/2017 231.964340.79885 108.763 8/1/2017 232.6411 41.75828 109.5027 9/1/2017 236.1567 41.73965 109.448 10/1/2017 242.9211 43.10892 109.6552 11/1/2017 250.3462 42.94125 109.1948 12/1/2017 252.0938 43.89137 110.6225 1/1/2018 267.6628 48.2538 109.7904 2/1/2018 257.9305 45.40755 107.0472 3/1/2018 249.8598 45.6534 107.6275 4/1/2018 252.157 44.3674 105.9366 5/1/2018 258.2867 43.20431 106.4906 6/1/2018 258.6108 40.97271 105.9448 7/1/2018 269.3957 42.69659 107.379 8/1/2018 277.9948 4108809 107.4056 9/1/2018 278.3874 40.85015 107.2489 10/1/2018 260.3228 37.27148 105.046 11/1/2018 265.1516 39.09889 104.6458 12/1/2018 240.4015 37.1763 106.272 This projects that forenky SPY (SAP 500 ETT LOD wenigde boods FM More for the hearing the prim 2014 through 2018 spreml Projects. Cha Tales and you did this by 13 the myride televide Beers Care/printstoly me the expected them the color och we 2. Opp Setary and IOC del POD V 110 Powe wum aldri. 10, IRACE Terwyl COLOD CAL CAL die

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions