Presenting Data Analysis Results Effectively

money017
PreviousAssignment2B.docx

Using Analytic Techniques to Add Meaning to Data 9

Using Analytic Techniques to Add Meaning to Data

3/12/2020

Introduction of The Company: Ford Motors

Since the organization's establishing in 1903, the name Ford has been similar with the car business. Company's originator Henry Ford Sr. got known for development, changing vehicles into commodities for the general population and his organization into an American symbol.

On June 16, 1903, Henry Ford and 11 shareholders sign articles of integration for Ford Motor Business in Michigan. Ford presents the Model T in 1908, which got one of the most mainstream vehicles on the planet. It was around this time only a couple of vehicles daily were being created at a leased production line in Detroit. In the Model T's first year a little more than 10,000 Model T's were delivered. Since interest for the Model T's turned out to be so high, the organization moved creation to a lot bigger plant in 1910. By 1913, Ford had built up the essential methods of a sequential construction system and had got creation down from 12 ½ hours to only 2 hours and 40 minutes, bringing down that much further to 1 hour and 33 minutes (A BRIEF HISTORY OF FORD MOTOR COMPANY).

As the second-biggest automobile enterprise in the world, Ford Motor Company speaks to a $164 billion global business realm. Referred to basically as a maker of vehicles, Ford additionally works Ford Credit, which produces more than $3 billion revenue, and possesses The Hertz Corporation, the biggest car rental organization in the world. The organization produces vehicles under the names Ford, Lincoln, Mercury, Jaguar, Volvo, Land Rover, and Aston Martin. Passage likewise keeps up controlling enthusiasm for Mazda Motor Corporation. Ford's economic stability was disturbed in early years of the new century because of easing back deals, quality issues, and a calamity, including Firestone wheels. Henry Ford and his architects planned a few cars, everyone assigned by a letter of the alphabet set; these incorporated the little, four-chamber Model N, and the more extravagant six-chamber Model K (Gross, July 2000).

Scatterplot of the highest stock price

From the above graph we can see that share prices change because of supply and demand. If people want to purchase a stock (demand) than sell it, then the price rises. As we can see in the above graph on 11th march 2019 stock price was 8.63 and it was rises to 10.51 in 4 months which means that company was flourished then again market fluctuates and stock price face ups and down in the entire year. The Ford Motor company's 52-week high stock price is 10.56, which is 68.7% overhead the present share price. In current days, stock price decreased to 6.29 from 10.56 which means people purchase the company's stock when the price surpasses its 52-week high.

Traded on an open market organization place incredible significance on their stock share value, which comprehensively mirrors a company's general financial health. Generally speaking, the higher a stock cost is, the more advantageous an organization's possibilities become (HAYES, 2019).

Investment analysts ceremonially track a traded on an open market organization's stock cost so as to check an organization's financial wellbeing, advertising execution, and general practicality. A consistently rising offer value flags that an organization's heavy hitters is guiding activities toward benefit. Moreover, if investors are satisfied, and the organization is tilting towards progress, as showed by a rising offer value, C-level administrators are probably going to hold their situations with the organization.

Scatterplot of the lowest stock price

From the above graph of the lowest stock price, we can see that on 11th march 2019 the stock price was 8.45 which went up to 10.14 in just 4 months and then it again fell down and goes these ups and downs continues in the entire year and ultimately in the year 2020, stock price of Ford company decreased to 5.8 in the month of march. The Ford Motor company's 52-week low share price is 5.80, which is 7.3% underneath the present share price. when the price decreased below its 52-week low then people will sell their stocks. It means that when the current stock price decreased from 5.80 then that would be the right time for investors to sell the stocks (CHEN, 2019).

Histogram of Adjusted daily closing stock price

The adjusted closing price is a further complex breakdown that treats the closing price as an initial point, but it considers aspects such as dividends, stock separations and extra stock contributions to fix a value. The adjusted closing price signifies a more precise image of a stock's value, meanwhile, distributions and new offerings can change the closing price. When a stock rises, or upsurges in value, the company may select to reward shareholders with a dividend. That dividend can derive either in the formula of money compensated per share or as an extra ratio of shares. When new stocks come in the marketplace, the price of the standing stocks reduced. The price reduced for the reason that the upsurge in the number of stocks makes each person share value decreased, just similar with stock separations. The adjusted closing price for the current offerings and the subsequent devaluation of each person shares (Bea Bischoff, 2019).

