Select Page

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.
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 or recorded voice-over 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.
If you include a voice-over in lieu of presenter’s notes, your recording should be no longer than 12 minutes.
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.

APPLYING ANALYTIC TECHNIQUES TO BUSINESS

Capella University

MBA-FPX5008

24 May 2021

APPLYING ANALYTIC TECHNIQUES TO BUSINESS

IBM is an abbreviation for the international business machine, and it is a multinational

company whose headquarters are located in New York City. The Company was founded in then 1911

under a different name; the initial name was the computing-tabulating recording company, which

IBM dealt with computer-related services and goods. It sold middleware, software, and hardware

(Watson, 2017). Additionally, the Company has a section specifically for cloud hosting and

consulting services. For about 28 consecutive years, IBM has held the record for most US patents by

a business.

IBM is the largest IT service provider in the world’s service business, whereby it has more

than 5 percent of the market share that is almost double the closest competitor. The Company counts

on investments and acquisitions to offer future growth. History of Stock Prices Volatility entails

statistical measures used to measure the spreading of the returns for a particular security or the

market index.

Often, if the Volatility is higher, the security is riskier. It shows the rates at which stock prices

increase or decrease within a given time. Volatility also helps in measuring the risks that are attached

to various securities. Two different stocks may begin from a similar stock price and end at the same

comparable Price, yet the Volatility may indicate the magnitude of fluctuation with time. Thus, before

commenting on the Volatility of the IBM stock, it is essential to calculate the Volatility using the last

prices provided in the image above on various dates (Stikeleather, 2013, Apr 24).

The Company is one of the most valuable companies in the world of computing since it has

invested heavily in research and development, which has been paying handsomely. Through research

and development, the worlds hope that more advanced hardware and software can solve problems.

Power inadequacy, for instance, has plagued the world for a very long time.

APPLYING ANALYTIC TECHNIQUES TO BUSINESS

This first graph represents the lowest numbers for the year. The scattergraph is one of the

more accessible graphs to look at and interpret. While studying this graph, it shows throughout the

year that the numbers are constantly changing. There are says that have a significant increase, but in

turn, it has a drastic drop in numbers; by the end of the year, the numbers were up above 130,

whereas at the beginning of the year, it was above 112.5.

While looking over the second graph, the scatter graph is showing the lows throughout the

year. If I were to place the two charts side-by-side, they would almost look the same. By this

happening, it shows that the numbers did not fluctuate throughout the high and low numbers. As in

the first graph, the numbers started above 112.5 at the beginning of the year and went up and down

throughout the year and ended above 130.

APPLYING ANALYTIC TECHNIQUES TO BUSINESS

Descritive Statistics

Descriptive Statistics

Next, I will discuss the mean, mode, median, and standard deviation for the adjusted daily

closing stock prices and the stock volume. I found the mode by putting all the numbers in sequence

order, and then I look for the number showing up the most amount of times, which is the mode. The

mode for the adjusted daily closing stock price is $121.98. The mode for stock volume is nothing

because no number is duplicated. The median is found by looking for the number that is in the middle

of all the numbers.

The median for the adjusted daily closing stock price is $5507.671. The median for stock

volume is 120.8268. The standard deviation for the adjusted everyday closing stock price was

ad close

mean 121.5773

median 120.8268

mode 121.98

standard
deviation

7.08524

Volume

mean 121.577
3

54994
49

median 120.826
8

55017
35

mode 121.98 55076
71

standar
d
deviati
on

7.0852
4

551413
0

APPLYING ANALYTIC TECHNIQUES TO BUSINESS

$104.96, and for stock, volume was 1484781. I used the formula in Excel to calculate this

information. The mean for the adjusted daily closing stock price is $1842.80. This is done by adding

all the numbers and dividing by the number of digits there are. The mean stock price is 121.5773.

First, you need to understand how to get the mean of the data. You would add up all the data

in the adjusted daily closing stock price and then divide it by the number of added numbers, which

will give you the mean. The changed daily closing stock price would be what on average for the daily

fee. This does not mean that it cannot go over that amount, but that, on average, it will be around that

price throughout the whole year. What does it imply if the median is different from the mean? The

median is the middle number of all the numbers from the data. If they are different, that means that

the data is skewed in some ways. With standard deviation, it is a statistical measure to show

volatility. Using this allows people to see the estimated price movement, which will lead to average

strengths and weaknesses (Watson, 2017).

Histogram

1761100 Frequenc
y

3576220 47

5391340 114

7206460 50

9021580 22

1083670
0

7

APPLYING ANALYTIC TECHNIQUES TO BUSINESS

This graph represents IBM’s adjusted closing numbers for the whole year; this graph is called

a histogram graph and shows up differently compared to the last two graphs. With this graph it does

