cpy these figures in excel sheet

Use the following link to a larger data set, the daily average of the Canadian Dollar - European Euro exchange rate from Jan 1st 2020 to Oct 9th 2021. Weekends and holidays are excluded.

Considering the size of the dataset, I suggest calculating in Excel.

https://mycbu-my.sharepoint.com/:x:/g/personal/adam_brown_cbu_ca/EY1Q7R_5Hq5FsYW1kZZ8ODQB28ssi_kjngiRnMMPfyK6LQ?e=I3hbPi

Calculate the following. Consider this a sample. Use 4 decimal places.

Answer	Mean
Answer	Median
Answer	Range
Answer	Standard Deviation

Questions about modal characteristics:

Does this data have a mode or is every value unique? AnswerNo ModeHas a Mode

If it has a mode, does it have one mode (unimodal), 2 modes (bimodal), or more than two modes (multimodal)?

Unimodal

Bimodal

Multimodal

N/A

Calculating modes:

If this data has multiple modes, how many modes does it have? Answer

What is the lowest modal value? Answer

What is the highest modal value? Answer

Take the arithmetic mean of any and all modes in this data. Answer

How to calculate modes (hints for above)

Are the Excel functionsMODE.SNGLE and MODEefficient choices to help you answer a question about multiple modes?

AnswerNoProbably NotYes

While UNIQUE and COUNTIF can be useful, what is the most direct function to find multiple modes? AnswerTHROW.DARTROMANMODE.MULT

Do you know how to use array functions in Excel? AnswerYes, I learned it for this question (Google, YouTube, etc.)Yes, I already didNo, I used a more painful method to find the modes (don't pick this answer)

Probability

What is the probability of selecting a day when the exchange rate was greaterthan the median? Answer

What is the probability of selecting a day when the exchange rate wasgreater than the mean? Answer

How does this data appear to be distributed? AnswerNormallyUniformlyHypergeometricallyNone of the Above

*Hint appear, you should be able to avoid further calculations. You might graph it, make a histogram, or consider the measures of centre that you have found.

European Euro, daily average, exchange rate with Canadian Dollar
Jan 1st 2020 - Oct 9th 2021
1.452
1.4497
1.4515
1.4502
1.448
1.4526
1.4504
1.4528
1.453
1.4554
1.4532
1.4493
1.4471
1.4502
1.4541
1.4533
1.4493
1.4525
1.4509
1.452
1.4579
1.4653
1.4681
1.4662
1.4622
1.4596
1.4574
1.4548
1.451
1.4431
1.4378
1.4368
1.4326
1.4282
1.4312
1.4341
1.4407
1.4431
1.4476
1.4672
1.4766
1.489
1.4912
1.4902
1.5021
1.5187
1.5559
1.5571
1.5531
1.544
1.543
1.5574
1.5574
1.5772
1.5555
1.5327
1.5584
1.5634
1.5495
1.5487
1.5525
1.5613
1.5584
1.5538
1.5396
1.5267
1.5251
1.5245
1.5254
1.5277
1.5209
1.5253
1.536
1.5331
1.5262
1.5308
1.5412
1.5335
1.5185
1.5215
1.5227
1.5159
1.5117
1.5186
1.5453
1.5371
1.5225
1.5264
1.5141
1.5109
1.5156
1.5221
1.5255
1.5206
1.5248
1.5196
1.5254
1.5281
1.5272
1.524
1.5154
1.5144
1.5224
1.5314
1.5162
1.5101
1.5161
1.5279
1.5174
1.5121
1.5216
1.5225
1.5384
1.5309
1.5348
1.5279
1.5223
1.5238
1.5221
1.5236
1.5303
1.5316
1.5308
1.5345
1.5389
1.5305
1.5279
1.5247
1.5326
1.5337
1.5332
1.5328
1.5367
1.5407
1.5513
1.5453
1.545
1.552
1.5488
1.5452
1.554
1.5526
1.5608
1.5723
1.5682
1.5721
1.5851
1.5831
1.5732
1.5751
1.5764
1.5765
1.5701
1.564
1.5626
1.5628
1.5678
1.5671
1.5718
1.5668
1.5633
1.5552
1.5599
1.5598
1.5544
1.5512
1.5576
1.5573
1.5592
1.547
1.5537
1.5478
1.5552
1.5552
1.5617
1.5612
1.5641
1.5622
1.5583
1.5603
1.5628
1.5624
1.5599
1.5599
1.5591
1.5575
1.5602
1.5705
1.5631
1.5612
1.5593
1.5631
1.5637
1.5623
1.5537
1.5524
1.5432
1.5447
1.5479
1.5465
1.551
1.5536
1.5571
1.5538
1.5568
1.5598
1.5568
1.5619
1.5586
1.5533
1.5421
1.5396
1.5391
1.5428
1.549
1.5357
1.538
1.5491
1.5548
1.5489
1.5541
1.55
1.5499
1.5503
1.5501
1.5473
1.5487
1.5494
1.5516
1.5509
1.5578
1.5635
1.5649
1.5548
1.553
1.5513
1.5472
1.5442
1.5472
1.5501
1.546
1.5532
1.5589
1.5638
1.5707
1.573
1.5669
1.5644
1.5688
1.5691
1.5608
1.5641
1.5611
1.5614
1.5589
1.5545
1.5549
1.5514
1.5459
1.5365
1.5393
1.5408
1.5443
1.5319
1.5347
1.5475
1.5463
1.5446
1.546
1.5535
1.5513
1.5487
1.5416
1.5368
1.5358
1.537
1.5363
1.5395
1.5392
1.5392
1.5396
1.5363
1.5305
1.5338
1.5293
1.533
1.5312
1.5234
1.5299
1.5348
1.5253
1.5234
1.524
1.5179
1.5098
1.5017
1.5028
1.5049
1.5033
1.4919
1.4883
1.4831
1.4858
1.4853
1.488
1.493
1.4908
1.4856
1.4858
1.4831
1.483
1.4808
1.4759
1.4781
1.4783
1.4879
1.4994
1.4977
1.492
1.4952
1.4984
1.5004
1.4998
1.4979
1.5063
1.5133
1.5056
1.5023
1.508
1.4997
1.4985
1.4941
1.4897
1.4798
1.4808
1.4803
1.4726
1.4708
1.4761
1.4707
1.471
1.462
1.4677
1.4697
1.468
1.4724
1.477
1.4744
1.4694
1.4767
1.4784
1.4723
1.4723
1.4749
1.4729
1.4709
1.4688
1.47
1.4713
1.4734
1.4741
1.4723
1.4709
1.4718
1.4774
1.4747
1.4711
1.4746
1.4741
1.4726
1.4675
1.4699
1.4685
1.4709
1.4733
1.4699
1.4638
1.4646
1.4718
1.4727
1.4855
1.4806
1.4789
1.4773
1.4778
1.4847
1.4869
1.5054
1.4988
1.4842
1.4804
1.4799
1.4813
1.4872
1.4839
1.4797
1.4788
1.4889
1.4867
1.4796
1.4768
1.4763
1.4695
1.4681
1.4692
1.4752
1.4803
1.4799
1.4789
1.495
1.5025
1.4886
1.4813
1.4832
1.4873
1.489
1.4867
1.4906
1.4932
1.4914
1.488
1.4954
1.4984
1.4965
1.4934
1.4942
1.4966
1.4945
1.4904
1.4937
1.5039
1.5013
1.4961
1.4854
1.4854
1.4788
1.4811
1.4801
1.4676
1.4627
1.4587
1.4563