Histogram of Stock trading volume

Volume gauges the number of shares exchanged a stock or agreements exchanged prospects or alternatives. Volume can be an indication of market quality, as rising markets on expanding volume are commonly seen as solid and sound. At the point when prices fall on expanding volume, the pattern is gathering solidarity to the drawback. At the point when costs arrive at new highs on diminishing volume, look out; an inversion may be coming to success. A rising business sector should see the rising volume. Purchasers require expanding numbers and expanding passion so as to continue pushing costs higher. Expanding cost and diminishing volume may recommend an absence of intrigue, and this is a warning of a potential inversion. Mean, Median, Mode, and Standard Deviation of the Adjusted Daily Closing Stock Price:

Adj Close

Mean

8.87616

Median

8.918327

Mode

9.722382

S. D

0.694195

These insights are significant for investigation since they give us various measurements about the Ford Company Stock. For instance, we can see that the median cost is 8.91 yet the average cost is 8.87 which permits a financial specialist to decide how the stock is getting along in contrast with the minimum and maximum of adjusted daily close. Standard Deviation gives us further knowledge into the stock since it permits us to measure or put a numerical incentive to speak to the variety in the stock concerning the adjusted daily close.

Mean, Median, Mode, and Standard Deviation of the Stock Volume:

Volume

Mean

43429128

Median

37551600

Mode

39796300

S. D

22767037

Stock volume is the number of shares or agreements traded in safety or a whole market throughout a year. For every purchaser, there is a vender, and each contract subsidizes to the sum of total volume. As for Ford company, 43 million is the average number of shares that has been traded in the year of 2019-20. And 37 million is the middle value of the total shares that has been traded.

Standard Deviation is a factual term that gives a great indication of unpredictability. It gauges how generally values closing prices are scattered from the average price.

References A BRIEF HISTORY OF FORD MOTOR COMPANY. (n.d.). Retrieved from OSV: https://www.osv.ltd.uk/brief-history-of-ford/ Bea Bischoff, A. D. (2019, May 23). Adjusted Closing Price vs. Closing Price. Retrieved from The Nest: https://budgeting.thenest.com/adjusted-closing-price-vs-closing-price-32457.html CHEN, J. (2019, October 13). 52-Week High/Low. Retrieved from Investopedia: https://www.investopedia.com/terms/1/52weekhighlow.asp Ford Company. (n.d.). Retrieved from Yahoo Finance: https://finance.yahoo.com/quote/F/history Gross, K. (July 2000). Ford: Big, Bigger, Biggest. Automotive Industries, 64. HAYES, A. (2019, October 1). How to Understand a Stock Quote. Retrieved from Investopedia: https://www.investopedia.com/articles/investing/093014/stock-quotes-explained.asp