depict the whole year, however it is with grouping of numbers. Looking at this graph it shows that

highest numbers were between 110.4895 and 144.24, which was between 0 and 120 (Stikeleather,

2013, Apr 24).

The figure shows the frequency of daily adjusted closing stock prices, which fall within equally

distributed data ranges (bin). The adjusted closing stock prices are shown on the horizontal axis, and

the frequency of adjusted closing prices falls within the vertical axis. As shown in the table above, the

histogram is skewed to the left. This indicates that a significant part of points lower on the higher

1265182
0

4

1446694
0

2

1628206
0

2

1809718
0

0

3806350
0

3

More 0

APPLYING ANALYTIC TECHNIQUES TO BUSINESS

ranges of daily adjusted stock prices. A more substantial number of data set lies between 105 and

$140. This shows that the adjusted everyday closing stock price was more stable in that bin. The

smaller number of adjusted daily closing stock prices lies between $110 and $137. This shows that

the stock prices were less stable in that ranges.

Conclusion

In conclusion, I have learned a lot about IBM, and after creating graphs and working on the data, it

has come to my attention that IBM will be around for a long time (Stikeleather, 2013, Apr 24). If you

continue to purchase from them, IBM is a company that might eventually be able to close down other

stores. I know that Walmart and other stores are starting to do the same thing as IBM, and I have tried

that, and I don’t particularly appreciate how they set up is and how if the product is not available, I

will have to wait longer than they are wanting. While working on this data and creating the graphs, I

have learned a lot more about IBM that I was not aware of. The company needs to make sure that

they are aware of the trends, showing that there will be higher traffic during the holidays or more

purchases being made during this time.

 Then during the off-seasons, there still be a lot of traffic, but a lot of time, the consumers might just

be browsing and not making as many purchases. This information will help IBM to know what to be

expecting within certain times of the year and will help them with products and being able to plan.

The scatterplots for lowest and highest stock prices show a positive linear relationship between stock

value and time starting February 2019, which assists know the effect of the improved revenue growth

for IBM Corporation in 2018 compared to the previous years. Also, the scatterplots show better price

valuation at the beginning of 2019 compared to 2018 (Watson, 2017). This exhibits the underlying

impact of IBM’s quarterly performance. Interpretation of histograms assists understands while the

median for closing stock prices lay on the higher bin, median for stock volume fell on lower data bin,

showing increased demand for stocks of IBM (Watson, 2017).

APPLYING ANALYTIC TECHNIQUES TO BUSINESS

 The information will help IBM to be able to plan their budget and also let them know if they can hire

more people or if they are going to lay off people. Learning about the greater world and their

expectations is also something that this data will let IBM know by watching the trends with the data.

APPLYING ANALYTIC TECHNIQUES TO BUSINESS

Reference

Lind, D. A., Marchal, W. G., & Wathen, S. A. (2019). Basic statistics for business and

economics (9th ed.). New York, NY: McGraw-Hill.

Chapter 5, “A Survey of Probability Concepts.”

While previous chapters on descriptive statistics have concerned data on past phenomena, this

chapter addresses computing the likelihood that something will occur in the future.

Chapter 8, “Sampling Methods and the Central Limit Theorem.”

Sampling a population gives us information to make judgments and inferences about the

population. This chapter discusses methods of selecting a sample from a population and how to think

about the distribution of the sample.

Chapter 9, “Estimation and Confidence Intervals.”

This chapter will help you think about different aspects of sampling, such as estimating a

population value and the range of values, or the confidence interval.

Hewitt, F. (2015). Storytelling: The heart of leadership. New Zealand Management, 62(1),

26–27.

This article is a brief account of the importance of using personal connections to make data

accessible in presentations.

Nussbaumer Knaflic, C. (2015). Storytelling with data: A data visualization guide for

business professionals. Hoboken, NJ: Wiley.

Chapter 1, “The Importance of Context.”

The components of context are who, what, and how. This chapter offers strategies for

interpreting context so you can communicate visually with data.

Stikeleather, J. (2013, Apr 24). How to tell a story with data [Blog post]. Retrieved from

https://hbr.org/2013/04/how-to-tell-a-story-with-data

http://library.capella.edu/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=bth&AN=100811720&site=ehost-live&scope=site

https://ebookcentral-proquest-com.library.capella.edu/lib/capella/detail.action?docID=4187267

https://ebookcentral-proquest-com.library.capella.edu/lib/capella/detail.action?docID=4187267

https://hbr.org/2013/04/how-to-tell-a-story-with-data

APPLYING ANALYTIC TECHNIQUES TO BUSINESS

This short post highlights five steps to tell a good story with data from the journalistic

perspective, including a helpful categorization of the different types of audiences that you may be

