L$34$

$6-$ The table below contains daily Bitcoin prices. Create a pivot table that summarizes returns by year and another pivot table that summarizes returns by day of the week. Analyze the results of the pivot table.

$2$ points

$\backslash$table$[[,$Open,Close,Day of wee,Return$],[40375,0\mathrm{.}04951,0\mathrm{.}04951,$Fri,$0],[40376,0\mathrm{.}04951,0\mathrm{.}08584,$Sat,$0\mathrm{.}7337912],[40377,0\mathrm{.}08584,0\mathrm{.}0808,$Sun,$-0\mathrm{.}0587139],[40378,0\mathrm{.}0808,0\mathrm{.}07474,$Mon,$-0\mathrm{.}075],[40379,0\mathrm{.}07474,0\mathrm{.}07921,$Tue,$0\mathrm{.}0598073],[40380,0\mathrm{.}07921,0\mathrm{.}0505,$Wed,$-0\mathrm{.}3624542],[40381,0\mathrm{.}0505,0\mathrm{.}06262,$Thu,$0\mathrm{.}24],[40382,0\mathrm{.}06262,0\mathrm{.}05454,$Fri,$-0\mathrm{.}1290323],[40383,0\mathrm{.}05454,0\mathrm{.}0505,$Sat,$-0\mathrm{.}0740741],[40384,0\mathrm{.}0505,0\mathrm{.}056$ :$,$Sun,$0\mathrm{.}1089109],[40385,0\mathrm{.}056,0\mathrm{.}06,$Mon,$0\mathrm{.}0714286],[40386,0\mathrm{.}06,0\mathrm{.}0589,$Tue,$-0\mathrm{.}0183333],[40387,0\mathrm{.}0589,0\mathrm{.}0699,$Wed,$0\mathrm{.}1867572],[40388,0\mathrm{.}0699,0\mathrm{.}0627,$Thu,$-0\mathrm{.}1030043],[40389,0\mathrm{.}0627,0\mathrm{.}06785,$Fri,$0\mathrm{.}0821372],[40390,0\mathrm{.}06785,0\mathrm{.}0611,$Sat,$-0\mathrm{.}0994842],[40391,0\mathrm{.}0611,0\mathrm{.}06,$Sun,$-0\mathrm{.}0180033],[40392,0\mathrm{.}06,0\mathrm{.}06,$Mon,$0],[40393,0\mathrm{.}06,0\mathrm{.}057,$Tue,$-0\mathrm{.}05],[40394,0\mathrm{.}057,0\mathrm{.}061,$Wed,$0\mathrm{.}0701754],[40395,0\mathrm{.}061,0\mathrm{.}0623,$Thu,$0\mathrm{.}0213115],[40396,0\mathrm{.}0623,0\mathrm{.}059,$Fri,$-0\mathrm{.}0529695],[40397,0\mathrm{.}059,0\mathrm{.}0609,$Sat,$0\mathrm{.}0322034],[40398,0\mathrm{.}0609,0\mathrm{.}071,$Sun,$0\mathrm{.}1658456],[40399,0\mathrm{.}071,0\mathrm{.}07,$Mon,$-0\mathrm{.}0140845],[40400,0\mathrm{.}07,0\mathrm{.}067,7$ Tue,$-0\mathrm{.}0428571],[40401,0\mathrm{.}067,0\mathrm{.}07,7$ Wed,$0\mathrm{.}0447761],[40402,0\mathrm{.}07,0\mathrm{.}0645,5$ Thu,$-0\mathrm{.}0785714],[40403,0\mathrm{.}0645,0\mathrm{.}067,7$ Fri,$0\mathrm{.}0387597],[40404,0\mathrm{.}067,,,]]$