Must Review Scoring Guide and Instructions and create slides based on instructions and scoring guide. also must review all previous assignments to incorporate into this assignment

Create a 9-slide PowerPoint presentation that interprets four of the graphs from the report you created in the last two assessments. You have the option of recording a voice-over of up to 10 minutes or including detailed presenter’s notes in the PowerPoint slide deck to explain the points in each slide.

The ability to translate analytic results into clear, concise business language and actionable results is vital for managers and analysts. Managers are often required to present the results of their team’s analysis to executives and must be able to explain the results at a high level as well as understand enough about the details to answer any questions the executives might pose.

How much an analysis is valued can depend heavily on how well the results of that analysis are articulated. Communicating the results of your data analysis so the applications to your business are clear and explicit can greatly enhance the value of your analytic work. In this assessment, consider how you can best communicate the results that you wrote about in your previous assessment. Review any feedback you received on your first assessment and use it to enhance this assessment.

Must Review Scoring Guide and Instructions and create slides based on instructions and scoring guide. also must review all previous assignments to incorporate into this assignment

Presenting Data Analysis Results Effectively Scoring Guide

CRITERIA NON-PERFORMANCE BASIC PROFICIENT DISTINGUISHED

Describe the
company
background and the
practical business
context.

Does not describe
the company
background or the
practical business
context.

Describes the
company background
or the business
context, but not both.

Describes the
company
background and
the practical
business context.

Thoroughly describes the
company background and
the practical business
context using examples
and details that
demonstrate exemplary
understanding.

Interpret or explain
the meaning of the
four different
graphical
representations of
data.

Does not interpret
the four different
graphical
representations of
data.

Interprets some of the
different graphical
representations of data
but lacks professional
understanding of the
graphs in context.

Interpret or explain
the meaning of the
four different
graphical
representations of
data.

Interprets and explains
thoughtfully the four
different graphical
representations of data in
a way that indicates
exceptional understanding
of the strategies and
examples from the field.

Explain how the
results of the data
analysis can be
applied to the
business context.

Does not explain
how the results of
the data analysis
can be applied to
the business
context.

Partially explains how
some results of the
data analysis could be
applied to the business
context, or application
is irrelevant to the
context.

Explains how the
results of the
analysis can be
applied to the
business context.

Explains in detail how the
results of the data
analysis can be applied to
the business context and
provides specific
examples.

Format citations and
references correctly,
using current APA
style.

Does not format
citations and
references correctly,
using current APA
style.

Formats citations and
references with errors
in APA style.

Formats citations
and references
correctly, using
current APA style.

Formats citations and
references flawlessly in
current APA style.

Present content
clearly,
professionally, and
logically for the
identified audience.

Does not present
content clearly,
professionally, or
logically for the
identified audience.

Presents content with
some flaws in
organization or clarity
that affect professional
delivery for the
identified audience.

Presents content
clearly,
professionally, and
logically for the
identified audience.

Presents content with
exceptional clarity,
organization,
professionalism, and
appropriateness for the
identified audience.

Scenario

You are a senior analyst in a business. You may choose any publicly traded company of interest that has practical meaning for you. Your immediate supervisor read your last analytics report on the company’s historical stock performance and was so impressed with your work that she has asked you to present the key points from that report at a company-wide meeting. 

Your Role

You have been allotted no more than 10 minutes to present the highlights of your analytics report to an audience from all levels of the company and explain how the results of your analysis apply to the business using four charts or tables from your report.

Instructions

Create a 9-slide PowerPoint presentation with detailed presenter’s notes in which you present and interpret four graphs from the report you created in the last two assessments. Format your presentation as follows: 

· 1 title slide.

· 1 introduction slide explaining the business context.

· 4 graphics slides: one for each of the four charts in your report and your interpretation of each chart.

· 2 conclusion slides explaining how the data analysis results can be applied in the chosen business context.

· 1 slide with APA-formatted references.

Additional Requirements 

· Use short but complete sentences that are clear, comprehensible, and free of jargon for each bullet point.

· Include no more than 3 bullet points per slide if possible.

· Include APA-formatted in-text citations where appropriate

· Ensure your presentation is relevant to and easily understood by everyone in the audience. Remember, you will be speaking to people of all levels in the company.

·

Your written communication should be free of errors that detract from the overall message.

· Include an APA-formatted references slide at the end of the presentation.

Evaluation

By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies through corresponding scoring guide criteria:

