Question

pul u nei generale sing knit titled homework-2.pdf. You are required to: Add your name to the author information in Rmd header section Answer the questions below by adding your R code to the code chunk areas provided. Remember to use the course's R Style Guide. • Knit the Rmd file to a pdf document. • Submit your completed Rmd file and Knited pdf document to Canvas by the due date (no extensions will be granted). Note: Changes to this document, such as due date or otherwise, will be communicated via Canvas. Question 1 1. From Yahoo! Finance, download the Facebook (FB) historical prices from 03/01/2019 to 03/01/2020 using daily frequency to a CSV file named FB.csv. Load the file into a dataframe in your workspace. # Answer 1 2. How many observations does this dataframe contain? What variables does it include? # Answer 2 3. What is the highest closing price in this time frame? On what date did this price occur? # Answer 3 4. Add a column to the dataframe that contains the average price of daily high and low prices. Plot the histogram of this variable. What are the mean and variance of this column? # Answer 4 5. Report the statistical correlation between all the variables in a table, hint: use Google if necessary # Answer 5 6. Plot the closing price vs opening price. Is the plot in accordance with the correlation table?

question 1. using Rstudio

Answer 1

Answer 1:- The data frame contains 253 observations. The variables contained in this database are :-

• Open Prices
• High Prices
• Low Prices
• Closing Prices
• Adjusted Closing
• Volume

Answer2 :- The highest Closing Price was 209.78 and it was made on 02nd Jan,2020

Answer 3:- The column has been added to the excel file and the histogram of the same has been drawn. The mean of that column is 273.91 and the variance is 572.0351

Answer 4:- The Statistical correlation between all the variables of table is as follows:-

	Open	High	Low	Close	Adj Close	Volume	Avg of High& Low
Open	1
High	0.995732	1
Low	0.993476	0.994109	1
Close	0.988793	0.994323	0.996266	1
Adj Close	0.988793	0.994323	0.996266	1	1
Volume	-0.23677	-0.21591	-0.27924	-0.25705	-0.25705	1
Avg of High& Low	0.996285	0.999345	0.997379	0.996276	0.996276	-0.23733	1

Answer 5:- The plot of open and close prices:-

Yes, the plot is very much in accordance with the correlation

Open & Close price plot close 120 140 160 180 200 220 Open

Answer6:- The Log returns has been calculated in the excel sheet

Log Returns -0.02 260 300 -0.04 -0.06 -0.08 -0.1

The trend of Log returns is range bound. The Trend is more or less Stationary.

The pictures of excel file created are attached below:-

ASSBE FB (1) - Excel nitin arora - o X Share File Home Insert Page Layout Formulas DataReview View Help ? Tell me what you want to do J K L M N O р Histogram of average of high and low A1 - X ✓ for Date A B C D E F G H I 1 Date Open High Low Close Adj Close Volume Avg of High & Low Log Returns 2 03-01-2019 134.69 137.17 131.12 131.74 131.74 22717900 202.73 3 04-01-2019 134.01 138 133.75 137.95 137.95 29002100 204.88 0.046061 4 07-01-2019 137.56 138.87 135.91 138.05 138.05 20089300 206.82 0.0007247 5 08-01-2019 139.89 143.14 139.54 142.53 142.53 26263800 212.91 0.0319365 6 09-01-2019 142.95 144.7 141.27 144.23 144.23 22205900 215.33 0.0118567 7 10-01-2019 143.08 144.56 140.84 144.2 144.2 16125000 214.98 -0.000208 8 11-01-2019 143.15 145.36 142.57 143.8 143.8 12908000 216.65 -0.0027777 9 14-01-2019 142 146.57 141.27 145.39 145.39 20520300 217.21 0.0109963 10 15-01-2019 146.01 150.68 145.99 148.95 148.95 24069000 223.67 0.0241909 11 16-01-2019 149 149.65 147 147.54 147.54 18025700 223.15 -0.0095114 12 17-01-2019 146.95 149 146.5 148.3 148.3 15787900 222.25 0.005138 13 18-01-2019 149.75 152.43 148.55 150.04 150.04 31029600 226.70 0.0116646 14 22-01-2019 149.2 151.53 146.37 147.57 147.57 22378700 224.71 -0.0165992 15 23-01-2019 148.28 148.8 143.06 144.3 144.3 20098400 220.33 -0.0224082 16 24-01-2019 144.64 146.44 142.52 145.83 145.83 20955500 217.70 0.0105471 17 25-01-2019 147.48 149.83 146.54 149.01 149.01 22237200 223.10 0.0215718 18 28-01-2019 148.05 148.96 146.21 147.47 147.47 15508500 222.07 -0.0103886 19 29-01-2019 148.09 148.1 143.43 144.19 144.19 17632100 219.82 -0.0224929 20 30-01-2019 146.22 150.95 145.7 150.42 150.42 44613200 223.80 0.0422995 21 31-01-2019 165.6 171.68 165 166.69 166.69 77233600 254.18 0.1027044 22 01-02-2019 165.84 169.1 165.66 165.71 165.71 30806500 251.93 -0.0058965 23 04-02-2019 165.7 169.3 163.62 169.25 169.25 20036000 251.11 0.0211376 24 05-02-2019 169.15 171.98 168.69 171.16 171.16 22557000 256.32 0.0112219 25 06-02-2019 171.2 172.47 169.27 170.49 170.49 13281200 257.11 -0.0039221 26 07-02-2019 168.2 169.24 165.25 166.38 166.38 17517600 251.87 -0.0244023 I FB (1) Đ Calculate [202.73, 215.73] (215.73, 228.73] (228.73, 241.73] (241.73, 254.73] (254.73, 267.73] (267.73, 280.73] (280.73, 293.73] (293.73, 306.73] (306.73, 319.73] Mean Variance 273.91 572.0351 Low Close Adj Close Volume Table of Correlation Open High Open 1 High 0.995732 + 100% 0 . 0 o Type here to search o -- + H 20:42 ENG 2.20 13-03-2020 Ô e x @ ^ . . Tra

