Description
please answer all the questions well.
Unformatted Attachment Preview
Ted Rogers School of Information
Technology Management
CITM 618: Business Intelligence
and Analytics
Assignment #1
Due on October 24, 2023
Part I
Submit your answers to the part I questions as a PDF file to D2L
1- (2.5 points) [Introduction to Data Analytics] Determine the most relevant business
analytics methods (e.g., classification, regression, clustering, association mining,
Simulation, etc.) for the following business problem:
a. [0.5 point] Grouping a public bank’s customers based on customer value, accounts
type, accounts balances, address, education and family income.
b. [0.5 point] Estimating the price of a house using historical data.
c. [0.5 point] Predicting whether an applicant’s credit application will be approved
or denied based on historical data
d. [0.5 point] Producing a list of recommendations for a user.
e. [0.5 point] Determining the bottleneck(s) of a business process.
2- (2 points) [OLAP Operations] Assume we have a data cube consists of three dimensions:
Item, Time and Location. The values (i.e., facts) show the revenue in thousand dollars.
Assume we have the following hierarchy:
Location
Country
City
Page 1 of 5
Ted Rogers School of Information
Technology Management
CITM 618: Business Intelligence
and Analytics
Assignment #1
Due on October 24, 2023
Which OLAP operations should be performed in order to answer the following questions:
a) [1 point] Total revenue earned by selling Mobil and Modem in Canada in Q1.
b) [1 point] Total revenue earned by each Item in each Quarter.
3- (1.5 points) [Predictive Analytics] The following decision tree is for the concept “buy
computer” that indicates whether a customer at a company is likely to buy a computer or
not.
Determine if the following instances will buy a computer and explain the steps (If the tree
cannot provide the value for the instance, explain why):
a) [0.5 point] Alex is a young student.
b) [0.5 point] Jon is middle aged with an excellent credit_rating.
c) [0.5 point] David is a teenager with an excellent credit rating.
Submission for Part-1:
Please submit only one pdf file for part-1.
Part II
In the second part of the assignment, you will write an R script to calculate the relative
volatility for the three given stocks: enb, baba, and aapl
Page 2 of 5
Ted Rogers School of Information
Technology Management
CITM 618: Business Intelligence
and Analytics
Assignment #1
Due on October 24, 2023
Files to download: Please download the following files from
D2L”baba.csv”, “aapl.csv”, “enb.csv”
These CSV files contain the historical trading data for the corresponding stocks trading
atNYSE/Nasdaq stock exchange, and each of them has the following information:
Date, Open Price, High Price, Low Price, Close Price, Adj Close, Volume
Your task is to write an R script that will calculate the covariance for each of the stocks to
calculatethe volatility for the year 2019 using the closing price of the stocks. A higher value of
covariancemeans the stock is more volatile.
How to calculate covariance?
To calculate the covariance, we need to know the mean and the standard deviation (sd). Then
using the mean and the standard deviation, we can calculate the covariance (cv) using the
followingformula:
cv = sd/mean
Your R script should deliver the following:
1. The script should save the covariance for each of the three stocks to a data frame, and
thenthe data frame should be saved to a CSV file named “covariance.csv” (3 Points)
2. All the covariances of the three stocks should be plotted on a single plot (2 Points)
3. Your program should save the stock tickers for the most and the least volatile stocks to
a data frame, and then the data frame should be saved to another CSV file named
“maxMin.csv” (2 Points)
4. Make sure the script is well documented. I mean, each line of code should be
documented(1 Point)
Sample output:
I expect your R script will generate the outputs similar to Figure-1 to Figure-3 for Question-1
toQuestion-3, respectively. I have experimented using the following five stocks (on the
Close price for the year 2019):
“aapl.csv”, “acst.csv”,”amd.csv”,”bac.csv”,”eng.csv”
Figure-1 illustrates the “covariance.csv” file for these five stocks.
Page 3 of 5
Ted Rogers School of Information
Technology Management
CITM 618: Business Intelligence
and Analytics
Assignment #1
Due on October 24, 2023
Figure-1: Covariance for the five stocks
In Figure-1, the ticker column shows the ticker name for each stock, and the CV shows
thecovariance for the corresponding stock. In your case, the “covariance.csv” should
have covariance for all the three stocks listed, similar to figure-1.
Figure-2 shows the plotting of the covariances for the same five stocks (“aapl.csv”,
“acst.csv”,”amd.csv”, “bac.csv”, “eng.csv”)
Figure-2: Covariance Plot
NB: Make sure you are also printing the axis labels, i.e., CV for Y-axis and Tickers for X- axis
In your case, you will have three points plotted because you will be experimenting with three
stocks
Page 4 of 5
Ted Rogers School of Information
Technology Management
CITM 618: Business Intelligence
and Analytics
Assignment #1
Due on October 24, 2023
Figure-3 illustrates how the most and the least volatile stocks out of the five stocks (three
stocksin your case) should be shown using the “maxMin.csv” file:
Figure-3: The most and the least volatile stocks
Figure-3 shows that “acst” is the most volatile stock out of the five stocks and “bac” is the least
volatile stock. In your case, the most and the least volatile tickers will be different because you
will be analyzing three different stocks.
Submission for Part-2:
To submit, you will be uploading only one file.
Here is how:
Save all the R-code to a text file named “assignment1.txt”. Then upload the text file to D2L,
and itwill complete your submission for Part-2
Please do not upload anything other than the text file. Only “.txt” files will be graded.
Page 5 of 5
Date
Open
High
Low
Close
Adj Close
Volume
12/12/1980 0.5133928656578064
0.515625 0.5133928656578064
0.5133928656578064
0.40678155422210693
117258400
12/15/1980 0.4888392984867096
0.4888392984867096
0.4866071343421936
0.4866071343421936
0.38555816
43971200
12/16/1980
0.453125
0.453125 0.4508928656578064
0.4508928656578064
0.3572602868080139
26432000
12/17/1980 0.4620535671710968
0.4642857015132904
0.4620535671710968
0.4620535671710968
0.3661033511161804
21610400
12/18/1980 0.4754464328289032
0.4776785671710968
0.4754464328289032
0.4754464328289032
0.37671515345573425
18362400
12/19/1980 0.5044642686843872
0.5066964030265808
0.5044642686843872
0.5044642686843872
0.3997070789337158
12157600
12/22/1980 0.5290178656578064
0.53125 0.5290178656578064
0.5290178656578064
0.4191618859767914
9340800
12/23/1980 0.5513392686843872
0.5535714030265808
0.5513392686843872
0.5513392686843872
0.4368479549884796
11737600
12/24/1980 0.5803571343421936
0.5825892686843872
0.5803571343421936
0.5803571343421936
0.4598398804664612
12000800
12/26/1980 0.6339285969734192
0.6361607313156128
0.6339285969734192
0.6339285969734192
0.5022867918014526
13893600
12/29/1980 0.6428571343421936
0.6450892686843872
0.6428571343421936
0.6428571343421936
0.50936121
23290400
12/30/1980 0.6294642686843872
0.6294642686843872
0.6272321343421936
0.6272321343421936
0.4969809353351593
17220000
12/31/1980 0.6116071343421936
0.6116071343421936
0.609375
0.609375 0.48283201456069946
8937600
1/2/1981 0.6160714030265808
0.6205357313156128
0.6160714030265808
0.6160714030265808
0.4881376624107361
5415200
1/5/1981 0.6049107313156128
0.6049107313156128
0.6026785969734192
0.6026785969734192
0.4775262176990509
8932000
1/6/1981
0.578125
0.578125 0.5758928656578064
0.5758928656578064
0.4563027024269104
11289600
1/7/1981 0.5535714030265808
0.5535714030265808
0.5513392686843872
0.5513392686843872
0.4368479549884796
13921600
1/8/1981 0.5424107313156128
0.5424107313156128
0.5401785969734192
0.5401785969734192
0.42800483107566833
9956800
1/9/1981 0.5691964030265808
0.5714285969734192
0.5691964030265808
0.5691964030265808
0.45099684596061707
5376000
1/12/1981 0.5691964030265808
0.5691964030265808
0.5647321343421936
0.5647321343421936
0.44745975732803345
5924800
1/13/1981
0.546875
0.546875 0.5446428656578064
0.5446428656578064
0.4315420687198639
5762400
1/14/1981
0.546875 0.5491071343421936
0.546875
0.546875 0.4333106577396393
3572800
1/15/1981 0.5580357313156128
0.5625 0.5580357313156128
0.5580357313156128
0.4421537220478058
3516800
1/16/1981 0.5558035969734192
0.5558035969734192
0.5535714030265808
0.5535714030265808
0.4386165738105774
3348800
1/19/1981 0.5870535969734192
0.5892857313156128
0.5870535969734192
0.5870535969734192
0.46514588594436646
10393600
1/20/1981 0.5714285969734192
0.5714285969734192
0.5691964030265808
0.5691964030265808
0.45099684596061707
7520800
1/21/1981 0.5803571343421936
0.5848214030265808
0.5803571343421936
0.5803571343421936
0.4598398804664612
3976000
1/22/1981 0.5870535969734192
0.5915178656578064
0.5870535969734192
0.5870535969734192
0.46514588594436646
8887200
1/23/1981 0.5870535969734192
0.5892857313156128
0.5848214030265808
0.5848214030265808
0.4633772075176239
2805600
1/26/1981
0.578125
0.578125 0.5758928656578064
0.5758928656578064
0.4563027024269104
6160000
1/27/1981 0.5758928656578064
0.5758928656578064
0.5714285969734192
0.5714285969734192
0.4527655839920044
5924800
1/28/1981 0.5558035969734192
0.5558035969734192
0.5535714030265808
0.5535714030265808
0.4386165738105774
7039200
1/29/1981 0.5357142686843872
0.5357142686843872
0.5334821343421936
0.5334821343421936
0.42269906401634216
10976000
1/30/1981 0.5089285969734192
0.5089285969734192
0.5044642686843872
0.5044642686843872
0.3997070789337158
11547200
2/2/1981 0.4776785671710968
0.4776785671710968
0.4754464328289032
0.4754464328289032
0.37671515345573425
5941600
2/3/1981 0.4933035671710968
0.4955357015132904
0.4933035671710968
0.4933035671710968
0.39086395502090454
4788000
2/4/1981 0.5111607313156128
0.5133928656578064
0.5111607313156128
0.5111607313156128
0.40501296520233154
6966400
2/5/1981 0.5111607313156128
0.515625 0.5111607313156128
0.5111607313156128
0.40501296520233154
1982400
2/6/1981 0.5133928656578064
0.515625 0.5133928656578064
0.5133928656578064
0.40678155422210693
3466400
2/9/1981 0.4910714328289032
0.4910714328289032
0.4866071343421936
0.4866071343421936
0.38555816
4188800
2/10/1981 0.4866071343421936
0.4888392984867096
0.4866071343421936
0.4866071343421936
0.38555816
4586400
2/11/1981 0.4732142984867096
0.4732142984867096
0.4709821343421936
0.4709821343421936
0.37317776679992676
3460800
2/12/1981
0.46875
0.46875 0.4665178656578064
0.4665178656578064
0.36964061856269836
3640000
2/13/1981 0.4598214328289032
0.4598214328289032
0.4553571343421936
0.4553571343421936
0.36079761385917664
2788800
2/17/1981 0.4665178656578064
0.46875 0.4665178656578064
0.4665178656578064
0.36964061856269836
3068800
2/18/1981 0.4866071343421936
0.4910714328289032
0.4866071343421936
0.4866071343421936
0.38555816
4810400
2/19/1981 0.4598214328289032
0.4598214328289032
0.4575892984867096
0.4575892984867096
0.3625660538673401
5577600
2/20/1981 0.4352678656578064
0.4352678656578064
0.4330357015132904
0.4330357015132904
0.3431113362312317
6092800
2/23/1981 0.4397321343421936
0.4419642984867096
0.4397321343421936
0.4397321343421936
0.3484172224998474
3528000
2/24/1981 0.4285714328289032
0.4285714328289032
0.4241071343421936
0.4241071343421936
0.3360368311405182
4244800
2/25/1981 0.4508928656578064
0.453125 0.4508928656578064
0.4508928656578064
0.3572602868080139
4872000
2/26/1981 0.4575892984867096
0.4598214328289032
0.4575892984867096
0.4575892984867096
0.3625660538673401
2710400
2/27/1981 0.4732142984867096
0.4776785671710968
0.4732142984867096
0.4732142984867096
0.3749464452266693
3690400
3/2/1981 0.4754464328289032
0.4776785671710968
0.4754464328289032
0.4754464328289032
0.37671515345573425
2940000
3/3/1981 0.4709821343421936
0.4709821343421936
0.46875
0.46875 0.3714093267917633
4043200
3/4/1981 0.4665178656578064
0.4665178656578064
0.4642857015132904
0.4642857015132904
0.3678719997406006
3427200
3/5/1981 0.4642857015132904
0.4642857015132904
0.4620535671710968
0.4620535671710968
0.3661033511161804
1344000
3/6/1981 0.4620535671710968
0.4620535671710968
0.4575892984867096
0.4575892984867096
0.3625660538673401
2900800
3/9/1981 0.4241071343421936
0.4241071343421936
0.421875
0.421875 0.3342682719230652
3830400
3/10/1981 0.4040178656578064
0.4040178656578064
0.4017857015132904
0.4017857015132904
0.3183508515357971
7095200
3/11/1981
0.390625
0.390625 0.3861607015132904
0.3861607015132904
0.3059704303741455
7464800
3/12/1981 0.4017857015132904
0.4040178656578064
0.4017857015132904
0.4017857015132904
0.3183508515357971
14812000
3/13/1981 0.3995535671710968
0.3995535671710968
0.3973214328289032
0.3973214328289032
0.31481367349624634
57825600
3/16/1981 0.4129464328289032
0.4174107015132904
0.4129464328289032
0.4129464328289032
0.32719382643699646
9307200
3/17/1981 0.4330357015132904
0.4375 0.4330357015132904
0.4330357015132904
0.3431113362312317
10936800
3/18/1981 0.4598214328289032
0.4642857015132904
0.4598214328289032
0.4598214328289032
0.36433476209640503
9234400
3/19/1981 0.4575892984867096
0.4575892984867096
0.4553571343421936
0.4553571343421936
0.36079761385917664
9452800
3/20/1981 0.4598214328289032
0.4642857015132904
0.4598214328289032
0.4598214328289032
0.36433476209640503
3651200
3/23/1981 0.4776785671710968
0.4821428656578064
0.4776785671710968
0.4776785671710968
0.37848371267318726
5504800
3/24/1981 0.4776785671710968
0.4776785671710968
0.4754464328289032
0.4754464328289032
0.37671515345573425
7039200
3/25/1981 0.4709821343421936
0.4709821343421936
0.4665178656578064
0.4665178656578064
0.36964061856269836
1764000
3/26/1981 0.4598214328289032
0.4598214328289032
0.4575892984867096
0.4575892984867096
0.3625660538673401
3068800
3/27/1981 0.4441964328289032
0.4441964328289032
0.4419642984867096
0.4419642984867096
0.3501858413219452
3063200
3/30/1981 0.4419642984867096
0.4464285671710968
0.4419642984867096
0.4419642984867096
0.3501858413219452
2475200
3/31/1981 0.4419642984867096
0.4419642984867096
0.4375
0.4375 0.3466486632823944
3998400
4/1/1981 0.4352678656578064
0.4352678656578064
0.4330357015132904
0.4330357015132904
0.3431113362312317
8517600
4/2/1981 0.4709821343421936
0.4732142984867096
0.4709821343421936
0.4709821343421936
0.37317776679992676
7851200
4/3/1981 0.4732142984867096
0.4754464328289032
0.4732142984867096
0.4732142984867096
0.3749464452266693
4121600
4/6/1981 0.4665178656578064
0.4665178656578064
0.4642857015132904
0.4642857015132904
0.3678719997406006
5700800
4/7/1981 0.4620535671710968
0.4620535671710968
0.4598214328289032
0.4598214328289032
0.36433476209640503
2671200
4/8/1981 0.4821428656578064
0.4866071343421936
0.4821428656578064
0.4821428656578064
0.3820209205150604
5488000
4/9/1981 0.4910714328289032
0.4933035671710968
0.4910714328289032
0.4910714328289032
0.3890954852104187
3124800
4/10/1981 0.4977678656578064 0.5 0.4977678656578064
0.4977678656578064
0.3944011628627777
8366400
4/13/1981 0.4977678656578064 0.5 0.4977678656578064
0.4977678656578064
0.3944011628627777
4015200
4/14/1981 0.4977678656578064 0.5 0.4977678656578064
0.4977678656578064
0.3944011628627777
1663200
4/15/1981 0.4754464328289032
0.4754464328289032
0.4732142984867096
0.4732142984867096
0.3749464452266693
8512000
4/16/1981 0.4486607015132904
0.4486607015132904
0.4464285671710968
0.4464285671710968
0.35372301936149597
5969600
4/20/1981 0.4598214328289032
0.4620535671710968
0.4598214328289032
0.4598214328289032
0.36433476209640503
8836800
4/21/1981 0.4910714328289032
0.4933035671710968
0.4910714328289032
0.4910714328289032
0.3890954852104187
7134400
4/22/1981 0.5089285969734192
0.5111607313156128
0.5089285969734192
0.5089285969734192
0.40324429
4748800
4/23/1981 0.5223214030265808
0.5245535969734192
0.5223214030265808
0.5223214030265808
0.41385602951049805
14504000
4/24/1981 0.5223214030265808
0.5223214030265808
0.5178571343421936
0.5178571343421936
0.4103188216686249
8764000
4/27/1981
0.515625
0.515625 0.5133928656578064
0.5133928656578064
0.40678155422210693
9632000
4/28/1981 0.5066964030265808
0.5066964030265808
0.5044642686843872
0.5044642686843872
0.3997070789337158
8047200
4/29/1981
0.5
0.5 0.4977678656578064
0.4977678656578064
0.3944011628627777
3410400
4/30/1981 0.5066964030265808
0.5111607313156128
0.5066964030265808
0.5066964030265808
0.40147573
3152800
5/1/1981 0.5066964030265808
0.5111607313156128
0.5066964030265808
0.5066964030265808
0.40147573
4138400
5/4/1981 0.5066964030265808
0.5066964030265808
0.5044642686843872
0.5044642686843872
0.3997070789337158
3612000
5/5/1981 0.5044642686843872
0.5044642686843872
0.5022321343421936
0.5022321343421936
0.39793848991394043
4384800
5/6/1981 0.4910714328289032
0.4910714328289032
0.4888392984867096
0.4888392984867096
0.38732683658599854
4737600
5/7/1981 0.4955357015132904
0.4977678656578064
0.4955357015132904
0.4955357015132904
0.3926325738430023
2340800
5/8/1981
0.5 0.5022321343421936 0.5
0.5 0.39616990089416504
1976800
5/11/1981 0.4910714328289032
0.4910714328289032
0.4888392984867096
0.4888392984867096
0.38732683658599854
2984800
5/12/1981 0.4888392984867096
0.4955357015132904
0.4888392984867096
0.4888392984867096
0.38732683658599854
1064000
5/13/1981 0.4888392984867096
0.4933035671710968
0.4866071343421936
0.4866071343421936
0.38555816
1226400
5/14/1981
0.484375
0.484375 0.4799107015132904
0.4799107015132904
0.38025227189064026
1232000
5/15/1981 0.4910714328289032
0.4977678656578064
0.4910714328289032
0.4910714328289032
0.3890954852104187
1226400
5/18/1981
0.5 0.5044642686843872 0.5
0.5 0.39616990089416504
1041600
5/19/1981 0.4933035671710968
0.4933035671710968
0.4910714328289032
0.4910714328289032
0.3890954852104187
6356000
5/20/1981 0.5066964030265808
0.5111607313156128
0.5066964030265808
0.5066964030265808
0.40147573
3320800
5/21/1981 0.5357142686843872
0.5379464030265808
0.5357142686843872
0.5357142686843872
0.4244675934314728
8052800
5/22/1981 0.5602678656578064
0.5647321343421936
0.5602678656578064
0.5602678656578064
0.4439224600791931
7856800
5/26/1981 0.5602678656578064
0.5602678656578064
0.5580357313156128
0.5580357313156128
0.4421537220478058
21336000
5/27/1981 0.5892857313156128
0.5915178656578064
0.5892857313156128
0.5892857313156128
0.4669145345687866
37374400
5/28/1981 0.5892857313156128
0.5915178656578064
0.5892857313156128
0.5892857313156128
0.4669145345687866
18496800
5/29/1981 0.5915178656578064
0.59375 0.5915178656578064
0.5915178656578064
0.4686829745769501
14845600
6/1/1981 0.5915178656578064
0.59375 0.5915178656578064
0.5915178656578064
0.4686829745769501
12812800
6/2/1981 0.5647321343421936
0.5647321343421936
0.5625
0.5625 0.4456910490989685
10108000
6/3/1981
0.5625 0.5669642686843872
0.5625
0.5625 0.4456910490989685
9861600
6/4/1981 0.5736607313156128
0.5758928656578064
0.5736607313156128
0.5736607313156128
0.4545341432094574
14016800
6/5/1981 0.5669642686843872
0.5669642686843872
0.5647321343421936
0.5647321343421936
0.44745975732803345
14420000
6/8/1981
0.546875
0.546875 0.5446428656578064
0.5446428656578064
0.4315420687198639
23374400
6/9/1981 0.5558035969734192
0.5580357313156128
0.5558035969734192
0.5558035969734192
0.44038525223731995
29898400
6/10/1981
0.5625 0.5691964030265808
0.5625
0.5625 0.4456910490989685
6305600
6/11/1981 0.5870535969734192
0.5892857313156128
0.5870535969734192
0.5870535969734192
0.46514588594436646
9744000
6/12/1981 0.5825892686843872
0.5825892686843872
0.5803571343421936
0.5803571343421936
0.4598398804664612
6451200
6/15/1981 0.5803571343421936
0.5803571343421936
0.578125
0.578125 0.45807135105133057
35940800
6/16/1981 0.5691964030265808
0.5691964030265808
0.5669642686843872
0.5669642686843872
0.44922828674316406
9312800
6/17/1981 0.5602678656578064
0.5602678656578064
0.5580357313156128
0.5580357313156128
0.4421537220478058
6893600
6/18/1981 0.5580357313156128
0.5602678656578064
0.5558035969734192
0.5558035969734192
0.44038525223731995
5762400
6/19/1981 0.5424107313156128
0.5424107313156128
0.5401785969734192
0.5401785969734192
0.42800483107566833
6876800
6/22/1981 0.5223214030265808
0.5223214030265808
0.5200892686843872
0.5200892686843872
0.4120873808860779
2710400
6/23/1981 0.5290178656578064
0.5334821343421936
0.5290178656578064
0.5290178656578064
0.4191618859767914
3757600
6/24/1981 0.5200892686843872
0.5200892686843872
0.515625
0.515625 0.40855029225349426
5756800
6/25/1981 0.5267857313156128
0.5290178656578064
0.5267857313156128
0.5267857313156128
0.41739314794540405
6064800
6/26/1981 0.5245535969734192
0.5245535969734192
0.5200892686843872
0.5200892686843872
0.4120873808860779
5947200
6/29/1981 0.5066964030265808
0.5066964030265808
0.5022321343421936
0.5022321343421936
0.39793848991394043
2648800
6/30/1981 0.4665178656578064
0.4665178656578064
0.4642857015132904
0.4642857015132904
0.3678719997406006
8976800
7/1/1981 0.4620535671710968
0.4620535671710968
0.4598214328289032
0.4598214328289032
0.36433476209640503
42616000
7/2/1981 0.4598214328289032
0.4620535671710968
0.4598214328289032
0.4598214328289032
0.36433476209640503
7571200
7/6/1981 0.4486607015132904
0.4486607015132904
0.4441964328289032
0.4441964328289032
0.35195446014404297
4132800
7/7/1981 0.4486607015132904
0.453125 0.4486607015132904
0.4486607015132904
0.3554917573928833
3959200
7/8/1981 0.4665178656578064
0.46875 0.4665178656578064
0.4665178656578064
0.36964061856269836
4155200
7/9/1981 0.4330357015132904
0.4330357015132904
0.4308035671710968
0.4308035671710968
0.3413427472114563
8220800
7/10/1981 0.3995535671710968
0.3995535671710968
0.3973214328289032
0.3973214328289032
0.31481367349624634
13792800
7/13/1981
0.40625 0.4084821343421936
0.40625
0.40625 0.32188811898231506
11435200
7/14/1981 0.4241071343421936
0.4285714328289032
0.4241071343421936
0.4241071343421936
0.3360368311405182
4944800
7/15/1981 0.4352678656578064
0.4375 0.4352678656578064
0.4352678656578064
0.34488004446029663
2738400
7/16/1981 0.4464285671710968
0.4508928656578064
0.4464285671710968
0.4464285671710968
0.35372301936149597
3808000
7/17/1981 0.4620535671710968
0.4642857015132904
0.4620535671710968
0.4620535671710968
0.3661033511161804
4956000
7/20/1981 0.4330357015132904
0.4330357015132904
0.4308035671710968
0.4308035671710968
0.3413427472114563
5913600
7/21/1981 0.4308035671710968
0.4308035671710968
0.4285714328289032
0.4285714328289032
0.3395741581916809
7985600
7/22/1981 0.4084821343421936
0.4084821343421936
0.4040178656578064
0.4040178656578064
0.32011938095092773
5667200
7/23/1981 0.4151785671710968
0.4174107015132904
0.4151785671710968
0.4151785671710968
0.32896244525909424
8612800
7/24/1981 0.4285714328289032
0.4308035671710968
0.4285714328289032
0.4285714328289032
0.3395741581916809
7212800
7/27/1981 0.4464285671710968
0.4486607015132904
0.4464285671710968
0.4464285671710968
0.35372301936149597
4334400
7/28/1981 0.4330357015132904
0.4330357015132904
0.4308035671710968
0.4308035671710968
0.3413427472114563
5712000
7/29/1981 0.4263392984867096
0.4263392984867096
0.4241071343421936
0.4241071343421936
0.3360368311405182
3875200
7/30/1981 0.4397321343421936
0.4441964328289032
0.4397321343421936
0.4397321343421936
0.3484172224998474
2475200
7/31/1981 0.4464285671710968
0.4486607015132904
0.4464285671710968
0.4464285671710968
0.35372301936149597
2738400
8/3/1981 0.4464285671710968
0.4464285671710968
0.4419642984867096
0.4419642984867096
0.3501858413219452
3108000
8/4/1981 0.4486607015132904
0.4508928656578064
0.4486607015132904
0.4486607015132904
0.3554917573928833
7918400
8/5/1981 0.4620535671710968
0.4642857015132904
0.4620535671710968
0.4620535671710968
0.3661033511161804
4373600
8/6/1981
0.453125
0.453125 0.4508928656578064
0.4508928656578064
0.3572602868080139
2632000
8/7/1981 0.4508928656578064
0.453125 0.4508928656578064
0.4508928656578064
0.3572602868080139
2301600
8/11/1981 0.4419642984867096
0.4419642984867096
0.4375
0.4375 0.3466486632823944
17864000
8/12/1981 0.4308035671710968
0.4308035671710968
0.4285714328289032
0.4285714328289032
0.3395741581916809
6568800
8/13/1981 0.4174107015132904
0.4174107015132904
0.4151785671710968
0.4151785671710968
0.32896244525909424
6871200
8/14/1981 0.4129464328289032
0.4129464328289032
0.4084821343421936
0.4084821343421936
0.3236565887928009
6048000
8/17/1981 0.3995535671710968
0.3995535671710968
0.3950892984867096
0.3950892984867096
0.3130449652671814
4726400
8/18/1981
0.390625
0.390625 0.3861607015132904
0.3861607015132904
0.3059704303741455
4250400
8/19/1981 0.3861607015132904
0.3861607015132904
0.3816964328289032
0.3816964328289032
0.3024332523345947
5168800
8/20/1981 0.3861607015132904
0.3883928656578064
0.3861607015132904
0.3861607015132904
0.3059704303741455
4278400
8/21/1981 0.3638392984867096
0.3638392984867096
0.359375
0.359375 0.2847471237182617
10477600
8/24/1981 0.3392857015132904
0.3392857015132904
0.3370535671710968
0.3370535671710968
0.2670608460903168
5768000
8/25/1981 0.3459821343421936
0.3482142984867096
0.3459821343421936
0.3459821343421936
0.27413538098335266
10175200
8/26/1981 0.3415178656578064
0.3415178656578064
0.3392857015132904
0.3392857015132904
0.2688296437263489
8400000
8/27/1981 0.3415178656578064
0.34375 0.3415178656578064
0.3415178656578064
0.2705981433391571
6479200
8/28/1981
0.359375 0.3616071343421936
0.359375
0.359375 0.2847471237182617
9508800
8/31/1981
0.359375 0.3616071343421936
0.359375
0.359375 0.2847471237182617
10236800
9/1/1981 0.3816964328289032
0.3839285671710968
0.3816964328289032
0.3816964328289032
0.3024332523345947
9256800
9/2/1981 0.3883928656578064
0.390625 0.3883928656578064
0.3883928656578064
0.30773926
4844000
9/3/1981 0.3727678656578064
0.3727678656578064
0.3683035671710968
0.3683035671710968
0.2918216288089752
9368800
9/4/1981 0.3660714328289032
0.3660714328289032
0.3638392984867096
0.3638392984867096
0.2882843315601349
3813600
9/8/1981 0.3549107015132904
0.3549107015132904
0.3526785671710968
0.3526785671710968
0.2794412672519684
6361600
9/9/1981 0.3526785671710968
0.3549107015132904
0.3526785671710968
0.3526785671710968
0.2794412672519684
7632800
9/10/1981 0.3549107015132904
0.3571428656578064
0.3549107015132904
0.3549107015132904
0.2812098264694214
8702400
9/11/1981 0.3526785671710968
0.3526785671710968
0.3504464328289032
0.3504464328289032
0.27767268
4384800
9/14/1981 0.3415178656578064
0.3415178656578064
0.3392857015132904
0.3392857015132904
0.2688296437263489
6921600
9/15/1981 0.3325892984867096
0.3325892984867096
0.3303571343421936
0.3303571343421936
0.2617550790309906
4877600
9/16/1981 0.3258928656578064
0.3258928656578064
0.3236607015132904
0.3236607015132904
0.2564491927623749
4838400
9/17/1981 0.3169642984867096
0.3169642984867096
0.3147321343421936
0.3147321343421936
0.24937471747398376
4844000
9/18/1981 0.3169642984867096
0.3191964328289032
0.3169642984867096
0.3169642984867096
0.2511433959007263
6580000
9/21/1981 0.3191964328289032
0.3214285671710968
0.3191964328289032
0.3191964328289032
0.25291192531585693
12258400
9/22/1981 0.3035714328289032
0.3035714328289032
0.3013392984867096
0.3013392984867096
0.23876310884952545
11855200
9/23/1981 0.2991071343421936
0.2991071343421936
0.2946428656578064
0.2946428656578064
0.2334572672843933
7050400
9/24/1981 0.2946428656578064
0.2946428656578064
0.2924107015132904
0.2924107015132904
0.23168860375881195
4575200
9/25/1981 0.2589285671710968
0.2589285671710968
0.2544642984867096
0.2544642984867096
0.2016221433877945
8652000
9/28/1981 0.2566964328289032
0.2589285671710968
0.2566964328289032
0.2566964328289032
0.20339077711105347
22932000
9/29/1981 0.2700892984867096
0.2723214328289032
0.2700892984867096
0.2700892984867096
0.21400241553783417
23671200
9/30/1981 0.2723214328289032
0.2745535671710968
0.2723214328289032
0.2723214328289032
0.21577103435993195
12499200
10/1/1981 0.2723214328289032
0.2745535671710968
0.2723214328289032
0.2723214328289032
0.21577103435993195
15282400
10/2/1981 0.2946428656578064
0.296875 0.2946428656578064
0.2946428656578064
0.2334572672843933
11261600
10/5/1981 0.3035714328289032
0.3080357015132904
0.3035714328289032
0.3035714328289032
0.24053166806697845
10774400
10/6/1981 0.3035714328289032
0.3035714328289032
0.3013392984867096
0.3013392984867096
0.23876310884952545
7089600
10/7/1981 0.3191964328289032
0.3236607015132904
0.3191964328289032
0.3191964328289032
0.25291192531585693
9710400
10/8/1981 0.3303571343421936
0.3325892984867096
0.3303571343421936
0.3303571343421936
0.2617550790309906
7772800
10/9/1981 0.3325892984867096
0.3370535671710968
0.3325892984867096
0.3325892984867096
0.26352381706237793
13630400
10/12/1981
0.34375 0.3459821343421936
0.34375
0.34375 0.2723669409751892
6837600
10/13/1981
0.34375 0.3482142984867096
0.34375
0.34375 0.2723669409751892
11048800
10/14/1981 0.3258928656578064
0.3258928656578064
0.3236607015132904
0.3236607015132904
0.2564491927623749
7744800
10/15/1981 0.3303571343421936
0.3325892984867096
0.3303571343421936
0.3303571343421936
0.2617550790309906
7358400
10/16/1981
0.328125
0.328125 0.3258928656578064
0.3258928656578064
0.25821784138679504
9116800
10/19/1981 0.3325892984867096
0.3348214328289032
0.3325892984867096
0.3325892984867096
0.26352381706237793
5146400
10/20/1981 0.3504464328289032
0.3526785671710968
0.3504464328289032
0.3504464328289032
0.27767268
8932000
10/21/1981 0.3504464328289032
0.3526785671710968
0.3504464328289032
0.3504464328289032
0.27767268
19224800
10/22/1981 0.3504464328289032
0.3504464328289032
0.3482142984867096
0.3482142984867096
0.2759040594100952
8069600
10/23/1981 0.3415178656578064
0.3415178656578064
0.3392857015132904
0.3392857015132904
0.2688296437263489
6977600
10/26/1981 0.3392857015132904
0.3415178656578064
0.3392857015132904
0.3392857015132904
0.2688296437263489
6820800
10/27/1981 0.3459821343421936
0.3504464328289032
0.3459821343421936
0.3459821343421936
0.27413538098335266
21397600
10/28/1981 0.3571428656578064
0.359375 0.3571428656578064
0.3571428656578064
0.2829784154891968
11043200
10/29/1981 0.3549107015132904
0.3549107015132904
0.3526785671710968
0.3526785671710968
0.2794412672519684
7621600
10/30/1981 0.3571428656578064
0.359375 0.3571428656578064
0.3571428656578064
0.2829784154891968
13182400
11/2/1981 0.3571428656578064
0.359375 0.3571428656578064
0.3571428656578064
0.2829784154891968
9228800
11/3/1981 0.3549107015132904
0.3549107015132904
0.3526785671710968
0.3526785671710968
0.2794412672519684
7095200
11/4/1981 0.3459821343421936
0.3459821343421936
0.34375
0.34375 0.2723669409751892
5952800
11/5/1981 0.3214285671710968
0.3214285671710968
0.3191964328289032
0.3191964328289032
0.25291192531585693
5840800
11/6/1981 0.3214285671710968
0.3236607015132904
0.3214285671710968
0.3214285671710968
0.2546806037425995
6148800
11/9/1981 0.3258928656578064
0.328125 0.3258928656578064
0.3258928656578064
0.25821784138679504
5096000
11/10/1981
0.328125 0.3303571343421936
0.328125
0.328125 0.2599865198135376
4188800
11/11/1981 0.3370535671710968
0.3392857015132904
0.3370535671710968
0.3370535671710968
0.2670608460903168
6860000
11/12/1981 0.3482142984867096
0.3504464328289032
0.3482142984867096
0.3482142984867096
0.2759040594100952
9979200
11/13/1981 0.3258928656578064
0.3258928656578064
0.3236607015132904
0.3236607015132904
0.2564491927623749
5252800
11/16/1981 0.3214285671710968
0.3214285671710968
0.3191964328289032
0.3191964328289032
0.25291192531585693
5639200
11/17/1981 0.3258928656578064
0.328125 0.3258928656578064
0.3258928656578064
0.25821784138679504
8853600
11/18/1981 0.3370535671710968
0.3392857015132904
0.3370535671710968
0.3370535671710968
0.2670608460903168
7285600
11/19/1981 0.3370535671710968
0.3392857015132904
0.3370535671710968
0.3370535671710968
0.2670608460903168
10001600
11/20/1981 0.3392857015132904
0.3415178656578064
0.3392857015132904
0.3392857015132904
0.2688296437263489
9525600
11/23/1981
0.328125
0.328125 0.3236607015132904
0.3236607015132904
0.2564491927623749
5740000
11/24/1981 0.3236607015132904
0.3236607015132904
0.3214285671710968
0.3214285671710968
0.2546806037425995
5538400
11/25/1981
0.328125 0.3303571343421936
0.328125
0.328125 0.2599865198135376
13137600
11/27/1981 0.3370535671710968
0.3392857015132904
0.3370535671710968
0.3370535671710968
0.2670608460903168
9312800
11/30/1981 0.3348214328289032
0.3348214328289032
0.3325892984867096
0.3325892984867096
0.26352381706237793
5992000
12/1/1981 0.3325892984867096
0.3348214328289032
0.3325892984867096
0.3325892984867096
0.26352381706237793
5846400
12/2/1981 0.3348214328289032
0.3370535671710968
0.3348214328289032
0.3348214328289032
0.26529231667518616
9391200
12/3/1981 0.3325892984867096
0.3325892984867096
0.3303571343421936
0.3303571343421936
0.2617550790309906
5107200
12/4/1981 0.3392857015132904
0.3415178656578064
0.3392857015132904
0.3392857015132904
0.2688296437263489
34288800
12/7/1981 0.3415178656578064
0.34375 0.3415178656578064
0.341517865