addressing with your data visualization.

Watson, H. J. (2017). Data visualization, data interpreters, and storytelling. Business

Intelligence Journal, 22(1), 5–10.

This cautionary reading gives specific examples of what not to do when creating an executive

presentation with data visualizations.

Microsoft. (n.d.). Add a pie chart. Retrieved from https://support.office.com/en-us/article/

Add-a-pie-chart-1a5f08ae-ba40-46f2-9ed0-ff84873b7863?ui=en-US&rs;=en-

US&ad;=US#__toc348714905

Microsoft. (n.d.). Create a box and whisker chart. Retrieved from https://support.office.com/

en-us/article/Create-a-box-and-whisker-chart-62f4219f-db4b-4754-aca8-4743f6190f0d

Microsoft. (n.d.). Create a histogram in Excel. Retrieved from https://support.office.com/en-

us/article/Create-a-histogram-in-Excel-85680173-064b-4024-b39d-80f17ff2f4e8?ui=en-US&rs;=en-

US&ad;=US

Microsoft. (n.d.). Load the Analysis ToolPak in Excel. Retrieved fromhttps://

support.office.com/en-us/article/Load-the-Analysis-ToolPak-in-Excel-6a63e598-

cd6d-42e3-9317-6b40ba1a66b4?

CTT=1&CorrelationId;=9f089166-5317-42d4-8d41-56b3d207e812&ui;=en-US&rs;=en-

US&ad;=US

Microsoft. (n.d.). Present your data in a column chart. Retrieved from https://

support.office.com/en-us/article/Present-your-data-in-a-column-chart-d89050ba-e6b6-47de-b090-

e9ab353c4c00

http://library.capella.edu/login?qurl=https%253A%252F%252Fsearch.proquest.com%252Fdocview%252F1873946557%253Faccountid%253D27965

https://support.office.com/en-us/article/Add-a-pie-chart-1a5f08ae-ba40-46f2-9ed0-ff84873b7863?ui=en-US&rs=en-US&ad=US#__toc348714905

https://support.office.com/en-us/article/Create-a-box-and-whisker-chart-62f4219f-db4b-4754-aca8-4743f6190f0d

https://support.office.com/en-us/article/Create-a-histogram-in-Excel-85680173-064b-4024-b39d-80f17ff2f4e8?ui=en-US&rs=en-US&ad=US

https://support.office.com/en-us/article/Load-the-Analysis-ToolPak-in-Excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4?CTT=1&CorrelationId=9f089166-5317-42d4-8d41-56b3d207e812&ui=en-US&rs=en-US&ad=US

https://support.office.com/en-us/article/Present-your-data-in-a-column-chart-d89050ba-e6b6-47de-b090-e9ab353c4c00

APPLYING ANALYTIC TECHNIQUES TO BUSINESS

Microsoft. (n.d.). Present your data in a scatter chart or line chart. Retrieved from https://

support.office.com/en-us/article/Present-your-data-in-a-scatter-chart-or-a-line-

chart-4570A80F-599A-4D6B-A155-104A9018B86E.

Microsoft. (n.d.). Use the Analysis ToolPak to perform complex data analysis. Retrieved

from https://support.office.com/en-us/article/Use-the-Analysis-ToolPak-to-perform-complex-data-

analysis-6C67CCF0-F4A9-487C-8DEC-BDB5A2CEFAB6

https://support.office.com/en-us/article/Present-your-data-in-a-scatter-chart-or-a-line-chart-4570A80F-599A-4D6B-A155-104A9018B86E

https://support.office.com/en-us/article/Use-the-Analysis-ToolPak-to-perform-complex-data-analysis-6C67CCF0-F4A9-487C-8DEC-BDB5A2CEFAB6

Running Head: 12

Running Head: IBM STOCK PRICE ANALYSIS

IBM STOCK PRICE ANALYSIS

Capella University

13 May 2021

IBM STOCK PRICE ANALYSIS 2

IBM is an abbreviation for the international business machine, and it is a multinational

company whose headquarters are located in New York City. The company was founded in then

1911 under a different name; the initial name was the computing-tabulating recording company,

which the company dealt with computer-related services and goods. It sold middleware,

software, and hardware. Additionally, the company has a section specifically for cloud hosting

and consulting services. For about 28 consecutive years, IBM has held the record for most US

patents by a business. The automated teller machine was the creation of IBM. Among other

inventions include the hard disk drive and floppy disk. Over the years, the company has been

shift business to focus on a more profitable market and higher value items. It has acquired other

companies such as PwC Consulting (Pugh, 2015).

This company is not only F500 but also one of the top 30 companies doing very well in

the US market. It has branches in almost 170 countries all over the world. As of the year 2020,

