Question
Hello. Please help me calculate the daily closing price change for XPO Logistics by taking the difference between the closing price and the opening price
Hello.
Please help me calculate the daily closing price change for XPO Logistics by taking the difference between the closing price and the opening price of the day. This is the daily change in stock.
2. Run the Descriptive Statistics->Summary Table in Excel Data Analysis on the daily stock change. Share the summary table.
3.Calculate the 1st and 3rd quartiles of the daily stock change. Share these along with the min, median, and max from 2) as 5-Number Summary.
4.Create a Box & Whiskers Plot using your 5-Number Summary.
5. As a result, daily inventory changes are distributed normally? Why or why not?
Date | Open | High | Low | Close* | Adj Close** | Volume |
---|---|---|---|---|---|---|
Dec 03, 2021 | 74.38 | 74.98 | 72.58 | 73.60 | 73.60 | 1,014,000 |
Dec 02, 2021 | 70.81 | 75.21 | 70.31 | 74.53 | 74.53 | 1,677,500 |
Dec 01, 2021 | 74.07 | 74.43 | 70.29 | 70.31 | 70.31 | 1,585,000 |
Nov 30, 2021 | 75.46 | 75.50 | 72.03 | 72.44 | 72.44 | 2,000,300 |
Nov 29, 2021 | 78.02 | 78.51 | 74.81 | 76.24 | 76.24 | 1,188,400 |
Nov 26, 2021 | 76.38 | 77.15 | 75.17 | 75.97 | 75.97 | 789,900 |
Nov 24, 2021 | 77.90 | 79.08 | 77.16 | 78.45 | 78.45 | 598,800 |
Nov 23, 2021 | 79.09 | 79.51 | 77.14 | 78.09 | 78.09 | 926,600 |
Nov 22, 2021 | 79.11 | 80.90 | 78.76 | 78.90 | 78.90 | 1,952,600 |
Nov 19, 2021 | 76.37 | 78.99 | 75.32 | 78.78 | 78.78 | 2,621,400 |
Nov 18, 2021 | 79.05 | 79.05 | 75.89 | 76.61 | 76.61 | 926,100 |
Nov 17, 2021 | 76.26 | 77.97 | 75.69 | 77.58 | 77.58 | 1,760,300 |
Nov 16, 2021 | 78.44 | 79.07 | 77.30 | 77.41 | 77.41 | 828,200 |
Nov 15, 2021 | 79.89 | 80.16 | 78.44 | 78.49 | 78.49 | 681,100 |
Nov 12, 2021 | 76.81 | 80.21 | 76.60 | 79.85 | 79.85 | 1,257,100 |
Nov 11, 2021 | 76.49 | 77.00 | 75.95 | 76.65 | 76.65 | 847,300 |
Nov 10, 2021 | 77.00 | 78.34 | 75.91 | 76.25 | 76.25 | 863,000 |
Nov 09, 2021 | 79.81 | 80.25 | 77.01 | 77.39 | 77.39 | 1,775,100 |
Nov 08, 2021 | 79.30 | 79.93 | 78.04 | 79.58 | 79.58 | 1,431,400 |
Nov 05, 2021 | 82.71 | 83.38 | 78.23 | 78.60 | 78.60 | 1,769,200 |
Nov 04, 2021 | 80.96 | 82.42 | 79.63 | 82.09 | 82.09 | 1,600,300 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started