Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Peer Reply #2: Read a different classmate's response. Consider investing in your classmate's stock. If you wanted to be 95% sure what the daily change
Peer Reply #2:Read a different classmate's response. Consider investing in your classmate's stock. If you wanted to be 95% sure what the daily change would be, what range for a daily change would you expect? Use the Normal Distribution
https://www.livebinders.com/media//media/get/MTgzNDE3NzQ=
https://www.livebinders.com/media//media/get/MTgzNDE3NzY=
these are the excel links
This is my Peer's Discussion:
For my company of choice, I chose Nike. The company's six week stock price data is below: Dpen High Low Close Ad] Close Volume Daily Stock the 153.20 154. 12 152.22 153.29 153.29 4,254,500 153.20 153. 35 151.91 152.54 152.54 5,543,300 1521!} 152.09 159.25 150.21 150.21 5,591,200 155.25 155. 15 153.20 153.34 153.34 3,414,300 154.25 155. 55 153.44 153.59 153.59 4,250,300 151.55 152. 92 153.33 159.52 159.52 3,314,500 159.12 159. 39 152.02 153.25 153.25 5,323,900 152.50 153. 32 155.52 152.91 152.91 5,322,100 152.59 159.01 152.20 152.50 152.50 5,035,900 152.95 15 1.03 155.02 155.42 155.42 2,944,300 153.23 155. 22 152.32 154.25 154.25 2,041,200 155.09 155. 13 153.53 155.02 155.02 5,352,900 155.29 153.11] 155.50 152.44 152.44 5,344,300 153.21 150. B 153.22 159.53 159.53 11,931,501} 151.04 15 1. 35 143.00 149.59 149.59 25,913,301} 149.51 149. 91 142.29 143.04 143.04 11,429,301} 142.34 142. 53 145.00 145.30 145.30 10,592,3{I} 145.21 142. 94 145.59 145.02 145.02 2,294,900 145.33 141.43 144.42I 145 .23 145.23 10,133,6[1] 145.22 143.31] 144.31 141.06 141.06 3,112,300 141.06 141.62 145.16 141.14 141.14 1,951,000 143.09 15 1.31] 141.32 149.46 149.46 10,331,901} 143.09 149.46 141.51 143.30 143.30 1,610,100 150.30 153. 66 150.26 151.35 151.35 1,953,000 152.22 152. 31 150.61 152.43 152.43 6,329,300 151.99 153. 59 150.06 150.23 150.23 5,551,200 152.42 153. 60 151.30 153 .35 153.35 1,403,600 154.32 156. 61 153.16 156.30 156.30 3,456,300 153.13 153.46 156.25 151.14 151. 14 6,024,500 After running descriptive statistics on this data. I came up with the below five number summary: Daily Change 5 Number Summary Min -2.04 Mean -0.192757517 Q1 -1.29 Standard Error 0.223421645 Median 0.01 Median 0.01001 Q3 0.65 Mode #N/A Max 1.98 Standard Deviation 1.203162379 Sample Variance 1.44759971 Kurtosis -1.038391518 Skewness 0.065050303 Range 4.01999 Minimum -2.039994 Maximum 1.979996 Sum -5.589968 Count 29 Here is the box and whisker plot the data produced:Daily Stock Change 2.50 2.00 1.50 1.00 0.50 0.00 4150 1.0l] 1.5l] 4.00 -2.50 The data has a mean of 4119 and a median of 0.01 therefore is is skewed left and normally distributed. It is normallyr distributed because there are no outliers that stand out in the data rangeStep 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