In the Excel file, sheet labeled #3 contains 250 random variates. Complete the f
ID: 3228675 • Letter: I
Question
In the Excel file, sheet labeled #3 contains 250 random variates. Complete the following.
Construct a PP Plot of the data.
Construct a 68%-95%-99.7% interval of the data.
Construct a histogram of the data.
Do the data appear to be approximately normally distributed?
Data -2.9848 1.232531 0.637772 0.108864 1.277616 0.252784 -0.13622 0.863965 -0.4467 0.148931 -0.95191 1.079363 -0.28758 -2.07863 2.075291 0.111472 1.336803 1.448689 -0.82678 1.191854 -0.41869 1.389554 0.195454 -0.77317 -0.11277 0.568386 -0.90423 -1.44146 1.317956 -0.73808 -0.64713 -0.49878 1.152475 -1.08963 0.24877 0.16994 1.017641 -0.76854 0.411212 0.195764 1.037207 -0.69227 -1.63432 -0.50598 -1.19877 0.402759 0.130063 0.054071 -0.01612 1.269693 -0.44728 0.804798 0.302486 0.220626 -0.05222 -0.17646 -1.0062 -0.31513 0.277192 -0.10019 -1.42154 0.685653 0.082584 -1.40816 -0.36486 0.205025 0.872985 0.511537 -2.56885 0.322266 -0.68733 -1.64168 0.940394 1.284396 -2.01163 -0.1233 0.960558 -1.52604 0.273786 0.431718 0.493274 0.451481 -1.22564 0.002564 -1.08755 0.240519 -0.7771 0.169631 0.698843 -0.54979 -0.23217 -0.44568 -2.18438 -0.41603 0.113775 1.216178 1.804667 1.347167 0.146772 0.300491 0.145153 0.065301 -0.43895 -1.34251 1.332323 0.917344 -0.08525 -0.25551 -0.05451 0.443219 -1.28467 -0.28702 0.087406 -0.2638 -0.306 0.783344 0.989817 -0.37836 0.886142 0.935531 1.466652 0.529534 -1.277 -0.36095 1.423968 0.301289 0.342982 1.875712 -0.66599 0.589045 -0.48414 -0.91047 -0.78353 -1.85011 0.923762 -0.77989 0.777444 -0.84184 -1.68851 -0.22621 0.054834 -0.45956 0.685266 0.641517 -1.2965 -1.22988 -0.68907 0.159581 -0.83012 0.451649 -1.51649 -1.59409 -0.32928 0.702746 -0.02322 -0.27385 0.099815 0.354249 1.405214 -0.79617 0.84395 0.035442 0.928218 -0.2914 -0.75861 0.423444 -0.21285 0.282665 -0.98421 -1.09088 0.53842 1.283349 1.801538 -0.63624 -1.37282 -0.13892 -0.0633 0.728882 -1.30419 1.398254 -0.71854 0.789898 0.133756 0.707346 0.886482 0.043609 0.42261 -0.19828 -1.12298 1.024333 -0.50606 -0.99144 -0.74482 0.502081 -1.1694 -0.27876 -0.37189 -0.386 0.198953 -1.24057 0.823303 0.364745 0.442966 -0.13992 -0.41237 -1.06783 -0.29841 1.139057 0.832233 -0.73117 0.260587 -1.34138 -0.0526 -0.48036 0.363847 -1.24572 -2.05186 1.523125 2.218696 0.246097 -0.01826 -1.26752 -0.06873 -2.16866 -0.92728 0.178922 0.03674 0.025066 1.369714 -0.20412 0.168394 -0.86263 -0.09521 0.332244 -0.1226 0.729877 0.550897 -2.00064 0.584604 -1.58268 -0.74079 -0.62069 0.579632 -0.08686 -2.66446 -0.53087 -0.06139 1.326579 0.789168 1.199201Explanation / Answer
rm(list=ls(all=TRUE))
x=read.csv("Book1.csv") ###### Excel file in csv format "Book1"
library(StatDA)
ppplot.das(x[,1])
x=read.csv("Book1.csv")
summary(x)
n=length(x)
m=mean(x[,1])
st=sd(x[,1])
l=c(0.68,0.95,0.997)
cil=c();error=c();ciu=c()
for (i in 1:3){
error[i]=qnorm(l[i]/2)*st/sqrt(n)
cil[i]=m-error[i]
ciu[i]=m+error[i]
}
d=data.frame(cil,ciu)
cil ciu
1 0.325516014 -0.44579106
2 -0.001506609 -0.11876844
3 -0.056621965 -0.06365308
>
hist(x[,1])
Yes, the data appear to be approximately normally distributed.