FB (1) - Excel nitin arora - o X File Home Insert Page Layout Formulas DataReview View Help ? Tell me what you want to do Share A1 X ✓ fx Date a od K L M N O P Open 1 High 0.995732 Low 0.993476 0.994109 1 Close 0.988793 0.994323 0.996266 Adj Close 0.988793 0.994323 0.996266 1 Volume -0.23677 -0.21591 -0.27924 -0.25705 -0.25705 Avg of Hig 0.996285 0.999345 0.997379 0.996276 0.996276 -0.237328454 A B 25 06-02-2019 171.2 26 07-02-2019 168.2 27 08-02-2019 164.47 28 11-02-2019 167. 9 29 12-02-2019 166.86 30 13-02-2019 165.38 31 14-02-2019 163.19 32 15-02-2019 164.51 33 19-02-2019 160.5 34 20-02-2019 162.25 35 21-02-2019 161.93 36 22-02-2019 160.58 37 25-02-2019 163.07 38 26-02-2019 164.34 39 27-02-2019 162.9 40 28-02-2019 162.37 41 01-03-2019 162.6 42 04-03-2019 163.9 43 05-03-2019 167.37 44 06-03-2019 172.9 45 07-03-2019 171.5 46 08-03-2019 166.2 47 11-03-2019 171.6 48 12-03-2019 172.09 49 13-03-2019 172.32 50 14-03-2019 169.76 4 | FB (1) + Calculate C 172.47 169.24 167.37 168.3 168.34 166.22 164.87 164.7 164.15 163.72 162.24 162.41 166.07 166.24 163.93 1 63.5 163.13 167.5 171.88 173.57 171.74 169.62 174.3 173.8 174.03 171.15 D E 169.27170.49 165.25 166.38 164.21 167.33 165.08 165.79 164.5 165.04 163.73 164.07 162.25 163.95 160.86 162.5 160.33 162.29 161.25 162.56 159.59 160.04 160.31 161.89 162.9 164.62 163.8 164.13 160.41 162.81 160.86 161.45 161.69 162.28 163.83 167.37 166.55 171.26 171.27 172.51 167.61 169.13 165.97 169.6 171.58 172.07 171.22 171.92 172.12 173.37 168.16 170.17 F G 170.49 13281200 166.38 17517600 167.33 12561400 165.79 12811200 165.04 16292300 164.07 14205100 163.95 12755200 162.5 15504400 162.29 14345400 162.56 11770700 160.04 15607800 161.89 15858500 164.62 18737100 164.13 13784100 162.81 12697500 161.45 11114200 162.28 11097800 167.37 18894700 171.26 28187900 172.51 21531700 169.13 18306500 169.6 13184800 172.07 18884000 171.92 12155300 173.37 11973300 170.17 18037400 HT 257.11 -0.0039221 251.87 -0.0244023 249.47 0.0056936 250.84 -0.009246 250.59 -0.0045341 248.08 -0.0058946 245.99 -0.0007317 245.13 -0.0088835 244.31 -0.0012932 244.35 0.0016623 242.04 -0.0156234 242.57 0.0114933 247.52 0.0167227 248.14 -0.0029809 244.13 -0.008075 243.93 -0.0083884 243.98 0.0051278 249.42 0.0308837 255.16 0.0229759 259.21 0.0072723 255.55 -0.0197875 252.60 0.0027751 260.09 0.0144587 259.41 -0.0008722 260.09 0.0083988 255.23 -0.0186301 Open & Close price plot Close 120 140 160 180 200 220 Open 0 0 -- + 100% Type here to search o + 20:42 13-03-2020 Ô e x 2 .01 ) la ll ENG 5

