Presenting data analysis results effectively
Ace your studies with our custom writing services! We've got your back for top grades and timely submissions, so you can say goodbye to the stress. Trust us to get you there!
Order a Similar Paper Order a Different Paper
- Create a 10-12 slide PowerPoint presentation that interprets four of the graphs from the report you created in the last two assessments. 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.
Scenario
Moving average calculations help interpret data. You can easily add a moving average calculation to your stock price scatter plot and use the information to add to your interpretation of the five years of stock price data. You will add the moving average calculation to your stock price scatter plot for this assessment.
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 of your enhanced business report to your supervisor and colleagues.Your Role
You are a senior analyst in a business. You may choose any publicly traded company of interest that has practical meaning for you including the company you used for Assessment 3.
Your immediate supervisor read your last analytics report on the company’s historical stock performance and was impressed with your work that she has asked you to add to the report and present the key points from that report at a company-wide meeting.
You have been invited to present the highlights of your analytics report at an annual company-wide meeting that employees of all levels will attend. The purpose of your speech or presentation is to explain how the results of your analysis apply to the business and how the data you are presenting may impact various aspects of business context.
Instructions
Create an approximately 10-12 slide PowerPoint presentation with detailed presenter’s notes including citations on slides and in Notes area of the slide.
Format your presentation as follows:- One title slide.
- Introduction slides explaining the business context.
- Four graphics slides: One for each of the four charts in your report. Be sure to add moving average to your stock price chart.
- One slide on descriptive stats.
- Two or more conclusion slides explaining the application of each graph in the chosen business context.
- One slide calling for discussion and questions.
- One slide thanking everyone for their attention.
- One slide with APA-formatted references.
- Additional Requirements
- Eliminate all bias from your presentation by using supported facts.
- Use short but complete sentences that are clear, comprehensible, and free of jargon for each bullet point.
- Include no more than five 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.
9
Graphical Representation
Student’s Name
Institution Affiliation
Course
Instructor
Date
Nike Company Stock Price
Introduction
Nike Company is a multinational organization that designs, develops, manufactures, and sells footwear, apparel, equipment, and accessories mostly related to sports activities. The company operates through numerous segments, including Europe, North America, the Middle East, Asia Pacific and Latin America, Greater China and Global Brand Divisions, Converse, and Corporate. Formerly known as Blue Ribbon Sports, Nike Company was founded by Bill Bowerman in 1964 and was branded the name Nike shoe in 1972, then went public in the two years that followed. The entity has seen consistent expansion since the 1980s in its business. It has steadily diversified its product line through several acquisitions like the shoe entities Converse, Inc., Canstar Sports, Inc., and Cole Haan (Bonetti, 2020). It directly sells its products to consumers through its platforms, including digital and retail platforms. The company also involves retailers and independent distributors in its sales strategy.
Part of the entity’s success story has been attributed to endorsements by athletes such as Roger Federer, Mia Hamm, Tiger Woods, and Michael Jordan. Currently, the company employs over 79100 individuals, and based on the latest report, its current net worth is valued at $166.2 billion. The entity’s value is often reflected by its market capitalization or the multiplication of its current stock price and the shares’ outstanding number. The company’s success and potential growth can be witnessed by its sales and revenues, where since 2011, it has been generating revenues amounting to more than $23.7 billion. Based on the 2022 financial year, it recorded revenues amounting to $46.9 billion, reflecting a significant increase of $38.5 billion from the previous year (Yahoo Finance, 2023). Besides, it is currently the most valuable apparel brand globally, being on top of its major competitors, including Adidas, Puma, Gucci, and Under Armour. The company operates in more than forty-six countries and over seven hundred stores within those nations.
Graphical Representations of Data
Interpreting the Highest Stock Price
The above graph represents Nike’s highest stock price from December 2019 to February 2021. It illustrates how two variables, the highest stock prices and time, have been related to each over the period. The values in the x-axis represent the company’s highest stock prices, while the values in the y-axis represent time in days. From the end of 2019 to March 2020, the company’s stock prices showed a consistent decline. However, it rapidly inclined to over $140 in April 2021. The scatterplot illustrated a steady rising motion from March 2020 to April 2021. This indicated that the company’s top brass was steering operations toward profitability. The highest price was indicated in the January 2021.
Scatterplot of the Lowest Stock Price
The above graph also represents the lowest stock price of Nike Company from December 2019 to February 2021. Unlike the first graph, it shows the relationship between the lowest stock prices of the company against time. Similarly, the values on the x-axis represent the company’s highest stock prices, while the values on the y-axis represent time in days. Also, the scatterplot illustrates a steady decline from December 2019 to March 2020 (Yahoo Finance, 2023). However, the scatterplot rises from there to February 2021 consistently and steadily. In essence, low-priced stocks tend to come along with a lower profit-to-equity ratio. This means that the company’s investors had to pay less during the decline period when purchasing Nike’s stocks. From the point where the graph escalates, the investors have to pay more to purchase the company’s stock.
Histogram of the Adjusted Daily Closing Stock Price
The histogram above represents the Nike’s adjusted closing stock prices within equally distribution of concurrent data ranges. It shows the relationship between two variables, adjusted closing stock prices and ranges of adjusted closing stock prices. The values in the x-axis represents ranges of adjusted closing stock prices while y-axis’s values represent the number of occurrence. Based on the graph’s patter, the histogram is positively skewed with the median being lower than the mean. This is shown by the way the graph is skewed to the right side indicating more data points falling within the lowest ranges of daily adjusted closing stock prices. The graph therefore illustrates the non-volatility of Nike’s adjusted stock prices.
Histogram of the Stock Trading Volume
The above histogram represents the stock trading volume of Nike Company. It shows the relationship between its stock volume and the number of occurrences, also termed frequencies. On the x-axis are the values representing the company’s stock trading volume, while on the y-axis are the frequency or number of occurrences. Likewise, the histogram is positively skewed, with its mean value being more significant than the median. This is illustrated in the graph, whereby most values fall within the lower stock volume range. The graph skewed to the right, meaning the company’s daily stock volume is unevenly distributed, making it difficult for investors to speculate.
Descriptive Statistics
Mean, Median, and Standard Deviation of Adjusted Closing Stock Prices
The company’s mean in the adjusted closing stock prices was recorded at $105.6364523. This indicated that Nike’s market was stable as its sales and revenues steadily grew over the financial year. On the other hand, the company’s median in its adjusted closing stock prices was recorded at $100.656334 over the year. Compared to its mean, the company’s mean was lesser than its median value of the price, signifying the presence of outliers on the upper side of the entity’s stock prices (Freixo, 2023). This indicated that the company’s stock prices could be at risk of fluctuations. The company’s standard deviation in its adjusted closing stock prices was recorded at $18.54219923. Based on the presented values of the company’s adjusted stock prices mean, and standard deviation, the volatility of the company’s stock pricing was 19.58.
Mean, Median, and Standard Deviation of the Company’s Daily Traded Stock Volume
Nike Company recorded the mean of its daily traded stock volume at 7399826.98. The value meant that the company had low liquidity in its stocks. The company’s stock was considered a lower volume stock as it was trading fewer shares per day. On the other hand, the company’s median in its stock volume was recorded at 6158300. This was lesser than the value obtained in its mean. Likewise, the values represented the presence of outliers on the higher side of the data set, signifying a sharp increase in the company’s daily traded stock volume. The analysis showed that Nike’s daily stock volume had a mean of 7399826.98, while its standard deviation was 4395824.94. This was considered to be a relatively high value of standard deviation.
Conclusion
On the other hand, volume tends to measure the number of shares traded in stock in the future. Volume can indicate market strength, as rising markets on increasing volume are typically viewed as strong and healthy. Besides, there is no specific dividing line between the two. However, high-volume stocks typically trade at a volume of 500,000 or more daily shares. Low-volume stocks would be below that mark.
References
Bonetti, N. (2020).
NIKE, Inc.: equity valuation (Doctoral dissertation).
Chen, M. (2020).
Financial performance analysis: a case study of Nike (Doctoral dissertation).
Freixo, M. C. (2023).
Valuation of Nike Inc (Master’s thesis).
Javani, V., Ahmadi Bonabi, S., & Ashena, M. (2023). Predicting Nike Company Stock Price in Stock Market Using NARX Artificial Neural Network Method.
Research in Sport Management and Marketing,
4(1), 13-24.
Yahoo Finance. (2023). NIKE, Inc. (NKE). Retrieved from;
https://finance.yahoo.com/quote/NKE/
The highest stock price
High 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 43901 43902 43903 43906 43907 43908 43909 43910 43913 43914 43915 43916 43917 43920 43921 43922 43923 43924 43927 43928 43929 43930 43934 43935 43936 43937 43938 43941 43942 43943 43944 43945 43948 43949 43950 43951 43952 43955 43956 43957 43958 43959 43962 43963 43964 43965 43966 43969 43970 43971 43972 43973 43977 43978 43979 43980 43983 43984 43985 43986 43987 43990 43991 43992 43993 43994 43997 43998 43999 44000 44001 44004 44005 44006 44007 44008 44011 44012 44013 44014 44018 44019 44020 44021 44022 44025 44026 44027 44028 44029 44032 44033 44034 44035 44036 44039 44040 44041 44042 44043 44046 44047 44048 44049 44050 44053 44054 44055 44056 44057 44060 44061 44062 44063 44064 44067 44068 44069 44070 44071 44074 44075 44076 44077 44078 44082 44083 44084 44085 44088 44089 44090 44091 44092 44095 44096 44097 44098 44099 44102 44103 44104 44105 44106 44109 44110 44111 44112 44113 44116 44117 44118 44119 44120 44123 44124 44125 44126 44127 44130 44131 44132 44133 44134 44137 44138 44139 44140 44141 44144 44145 44146 44147 44148 44151 44152 44153 44154 44155 44158 44159 44160 44162 44165 44166 44167 44168 44169 44172 44173 44174 44175 44176 44179 44180 44181 44182 44183 44186 44187 44188 44189 44193 44194 44195 102.209999 102 101.839996 102.739998 102.139999 102.410004 101.93 102.339996 103.889999 103.699997 103.57 104.550003 104.69000200000001 105.620003 104.370003 103.889999 100.709999 101.050003 101.300003 99.75 98.449996999999996 100.91999800000001 102.779999 101.970001 101.529999 100.400002 100.510002 100.349998 103.08000199999999 103.739998 103.889999 103.379997 103.389999 102.629997 102.08000199999999 97.07 96.760002 94.650002000000001 93.059997999999993 89.470000999999996 93.139999000000003 94.980002999999996 93.82 91.68 89.389999000000003 86.739998 88.400002000000001 84.629997000000003 78.489998 78.199996999999996 72.970000999999996 73.330001999999993 68.330001999999993 72.709998999999996 74.059997999999993 66.879997000000003 72.660004000000001 83.489998 86.860000999999997 85.739998 85.959998999999996 85.730002999999996 81.180000000000007 81.599997999999999 79.790001000000004 85.040001000000004 88.870002999999997 85.769997000000004 87.389999000000003 85.989998 87.769997000000004 85.879997000000003 86.529999000000004 90.25 89.440002000000007 86.900002000000001 89.440002000000007 89.529999000000004 89.120002999999997 89.870002999999997 90.709998999999996 91.3899990000000 03 88 86.110000999999997 85.800003000000004 88.529999000000004 88.690002000000007 90.239998 90.639999000000003 91.419998000000007 91.669998000000007 87.739998 86.580001999999993 87.230002999999996 91.599997999999999 93.82 93.860000999999997 94.379997000000003 94.650002000000001 97.43 99.989998 100.69000200000001 99.25 99.779999000000004 100.879997 104.550003 103.900002 104.69000200000001 104.300003 103.769997 103.150002 98.989998 97.800003000000004 98.080001999999993 101.339996 100.239998 99.419998000000007 99.980002999999996 99.540001000000004 102.220001 101.849998 101.68 98.779999000000004 96 98.300003000000004 98.720000999999996 99.660004000000001 100.029999 99.550003000000004 98.980002999999996 98.910004000000001 98.050003000000004 98.940002000000007 97.25 99.040001000000004 98.230002999999996 97.230002999999996 96.349997999999999 99 98.989998 100.18 99.360000999999997 98.400002000000001 97.470000999999996 97.550003000000004 97.230002999999996 97.650002000000001 99.290001000000004 97.949996999999996 101.25 101.18 101.910004 106.83000199999999 107.33000199999999 105.889999 106.989998 106.779999 106.5 107 109.69000200000001 108.739998 109.769997 112 112.279999 112.089996 112.790001 112.66999800000001 112.519997 114.900002 117.410004 116.900002 113.75 113.839996 116.209999 118.230003 119.25 119.93 120.480003 119.69000200000001 118.550003 117.910004 114.05999799999999 117.199997 130.38000500000001 127.540001 124.75 126.19000200000001 127.099998 127.279999 127.730003 126.800003 128.5 130.44000199999999 130.41000399999999 130.929993 131.19000199999999 131.33999600000001 129.86999499999999 129.60000600000001 129.10000600000001 130.19000199999999 129.779999 129.89999399999999 131.38000500000001 130.259995 130.60000600000001 129.61999499999999 129.490005 126.400002 124.19000200000001 123.660004 124.099998 125.5 128.929993 130.41000399999999 129.91000399999999 136.35000600000001 130.11999499999999 129.800003 127.839996 128.60000600000001 130.320007 132.60000600000001 133.979996 132.11000100000001 133.529999 134.88999899999999 135.990005 135.800003 136.13000500000001 135.28999300000001 136.5 136.320007 137.949997 137.39999399999999 138.86000100000001 140.44000199999999 140.570007 139.13999899999999 138.13999899999999 139 139.44000199999999 140.490005 140.740005 141.13999899999999 147.949997 143.470001 143.60000600000001 142.19000199999999 142.91999799999999 143.05999800000001 142.61000100000001
Day of the year
Stock Prices
The lowest stock price
Low 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 43901 43902 43903 43906 43907 43908 43909 43910 43913 43914 43915 43916 43917 43920 43921 43922 43923 43924 43927 43928 43929 43930 43934 43935 43936 43937 43938 43941 43942 43943 43944 43945 43948 43949 43950 43951 43952 43955 43956 43957 43958 43959 43962 43963 43964 43965 43966 43969 43970 43971 43972 43973 43977 43978 43979 43980 43983 43984 43985 43986 43987 43990 43991 43992 43993 43994 43997 43998 43999 44000 44001 44004 44005 44006 44007 44008 44011 44012 44013 44014 44018 44019 44020 44021 44022 44025 44026 44027 44028 44029 44032 44033 44034 44035 44036 44039 440 40 44041 44042 44043 44046 44047 44048 44049 44050 44053 44054 44055 44056 44057 44060 44061 44062 44063 44064 44067 44068 44069 44070 44071 44074 44075 44076 44077 44078 44082 44083 44084 44085 44088 44089 44090 44091 44092 44095 44096 44097 44098 44099 44102 44103 44104 44105 44106 44109 44110 44111 44112 44113 44116 44117 44118 44119 44120 44123 44124 44125 44126 44127 44130 44131 44132 44133 44134 44137 44138 44139 44140 44141 44144 44145 44146 44147 44148 44151 44152 44153 44154 44155 44158 44159 44160 44162 44165 44166 44167 44168 44169 44172 44173 44174 44175 44176 44179 44180 44181 44182 44183 44186 44187 44188 44189 44193 44194 44195 101.019997 100.30999799999999 100.870003 100.80999799999999 100.849998 101.389999 100.760002 100.82 102.349998 102.480003 102.849998 103.339996 103.80999799999999 104.41999800000001 102.620003 101.660004 98.010002 99.519997000000004 99.169998000000007 97.370002999999997 95.919998000000007 98.57 101.260002 99.529999000000004 100.160004 98.970000999999996 99 99.440002000000007 100.44000200000001 101.68 102.449997 101.610001 102.43 100.550003 99.629997000000003 95.25 92.620002999999997 91.989998 88.5 85.150002000000001 87.910004000000001 90.57 90.839995999999999 89.940002000000007 85.879997000000003 80.919998000000007 82.879997000000003 82.07 73 71.760002 63.369999 62.400002000000001 60 64.150002000000001 67.199996999999996 60.580002 64 76.199996999999996 80.010002 79.510002 81.5 82.400002000000001 78.529999000000004 77.160004000000001 77.910004000000001 81.209998999999996 84.029999000000004 83.610000999999997 85.160004000000001 84.139999000000003 85.480002999999996 83.709998999999996 84.550003000000004 88.360000999999997 87.519997000000004 85.089995999999999 86.419998000000007 87.260002 87.650002000000001 87.309997999999993 88.629997000000003 87.830001999999993 86.510002 84.809997999999993 84.309997999999993 86.029999000000004 87.43 88.379997000000003 89.589995999999999 89.139999000000003 88.150002000000001 85.199996999999996 84.110000999999997 84.879997000000003 89.879997000000003 90.82 92.699996999999996 92.370002999999997 93.349997999999999 95.279999000000004 97.620002999999997 98.25 96.93 97.889999000000003 98.82 101.120003 100.470001 102.129997 102.709999 102.43 101.709999 94.879997000000003 94.739998 93.440002000000007 97.720000999999996 98.889999000000003 97.849997999999999 95.779999000000004 96.019997000000004 100.709999 98.089995999999999 98.800003000000004 93.57 93.699996999999996 95.639999000000003 97.110000999999997 98.019997000000004 99.040001000000004 96.919998000000007 96.959998999999996 96.370002999999997 95.720000999999996 96.260002 95.510002 97.309997999999993 97.040001000000004 96.040001000000004 95.110000999999997 96.099997999999999 97.910004000000001 97.720000999999996 97.699996999999996 96.889999000000003 96.160004000000001 96.300003000000004 95.800003000000004 96.300003000000004 97.82 96.550003000000004 97.080001999999993 100.029999 99.889999000000003 102.400002 104.860001 103.379997 105.199997 105.459999 105.120003 105.470001 107.349998 107.349998 107.75 109.900002 111.089996 111.290001 110.5 110.57 111.139 999 111.83000199999999 114.5 112 110.209999 110.540001 112.83000199999999 114 116.41999800000001 118.16999800000001 119.18 118.160004 115.800003 114.489998 111.739998 112.849998 125.260002 123.300003 122.269997 123.889999 123.959999 125.160004 125.30999799999999 123.589996 126.449997 127.269997 128.25 129.509995 129.33000200000001 129.259995 127.959999 127.010002 126.110001 127.550003 127.050003 127.720001 128.449997 128.86000100000001 128.64999399999999 126.68 127.900002 121.040001 121.150002 118.800003 121.099998 123.19000200000001 125.260002 128.46000699999999 128.35000600000001 128.770004 126.25 127.18 125.629997 126.83000199999999 127.370003 129.11000100000001 131.529999 129.929993 131.91000399999999 133.08999600000001 134.21000699999999 133.61999499999999 133.33999600000001 132.69000199999999 134.75 134.66999799999999 135 135.63999899999999 136.800003 137.64999399999999 138.270004 137.240005 136.229996 136.199997 137.25 137.46000699999999 138.75 137.16999799999999 142.509995 141.08999600000001 141.699997 141.10000600000001 141.03999300000001 140.429993 140.66000399999999
Day of the year
Stock Prices
image1.emf
image2.emf
5
Using Analytic Techniques to Add Meaning to Data
Students Name
Professor’s Name
Course
Date
Nike Company Stock Price
Introduction
As the world’s largest athletic apparel entity, Nike is one of the leading footwear, equipment and apparel corporation globally. It was founded as a Blue Ribbon Sport in 1964 and became the Nike it is today in 1971 after the victory Greek goddess. The term Nike was derived from the Greek name Greek goddess of victory, which, since it was established, has experienced numerous achievements in the footwear market. It has grown to be one of the most successful sports businesses in the world and currently employs more than 76000 individuals across all its operational stores globally (Yao & Chen, 2019). The entity offers its products through its Nike brand and its subsidiaries, including the Converse and Jordan brands. It sponsors the most significant sports and athletes teams across the globe, including Serena Williams, Alex Morgan, LeBron James and Rafael Nadal. Nike Company, as the most recognizable sports brand in the world, manufactures, markets and sells sports-related products to the global market. The organization is headquartered in Oregon near Beaverton and within the metropolis of Portland. Following its fiscal year ending May 2022, the company made more than $44.54 billion in revenue. Its brand currently stands at the value of $32 billion, representing the most valuable sportswear business in its industry.
Marketing Mission and Vision
Generally, the one company that is more likely to appear in one’s mind when it comes to sports products like shoes is Nike. Its strong mission statement has dramatically contributed to establishing the entity’s brand in people’s minds. It has aligned its mission and vision statement with its primary goals and strategies. Its mission statement can be described by three main aspects: creating innovation and inspiring and supporting athletes globally. The company’s mission statement is “to bring inspiration and innovation towards every athletes in the globally (Wondershare, 2021).” On the other hand, the company’s vision statement is “to remain the most authentic, connected and distinctive brand ever.” It uses inspirational words like “everyone with a body is an athlete,” which aligns with its mission. Such inspirational phrases or messages enhance its sales in the local and global markets. The company’s marketing plan transverses numerous guidelines and objectives on timelines. Through its marketing strategies, the company reported that it targets to increase its annual profits by 10 percent in the current year. This is a 25 percent raise in return on invested capital, raising its dividends to 35 percent (Freixo, 2023). The vision of Nike is based on creating innovative thinking in product manufacturing and enhancing its athlete’s abilities. In other words, the company aims to manufacture innovative products that put its brand ahead of advanced technology and innovation strategies. Nike’s products are often targeted toward athletes and sports events.
Sales
Nike has experienced consistent fluctuations in sales and revenue over the past few years. Following the most recent annual report, the company collected more sales and revenues in the first and fourth quarters than in the second and third quarters. The company’s sales and revenues were often made from its numerous products related to sports and also non-sporty items. It has attained flexibility associated with demographic changes, trends, preferences and styles. Based on recent past years, the company recorded a total revenue of $39.12 billion, $44.53 billion and 46.71 billion in 2020, 2021 and 2022, respectively. Following the revenue trend over the recent past periods, the company has consistently improved sales. It faced a significant decline in 2020 due to the impact of covid-19.
Having operated more than 122 footwear entities across 12 countries, Nike is surrounded by stiff competition pressure from rival companies like Adidas, Reebok, Converse, Fila and Puma. Nevertheless, the company has taken significant steps to remain on top of its main competitors. One of the approaches used by the company has been cost management. The company’s manufacturing operations and activities are often conducted outside the United States. This is a competitive advantage for the entity as it operates in countries where production costs are low. Lowering production costs helps the company widen its profitability margin, maximizing its profits. Other competitive advantages that hold the company at the top position include its famous and well-established brand, strong social media followers and international popularity.
Graphical Representation of Data
Scatterplot of the Highest Stock Price
Data and high columns were selected to prepare the scatterplot for the company’s highest stock price. On the Excel tab, click insert, followed by the option of the scattered graph under the chart slot. After clicking ok, a pave will open, and it is here where the scatterplot is generated. The title is then formatted based on the company’s values and the labelled axis. After completing the graph, it was copied from the Excel file and pasted into the word file.
Scatterplot of the Lowest Stock Price
When developing the scatterplot of the lowest stock price for the company, date and low columns were selected. The insert option is clicked on the Excel tab, and the scatterplot option under the charts slot is selected. After clicking the scatterplot option, a pave gets opened, and it is here where the scatterplot is generated, formatted and labelled. The complete scatterplot is then copied from the Excel file and pasted into the word document.
Histogram of the adjusted daily closing stock price
When creating the adjusted daily closing stock price histogram, the adjusted close columns were selected in the dataset. The insert option was clicked on the Excel commands tab, followed by the histogram option under the charts slot. This opened a pane where the histogram was then generated. The title is then formatted, and the axis is labelled. Besides, the gridlines and tick marks are removed, after which the graph is copied from the Excel file and pasted into the Word document.
Histogram of the stock trading volume
When developing the company’s stock trading volume, the volume column in the data set was selected. On the excel command tab, insert option was clicked followed by the click on the histogram option. The pane was opened after clicking on the histogram option where the histogram was generated to its completion. The complete graph was then copied and pasted from the excel file to the word document.
Descriptive Statistics
Some of the significant elements included in the descriptive statistics included the mean, mode, median and the standard deviation related to the adjusted daily price of the company’s daily closing.
|
Statistic |
Value |
|
Adj Close |
|
|
Mean |
105.6364523 |
|
Standard Error |
1.16804876 |
|
Median |
100.656334 |
|
Mode |
126.129288 |
|
Standard Deviation |
18.54219923 |
|
Count |
252 |
In creating the descriptive statistic table, the data analysis tool was clicked in the Excel workbook tab. The first dialogue box was opened up, where the descriptive statistics were chosen. This was by clicking, which was followed by another dialogue box that popped up. This was utilized in selecting the data whereby the adjusted close data were highlighted. The option of summary statistics was established, followed by the output generation.
Calculation of the mean, median, mode, and standard deviation of the company’s stock volume
|
Statistic |
Value |
|
Volume |
|
|
Mean |
7399826.98 |
|
Standard Error |
276910.943 |
|
Median |
6158300 |
|
Mode |
2985700 |
|
Standard Deviation |
4395824.94 |
|
Count |
252 |
This was developed by clicking on the data analysis tool in the Excel workbook tab. The first dialogue box popped up, followed by clicking the descriptive statistics. This was also followed by another dialogue box which popped up later. This was utilized in selecting the data whereby the column with the volume values was chosen from the dataset.
Discussion
The first and second graphs were based on the lowest and highest stock prices of Nike Company. As illustrated from the charts, Nike’s stock prices were lowest at the beginning of the year but later inclined at the year-ending period. The possible factor that led to the pattern is the most recent covid-19 pandemic that significantly affected its operations. Besides, the company’s adjusted stock prices conformed to a uniform distribution pattern, but the volume distribution skewed to the left. This showed that the company’s stock volume was decreasing during the year. Moreover, the company’s adjusted daily stock scored a mean of 105.64, while its standard deviation was 18.54. Further, the analysis showed that Nike’s daily stock volume had a mean of 7399826.98, while its standard deviation was 4395824.94. This was considered to be a relatively high value of standard deviation.
References
Freixo, M. C. (2023).
Valuation of Nike Inc (Master’s thesis).
Yahoo finance. (2020). Nike, Inc. (NKE). Retrieved from;
https://finance.yahoo.com/quote/NKE/
Wondershare. (2021). Nike Mission and Vision Statement Analysis. Retrieved from;
https://www.edrawmind.com/article/nike-mission-and-vision-statement-analysis.html
Yao, D. W., & Chen, X. (2019).
Nike inc.-footware and apparel (Doctoral dissertation).
The highest stock price
High 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 43901 43902 43903 43906 43907 43908 43909 43910 43913 43914 43915 43916 43917 43920 43921 43922 43923 43924 43927 43928 43929 43930 43934 43935 43936 43937 43938 43941 43942 43943 43944 43945 43948 43949 43950 43951 43952 43955 43956 43957 43958 43959 43962 43963 43964 43965 43966 43969 43970 43971 43972 43973 43977 43978 43979 43980 43983 43984 43985 43986 43987 43990 43991 43992 43993 43994 43997 43998 43999 44000 44001 44004 44005 44006 44007 44008 44011 44012 44013 44014 44018 44019 44020 44021 44022 44025 44026 44027 44028 44029 44032 44033 44034 44035 44036 44039 44040 44041 44042 44043 44046 44047 44048 44049 44050 44053 44054 44055 44056 44057 44060 44061 44062 44063 44064 44067 44068 44069 44070 44071 44074 44075 44076 44077 44078 44082 44083 44084 44085 44088 44089 44090 44091 44092 44095 44096 44097 44098 44099 44102 44103 44104 44105 44106 44109 44110 44111 44112 44113 44116 44117 44118 44119 44120 44123 44124 44125 44126 44127 44130 44131 44132 44133 44134 44137 44138 44139 44140 44141 44144 44145 44146 44147 44148 44151 44152 44153 44154 44155 44158 44159 44160 44162 44165 44166 44167 44168 44169 44172 44173 44174 44175 44176 44179 44180 44181 44182 44183 44186 44187 44188 44189 44193 44194 44195 102.209999 102 101.839996 102.739998 102.139999 102.410004 101.93 102.339996 103.889999 103.699997 103.57 104.550003 104.69000200000001 105.620003 104.370003 103.889999 100.709999 101.050003 101.300003 99.75 98.449996999999996 100.91999800000001 102.779999 101.970001 101.529999 100.400002 100.510002 100.349998 103.08000199999999 103.739998 103.889999 103.379997 103.389999 102.629997 102.08000199999999 97.07 96.760002 94.650002000000001 93.059997999 999993 89.470000999999996 93.139999000000003 94.980002999999996 93.82 91.68 89.389999000000003 86.739998 88.400002000000001 84.629997000000003 78.489998 78.199996999999996 72.970000999999996 73.330001999999993 68.330001999999993 72.709998999999996 74.059997999999993 66.879997000000003 72.660004000000001 83.489998 86.860000999999997 85.739998 85.959998999999996 85.730002999999996 81.180000000000007 81.599997999999999 79.790001000000004 85.040001000000004 88.870002999999997 85.769997000000004 87.389999000000003 85.989998 87.769997000000004 85.879997000000003 86.529999000000004 90.25 89.440002000000007 86.900002000000001 89.440002000000007 89.529999000000004 89.120002999999997 89.870002999999997 90 .709998999999996 91.389999000000003 88 86.110000999999997 85.800003000000004 88.529999000000004 88.690002000000007 90.239998 90.639999000000003 91.419998000000007 91.669998000000007 87.739998 86.580001999999993 87.230002999999996 91.599997999999999 93.82 93.860000999999997 94.379997000000003 94.650002000000001 97.43 99.989998 100.69000200000001 99.25 99.779999000000004 100.879997 104.550003 103.900002 104.69000200000001 104.300003 103.769997 103.150002 98.989998 97.800003000000004 98.080001999999993 101.339996 100.239998 99.419998000000007 99.980002999999996 99.540001000000004 102.220001 101.849998 101.68 98.779999000000004 96 98.300003000000004 98.720000999999996 99.660004000000001 100.029999 99.550003000000004 98.980002999999996 98.910004000000001 98.050003000000004 98.940002000000007 97.25 99.040001000000004 98.230002999999996 97.230002999999996 96.349997999999999 99 98.989998 100.18 99.360000999999997 98.400002000000001 97.470000999999996 97.550003000000004 97.230002999999996 97.650002000000001 99.290001000000004 97.949996999999996 101.25 101.18 101.910004 106.83000199999999 107.33000199999999 105.889999 106.989998 106.779999 106.5 107 109.69000200000001 108.739998 109.769997 112 112.279999 112.089996 112.790001 112.66999800000001 112.519997 114.900002 117.410004 116.900002 113.75 113.839996 116.209999 118.230003 119.25 119.93 120.480003 119.69000200000001 118.550003 117.910004 114.05999799999999 117.199997 130.38000500000001 127.540001 124.75 126.19000200000001 127.099998 127.279999 127.730003 126.800003 128.5 130.44000199999999 130.41000399999999 130.929993 131.19000199999999 131.33999600000001 129.86999499999999 129.60000600000001 129.10000600000001 130.19000199999999 129.779999 129.89999399999999 131.38000500000001 130.259995 130.60000600000001 129.61999499999999 129.490005 126.400002 124.19000200000001 123.660004 124.099998 125.5 128.929993 130.41000399999999 129.91000399999999 136.35000600000001 130.11999499999999 129.800003 127.839996 128.60000600000001 130.320007 132.60000600000001 133.979996 132.11000100000001 133.529999 134.88999899999999 135.990005 135.800003 136.13000500000001 135.28999300000001 136.5 136.320007 137.949997 137.39999399999999 138.86000100000001 140.44000199999999 140.570007 139.13999899999999 138.13999899999999 139 139.44000199999999 140.490005 140.740005 141.13999899999999 147.949997 143.470001 143.60000600000001 142.19000199999999 142.91999799999999 143.05999800000001 142.61000100000001
Day of the year
Stock Prices
The lowest stock price
Low 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 43901 43902 43903 43906 43907 43908 43909 43910 43913 43914 43915 43916 43917 43920 43921 43922 43923 43924 43927 43928 43929 43930 43934 43935 43936 43937 43938 43941 43942 43943 43944 43945 43948 43949 43950 43951 43952 43955 43956 43957 43958 43959 43962 43963 43964 43965 43966 43969 43970 43971 43972 43973 43977 43978 43979 43980 43983 43984 43985 43986 43987 43990 43991 43992 43993 43994 43997 43998 43999 44000 44001 44004 44005 44006 44007 44008 44011 44012 44013 44014 44018 44019 44020 44021 44022 44025 44026 44027 44028 44029 44032 44033 44034 44035 44036 44039 44040 44041 44042 44043 44046 44047 44048 44049 44050 44053 44054 44055 44056 44057 44060 44061 44062 44063 44064 44067 44068 44069 44070 44071 44074 44075 44076 44077 44078 44082 44083 44084 44085 44088 44089 44090 44091 44092 44095 44096 44097 44098 44099 44102 44103 44104 44105 44106 44109 44110 44111 44112 44113 44116 44117 44118 44119 44120 44123 44124 44125 44126 44127 44130 44131 44132 44133 44134 44137 44138 44139 44140 44141 44144 44145 44146 44147 44148 44151 44152 44153 44154 44155 44158 44159 44160 44162 44165 44166 44167 44168 44169 44172 44173 44174 44175 44176 44179 44180 44181 44182 44183 44186 44187 44188 44189 44193 44194 44195 101.019997 100.30999799999999 100.870003 100.80999799999999 100.849998 101.389999 100.760002 100.82 102.349998 102.480003 102.849998 103.339996 103.80999799999999 104.41999800000001 102.620003 101.660004 98.010002 99.519997000000004 99.169998000000007 97.370002999999997 95.919998000000007 98.57 101.260002 99.529999000000004 100.160004 98.970000999999996 99 99.440002000000007 100.44000200000001 101.68 102.449997 101.610001 102.43 100.550003 99.629997000000003 95.25 92.620002999999997 91.989998 88.5 85.150002000000001 87.910004000000001 90.57 90.839995999999999 89.940002000000007 85.879997000000003 80.919998000000007 82.879997000000003 82.07 73 71.760002 63.369999 62.400002000000001 60 64.150002000000001 67.199996999999996 60.580002 64 76.199996999999996 80.010002 79.510002 81.5 82.400002000000001 78.529999000000004 77.160004000000001 77.910004000000001 81.209998999999996 84.029999000000004 83.610000999999997 85.160004000000001 84.139999000000003 85.480002999999996 83.709998999999996 84.550003000000004 88.360000999999997 87.519997000000004 85.089995999999999 86.419998000000007 87.260002 87.650002000000001 87.309997999999993 88.6299970000000 03 87.830001999999993 86.510002 84.809997999999993 84.309997999999993 86.029999000000004 87.43 88.379997000000003 89.589995999999999 89.139999000000003 88.150002000000001 85.199996999999996 84.110000999999997 84.879997000000003 89.879997000000003 90.82 92.699996999999996 92.370002999999997 93.349997999999999 95.279999000000004 97.620002999999997 98.25 96.93 97.889999000000003 98.82 101.120003 100.470001 102.129997 102.709999 102.43 101.709999 94.879997000000003 94.739998 93.440002000000007 97.720000999999996 98.889999000000003 97.849997999999999 95.779999000000004 96.019997000000004 100.709999 98.089995999999999 98.800003000000004 93.57 93. 699996999999996 95.639999000000003 97.110000999999997 98.019997000000004 99.040001000000004 96.919998000000007 96.959998999999996 96.370002999999997 95.720000999999996 96.260002 95.510002 97.309997999999993 97.040001000000004 96.040001000000004 95.110000999999997 96.099997999999999 97.910004000000001 97.720000999999996 97.699996999999996 96.889999000000003 96.160004000000001 96.300003000000004 95.800003000000004 96.300003000000004 97.82 96.550003000000004 97.080001999999993 100.029999 99.889999000000003 102.400002 104.860001 103.379997 105.199997 105.459999 105.120003 105.470001 107.349998 107.349998 107.75 109.900002 111.089996 111.290001 110.5 110.57 111.139999 111.83000199999999 114.5 112 110.209999 110.540001 112.83000199999999 114 116.41999800000001 118.16999800000001 119.18 118.160004 115.800003 114.489998 111.739998 112.849998 125.260002 123.300003 122.269997 123.889999 123.959999 125.160004 125.30999799999999 123.589996 126.449997 127.269997 128.25 129.509995 129.33000200000001 129.259995 127.959999 127.010002 126.110001 127.550003 127.050003 127.720001 128.449997 128.86000100000001 128.64999399999999 126.68 127.900002 121.040001 121.150002 118.800003 121.099998 123.19000200000001 125.260002 128.46000699999999 128.35000600000001 128.770004 126.25 127.18 125.629997 126.83000199999999 127.370003 129.11000100000001 131.529999 129.929993 131.91000399999999 133.08999600000001 134.21000699999999 133.61999499999999 133.33999600000001 132.69000199999999 134.75 134.66999799999999 135 135.63999899999999 136.800003 137.64999399999999 138.270004 137.240005 136.229996 136.199997 137.25 137.46000699999999 138.75 137.16999799999999 142.509995 141.08999600000001 141.699997 141.10000600000001 141.03999300000001 140.429993 140.66000399999999
Day of the year
Stock Prices
image1.emf
image2.emf
Looking for top-notch essay writing services? We've got you covered! Connect with our writing experts today. Placing your order is easy, taking less than 5 minutes. Click below to get started.
Order a Similar Paper Order a Different Paper