High 43535 43536 43537 43538 43539 43542 43543 43544 43545 43546 43549 43550 43551 43552 43553 43556 43557 43558 43559 43560 43563 43564 43565 43566 43567 43570 43571 43572 43573 43577 43578 43579 43580 43581 43584 43585 43586 43587 43588 43591 43592 43593 43594 43595 43598 43599 43600 43601 43602 43605 43606 43607 43608 43609 43613 43614 43615 43616 43619 43620 43621 43622 43623 43626 43627 43628 43629 43630 43633 43634 43635 43636 43637 43640 43641 43642 43643 43644 43647 43648 43649 43651 43654 43655 43656 43657 43658 43661 43662 43663 43664 43665 43668 43669 43670 43671 43672 43675 43676 43677 43678 43679 43682 43683 43684 43685 43686 43689 43690 43691 43692 43693 43696 43697 43698 43699 43700 43703 43704 43705 43706 43707 43711 43712 43713 43714 43717 43718 43719 43720 43721 43724 43725 43726 43727 43728 43731 43732 43733 43734 43735 43738 43739 43740 43741 43742 43745 43746 43747 43748 43749 43752 43753 43754 43755 43756 43759 43760 43761 43762 43763 43766 43767 43768 43769 43770 43773 43774 43775 43776 43777 43780 43781 43782 43783 43784 43787 43788 43789 43790 43791 43794 43795 43796 43798 43801 43802 43803 43804 43805 43808 43809 43810 43811 43812 43815 43816 43817 43818 43819 43822 43823 43825 43826 43829 43830 43832 43833 43836 43837 43838 43839 43840 43843 43844 43845 43846 43847 43851 43852 43853 43854 43857 43858 43859 43860 43861 43864 43865 43866 43867 43868 43871 43872 43873 43874 43875 43879 43880 43881 43882 43885 43886 43887 43888 43889 43892 43893 43894 43895 43896 43899 43900 8.6300000000000008 8.6999999999999993 8.65 8.5500000000000007 8.4700000000000006 8.57 8.8699999999999992 8.67 8.69 8.67 8.65 8.76 8.86 8.83 8.89 9 9.0299999999999994 9.27 9.3000000000000007 9.27 9.32 9.36 9.35 9.41 9.6 9.5 9.4 9.58 9.6199999999999992 9.58 9.51 9.61 9.5299999999999994 10.45 10.39 10.5 10.5 10.35 10.45 10.42 10.41 10.45 10.3 10.41 10.26 10.29 10.4 10.44 10.44 10.3 10.31 10.210000000000001 9.85 9.9499999999999993 9.9 9.75 9.84 9.5399999999999991 9.65 9.9499999999999993 9.92 9.82 9.82 10.029999999999999 9.98 9.93 10.06 10.039999999999999 10.09 10.199999999999999 10.18 10.15 10.050000000000001 10.02 9.99 9.9600000000000009 10.24 10.31 10.43 10.210000000000001 10.3 10.27 10.26 10.19 10.26 10.199999999999999 10.5 10.56 10.51 10.5 10.31 10.32 10.17 10.220000000000001 10.35 9.7799999999999994 9.65 9.68 9.58 9.58 9.59 9.34 9.27 9.51 9.56 9.6199999999999992 9.58 9.43 9.42 9.15 9.06 9 9.1 9.07 9.0500000000000007 9.14 8.99 8.91 8.91 9.0399999999999991 9.14 9.23 9.1999999999999993 9.23 9.4 9.41 9.65 9.42 9.43 9.48 9.59 9.4499999999999993 9.31 9.36 9.33 9.3000000000000007 9.23 9.23 9.23 9.23 9.6 9.2100000000000009 9.24 8.86 8.7100000000000009 8.76 8.7899999999999991 8.66 8.64 8.65 8.8699999999999992 8.84 9.1 9.19 9.14 9.32 9.24 9.14 9.2100000000000009 8.89 8.75 8.76 8.7100000000000009 8.64 8.6 8.93 9.0500000000000007 9.15 9.0500000000000007 9.01 9.0399999999999991 9.1 9.1300000000000008 9 8.91 8.9600000000000009 9.0500000000000007 9 8.89 8.7899999999999991 8.9 9.01 9.02 9.15 9.1 9.14 8.9499999999999993 9.0299999999999994 9 9.07 9.07 9.1 9.14 9.36 9.39 9.39 9.41 9.57 9.57 9.5399999999999991 9.57 9.49 9.49 9.4600000000000009 9.35 9.33 9.42 9.3699999999999992 9.17 9.25 9.3000000000000007 9.31 9.36 9.26 9.33 9.3000000000000007 9.2799999999999994 9.23 9.2200000000000006 9.25 9.16 9.1199999999999992 8.9600000000000009 9 8.9600000000000009 8.84 8.84 9.14 9.24 8.48 8.3800000000000008 8.2100000000000009 8.15 8.15 8.33 8.36 8.27 8.15 8.1 8.07 8.0299999999999994 7.72 7.68 7.46 7.28 6.96 7.23 7.34 7.09 6.97 6.68 6.14 6.29

