Complete 2 classmate repsonses in Statistics Course : Urgent Assignments

Complete two discussion responses to classmates posts….please follow the discussion response questions for each post

POST 1:

First response: Read a classmate’s response. Consider investing in your classmate’s stock and assume that the daily change is normally distributed. Using Normal.xlsx, your classmate’s mean and standard deviation, determine the probability for the daily change of this stock to have:

A decrease of 0.5 point or more (X ≤ -0.5)?
An increase of more than 0.5 point (X > 0.5)?
A decrease of more 1 point or more (X ≤ -1)?
An increase of more than 1 point (X > 1)?

Hello everyone!

I chose to use Best Buy for this post. The mean for the daily price changes would be -.002 and the standard deviation is .688. The median is .025, which is greater than the mean, so that would make this left skewed.

Here is the chart of prices and changes for Best Buy.

Date	Open	Close	Daily Change
10/9/2017	59	59.04	0.04
10/10/2017	58.44	57.17	-1.27
10/11/2017	57.05	55.47	-1.58
10/12/2017	55.48	55.13	-0.35
10/13/2017	55.29	55.1	-0.19
10/16/2017	54.95	54.91	-0.04
10/17/2017	54.72	54.65	-0.07
10/18/2017	54.65	55.46	0.81
10/19/2017	55.1	55.46	0.36
10/20/2017	55.79	55.83	0.04
10/23/2017	56.01	56.02	0.01
10/24/2017	56.41	56.65	0.24
10/25/2017	56.63	55.17	-1.46
10/26/2017	55.07	55.95	0.88
10/27/2017	55.31	55.2	-0.11
10/30/2017	55.14	55.38	0.24
10/31/2017	55.5	55.98	0.48
11/1/2017	56.18	56.01	-0.17
11/2/2017	56.21	57.34	1.13
11/3/2017	57.21	56.92	-0.29
11/6/2017	56.76	56.39	-0.37
11/7/2017	56.59	55.13	-1.46
11/8/2017	55.02	56.55	1.53
11/9/2017	56.16	55.93	-0.23
11/10/2017	56.19	56.68	0.49
11/13/2017	56.7	56.97	0.27
11/14/2017	56.58	57.2	0.62
11/15/2017	57.06	57.3	0.24
11/16/2017	55.54	55.25	-0.29
11/17/2017	55.57	55.83	0.26
11/20/2017	56	56.35	0.35
11/21/2017	56.44	56.06	-0.38
11/22/2017	56.54	56.49	-0.05
11/24/2017	56.75	57	0.25

Here is the data analysis for the daily price change.

Column One

Mean	-0.00205882
Standard Error	0.117981221
Median	0.025
Mode	0.24
Standard Deviation	0.687942824
Sample Variance	0.47326533
Kurtosis	0.991946132
Skewness	-0.53950253
Range	3.11
Minimum	-1.58
Maximum	1.53
Sum	-0.07
Count	34

Here is the site I took the stock price history from:

http://www.nasdaq.com/symbol/bby/historical

POST 2:

Second Response: Read a different classmate’s response. Consider investing in your classmate’s stock and assume that it is normally distributed. If you wanted to be 95% sure of what the daily change would be, what range for a daily change would you expect? Use Normal.xlsx.

Hello Professor and Classmates,

I chose the stock for PepsiCo, Inc. (PEP)

The daily change of PepsiCo stock is:

The descriptive statistics summary table is:

The daily change of this stock is slightly right skewed with the median of 0.070 being slightly less than the mean of 0.159 or 0.160. Another consideration would be that in a right skewed distribution, the mean is higher than the median.