statistics assignment AAPL Historical Data DatePriceOpenHighLowVol.Change % 15-Jan-19152.8150.27152.89150.0616.82M1.87% 14-Jan-19150150.85151.24149.2232.44M-1.50%...

1 answer below »
see attached two files. this is a simple R programming homework assignment report.


statistics assignment AAPL Historical Data DatePriceOpenHighLowVol.Change % 15-Jan-19152.8150.27152.89150.0616.82M1.87% 14-Jan-19150150.85151.24149.2232.44M-1.50% 11-Jan-19152.29152.88153.7151.5127.02M-0.98% 10-Jan-19153.8152.5153.97150.8635.78M0.32% 9-Jan-19153.31151.29154.53149.6345.10M1.70% 8-Jan-19150.75149.56151.82148.5241.03M1.91% 7-Jan-19147.93148.7148.83145.954.78M-0.22% 4-Jan-19148.26144.53148.55143.858.61M4.27% 3-Jan-19142.19143.98145.7214291.31M-9.96% 2-Jan-19157.92154.89158.85154.2337.04M0.11% 31-Dec-18157.74158.53159.36156.4835.00M0.97% 28-Dec-18156.23157.5158.52154.5542.29M0.05% 27-Dec-18156.15155.84156.77150.0753.12M-0.65% 26-Dec-18157.17148.3157.23146.7258.58M7.04% 24-Dec-18146.83148.15151.55146.5937.17M-2.59% 21-Dec-18150.73156.86158.16149.6395.74M-3.89% 20-Dec-18156.83160.4162.11155.364.77M-2.52% 19-Dec-18160.89166167.45159.0949.05M-3.12% 18-Dec-18166.07165.38167.53164.3933.84M1.30% 17-Dec-18163.94165.45168.35162.7344.29M-0.93% 14-Dec-18165.48169169.08165.2840.70M-3.20% 13-Dec-18170.95170.49172.57169.5531.90M1.09% 12-Dec-18169.1170.4171.92169.0235.63M0.28% 11-Dec-18168.63171.66171.7916747.28M-0.57% 10-Dec-18169.6165170.09163.3362.03M0.66% 7-Dec-18168.49173.49174.49168.342.28M-3.57% 6-Dec-18174.72171.76174.78170.4243.10M-1.11% 4-Dec-18176.69180.95182.39176.2741.34M-4.40% 3-Dec-18184.82184.46184.94181.2140.80M3.49% 30-Nov-18178.58180.29180.33177.0339.53M-0.54% 29-Nov-18179.55182.66182.8177.741.77M-0.77% 28-Nov-18180.94176.73181.29174.9346.06M3.85% 27-Nov-18174.24171.51174.77170.8841.39M-0.22% 26-Nov-18174.62174.24174.95170.2645.00M1.35% 23-Nov-18172.29174.94176.59172.123.62M-2.54% 21-Nov-18176.78179.73180.27176.5531.12M-0.11% 20-Nov-18176.98178.37181.47175.5167.83M-4.78% 19-Nov-18185.86190190.7184.9941.92M-3.96% 16-Nov-18193.53190.5194.97189.4636.93M1.11% 15-Nov-18191.41188.39191.97186.946.48M2.47% 14-Nov-18186.8193.9194.48185.9360.80M-2.82% 13-Nov-18192.23191.63197.18191.4546.88M-1.00% 12-Nov-18194.17199199.85193.7951.14M-5.04% 9-Nov-18204.47205.55206.01202.2534.37M-1.93% 8-Nov-18208.49209.98210.12206.7525.36M-0.70% 7-Nov-18209.95205.97210.06204.1333.42M3.03% 6-Nov-18203.77201.92204.72201.6931.88M1.08% 5-Nov-18201.59204.3204.39198.1766.16M-2.84% 2-Nov-18207.48209.55213.65205.4391.33M-6.63% 1-Nov-18222.22219.05222.36216.8158.32M1.54% 31-Oct-18218.86216.88220.45216.6238.36M2.61% 30-Oct-18213.3211.15215.18209.2736.66M0.50% 29-Oct-18212.24219.19219.69206.0945.94M-1.88% 26-Oct-18216.3215.9220.19212.6747.26M-1.59% 25-Oct-18219.8217.71221.38216.7529.86M2.19% 24-Oct-18215.09222.6224.23214.5440.93M-3.43% 23-Oct-18222.73215.83223.25214.738.77M0.94% 22-Oct-18220.65219.79223.36218.9428.79M0.61% 19-Oct-18219.31218.06221.26217.4333.08M1.52% 18-Oct-18216.02217.86219.7421332.58M-2.34% 17-Oct-18221.19222.3222.64219.3422.89M-0.43% 16-Oct-18222.15218.93222.99216.7629.18M2.20% 15-Oct-18217.36221.16221.83217.2730.79M-2.14% 12-Oct-18222.11220.42222.88216.8440.34M3.57% 11-Oct-18214.45214.52219.5212.3253.12M-0.88% 10-Oct-18216.36225.46226.35216.0541.99M-4.63% 9-Oct-18226.87223.64227.27222.2526.89M1.39% 8-Oct-18223.77222.21224.8220.229.66M-0.23% 5-Oct-18224.29227.96228.41220.5833.58M-1.62% 4-Oct-18227.99230.78232.35226.7332.04M-1.76% 3-Oct-18232.07230.05233.47229.7828.65M1.22% 2-Oct-18229.28227.25230226.6324.79M0.89% 1-Oct-18227.26227.95229.42226.3523.60M0.67% 28-Sep-18225.74224.79225.84224.0222.93M0.35% 27-Sep-18224.95223.82226.44223.5430.18M2.06% 26-Sep-18220.42221223.75219.7623.98M-0.80% 25-Sep-18222.19219.75222.82219.724.55M0.63% 24-Sep-18220.79216.82221.26216.6327.69M1.44% 21-Sep-18217.66220.78221.36217.2996.25M-1.08% 20-Sep-18220.03220.24222.28219.1526.61M0.76% 19-Sep-18218.37218.5219.62215.327.12M0.06% 18-Sep-18218.24217.79221.85217.1231.57M0.17% 17-Sep-18217.88222.15222.95217.2737.20M-2.66% 14-Sep-18223.84225.75226.84222.5232.00M-1.14% 13-Sep-18226.41223.52228.35222.5741.71M2.42% 12-Sep-18221.07224.94225219.8449.28M-1.24% 11-Sep-18223.85218.01224.3216.5635.75M2.53% 10-Sep-18218.33220.95221.85216.4739.52M-1.34% 7-Sep-18221.3221.85225.37220.7137.62M-0.81% 6-Sep-18223.1226.23227.35221.334.29M-1.66% 5-Sep-18226.87228.99229.67225.133.33M-0.65% 4-Sep-18228.36228.41229.18226.6327.39M0.32% 31-Aug-18227.63226.51228.8722643.34M1.16% 30-Aug-18225.03223.25228.26222.448.79M0.92% 29-Aug-18222.98220.15223.49219.4127.25M1.49% 28-Aug-18219.7219.01220.54218.9222.78M0.81% 27-Aug-18217.94217.15218.74216.3320.53M0.82% 24-Aug-18216.16216.6216.9215.1118.48M0.31% 23-Aug-18215.49214.65217.05214.618.88M0.20% 22-Aug-18215.05214.1216.36213.8419.02M0.00% 21-Aug-18215.04216.8217.19214.0326.16M-0.19% 20-Aug-18215.46218.1219.18215.1130.29M-0.97% 17-Aug-18217.58213.44217.95213.1635.43M2.00% 16-Aug-18213.32211.75213.81211.4728.50M1.46% 15-Aug-18210.24209.22210.74208.3328.81M0.23% 14-Aug-18209.75210.16210.56208.2620.75M0.42% 13-Aug-18208.87207.7210.95207.725.89M0.65% 10-Aug-18207.53207.36209.1206.6724.61M-0.65% 9-Aug-18208.88207.28209.78207.223.49M0.79% 8-Aug-18207.25206.05207.81204.5222.53M0.07% 7-Aug-18207.11209.32209.5206.7625.59M-0.94% 6-Aug-18209.07208209.25207.0725.43M0.52% 3-Aug-18207.99207.03208.74205.4833.45M0.29% 2-Aug-18207.39200.58208.38200.3562.40M2.92% 1-Aug-18201.5199.13201.76197.3167.94M5.89% 31-Jul-18190.29190.3192.14189.3439.37M0.20% 30-Jul-18189.91191.9192.2189.0721.03M-0.56% 27-Jul-18190.98194.99195.19190.124.02M-1.66% 26-Jul-18194.21194.61195.96193.6119.08M-0.31% 25-Jul-18194.82193.06194.85192.4316.83M0.94% 24-Jul-18193192.45193.66192.0518.70M0.73% 23-Jul-18191.61190.68191.96189.5615.99M0.09% 20-Jul-18191.44191.78192.43190.1720.71M-0.23% 19-Jul-18191.88189.69192.55189.6920.29M0.78% 18-Jul-18190.4191.78191.8189.9316.39M-0.55% 17-Jul-18191.45189.75191.87189.215.53M0.28% 16-Jul-18190.91191.52192.65190.4115.04M-0.22% 13-Jul-18191.33191.08191.84190.912.52M0.16% 12-Jul-18191.03189.53191.41189.3118.04M1.68% 11-Jul-18187.88188.5189.78187.6118.83M-1.30% 10-Jul-18190.35190.71191.28190.1815.94M-0.12% 9-Jul-18190.58189.5190.68189.319.76M1.39% 6-Jul-18187.97185.42188.43185.217.49M1.39% 5-Jul-18185.4185.26186.41184.2816.60M0.80% 3-Jul-18183.92187.79187.95183.5413.95M-1.74% 2-Jul-18187.18183.82187.3183.4217.73M1.12% 29-Jun-18185.11186.29187.19182.9122.74M-0.21% 28-Jun-18185.5184.1186.21183.817.37M0.73% 27-Jun-18184.16185.23187.28184.0325.29M-0.15% 26-Jun-18184.43182.99186.53182.5424.57M1.24% 25-Jun-18182.17183.4184.92180.7331.66M-1.49% 22-Jun-18184.92186.12186.15184.727.20M-0.29% 21-Jun-18185.46187.25188.35184.9425.71M-0.56% 20-Jun-18186.5186.35187.2185.7320.63M0.44% 19-Jun-18185.69185.14186.33183.4533.58M-1.62% 18-Jun-18188.74187.88189.22187.218.48M-0.05% 15-Jun-18188.84190.03190.16188.2661.72M-1.03% 14-Jun-18190.8191.55191.57190.2221.61M0.05% 13-Jun-18190.7192.42192.88190.4421.64M-0.82% 12-Jun-18192.28191.38192.61191.1516.91M0.55% 11-Jun-18191.23191.35191.97190.2118.31M-0.25% 8-Jun-18191.7191.17192189.7726.66M-0.91% 7-Jun-18193.46194.14194.2192.3421.35M-0.27% 6-Jun-18193.98193.63194.08191.9220.93M0.35% 5-Jun-18193.31193.06193.94192.3621.57M0.77% 4-Jun-18191.83191.63193.42191.3526.27M0.84% 1-Jun-18190.24187.99190.26187.7523.44M1.80% 31-May-18186.87187.22188.23186.1427.48M-0.34% 30-May-18187.5187.72188186.7818.69M-0.21% 29-May-18187.9187.6188.75186.8722.51M-0.36% 25-May-18188.58188.23189.65187.6517.46M0.23% 24-May-18188.15188.77188.84186.2123.23M-0.11% 23-May-18188.36186.35188.5185.7620.06M0.64% 22-May-18187.16188.38188.88186.7815.24M-0.25% 21-May-18187.63188189.27186.9118.40M0.71% 18-May-18186.31187.19187.81186.1318.30M-0.36% 17-May-18186.99188188.91186.3617.29M-0.63% 16-May-18188.18186.07188.4618619.18M0.93% 15-May-18186.44186.78187.07185.123.70M-0.91% 14-May-18188.15189.01189.53187.8620.78M-0.23% 11-May-18188.59189.49190.06187.4526.21M-0.76% 10-May-18190.04187.74190.37187.6527.99M1.43% 9-May-18187.36186.55187.4185.2223.21M0.70% 8-May-18186.05184.99186.22183.6628.40M0.48% 7-May-18185.16185.18187.67184.7542.45M0.72% 4-May-18183.83178.25184.25178.1756.20M3.92% 3-May-18176.89175.88177.5174.4434.07M0.18% 2-May-18176.57175.22177.75173.866.54M4.42% 1-May-18169.1166.41169.2165.2753.57M2.32% 30-Apr-18165.26162.13167.26161.8442.43M1.81% 27-Apr-18162.32164164.33160.6335.66M-1.16% 26-Apr-18164.22164.12165.73163.3727.96M0.35% 25-Apr-18163.65162.62165.42162.4128.38M0.44% 24-Apr-18162.94165.67166.33161.2233.69M-1.39% 23-Apr-18165.24166.83166.92164.0936.52M-0.29% 20-Apr-18165.72170.59171.22165.4365.49M-4.10% 19-Apr-18172.8174.95175.39172.6634.81M-2.83% 18-Apr-18177.84177.81178.82176.8820.75M-0.22% 17-Apr-18178.24176.49178.94176.4126.61M1.38% 16-Apr-18175.82175.03176.19174.8321.58M0.62% 13-Apr-18174.73174.78175.84173.8525.12M0.34% 12-Apr-18174.14173.41175173.0422.89M0.99% 11-Apr-18172.44172.23173.92171.722.43M-0.47% 10-Apr-18173.25173174171.5328.61M1.88% 9-Apr-18170.05169.88173.09169.8429.02M0.99% 6-Apr-18168.38170.97172.48168.235.01M-2.56% 5-Apr-18172.8172.58174.23172.0826.93M0.69% 4-Apr-18171.61164.88172.01164.7734.61M1.91% 3-Apr-18168.39167.64168.75164.8830.28M1.03% 2-Apr-18166.68167.88168.94164.4737.59M-0.66% 29-Mar-18167.78167.81171.75166.938.40M0.78% 28-Mar-18166.48167.25170.02165.1941.67M-1.10% 27-Mar-18168.34173.68175.15166.9240.92M-2.56% 26-Mar-18172.77168.07173.1166.4437.54M4.75% 23-Mar-18164.94168.39169.92164.9441.03M-2.32% 22-Mar-18168.85170172.68168.641.49M-1.41% 21-Mar-18171.27175.04175.09171.2637.05M-2.27% 20-Mar-18175.24175.24176.8174.9419.65M-0.03% 19-Mar-18175.3177.32177.47173.6633.45M-1.53% 16-Mar-18178.02178.65179.12177.6239.40M-0.35% 15-Mar-18178.65178.5180.24178.0722.74M0.12% 14-Mar-18178.44180.32180.52177.8129.37M-0.85% 13-Mar-18179.97182.59183.5179.2431.69M-0.96% 12-Mar-18181.72180.29182.39180.2132.21M0.97% 9-Mar-18179.98177.96180177.3932.19M1.72% 8-Mar-18176.94175.48177.12175.0723.77M1.09% 7-Mar-18175.03174.94175.85174.2731.70M-0.93% 6-Mar-18176.67177.91178.25176.1323.79M-0.08% 5-Mar-18176.82175.21177.74174.5228.40M0.35% 2-Mar-18176.21172.8176.3172.4538.45M0.69% 1-Mar-18175178.54179.78172.6648.80M-1.75% 28-Feb-18178.12179.26180.62178.0537.78M-0.15% 27-Feb-18178.39179.1180.48178.1638.93M-0.32% 26-Feb-18178.97176.35179.39176.2138.16M1.98% 23-Feb-18175.5173.67175.65173.5433.81M1.74% 22-Feb-18172.5171.8173.95171.7130.99M0.84% 21-Feb-18171.07172.83174.12171.0137.47M-0.45% 20-Feb-18171.85172.05174.26171.4233.93M-0.34% 16-Feb-18172.43172.36174.82171.7740.18M-0.32% 15-Feb-18172.99169.79173.0916951.15M3.36% 14-Feb-18167.37163.04167.54162.8840.64M1.84% 13-Feb-18164.34161.95164.75161.6532.55M1.00% 12-Feb-18162.71158.5163.89157.5160.82M4.03% 9-Feb-18156.41157.07157.89150.2470.67M0.81% 8-Feb-18155.15160.29161155.0354.39M-2.75% 7-Feb-18159.54163.09163.4159.0751.61M-2.14% 6-Feb-18163.03154.83163.7215468.24M4.18% 5-Feb-18156.49159.1163.8815672.74M-2.50% 2-Feb-18160.5166166.8160.186.59M-4.34% 1-Feb-18167.78167.16168.62166.7647.23M0.21% 31-Jan-18167.43166.87168.44166.532.48M0.28% 30-Jan-18166.97165.53167.37164.746.05M-0.59% 29-Jan-18167.96170.16170.16167.0750.64M-2.07% 26-Jan-18171.51172172170.0639.14M0.23% 25-Jan-18171.11174.5174.95170.5341.53M-1.79% 24-Jan-18174.22177.25177.3173.251.11M-1.59% 23-Jan-18177.04177.3179.44176.8232.69M0.02% 22-Jan-18177177.3177.78176.627.11M-0.82% 19-Jan-18178.46178.61179.58177.4132.43M-0.45% 18-Jan-18179.26179.37180.1178.2531.19M0.09% 17-Jan-18179.1176.15179.25175.0734.39M1.65% 16-Jan-18176.19177.9179.39176.1429.57M-0.51% 12-Jan-18177.09176.18177.36175.6525.42M1.03% 11-Jan-18175.28174.59175.49174.4918.67M0.57% 10-Jan-18174.29173.16174.317323.96M-0.02% 9-Jan-18174.33174.55175.06173.4121.58M-0.01% 8-Jan-18174.35174.35175.61173.9320.57M-0.37% 5-Jan-18175173.44175.37173.0523.66M1.14% 4-Jan-18173.03172.54173.47172.0822.43M0.46% 3-Jan-18172.23172.53174.55171.9629.52M-0.02% 2-Jan-18172.26170.16172.3169.2625.56M1.79% 29-Dec-17169.23170.52170.59169.2226.00M-1.08% 28-Dec-17171.08171171.85170.4816.48M0.28% 27-Dec-17170.6170.1170.78169.7121.50M0.02% 26-Dec-17170.57170.8171.47169.6833.19M-2.54% 22-Dec-17175.01174.68175.42174.516.35M0.00% 21-Dec-17175.01174.17176.02174.120.95M0.38% 20-Dec-17174.35174.87175.42173.2523.48M-0.11% 19-Dec-17174.54175.03175.39174.0927.44M-1.07% 18-Dec-17176.42174.88177.2174.8629.42M1.41% 15-Dec-17173.97173.63174.17172.4640.17M1.02% 14-Dec-17172.22172.4173.13171.6520.48M-0.03% 13-Dec-17172.27172.5173.5417223.82M0.33% 12-Dec-17171.7172.15172.39171.4619.41M-0.56% 11-Dec-17172.67169.2172.89168.7935.27M1.95% 8-Dec-17169.37170.49171168.8223.36M0.03% 7-Dec-17169.32169.03170.44168.9125.67M0.18% 6-Dec-17169.01167.5170.2166.4628.56M-0.37% 5-Dec-17169.64169.06171.52168.427.35M-0.09% 4-Dec-17169.8172.48172.62169.6332.54M-0.73% 1-Dec-17171.05169.95171.67168.539.76M-0.47% 30-Nov-17171.85170.43172.14168.4441.53M1.40% 29-Nov-17169.48172.63172.92167.1641.67M-2.07% 28-Nov-17173.07174.3174.87171.8626.43M-0.59% 27-Nov-17174.09175.05175.08173.3420.72M-0.50% 24-Nov-17174.97175.1175.5174.6514.03M0.01% 22-Nov-17174.96173.36175173.0525.59M1.05% 21-Nov-17173.14170.78173.7170.7825.13M1.86% 20-Nov-17169.98170.29170.56169.5616.26M-0.10% 17-Nov-17170.15171.04171.39169.6421.90M-0.56%
Answered 3 days AfterFeb 22, 2022

