Expert answer:Complete 2 classmate repsonses in Statistics Cours
Expert answer:Complete two discussion responses to classmates posts….please follow the discussion response questions for each postPOST 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. DateOpen CloseDaily Change10/9/20175959.040.0410/10/201758.4457.17-1.2710/11/201757.0555.47-1.5810/12/201755.4855.13-0.3510/13/201755.2955.1-0.1910/16/201754.9554.91-0.0410/17/201754.7254.65-0.0710/18/201754.6555.460.8110/19/201755.155.460.3610/20/201755.7955.830.0410/23/201756.0156.020.0110/24/201756.4156.650.2410/25/201756.6355.17-1.4610/26/201755.0755.950.8810/27/201755.3155.2-0.1110/30/201755.1455.380.2410/31/201755.555.980.4811/1/201756.1856.01-0.1711/2/201756.2157.341.1311/3/201757.2156.92-0.2911/6/201756.7656.39-0.3711/7/201756.5955.13-1.4611/8/201755.0256.551.5311/9/201756.1655.93-0.2311/10/201756.1956.680.4911/13/201756.756.970.2711/14/201756.5857.20.6211/15/201757.0657.30.2411/16/201755.5455.25-0.2911/17/201755.5755.830.2611/20/20175656.350.3511/21/201756.4456.06-0.3811/22/201756.5456.49-0.0511/24/201756.75570.25Here is the data analysis for the daily price change.Column One Mean-0.00205882Standard Error0.117981221Median0.025Mode0.24Standard Deviation0.687942824Sample Variance0.47326533Kurtosis0.991946132Skewness-0.53950253Range3.11Minimum-1.58Maximum1.53Sum-0.07Count34Here is the site I took the stock price history from:http://www.nasdaq.com/symbol/bby/historicalPOST 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.Tina.https://finance.yahoo.com/quote/PEP/history?p=PEP
unit_3_discussion_example_post_02.pdf
unit_3_discussion_example_post_01.pdf
Unformatted Attachment Preview
Unit 3 Discussion Example – Second Response to Classmates’ Post
Second response: 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
Normal.xlsx.
*************************************************************************************
I will review the Crocs, Inc daily stock change for June 1 – July 15, 2016.
With 95% probability, I would expect the daily change in the stock price to be between -0.40 and 0.59 points.
Find X Values Given a Percentage
Percentage
95.00%
Z Value
-1.96
Lower X Value
-0.40
Upper X Value
0.59
Unit 3 Discussion Example – First Response to Classmates’ Post
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:
1. A decrease of 0.5 point or more (X ≤ -0.5)?
2. An increase of more than 0.5 point (X > 0.5)?
3. A decrease of more 1 point or more (X ≤ -1)?
4. An increase of more than 1 point (X > 1)?
In your own words, explain if these are high or low likelihoods for change.
******************************************************************************
*******
I will review the Crocs, Inc daily stock change. Using the mean = 0.094 and standard deviation
of 0.14378865 and Normal.xlsx:
1) P (X ≤ -0.5) = 0.0098 = 0.98%
2) P (X > 0.5) = 0.0539 = 5.39%
3) P (X ≤ -1) = 0.00 = 0%
4) P (X > 1) = 0.0002 = 0.02%
Common Data
Common Data
Mean
0.0922581 Mean
0.0922581
0.2535838
Standard Deviation
0.2535838 Standard Deviation
Probability for X <=
Probability for X <=
-1
X Value
-0.5 X Value
Z Value
-2.335552 Z Value
-4.307287
P(X<=-0.5)
0.0098 P(X<=-1)
0.0000
Probability for X >
X Value
Z Value
P(X>0.5)
0.5 X Value
1.6079181 Z Value
0.0539 P(X>1)
Probability for X >
1
3.5796531
0.0002
Comparing
thefor
decrease
of 0.5 points or more, it is more likely to increase (5.39%)
Probability
X<-0.5 ororX increase
>0.5
than
to decrease
P(X<-0.5
or X >0.5)(0.98%). 0.0637
Comparing the decrease or increase of 1 point or more, it is more likely to increase however; it
is a very low likelihood that the stock would change 1 point (only 0.02%).
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades