Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Non-Cooperative Game Theory

Authors: Takako Fujiwara Greve

1st Edition

4431556451, 9784431556459

More Books

Students also viewed these Mathematics questions