Presenting Data Analysis Results Effectively

Applying Analytic Techniques to Business

3/16/2020

Introduction

Ford Motor is a company that has its original situation in the United States of America. The company has its core business as producing motor vehicles; the company is the Fourth highest producer in the world. The company came to existence in the year 1903, with the present state being one of the companies with a production rate of higher standards compared to its competitors. The company has produced motor vehicles not only in the United States of America but the whole world consisting of diverse brands. Throughout the years, the firm has created different development techniques planned for supporting the general target of keeping up the upper hand in the market. The organization's development is bolstered by different escalated techniques that incorporate market improvement, item advancement, and market entrance. There likewise exist conventional methodologies that steer Ford's business seriousness. Even though there have been a few nonexclusive procedures, cost administration remains the hugest power behind the automaker's prosperity.

Ford’s Operations

The Ford Motor Company has an extensive list of their products and administrations which incorporate autos and substantial business vehicles just as car financing administrations. Their engines include minimal effort vehicles that are created to pull in a more extensive client extend, extravagance autos, trucks, transports, and Motorsport vehicles. Their blend of items and administrations guarantees that the firm can contend well in the vehicle business. Through advancement, the organization has likewise added to a superior situation by creating vehicles that sudden spike in demand for less fuel, hydrogen, and power along these lines empowering the association to acquire clients in recent years.

The firm effectively executes its commitments to its outer clients who buy their vehicles just as its inward clients who comprise of staff in different divisions and who depend on various offices to encourage the smooth progression of their day by day obligations. For the outside clients, the vehicles they buy must satisfy specific guidelines dependent on the details for which they are fabricated. For example, the extravagance vehicles ought to be in a situation to give solace and security dependent on the base market models, simplicity of route, and saving money on fuel utilization. While such principles are structure qualifiers, the firm should endeavor to think of more request champs that recognize their extravagance vehicles from those of contenders. To accomplish this, ford had created a technology that aimed at producing their products with diverse differentiation compared to their competitors.

Ford prior concocted advancements that set their items apart from others. For instance, it built up the EcoBoost suite of advances that decreased the size of their turbocharged motors and the heaviness of vehicles to give more power utilizing less fuel. The blend of this innovation and the utilization of aluminum to make cars encouraged the offer of more units as clients looked to go for items that could spare fuel costs while discharging fewer outflows. Additionally, Ford beat the opposition by creating the most remarkable GT autos with V6 and V8 motors. At the same time, the most significant contender of the time, GM, had a four-chamber motor execution vehicle.

Graphical Representations of Data

The following section includes four graphical representations of data.

This graph represents the high points of the Ford Motor Company stock prices between the period of July 2018 and August 2019. The graph shape tells me that the data did not change much over the specified period. The line has a consistent trend and stays right around the $10 mark. This tells me that the high price of the stock did not vary much during the specified sample period. This shows consistency and stability in the company's stock.

This graph represents the low points of the Ford Motor Company stock prices between the period of July 2018 and August 2019. The graph shape tells me that the data did not change much over the specified period. There are a few spots where you can visibly see that the lows were lower than usual, like in December 2018, but the line has a mostly consistent trend and stays right around the $10 mark. This tells me that the low price of the stock did not vary much during the specified sample period. This shows consistency and stability in the company's stock.

This graph represents the trend of the Adjusted Close price of the Ford Motor Company stock prices between the period of July 2018 and August 2019. The graph shape tells me that the Adjusted Close rate remained the same over 50% of the time throughout the specified period, and the lower Adjusted Close prices ranged from under 50% of the time to under 10% of the time. The line has a consistent trend and starts to taper off toward the end. This tells me that the Adjusted price of the stock did not vary much during the specified sample period.

This graph represents the trend of the Volume of the Ford Motor Company stock between the period of July 2018 and August 2019. The graph shape tells me that the Volume remained the same most of the time throughout the specified period. The line has a consistent trend and starts off rising and then starts to taper off toward the end. This tells me that the Volume stock only had a slight variation at the beginning of the specified sample period.

Mean, Median, Mode, and Standard Deviation