FB (1) - Excel nitin arora - o X File Home Insert Page Layout Formulas Data Review View Help ? Tell me what you want to do & Share A1 : x fx Date K L M N O P Q A B 51 15-03-2019 167.16 52 18-03-2019 163.57 53 19-03-2019 161.48 54 20-03-2019 161.5 55 21-03-2019 164.89 56 22-03-2019 165.65 57 25-03-2019 163 58 26-03-2019 167.35 59 27-03-2019 167.85 60 28-03-2019 164.57 61 29-03-2019 166.39 62 01-04-2019 167.83 63 02-04-2019 170.14 64 03-04-2019 174.5 65 04-04-2019 176.02 66 05-04-2019 176.88 67 08-04-2019 175.21 68 09-04-2019 175.62 69 10-04-2019 178.18 70 11-04-2019 178.24 71 12-04-2019 178 72 15-04-2019 178.5 73 16-04-2019 179 74 17-04-2019 179.6 75 18-04-2019 178.8 76 22-04-2019 178.25 FB (1) Calculate C 167.58 163.9 163.82 166.12 166.39 167.42 166.54 169.45 168.94 166.72 167.19 168.9 1 74.9 177.96 178 177 1 75.5 179.19 178.79 178.4 179.63 180.5 180.17 180.74 178.88 181.67 D 162.51 159.28 160.82 161.24 163.75 164.09 162 166.35 164.79 163.33 164.81 167.28 169.55 172.95 175.53 175.1 174.23 175.55 176.54 177 177.95 176.87 178.3 178.36 177.34 178.25 E 165.98 160.47 161.57 165.44 166.08 164.34 166.29 167.68 165.87 165.55 166.69 168.7 174.2 173.54 176.02 175.72 174.93 177.58 177.82 177.51 179.1 179.65 178.87 178.78 178.28 181.44 F G I 165.98 37135400 160.47 37524200 161.57 25611500 165.44 20211500 166.08 16223000 164.34 16389200 166.29 12631200 167.68 15437900 165.87 10620300 165.55 10689200 166.69 13455500 168.7 10381500 174.2 23946500 173.54 27590100 176.02 17847700 175.72 9594100 174.93 7297400 177.58 19751000 177.82 11701500 177.51 8071000 179.1 12329800 179.65 10834800 178.87 11215200 178.78 9973700 178.28 11655600 181.44 13389900 HT 248.83 -0.0249307 243.54 -0.0337603 244.23 0.0068315 246.74 0.0236701 248.26 0.003861 249.46 -0.0105322 247.54 0.0117958 252.63 0.0083241 251.33 -0.010853 248.39 -0.001931 249.60 0.0068625 252.54 0.0119862 259.67 0.0320821 264.44 -0.003796 265.76 0.0141896 264.55 -0.0017058 262.61 -0.004506 266.97 0.0150354 267.06 0.0013506 266.90 -0.0017449 268.61 0.0089174 268.93 0.0030661 269.32 -0.0043512 269.92 -0.0005033 267.55 -0.0028007 270.79 0.0175697 0 0 -- + 100% + H 20:42 13-03-2020 Type here to search o 9 e 2 .01 ) la ll ENG 5