· Competency 1: Explain how data management techniques and tools are used to support business decisions.

. Introduce the business context.

. Explain how the results of your analysis are applicable to the business context.

· Competency 4: Present the results of data analysis in clear and meaningful ways to multiple stakeholders.

. Interpret or explain the meaning of the two different graphical representations of data.

. Format citations and references correctly using current APA style.

. Present content clearly, professionally, and logically for the identified audience.

INTERPRETING PRESENTATIONS OF DATA ANALYSIS IN ARTICLES OR REPORTS

Apple Inc: The Business Context
The market value of Apple is $1.1 trillion
It has brought $56 billion net income in about four last four quarters.
62% of Apple’s revenue over the last four quarter is contributed by iPhone
14.0% of the revenue is from the other service
The unit sale was greatest in 2015 as compared to other years and 230, 000 unites were sold

By most conventional definitions, Apple (NASDAQ:AAPL) is the most successful company in the world. It’s worth more than any other publicly traded company, with a market value near $1.1 trillion, and it’s the most profitable, bringing in $56 billion in net income in its last four quarters.
2

Apple revenue by category
Out of the $255. billion revenue, $158.3 billion has been generated from iPhone
Mac has generated 9.9% of the revenue
iPad has generated 7.7% of the revenue
iPhone has made 62% of the total revenue
14% has been generated from service based products
6.4% from the other products.

Though Apple makes several other popular devices in addition to its trademark smartphone, including the iPad, Mac, Apple Watch, and others, the iPhone continues to drive the majority of its business as it has for the past several years. As you can see from the charts below, the iPhone has contributed about 62% of Apple’s revenue over the last four quarters:
3

Apple Inc Gross Profit Margin
Apple has generated 31% more in the most recent quarter
The gross profit margin was greatest in 2016
The gross margin was least in 2014
The margin has been decreased gradually from 2014
The current profit margin is 2020 is 38.27 less as compared to 2016

Apple now finds itself again at a turning point. It’s not enough for the company to rely on growth from Services or its Other Products segment, which includes devices like the Apple Watch, Apple TV, and AirPods, as sales in those categories are still just a fraction of iPhone sales. The company either needs to find another blockbuster product category that can add meaningful growth to an already enormous business, or it needs to find more ways to squeeze money out of a mature iPhone market, likely by raising prices.
4

Conclusions
The product segment and services can not be relied upon for the growth
The association needs blockbuster product category for better growth
Company needs more mature ways to squeeze money from the public
The signs for the investors to invest in Apple are positive
The Apple’s strategy is abundantly clear regarding their high process

Apple is making headlines once again after releasing the latest versions of its flagship smartphone, the iPhone, including the iPhone XS, XS Max, and XR; the stock recently topped the $1 trillion mark and is pushing record highs. As investors consider the stock’s potential with those two milestones behind it, now is an excellent time to dig into the numbers, to better understand how Apple’s business works and where it’s headed today.
5

References
Bowman, J. (2018). Apple in 5 Charts | The Motley Fool. The Motley Fool. Retrieved 5 March 2020, from https://www.fool.com/investing/2018/09/22/apple-in-5-charts.aspx
Robert William. (2020). Apple Chart (AAPL) – Investing.com. Investing.com. Retrieved 5 March 2020, from https://www.investing.com/equities/apple-computer-inc-chart
Aliza. (2019)AAPL Stock Price and Chart — Trading View. (2020). Trading View. Retrieved 5 March 2020, from https://www.tradingview.com/symbols/NASDAQ-AAPL/

Ford Company

.4

6

3

5

9825

8.65 8.5

8.4

52337

8.45 8.57 8.42 8.57 7.899825

8.61

7

8.61 8.7

8.67

8.5

8.69

442

8.63 8.67 8.52

8.65 8.47 8.51 7.844517

8.54

8.54 8.76

4968

8.62

8.65

8.8

8.86 9 8.86

8

7

3

8272

9.18

9.17 9.3

4559

9.27

9.17 9.21

9.2

9.35

1

9.33

9.33 8.752703

9.32 9.4 9.24 9.36

9.4

9.39 9.5

9.48

9.58 9.58

9.5 8.912184

9.36

9.3 9.5

516

9.45

9.4

1881

9.52

9.4

5

5

2548

6

36762

9

10.45

0675

10.5

10.3

10.3

10.2

5827

10.45 10.3 10.41 9.922548

2

10.37