Answer To: statistics assignment AAPL Historical Data DatePriceOpenHighLowVol.Change %...

Mohd answered on Feb 26 2022
115 Votes
-
-
-
2/24/2022
Loading Packages
library(dplyr)
library(magrittr)
library(rmarkdown)
library(Perfo
rmanceAnalytics)
Q1
library(readxl)
aapl<- read_excel("New folder (2)/aapl-historical-data.xlsx",
col_types = c("date", "numeric", "numeric",
"numeric", "numeric", "text", "numeric"))
head(aapl)
## # A tibble: 6 x 7
## Date Price Open High Low Vol. `Change %`
##
## 1 2019-01-15 00:00:00 153. 150. 153. 150. 16.82M 0.0187
## 2 2019-01-14 00:00:00 150 151. 151. 149. 32.44M -0.015
## 3 2019-01-11 00:00:00 152. 153. 154. 152. 27.02M -0.0098
## 4 2019-01-10 00:00:00 154. 152. 154. 151. 35.78M 0.0032
## 5 2019-01-09 00:00:00 153. 151. 155. 150. 45.10M 0.017
## 6 2019-01-08 00:00:00 151. 150. 152. 149. 41.03M 0.0191
n<-nrow(aapl)
st_price<-c(1:n)
for (i in 2:n) {

St_price=(aapl$Price[i]-aapl$Price[i-1])/aapl$Price[i-1]

st_price[i]<-St_price
#print(St_price)

...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here