Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
answerhappygod
Site Admin
Posts: 899604Joined: Mon Aug 02, 2021 8:13 am
Post
by answerhappygod Wed May 11, 2022 7:18 pm
1. The file Tesla share price (Excel below) contains the data
about the average weekly price per share of Tesla from March
4th, 2020 to March 30th, 2022.
a. Construct a frequency distribution and a percentage
distribution that have class intervals with the lower-class
boundaries $50, $250, and so on (using Excel).
b. Construct a histogram.
c. Around what amount does the Tesla’s weekly share price seem
to be concentrated?
1 The File Tesla Share Price Excel Below Contains The Data About The Average Weekly Price Per Share Of Tesla From Mar 1 (111.82 KiB) Viewed 20 times
Date Weekly Price 3/4/20 129 3/11/20 86 3/18/20 101 3/25/20 105 4/1/20 109 4/8/20 142 4/15/20 137 4/22/20 154 4/29/20 154 5/6/20 162 5/13/20 162 5/20/20 164 5/27/20 176 6/3/20 188 6/10/20 196 6/17/20 200 6/24/20 216 7/1/20 278 7/8/20 303 7/15/20 314 7/22/20 295 7/29/20 297 8/5/20 275 8/12/20 377 8/19/20 405 8/26/20 475 9/2/20 330 9/9/20 450 9/16/20 424 9/23/20 419 9/30/20 414 10/7/20 447 10/14/20 422 10/21/20 425 10/28/20 424 11/4/20 410 11/11/20 442 11/18/20 555 11/25/20 585 12/2/20 650 12/9/20 633 12/16/20 640 12/23/20 666 12/30/20 735 1/6/21 849 1/13/21 845 1/20/21 883 1/27/21 873 2/3/21 849
2/10/21 2/17/21 2/24/21 3/3/21 3/10/21 3/17/21 3/24/21 3/31/21 4/7/21 4/14/21 4/21/21 4/28/21 5/5/21 5/12/21 5/19/21 5/26/21 6/2/21 6/9/21 6/16/21 6/23/21 6/30/21 7/7/21 7/14/21 7/21/21 7/28/21 8/4/21 8/11/21 8/18/21 8/25/21 9/1/21 9/8/21 9/15/21 9/22/21 9/29/21 10/6/21 10/13/21 10/20/21 10/27/21 11/3/21 11/10/21 11/17/21 11/24/21 12/1/21 12/8/21 12/15/21 12/22/21 12/29/21 1/5/22 796 699 686 674 677 662 636 692 762 719 705 674 617 578 605 624 604 599 624 681 660 669 661 645 710 710 666 708 736 753 744 739 778 781 806 864 1018 1172 1024 1055 1109 1145 1052 959 939 1088 1150 1064
1/12/22 1/19/22 1/26/22 2/2/22 2/9/22 2/16/22 2/23/22 3/2/22 3/9/22 3/16/22 3/23/22 3/30/22 1031 918 931 922 922 822 864 824 802 994 1100 1091
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!