10.41 10.3

3953

Adj Close Volume

10.38 10.45

10.34 9.855827

6160233

10.3 10.07 10.2

2

2382

10.32 10.41 10.2 10.38 9.893953

39796300

10.26

10.29

0509

10.4 10.04

4889

10.3

10.3 10.4

3016

10.32 10.44 10.24 10.29

10.3 10.3 10.2

8635

10.31 10.31 10.15 10.24 9.760509

10.17 10.21

9.85 9.85

9.85

8772

9.92

9.8

9.87 9.9

9.55

9.74

3922

9.48

9.32 9.52

9.62

9.46 9.61

0008

9.95 9.72 9.92

9.87 9.92 9.65 9.78 9.322048

9.72

9.75

3454

9.76 9.82 9.7 9.76

9.89 10.03 9.76 9.82

9.87

9.79 9.92 9.455493

9.9 9.93 9.84 9.85 9.388772

9.87

9.8 10.06

10.04

9.98

9.94

10.08 10.2 10.05 10.1

10.15

10.03 10.04

9874

10.13 10.15 9.95 10.04 9.569874

10.03 10.05 9.91 9.99

9.95

9.93 9.95

9.97 9.99 9.83 9.84

9239

9.87 9.96 9.82 9.91

10.04 10.24 10 10.2 9.722382

10.2 10.31 10.2

37551600

10.34

10.07 10.15

10.15 10.21 10.04 10.12

10.18 10.3 10.13 10.2 9.722382

10.18 10.27 10.09 10.2 9.722382

10.2 10.26 10.18 10.2 9.722382

10.17

10.1

10.19 10.26

10.11

10.15 10.2 10.11 10.19

10.24 10.5 10.24

10.49

10.34 10.42

10.37

10.29 10.51

10.48 10.5 10.31 10.33

10.3 10.31 10.18 10.26

10.3 10.32 10.2 10.2 9.722382

10.13 10.17 10 10.02

10.13

10.06 10.17

10.18 10.35 10.14 10.33

9.75 9.78 9.4 9.56

9.58 9.65 9.51 9.57

9.6 9.68 9.52 9.6

9.56 9.58 9.48 9.55

9.57 9.58 9.4 9.53

9.53

9.28

9.26 9.34 9.21 9.28

7483

9.18 9.27 9.06 9.23

9112

9.51 9.36 9.48

9.56 9.32 9.53 9.219334

9.56 9.62 9.51 9.56 9.248356

9.54 9.58 9.39 9.45

1941

9.39 9.43 9.28 9.29

7157

9.29 9.42 9.18 9.26

9

9.06 9.06 8.78 8.86

8.92 9

8.96

9.05 9.1

9.03

5632

9 9.07

8.96 8.667914

9.02 9.05 8.97

5307

9.05 9.14 9.02 9.04 8.745307

8.9

8.73 8.77

8.91

8.89 8.91 8.75 8.76

8.72 9.04 8.7 9 8.706611

9.1 9.14 9.03 9.12

9.16 9.23 9.1 9.17

9.18 9.2 9.04 9.1

9.17 9.23 9.07 9.2

9.25 9.4 9.25 9.34

9.37

9.2 9.34 9.035527

9.39 9.65 9.39 9.54

9008

9.08 9.42 9.04 9.42

2919

9.29 9.43 9.29 9.42 9.112919

9.36 9.48 9.32 9.41

9.47 9.59 9.44 9.45

9.36 9.45 9.24 9.3

9.27 9.31 9.18 9.28

9.26 9.36 9.22 9.25

8462

9.31 9.33 9.1 9.1 8.803351

9.13 9.3 9.11 9.17 8.871069

9.13 9.23 9.08 9.16

9.23 9.05 9.11

9.1 9.23

9.2 8.900091

9.23 9.23 9.07 9.14

2048

9.14 9.6 9.06 9.08

9.11 9.21 9.1 9.16 8.861395

9.19 9.24 8.87 8.9

8.86

8.61

8.55 8.71 8.45 8.71

8.72 8.76 8.66 8.74

8.7 8.79 8.61

8.65 8.66 8.5 8.54

1606

8.61 8.64 8.56 8.56

8.65 8.52 8.62

8999

8.73 8.87 8.73 8.78

8.82 8.84 8.76 8.82 8.532478

8.84 9.1 8.78 9.07

9.11 9.19 9.06 9.07 8.774328

