100%(3)3 out of 3 people found this document helpful
This preview shows page 5 - 8 out of 12 pages.
the x-axis. In order to create this scatter plot, the historical data of Amazon’s stock prices from Nasdaq was downloaded into an Excel file. Once this was downloaded, column A which had the dates and column C which gave the highest prices had to be side by side. This is done by hiding Column B. Both A and C columns should be highlighted.The next step is to click on the insert tab which will then show an area for charts. Click on the chart that says scatterplot and then click on “more scatterplots”. This will bring up the scatterplot that will be used. Click ok and the scatterplot shown below will appear. Expand the
Using Analytic Techniques to Add Meaning to Data6chart to allow the dates to show. On the Excel sheet, click anywhere inside the scatterplot and three options will appear on the top right next to the graph. Click on the one that looks like a plussign. This will allow changes to be made to the chart tile as well as the addition of the axis titles. Ensure that both the chart titles and axis titles are selected. Within the chart, click on the chart title and change the name of the information the scatterplot is representing. Once that is completed, the same should be done with the axis titles and what each one represents. 10/27/201812/16/2018 2/4/2019 3/26/2019 5/15/2019 7/4/2019 8/23/201910/12/201912/1/2019 1/20/202005001000150020002500Scatterplot of Amazon's Highest Stock PricesTime in DaysStock Prices in U.S. DollarsThe following is the histogram for Amazon’s adjusted closing stock prices for the monthsof Nov. 2018 through Nov. 2019 created in Excel. The x-axis represents the ranges of the closingstock prices and the y-axis represents how many times those prices fell within a certain range. The histogram is created by first finding the highest and lowest prices in the F column. For the F column, the lowest price is 1,377.55 U.S. dollars and the highest price is 2,021 U.S. dollars. This shows that the binge range can be between 1400 and 2100. Once that is determined, create a separate column labeled BINS and placed the numbers 1400 thru 2100 in the column. For this histogram, the range can be 100 after each number. An example would be 1400 +100 which would be 1500.
Using Analytic Techniques to Add Meaning to Data7The histogram chart can be found in the DATA section in Excel (ensure the data analysis add on is enabled). After clicking on the data tab, the next step is to click on the data analysis tab,find histogram and click ok. This will open the histogram settings page. For the input range, select the numbers in the F column (adjusted closing price) which are the numbers between F2 and F253. The BIN range would be the column labeled BINS. Ensure chart output is checked and for the output range click on any available cell; click ok. The histogram chart below should appear. Change the titles to ensure they match the data that was collected.140015001600170018001900200021002200More01020304050607080Histogram of Adjusted Closing Stock PriceFrequencyRanges of Adjusted Closing Stock PriceNumber of OccurencesThe following is the histogram for Amazon’s daily stock trade volume for the months of Nov. 2018 through Nov. 2019 created in Excel. The x-axis shows the ranges in stock volume and