The data table is too large to
The data table is too large to be put in the question here iswhere I collected the data:
Visit the NASDAQ historical pricesweblink(https://finance.yahoo.com/quote/GOOG/history/). First, setthe date range to be for
1.16.18- 2.15.19. [Do this by clicking on the blue dates after“Time Period”. Next, click the “Apply” button. Next, click the linkon the right side of the page that says “Download Data” to save thefile to your computer].
Normal distribution Average=1110.68525 Standard Deviation=65.5518337 Mode= 1095.06006
- If a person bought 1 share of Google stock within the lastyear, what is the probability that the stock on that day closedwithin $50 of the mean for that year? (between 50 below and 50above the mean)c) If a person bought 1 share of Google stock withinthe last year, what is the probability that the stock on that dayclosed at less than the mean for that year?If a person bought 1share of Google stock within the last year, what is the probabilitythat the stock on that day closed at more than $950?
- If a person bought 1 share of Google stock within the lastyear, what is the probability that the stock on that day closed atless than $800 per share. Would this be considered unusal?
- At what prices would Google have to close in order for it to beconsidered statistically unusual?
- What are Quartile 1, Quartile 2, and Quartile 3 in this dataset? Use Excel to find these values. This is the only question thatyou must answer without using anything about the normaldistribution.
- Is the normality assumption that was made at the beginningvalid? Why or why not?
Answer:
Sol:
Downloaded data for the time period range1.16.18- 2.15.19
using descriptive statistics in excel for the column close
| Mean | 1110.685251 |
| StandardError | 3.9601311 |
| Median | 1099.264954 |
| Mode | 1095.060059 |
| StandardDeviation | 65.5518337 |
| SampleVariance | 4297.042902 |
| Kurtosis | -0.744581395 |
| Skewness | 0.351349751 |
| Range | 292.109985 |
| Minimum | 976.219971 |
| Maximum | 1268.329956 |
| Sum | 304327.7587 |
| Count | 274 |
mean=1110.685251
sample sd=65.5518337
n=274
If a person bought 1 share of Google stock within the last year,what is the probability that the stock on that day closed within$50 of the mean for that year? (between 50 below and 50 above themean
mean-50=1060.685
mean+50=1160.685
P(1060.685<xbar<1160.685)
=P(1060.685-1110.685251/65.5518337<1160.685-1110.685251/65.5518337)
=P(-0.762759<Z<0.7627514)
simply by entering the below one line of command in R studio weget the area between limits
pnormGC(bound=c(1060.685,1160.685),region=”between”,mean=1110.685251,sd=65.5518337,graph=TRUE)
=0.5543906
Solutionb:
If a person bought 1 share of Google stock within the last year,what is the probability that the stock on that day closed at morethan $950?
P(X>950)
pnormGC(bound=950,region=”above”,mean=1110.685251,sd=65.5518337,graph=TRUE)
=0.9928823
- If a person bought 1 share of Google stock within the lastyear, what is the probability that the stock on that day closed atless than $800 per share. Would this be considered unusal?
P(X<800)
pnormGC(bound=800,region=”below”,mean=1110.685251,sd=65.5518337,graph=TRUE)
1.071043e-06
ANSWER:0.0000
since probability less than 0.05
it is considered unusual.
What are Quartile 1, Quartile 2, and Quartile 3 in this dataset? Use Excel to find these values.
| QUARTILE(E2:E275;1)QUARTILE(E2:E275;2)QUARTILE(E2:E275;3) | |||||||
|
that is
|
- Is the normality assumption that was made at the beginningvalid? Why or why not?
here sample szie=n=274
large sample
n>30
follows normal distribution according to central limittheorem
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"