9.12 9.14 9.03 9.11 8.813025

9.09 9.32 9.09 9.29 8.987157

9.19 9.24 9.01 9.03

9.01 9.14 8.96 9.07 8.918327

9.01 9.21 8.97 9.21

8.87 8.89 8.55 8.6

8.67 8.75 8.62 8.72

8.76 8.76 8.58 8.61

8.59 8.71 8.59 8.64

8.64 8.64 8.52 8.54

8.58 8.6 8.5 8.59

8.64 8.93 8.64 8.89

8.93 9.05 8.93 9

9.02 9.15 9 9.02

9.05 9.05 8.89 8.92

8.96 9.01 8.88 8.89 8.741339

8.9 9.04 8.82 9.04

8.95 9.1 8.94 9.08

9.06 9.13 9.04 9.04 8.888829

9 9 8.8 8.81

8.85 8.91 8.78 8.79

8.85 8.96 8.85 8.95

9.05 9.05 8.89 8.95 8.800335

8.99 9 8.87 8.9

8.88 8.89 8.68 8.73

8.77 8.79 8.67 8.71

8.8 8.9 8.77 8.89 8.741339

8.9 9.01 8.87 9 8.849499

8.98 9.02 8.91 9.01

9.03 9.15 9.02 9.1

9.04 9.1 9.03 9.06

9.08 9.14 9 9.01 8.859331

8.95 8.95 8.8 8.89 8.741339

8.95 9.03 8.94 8.95 8.800335

8.97 9 8.88 8.93

8.96 9.07 8.95 9.02 8.869164

8.97 9.07 8.96 9.01 8.859331

9.02 9.1 8.96 9.07 8.918327

9.06 9.14 9.06 9.11

9.11 9.36 9.11 9.32

9.32 9.39 9.19 9.23

9.24 9.39 9.22 9.39

9.38 9.41 9.31 9.39 9.232977

9.39 9.57 9.36 9.54

9.55 9.57 9.38 9.41

9.5 9.54 9.44 9.48

9.5 9.57 9.4 9.44

9.44

9.43 9.47

9.47 9.49 9.43 9.45

9.45 9.46 9.35 9.36

9.34 9.35 9.23 9.25

9.25 9.33 9.25 9.3

9.29 9.42 9.19 9.42

9.31 9.37 9.15 9.21 9.055987

9.1 9.17 9.06 9.16

9.2 9.25 9.12 9.25 9.095318

9.23 9.3 9.17 9.25 9.095318

9.3 9.31 9.18 9.26

9.27 9.36 9.25 9.25 9.095318 39796300

9.25 9.26 9.11 9.24

9.22 9.33 9.21 9.29

9.27 9.3 9.18 9.19

9.23 9.28 9.15 9.17

9.19 9.23 9.13 9.16 9.006823

9.15 9.22 9.1 9.21 9.055987

9.22 9.25 9.15 9.16 9.006823

9.14 9.16 8.93 9.14

9.11 9.12 8.96 9 8.849499

8.88 8.96 8.78 8.89 8.741339

8.94 9 8.86 8.97

8.85 8.96 8.84 8.86 8.86

8.81 8.84 8.73 8.84 8.84

8.78 8.84 8.74 8.82 8.82

8.85 9.14 8.85 8.98 8.98

9.08 9.24 9.07 9.18 9.18

8.41 8.48 8.26

8.31

8.37

8.25 8.25

8.21

1

8.11

8.15

8.06

8.1 8.15

8.1 8.1

8.33

8.24

8.21

8.21 8.25 8.25

8.27 8.08 8.1 8.1

8.15 8.02 8.06 8.06

8.06 8.1 8 8 8

8 8.07

8.03

8.02 8.03 7.89 7.89 7.89

7.7

7.57

7.68

2

7.23

7.21 7.21

6.97

7

6.96 6.96

7.23

7.2 7.2

6.97 6.97

7.09 6.92

7.08

6.96 6.97

6.74

6.6

6.49

7

7

5.9 5.9

5.8

5.9919

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.05000000 00000007 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 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.4499999999999993 8.5500000000000007 8.5 8.4 8.3699999999999992 8.42 8.61 8.48 8.49 8.52 8.4700000000000006 8.5399999999999991 8.6199999999999992 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

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

APPLYING ANALYTIC TECHNIQUES TO BUSINESS
1

APPLYING ANALYTIC TECHNIQUES TO BUSINESS
2

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

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

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