the company recorded annual revenue of $ 73.6 billion. It is unfortunate because, over the last

nine years, the profit has dropped by about eight years. It has been criticized for not using the

long-term investment technique; instead has used financial engineering.

This is one of the most valuable companies in the world of computing since it has

invested heavily in research and development, which has been paying handsomely. Through

research and development, the worlds hope that more advanced hardware and software can be

developed to solve problems. Power inadequacy, for instance, has plagued the world for a very

long time.

IBM STOCK PRICE ANALYSIS 3

Scatter plots

This was created in a simple manner. The date column was selected as well as the low queue.

Then on the Insert tab, a scatter plot was selected on the chart section. The x and y-axis were

labeled accordingly (Pishro-Nik, 2014).

This is a similar manner to that of the low. The date column was selected as well as the high

column. Then on the Insert tab, a scatter plot was established on the chart section. The x and y-

axis were labeled by clicking the graph to produce a window. From that window, axis time was

Low

pr
ic

es

0

37.5

75

112.5

150

dates
4/20/2024 7/23/2024 10/25/2024 1/27/2025 5/2/2025

High

pr
ic

e

0

37.5

75

112.5

150

date
4/20/2024 7/23/2024 10/25/2024 1/27/2025 5/2/2025

IBM STOCK PRICE ANALYSIS 4

checked. Then on the graph, the “axis title” was replaced with price and date for the x and y-axis,

respectively. The title could be changed, but it was labeled automatically (Lind, Marchal, &

Wathen, 2019).

Histogram

Making a histogram is a simple process. It can either be done manually or automatically. Either

of the methods produces histograms that are desirable. However, the manual method gives one

room to control parameters, such as the number of classes included. There is a challenge, though.

Selecting the bins presents a severe problem because of the data distribution. Several trials give

one enough experience to choose the correct upper and lower limits correctly.

In this case, I looked for the difference between the maximum and minimum values. The

difference is divided by the selected number of classes. I chose six levels with equal intervals.

So, the quotient of the difference and the number, of course, are added to the minimum values.

For the ad close, the following figure was obtained (Pishro-Nik, 2014).

The upper-class limit and the frequency is as follows;

Histogram Adj
Close

Fr
eq

ue
nc

y

0
35
70

105
140

103.739372

110.4894775 137.4898995

Frequency

Upper class limit Frequency

IBM STOCK PRICE ANALYSIS 5

The volume histogram is as follows;

110.4895 7

117.2396 57

123.9897 123

130.7398 38

137.4899 17

144.24 9

More 0

Histogram

Fr
eq

ue
nc

y

0
30
60
90

120

1761100

3576220 10836700 18097180

Frequency

1761100 Frequency

3576220 47

5391340 114

7206460 50

9021580 22

10836700 7

12651820 4

14466940 2

16282060 2

18097180 0

38063500 3

More 0

IBM STOCK PRICE ANALYSIS 6

The process of making this histogram was as follows. The maximum value and minimum

value were evaluated, and their difference found. The difference was then divided by the number

of class of classes desired. This was to give the class interval needed. This was how the volume

histogram was created. This histogram, however, did not have an equal break because the values

were not normally distributed.

Descriptive statistics

The above measure of central tendency was calculated using the inbuilt function. First

was the mean. The mean could be obtained by using the function =average(f2:f253) where f2

was the cell where the first value of ad close was located and f253 was the cell where the last

value of adj close was located. The model was obtained using the function “=mode(f2:f253)”.

The standard deviation and the median were calculated using inbuilt function as well,

“ =stdev(f2:f253)” and “=median(f2:f253)” respectively (Deep, 2016).

ad close

mean 121.5773

median 120.8268

mode 121.98

standard
deviaAon

7.08524

Volume

mean 121.5773 5499449

median 120.8268 5501735

mode 121.98 5507671

IBM STOCK PRICE ANALYSIS 7

As for the volume, mean, median, mode and standard deviation were calculated using =

average(g2:g253), “=median(g2:g253)”, “=mode(g2:g253)”, and “=stdev(g2:g253)”

respectively. Those formula could calculate the values automatically. However, the manual

method could also get employed only that a lot of time would be required.

standard
deviaAon

7.08524 5514130

IBM STOCK PRICE ANALYSIS 8

References

Pugh, E. W. (2015). Building IBM: Shaping an industry and its technology. MIT Press:

Cambridge, Mass.

Pishro-Nik, H. (2014). Introduction to probability, statistics, and random processes.

Deep, R. (2016). Probability and statistics with integrated software routines. Burlington,

MA: Academic Press.

Lind, D. A., Marchal, W. G., & Wathen, S. A. (2019). Basic statistics for business

and economics (9th ed.). New York, NY: McGraw-Hill