FB (1) - Excel nitin arora - o X File Home Insert Page Layout Formulas Data Review View Help ? Tell me what you want to do & Share A76 : X fx 22-04-2019 H K L M N O P Q A B 76 22-04-2019 178.25 77 23-04-2019 182.74 78 24-04-2019 184.49 79 25-04-2019 196.98 80 26-04-2019 192. 5 81 29-04-2019 190.95 82 30-04-2019 194.19 83 01-05-2019 194.78 84 02-05-2019 193 85 03-05-2019 194.38 86 06-05-2019 191.24 87 07-05-2019 192.54 88 08-05-2019 189.39 89 09-05-2019 1 87.2 90 10-05-2019 188.25 91 13-05-2019 183.5 92 14-05-2019 182.52 93 15-05-2019 180.42 94 16-05-2019 185.05 95 17-05-2019 184.84 96 20-05-2019 181.88 97 21-05-2019 184.57 98 22-05-2019 184.73 99 23-05-2019 182.42 100 24-05-2019 182.33 101 28-05-2019 181.54 FB (1) Calculate C 181.67 184.22 185.14 198.48 1 92.9 195.41 197.39 196.18 194 196.16 194.28 192.9 190.72 189.77 190 185.43 183.49 187.28 188.58 187.58 184.23 185.7 186.74 1 83.9 183.63 184.71 D E 178.25181.44 181.48 183.78 181.65 182.58 192.12 193.26 189.09 191.49 190.65 194.78 192.28 193.4 193.01 193.03 189.75 192.53 193.71 195.47 190.55 193.88 187.85 189.77 188.55 189.54 186.26 188.65 184.59 188.34 180.84 181.54 178.1 180.73 180.02 186.27 185.05 186.99 184.28 185.3 181.37 182.72 183.89 184.82 183.61 185.32 179.67 180.87 180.83 181.06 181.45 184.31 F G 181.44 13389900 183.78 19954800 182.58 37289900 193.26 54148800 191.49 22075000 194.78 19641300 193.4 23494700 193.03 15996600 192.53 13209500 195.47 14575400 193.88 13994900 189.77 16253000 189.54 12505700 188.65 12967000 188.34 12578500 181.54 16833300 180.73 17628100 186.27 16746900 186.99 12953100 185.3 10485400 182.72 10352000 184.82 7502800 185.32 9213800 180.87 12768800 181.06 8807700 184.31 14843300 270.79 0.0175697 274.96 0.0128144 275.96 -0.0065509 294.54 0.056848 287.44 -0.0092008 290.74 0.0170351 293.53 -0.0071102 292.68 -0.0019149 288.88 -0.0025936 293.02 0.0151549 289.56 -0.0081675 286.82 -0.0214266 285.00 -0.0012128 282.90 -0.0047066 282.29 -0.0016446 275.85 -0.0367728 272.54 -0.0044718 277.29 0.0301931 281.11 0.0038579 279.72 -0.009079 274.91 -0.0140212 277.64 0.0114275 278.55 0.0027017 273.73 -0.0243056 274.05 0.0010499 275.44 0.0177907 0 0 -- Type here to search o 9 + H + 100% 20:43 13-03-20205 e ? ^ . . 4» Ta & ENG

FB (1) - Excel nitin arora - o X File Home Insert Page Layout Formulas Data Review View Help ? Tell me what you want to do Share A76 : X fx 22-04-2019 K L M N O P Q A 101 28-05-2019 102 29-05-2019 103 30-05-2019 104 31-05-2019 105 03-06-2019 106 04-06-2019 107 05-06-2019 108 06-06-2019 109 07-06-2019 110 10-06-2019 111 11-06-2019 112 12-06-2019 113 13-06-2019 114 14-06-2019 115 17-06-2019 B C 181.54184.71 183.5 184.56 183.08 183.48 180.28 180.54 175 175.05 163.71 168.28 167.48 168.72 168.3 169.7 170.17 173.87 174.75 177.86 178.48 179.98 178.38 179.27 175.53 178.03 180.51 181.84 185.01 189.5 D E 181.45 184.31 181.35 182.19 180.89 183.01 177.16 177.47 161.01 164.15 160.84 167.5 164.63 168.17 167.23 168.33 168.84 173.35 173.8 174.82 176.79 178.1 172.88 175.04 174.61 177.47 180 181.33 184.41 189.01 187.28 188.47 184.55187.48 187.64 189.53 188.75 191.14 191.57 192.6 188.13 188.84 187.31 187.66 188.27 189.5 189.94 1 93 191.93 193 192.71 195 F G 184.31 14843300 182.19 12797700 183.01 8581500 177.47 15226500 164.15 56059600 167.5 46044300 168.17 19758300 168.33 12446400 173.35 16917300 174.82 14767900 178.1 15266600 175.04 17681500 177.47 12253600 181.33 16773700 189.01 29459900 188.47 37571400 187.48 21417100 189.53 14635700 191.14 22751200 192.6 15509000 188.84 16750300 187.66 12808600 189.5 11159000 193 16378900 193 14204700 195 9050000 275.44 0.0177907 275.24 -0.011569 273.92 0.0044907 269.12 -0.0307392 255.56 -0.078021 248.70 0.0202027 251.04 0.003992 253.31 0.000951 258.29 0.0293864 264.76 0.0084442 268.37 0.0185883 265.71 -0.0173307 265.33 0.0137871 271.84 0.021517 281.71 0.0414813 288.17 -0.002861 280.38 -0.0052667 284.98 0.0108752 286.38 0.0084588 289.76 0.0076094 287.21 -0.0197155 284.41 -0.0062682 293.02 0.0097572 288.17 0.0183012 291.24 291.36 0.0103094 117 19-06-2019 187 118 20-06-2019 190.95 119 21-06-2019 188.75 120 24-06-2019 192.42 121 25-06-2019 192.88 122 26-06-2019 189.54 123 27-06-2019 189.88 124 28-06-2019 190.55 125 01-07-2019 195.21 126 02-07-2019 193 FB (1) Calculate 188.1 191.16 192 193.98 193.14 190.76 198.88 193.2 195.28 195 0 0 -- + 100% + H 20:43 13-03-2020 O Type here to search o El A 9 e 2 .01 ) la ll ENG 5