Low 43535 43536 43537 43538 43539 43 542 43543 43544 43545 43546 43549 43550 43551 43552 43553 43556 43557 43558 43559 43560 43563 43564 43565 43566 43567 43570 43571 43572 43573 43577 43578 43579 43580 43581 43584 43585 43586 43587 43588 43591 43592 43593 43594 43595 43598 43599 43600 43601 43602 43605 43606 43607 43608 43609 43613 43614 43615 43616 43619 43 620 43621 43622 43623 43626 43627 43628 43629 43630 43633 43634 43635 43636 43637 43640 43641 43642 43643 43644 43647 43648 43649 43651 43654 43655 43656 43657 43658 43661 43662 43663 43664 43665 43668 43669 43670 43671 43672 43675 43676 43677 43678 43679 43682 43683 43684 43685 43686 43689 43690 43691 43692 43693 43696 43697 43698 43699 43700 43703 43704 43705 43706 43707 43711 43712 43713 43714 43717 43718 43719 43720 43721 43724 43725 43726 43727 43728 43731 43732 43733 43734 43735 43738 43739 43740 43741 43742 43745 43746 43747 43748 43749 43752 43753 43754 43755 43756 43759 43760 43761 43762 43763 43766 43767 43768 43769 43770 43773 43774 43775 43776 43777 43780 43781 43782 43783 43784 43787 43788 43789 43790 43791 43794 43795 43796 43798 43801 43802 43803 43804 43805 43808 43809 43810 43811 43812 43815 43816 43817 43818 43819 43822 43823 43825 43826 43829 43830 43832 43833 43836 43837 43838 43839 43840 43843 43844 43845 43846 43847 43851 43852 43853 43854 43857 43858 43859 43860 43861 43864 43865 43866 43867 43868 43871 43872 43873 43874 43875 43879 43880 43881 43882 43885 43886 43887 43888 43889 43892 43893 43894 43895 43896 43899 43900 8.4499999999999993 8.5500000000000007 8.5 8.4 8.3699999999999992 8.42 8.61 8.48 8.49 8.52 8.4700000000000006 8.5399999999999991 8.619999999999999 2 8.64 8.7100000000000009 8.86 8.91 9.06 9.18 9.08 9.17 9.17 9.1999999999999993 9.33 9.44 9.26 9.24 9.39 9.48 9.4600000000000009 9.3000000000000007 9.4 9.34 9.9499999999999993 10.07 10.27 10.29 10.199999999999999 10.3 10.119999999999999 10.3 10.31 10.07 10.199999999999999 10.039999999999999 10.130000000000001 10.039999999999999 10.3 10.24 10.199999999999999 10.15 9.93 9.67 9.8000000000000007 9.77 9.5500000000000007 9.68 9.32 9.4600000000000009 9.7200000000000006 9.65 9.66 9.6999999999999993 9.76 9.7899999999999991 9.84 9.8000000000000007 9.94 9.94 10.050000000000001 10.029999999999999 9.9499999999999993 9.91 9.93 9.83 9.82 10 10.199999999999999 10.07 10.039999999999999 10.130000000000001 10.09 10.18 10.1 10.11 10.11 10.24 10.34 10.29 10.31 10.18 10.199999999999999 10 10.06 10.14 9.4 9.51 9.52 9.48 9.4 9.2799999999999994 9.2100000000000009 9.06 9.36 9.32 9.51 9.39 9.2799999999999994 9.18 8.9600000000000009 8.7799999999999994 8.81 9.02 8.93 8.9700000000000006 9.02 8.73 8.7899999999999991 8.75 8.6999999999999993 9.0299999999999994 9.1 9.0399999999999991 9.07 9.25 9.1999999999999993 9.39 9.0399999999999991 9.2899999999999991 9.32 9.44 9.24 9.18 9.2200000000000006 9.1 9.11 9.08 9.0500000000000007 9.09 9.07 9.06 9.1 8.8699999999999992 8.44 8.4499999999999993 8.66 8.61 8.5 8.56 8.52 8.73 8.76 8.7799999999999994 9.06 9.0299999999999994 9.09 9.01 8.9600000000000009 8.9700000000000006 8.5500000000000007 8.6199999999999992 8.58 8.59 8.52 8.5 8.64 8.93 9 8.89 8.8800000000000008 8.82 8.94 9.0399999999999991 8.8000000000000007 8.7799999999999994 8.85 8.89 8.8699999999999992 8.68 8.67 8.77 8.8699999999999992 8.91 9.02 9.0299999999999994 9 8.8000000000000007 8.94 8.8800000000000008 8.9499999999999993 8.9600000000000009 8.9600000000000009 9.06 9.11 9.19 9.2200000000000006 9.31 9.36 9.3800000000000008 9.44 9.4 9.43 9.43 9.35 9.23 9.25 9.19 9.15 9.06 9.1199999999999992 9.17 9.18 9.25 9.11 9.2100000000000009 9.18 9.15 9.1300000000000008 9.1 9.15 8.93 8.9600000000000009 8.7799999999999994 8.86 8.84 8.73 8.74 8.85 9.07 8.26 8.25 8.02 8.0500000000000007 8.08 8.1300000000000008 8.2100000000000009 8.08 8.02 8 7.99 7.89 7.55 7.22 7.21 6.92 6.67 6.88 6.89 6.92 6.71 6.4 5.87 5.8