Adjusted Daily Closing Stock Price

Mean	8.8582
Median	8.7373
Mode	10.05
Standard Deviation	0.792

This statistic represents the adjusted daily closing stock prices. The mean is the average regular stock price. The median in the daily stock prices that fell right in the middle of the highest and the lowest daily stock price and the mode is the everyday stock price that occurred the most. Because the mean is higher than the median, it implies that the average stock price is on the more upper that the mid-range of the adjusted daily closing stock prices.

Stock Volume

Mean	43,079,356
Median	40,183,200
Mode	#N/A
Standard Deviation	16,392,385

This statistic represents the Stock volume. The mean is the average stock volume. The median in the stock volume that fell right in the middle of the highest and the lowest stock volume and the mode is the stock volume that occurred the most. Because the mean is higher than the median, it implies that the average stock volume is higher than the mid-range of the stock volume.

Descriptive Statistics

To create the "High" graph, I pulled the stock history over the last year, filtered out the unneeded columns, and selected the "high" price column as the "y" axis and the dates as the "x" axis and created a scatterplot in Microsoft Excel. To create the "Low" graph, I pulled the stock history over the last year, filtered out the unneeded columns, and selected the "low" price column as the "y" axis and the dates as the "x" axis and created a scatterplot in Microsoft Excel. To create the "Adj Close” graph, I pulled the stock history over the last year, filtered out the unneeded columns and selected the “Adj Close” price column as the “y” axis and the dates as the “x” axis and created a scatterplot in Microsoft Excel. To create the “Volume” graph, I pulled the stock history over the last year, filtered out the unneeded columns and selected the “Volume” price column as the “y” axis and the dates as the “x” axis and created a scatterplot in Microsoft Excel.

I had the option to compute the Adjusted Daily Closing Stock Price measurements by choosing the information in the "Adj Close" section and utilize the Microsoft Excel work (=AVERAGE()) to ascertain the mean, utilized the Microsoft Excel work (=MEDIAN()) to figure the middle, used the Microsoft Excel work "MODE" (=MODE()) to compute the mode and utilized the Microsoft Excel work for (=STDEV()) to figure the Standard Deviation.

I had the option to figure the Stock Volume measurements by choosing the information in the "Volume" segment and utilize the Microsoft Excel work (=AVERAGE()) to ascertain the mean, utilized the Microsoft Excel work (=MEDIAN()) to compute the middle, used the Microsoft Excel work "MODE" (=MODE()) to ascertain the mode yet was not ready to concoct a count as it was not accessible and utilized the Microsoft Excel work for (=STDEV()) to figure the Standard Deviation.

Conclusions

My stock analysis was based on the Ford Motor Company. The sample of data I extracted was from July 2018 to August 8, 2019. Some limitations of the conclusions I could draw from this sample include limited possibilities to review the data in-depth and limitations on comparable data to compare the data sample to. Having more information available to analyze the data would enable me to be able to conclude about the trends in the data.

It would not be possible to infer the exact average stock price for all time from my sample as it was only a glimpse into the company's stock history from when the company's stock first traded on the New York Stock Exchange on March 7, 1956 (Ford). It would be possible to calculate the average inventory for all time using a confidence interval but only with a certain degree of confidence, based on the size of the sample used (Cox, 2006).

References

(2019, August 8). Ford Motor Company (F) Stock Historical Prices & Data. Retrieved from

https://finance.yahoo.com/quote/F/history?period1=1533787200&period2=1565323200&interval=1d&filter=history&frequency=1d

Britannica, T. E. (2019, January 3). Ford Motor Company. Retrieved from

https://www.britannica.com/topic/Ford-Motor-Company

Cox, D. (2006). Principles of statistical inference. New York, NY: Cambridge University Press.

Ford. (2018). Strategy and Governance. Retrieved June 31, 2019, from

https://corporate.ford.com/microsites/sustainability-report-2017-18/strategy-governance/index.html

Ford. Stock Information. Retrieved from https://shareholder.ford.com/investors/stock-

information/splits-and-spinoffs/default.aspx