FB (1) - Excel nitin arora - o X File Home Insert Page Layout Formulas Data Review View Help ? Tell me what you want to do & Share A76 : X fx 22-04-2019 J K L M N O P Q A A B C 127 03-07-2019 194.16 1 97.4 128 05-07-2019 196.18 197.07 129 08-07-2019 195.19196.68 130 09-07-2019 194.97 199.46 131 10-07-2019 200 202.96 132 11-07-2019 203.26 203.8 133 12-07-2019 199.68 205.3 134 15-07-2019 204.25 205.33 135 16-07-2019 203.89 205.47 136 17-07-2019 204.18 204.36 137 18-07-2019 200.15202.47 138 19-07-2019 202.18 202.33 139 22-07-2019 199.91 202.57 140 23-07-2019 202.84 204.24 141 24-07-2019 197.63 204.81 142 25-07-2019 206.7 208.66 143 26-07-2019 200.19 202.88 144 29-07-2019 199 199.63 145 30-07-2019 195.39 198.71 146 31-07-2019 196.95 198.76 147 01-08-2019 194.17 198.47 148 02-08-2019 191.1 192.62 149 05-08-2019 184.69 185.67 150 06-08-2019 183.69 185.79 151 07-08-2019 183.6 186.37 152 08-08-2019 186.62 190.34 FB (1) Calculate D 194.16 194.17 193.64 194.89 199.67 200.21 199.16 201.82 203.1 201.59 199.38 198.07 198.81 200.96 197.22 198.26 196.25 195.3 193.5 192.68 190.88 188.07 179.34 183.09 181.22 184.05 E 197.2 196.4 195.76 199.21 202.73 201.23 204.87 203.91 203.84 201.8 200.78 198.36 202.32 202.36 204.66 200.71 199.75 195.94 197.04 194.23 192.73 189.02 181.73 184.51 185.15 190.16 F G 197.2 10246100 196.4 11164100 195.76 9723900 199.21 14698600 202.73 20571700 201.23 13678500 204.87 15366300 203.91 16030300 203.84 12132700 201.8 12083700 200.78 11956600 198.36 12098300 202.32 13589000 202.36 14583700 204.66 32532500 200.71 39889900 199.75 24434000 195.94 16530800 197.04 11903600 194.23 14593500 192.73 17777000 189.02 15297000 181.73 23086700 184.51 18035700 185.15 15833200 190.16 14828900 I 294.48 0.0112189 294.16 -0.0040651 293.50 -0.003264 296.91 0.0174702 302.80 0.0175154 303.91 -0.0074265 304.88 0.0179271 306.24 -0.0046969 307.02 -0.0003434 305.15 -0.0100582 302.16 -0.0050673 301.37 -0.0121262 301.98 0.0197671 304.72 0.0001977 303.42 0.0113018 307.79 -0.019489 301.01 -0.0047945 297.28 -0.0192581 295.46 0.0055982 295.10 -0.0143637 293.91 -0.0077528 286.65 -0.0194374 275.34 -0.0393308 277.33 0.0151816 276.98 0.0034626 282.36 0.0266996 0 0 -- + 100% Type here to search o 9 + H 20:43 13-03-2020 e 2 .01 ) la ll ENG 5

