Q1) construct a contingency table for the positive and non-positive returns of the two stocks Date BIT MAC 11/3/13 52.06 37.7145 18/3/13 53.84 34.8626 25/3/13 99.99 36.5344 1/4/13 139.23 36.023 8/4/13 113.07 37.5375 15/4/13 123.93 35.3838 22/4/13 141.36 37.3506 29/4/13 126.5 42.3956 6/5/13 120.39 45.2082 13/5/13 125.5 43.8118 20/5/13 142.52 41.8547 27/5/13 137.88 42.4546 3/6/13 115.66 39.6617 10/6/13 120.98 40.8615 17/6/13 125.28 41.127 24/6/13 111.97 41.1762 1/7/13 97.54 41.2647 8/7/13 114.95 43.9986 15/7/13 96.5 43.3299 22/7/13 92 42.2973 29/7/13 99.95 44.451 5/8/13 125.49 43.025 12/8/13 104.1 43.6839 19/8/13 109.53 43.8904 26/8/13 158.75 43.1332 2/9/13 136.12 45.4049 9/9/13 147.87 47.9913 16/9/13 143.09 49.1715 23/9/13 142.08 48.0897 30/9/13 140.24 47.7455 7/10/13 151.77 47.2538 14/10/13 193.52 49.3386 21/10/13 213.89 50.3516 28/10/13 233.5 52.2201 4/11/13 331.05 53.6559 11/11/13 547.08 53.6461 18/11/13 974.55 53.5969 25/11/13 1191.99 53.2822 2/12/13 1016.27 50.9908 9/12/13 1027.82 51.335 16/12/13 781.78 54.8 23/12/13 889.11 54.95 30/12/13 999 55 please construct...

70.2K

Verified Solution

Question

Statistics

Q1) construct a contingency tablefor the positive and non-positive returns of the two stocks

DateBITMAC
11/3/1352.0637.7145
18/3/1353.8434.8626
25/3/1399.9936.5344
1/4/13139.2336.023
8/4/13113.0737.5375
15/4/13123.9335.3838
22/4/13141.3637.3506
29/4/13126.542.3956
6/5/13120.3945.2082
13/5/13125.543.8118
20/5/13142.5241.8547
27/5/13137.8842.4546
3/6/13115.6639.6617
10/6/13120.9840.8615
17/6/13125.2841.127
24/6/13111.9741.1762
1/7/1397.5441.2647
8/7/13114.9543.9986
15/7/1396.543.3299
22/7/139242.2973
29/7/1399.9544.451
5/8/13125.4943.025
12/8/13104.143.6839
19/8/13109.5343.8904
26/8/13158.7543.1332
2/9/13136.1245.4049
9/9/13147.8747.9913
16/9/13143.0949.1715
23/9/13142.0848.0897
30/9/13140.2447.7455
7/10/13151.7747.2538
14/10/13193.5249.3386
21/10/13213.8950.3516
28/10/13233.552.2201
4/11/13331.0553.6559
11/11/13547.0853.6461
18/11/13974.5553.5969
25/11/131191.9953.2822
2/12/131016.2750.9908
9/12/131027.8251.335
16/12/13781.7854.8
23/12/13889.1154.95
30/12/1399955

please construct on on excel.

Answer & Explanation Solved by verified expert
4.0 Ratings (435 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students