FB (1) - Excel nitin arora - o X File Home Insert Page Layout Formulas Data Review View Help ? Tell me what you want to do Share A76 : X fx 22-04-2019 Н J K L M N O P Q .31 A B 153 09-08-2019 190 154 12-08-2019 186.85 155 13-08-2019 185.52 156 14-08-2019 185.8 157 15-08-2019 180.95 158 16-08-2019 183.75 159 19-08-2019 186.01 160 20-08-2019 185.45 161 21-08-2019 185 162 22-08-2019 183.43 163 23-08-2019 180.84 164 26-08-2019 179.4 165 27-08-2019 181.93 166 28-08-2019 180.53 167 29-08-2019183.77 168 30-08-2019 186.78 169 03-09-2019 184 170 04-09-2019 184.65 171 05-09-2019 188.53 172 06-09-2019 190.21 173 09-09-2019 187.73 174 10-09-2019 187.44 175 11-09-2019 186.46 176 12-09-2019 189.86 177 13-09-2019 187.33 178 16-09-2019 186.93 FB (1) C 190.98 187.59 191.38 185.99 1 83.2 185.1 187.5 186 185.9 184.11 183.13 180.5 184.04 181.95 186.08 186.8 185.67 187.75 191.36 190.21 188.98 188.1 189.44 190.93 187.97 187.79 D E 187.12187.85 184.46 185.37 185.37 188.45 179.31 179.71 180.03 182.59 182.36 183.7 184.85 186.17 182.39 183.81 183.14 183.55 179.91 182.04 176.66 177.75 178.24 180.36 181.01 181.3 178.92 181.76 183.47 185.57 183.46 185.67 182.11182.39 183.89 187.14 187.94 190.9 186.35 187.49 185.85 188.76 184.55 186.17 186.08 188.49 187.23 187.47 186.54 187.19 185.77 186.22 F G 187.85 11058800 185.37 10936300 188.45 13577000 179.71 18903700 182.59 12925900 183.7 12654600 186.17 9691200 183.81 10083400 183.55 8398200 182.04 10821400 177.75 17323400 180.36 8773600 181.3 14399600 181.76 9386100 185.57 10128700 185.67 10774500 182.39 9779400 187.14 11308000 190.9 13876700 187.49 15226800 188.76 14722400 186.17 15455900 188.49 11761700 187.47 11419800 187.19 11297800 186.22 8444800 284.54 -0.012222 279.82 -0.01329 284.07 0.0164789 275.65 -0.0474882 273.21 0.0158987 276.28 0.0060608 279.93 0.0133562 277.19 -0.0127576 277.47 -0.0014155 274.07 -0.0082607 271.46 -0.0238483 269.62 0.0145768 274.54 0.0051983 271.41 0.002534 277.82 0.0207451 278.53 0.0005387 276.72 -0.0178236 279.69 0.0257097 285.33 0.0198927 283.39 -0.0180242 281.90 0.0067508 280.38 -0.0138161 282.48 0.0123848 284.54 -0.0054261 281.24 -0.0014947 280.67 -0.0051954 Calculate @ J - O Type here to search o & 9 e H + 100% 20:43 13-03-20205 ? ^ . ,» la ENG

FB (1) - Excel nitin arora - o X File Home Insert Page Layout Formulas Data Review View Help ? Tell me what you want to do & Share A76 - : X Fax 22-04-2019 K L M N O P Q D 185.77 185.54 186.01 188.15 188.12 185.21 A B 178 16-09-2019 186.93 179 17-09-2019 186.66 180 18-09-2019 188.09 181 19-09-2019 188.66 182 20-09-2019 190.66 183 23-09-2019 189.34 184 24-09-2019 187.98 185 25-09-2019 181.45 186 26-09-2019 181.33 187 27-09-2019 180.49 188 30-09-2019 177.87 189 01-10-2019 179.15 190 02-10-2019 174.84 191 03-10-2019 175.57 192 04-10-2019 179.55 193 07-10-2019 180 194 08-10-2019 178.26 195 09-10-2019 179.16 196 10-10-2019 180.32 197 11-10-2019 182.15 198 14-10-2019 184.2 199 15-10-2019 183.8 200 16-10-2019 188.32 201 17-10-2019 190.3 202 18-10-2019 190.23 203 21-10-2019 187.04 TT FB (1) C 187.79 188.32 189.08 191.1 1 93.1 190.1 188.04 183.42 181.4 180.76 178.67 179.84 176.53 179.84 180.98 181.18 180.37 180.72 181.61 186.49 184.62 190.38 1 89.7 190.84 191.49 189.91 177.87 177.67 175.66 176.85 174.88 173.09 173.63 178.1 178.09 177.72 177.94 179.17 182.14 182.57 183.66 186.9 188.77 183.92 186.75 E 186.22 188.08 188.14 190.14 189.93 186.82 181.28 182.8 180.11 177.1 178.08 175.81 174.6 179.38 180.45 179.68 177.75 179.85 180.03 184.19 183.28 188.89 189.55 190.39 185.85 189.76 F G 186.22 8444800 188.08 9671100 188.14 9681900 190.14 10392700 189.93 19934200 186.82 13327600 181.28 18546600 182.8 18068300 180.11 16083300 177.1 14656200 178.08 10740000 175.81 17073000 174.6 16151700 179.38 16086300 180.45 10430200 179.68 9178300 177.75 9466900 179.85 7556900 180.03 8605000 184.19 14930500 183.28 7006000 188.89 15039100 189.55 10516900 190.39 9603000 185.85 16874200 189.76 8122600 280.67 -0.0051954 281.09 0.0099386 282.08 0.0003189 285.18 0.0105743 287.16 -0.0011051 282.71 -0.0165099 278.23 -0.0301028 272.35 0.0083499 270.23 -0.0148249 268.59 -0.0168532 267.10 0.0055183 267.28 -0.012829 263.07 -0.0069062 266.65 0.0270088 270.03 0.0059472 270.22 -0.0042763 269.23 -0.0107994 269.69 0.0117451 271.20 0.0010003 277.56 0.0228443 275.90 -0.0049528 282.21 0.0301498 283.15 0.003488 285.22 0.0044217 283.45 -0.0241347 283.29 0.0208202 Calculate + 100% 0 T 0 -- + H 20:44 & ENG220 13-03-2020 Type here to search o & 9 e x ^.

FB (1) - Excel nitin arora - o X File Home Insert Page Layout Formulas Data Review View Help ? Tell me what you want to do Share A76 - : X Fax 22-04-2019 H K L M N O P Q C 189.91 190.65 186.38 186.73 A B 203 21-10-2019 187.04 204 22-10-2019 190 205 23-10-2019 182.01 206 24-10-2019 184.62 207 25-10-2019 185.83 208 28-10-2019 187.2 209 29-10-2019 191.69 210 30-10-2019 189.56 211 31-10-2019 196.7 212 01-11-2019 192.85 213 04-11-2019 194.55 214 05-11-2019 195.37 215 06-11-2019 194.03 216 07-11-2019 191.91 217 08-11-2019 190 218 11-11-2019 189.93 219 12-11-2019 190 220 13-11-2019 194.7 221 14-11-2019 192.93 222 15-11-2019 194.26 223 18-11-2019 194.56 224 19-11-2019 197.4 225 20-11-2019 198.58 226 21-11-2019 197.42 227 22-11-2019 198.38 228 25-11-2019 199.52 T FB (1) Calculate 189.53 192.53 190.45 198.09 194.11 197.37 195.75 194.37 193.44 192.34 190.08 195.06 195.7 194.03 195.3 198.63 200 199.59 199.09 199.3 200.97 D 186.75 181.5 182 182.8 185.09 185.08 188.47 185.98 188.25 189.91 193.81 193.6 191.35 189.47 189.7 188.54 189.74 192.74 191.45 193.38 193.05 196.86 195.43 196.86 197.62 199.25 E 189.76 182.34 186.15 186.38 187.89 189.4 189.31 188.25 191.65 193.62 194.72 194.32 191.55 190.42 190.84 189.61 194.47 193.19 193.15 195.1 197.4 199.32 197.51 197.93 198.82 199.79 F G 189.76 8122600 182.34 19537600 186.15 12300400 186.38 11413500 187.89 8061200 189.4 13657900 189.31 13574900 188.25 28734600 191.65 42286500 193.62 21711800 194.72 16371300 194.32 9942000 191.55 10973000 190.42 13473000 190.84 10760800 189.61 8631200 194.47 17615500 193.19 10860700 193.15 9040500 195.1 11524300 197.4 16167200 199.32 19056800 197.51 12355400 197.93 12131000 198.82 9959800 199.79 15272300 283.29 0.0208202 281.40 -0.039887 277.38 0.0206797 278.13 0.0012349 281.54 0.0080691 282.07 0.0080045 286.76 -0.0004753 283.44 -0.005615 292.21 0.0178999 289.07 0.0102267 294.27 0.0056652 292.55 -0.0020563 290.04 -0.0143574 288.18 -0.0059167 287.19 0.0022032 284.35 -0.006466 289.93 0.0253086 292.07 -0.0066037 289.75 -0.0002071 291.99 0.0100452 295.16 0.0117198 298.43 0.0096795 297.30 -0.0091224 297.52 0.0021242 298.11 0.0044865 300.60 0.0048669 0 0 -- + 100% Type here to search o 1 e 9 e + H 20:44 13-03-2020 x ? ^ . 1» ( ] ENG

FB (1) - Excel nitin arora - o X File Home Insert Page Layout Formulas Data Review View Help ? Tell me what you want to do Share A76 - : X Fax 22-04-2019 J K L M N O P Q A B 228 25-11-2019 199.52 229 26-11-2019 200 230 27-11-2019 199.9 231 29-11-2019 201.6 232 02-12-2019 202.13 233 03-12-2019 197.6 234 04-12-2019 200 235 05-12-2019 199.86 236 06-12-2019 200.5 237 09-12-2019 200.65 238 10-12-2019 201.66 239 11-12-2019 200.28 240 12-12-2019 202.35 241 13-12-2019 196.4 242 16-12-2019 195.27 243 17-12-2019 198.84 244 18-12-2019 200.09 245 19-12-2019 202.78 246 20-12-2019 207.48 247 23-12-2019 206.7 248 24-12-2019 206.3 249 26-12-2019 205.57 250 27-12-2019 208.67 251 30-12-2019 207.86 252 31-12-2019 204 253 02-01-2020 206.75 FB (1) € Calculate C 200.97 200.15 203.14 203.8 202.18 198.93 200.03 201.29 201.57 203.14 202.05 202.63 203.66 196.8 199.12 199 204.3 2 06.3 207.71 208.59 206.79 207.82 208.93 207.9 205.56 209.79 D 199.25 198.04 199.42 201.21 198.05 195.08 198.05 198.21 200.06 200.21 200.15 200.28 194.1 193.17 194.81 196.13 200.09 202.51 203.43 205.68 205 205.31 206.59 203.9 203.6 206.27 E 199.79 198.97 202 201.64 199.7 198.82 198.71 199.36 201.05 201.34 200.87 202.26 196.75 194.11 197.92 198.39 202.5 206.06 206.3 206.18 205.12 207.79 208.1 204.41 205.25 209.78 F G 199.79 15272300 198.97 11735500 202 12736600 201.64 7985200 199.7 11503400 198.82 11595300 198.71 8456300 199.36 9740400 201.05 12270600 201.34 11954800 200.87 9475700 202.26 8036800 196.75 23734800 194.11 18798000 197.92 14911500 198.39 10175700 202.5 23274400 206.06 16514600 206.3 27306900 206.18 13348900 205.12 6046300 207.79 9350700 208.1 10284200 204.41 10524300 205.25 8953500 209.78 12077100 HT 300.60 0.0048669 299.17 -0.0041127 302.85 0.0151136 304.41 -0.0017838 301.20 -0.0096677 296.47 -0.0044163 299.06 -0.0005534 300.39 0.0032657 301.60 0.0084414 303.25 0.0014414 302.13 -0.0023371 302.77 0.0068961 300.71 -0.0276201 293.39 -0.0135089 296.52 0.0194379 297.07 0.0023719 304.35 0.0205051 307.56 0.0174275 309.43 0.0011641 311.43 -0.0005819 309.29 -0.0051544 310.48 0.0129328 312.22 0.0014908 309.85 -0.017891 307.36 0.0041009 312.92 0.0218306 0 + 100% 0 al -- ENG O Type here to search o & 9 + H 20:45 13-03-2020 e ^ . 1 Ta

FB (1) - Excel nitin arora - o X File Home Insert Page Layout Formulas Data Review View Help ? Tell me what you want to do Share A76 - H J K L M N O P Q A A 231 29-11-2019 232 02-12-2019 233 03-12-2019 234 04-12-2019 235 05-12-2019 236 06-12-2019 237 09-12-2019 238 10-12-2019 239 11-12-2019 240 12-12-2019 241 13-12-2019 242 16-12-2019 243 17-12-2019 244 18-12-2019 245 19-12-2019 246 20-12-2019 247 23-12-2019 248 24-12-2019 249 26-12-2019 250 27-12-2019 251 30-12-2019 252 31-12-2019 253 02-01-2020 254 03-01-2020 : X Fax B C 201.6 203.8 202.13 202.18 197.6 198.93 200 200.03 199.86 201.29 200. 5 201.57 200.65 203.14 201.66 202.05 200.28 202.63 202.35 203.66 196.4 196.8 195.27 199.12 198.84 199 200.09 204.3 202.78 206.3 207.48 207.71 206.7 208.59 206.3 206.79 205.57207.82 208.67 208.93 207.86 2 07.9 204 205.56 206.75 209.79 207.21 2 10.4 22-04-2019 D E 201.21201.64 198.05 199.7 195.08 195.08 198.82 198.05 198.21 199.36 200.06 201.05 200.21 201.34 200.15 200.87 200.28 202.26 194.1 196.75 193.17 194.11 194.81 197.92 196.13 198.39 200.09 202.5 202.51 206.06 203.43 206.3 205.68 206.18 205 205.12 205.31 207.79 206.59 208.1 203.9 204.41 203.6 205.25 206.27 209.78 206.95 208.67 F G 201.64 7985200 199.7 11503400 198.82 11595300 198.71 8456300 199.36 9740400 201.05 12270600 201.34 11954800 200.87 9475700 202.26 8036800 196.75 23734800 194.11 18798000 197.92 14911500 198.39 10175700 202.5 23274400 206.06 16514600 206.3 27306900 206.18 13348900 205.12 6046300 207.79 9350700 208.1 10284200 204.41 10524300 205.25 8953500 209.78 12077100 208.67 11188400 I 304.41 -0.0017838 301.20 -0.0096677 296.47 -0.0044163 299.06 -0.0005534 300.39 0.0032657 301.60 0.0084414 303.25 0.0014414 302.13 -0.0023371 302.77 0.0068961 300.71 -0.0276201 293.39 -0.0135089 296.52 0.0194379 297.07 0.0023719 304.35 0.0205051 307.56 0.0174275 309.43 0.0011641 311.43 -0.0005819 309.29 -0.0051544 310.48 0.0129328 312.22 0.0014908 309.85 -0.017891 307.36 0.0041009 312.92 0.0218306 313.87 -0.0053053 255 256 > Calculate FB (1) + 0 0 -- + 100% 1 0 Type here to search o El @ 9 + H 20:45 13-03-2020 e x 2 .01 ) la ll ENG 5