Can someone please help me solve this with excel, thank you! -12.76111659 12.341
ID: 2929315 • Letter: C
Question
Can someone please help me solve this with excel, thank you!
-12.76111659 12.34116753 0.182075603 -10.91864903 17.64487993 0.133440919 -13.40347971 24.47454361 0.05068397 -10.19303512 22.01020297 0.217708936 -11.14261548 19.65622726 0.204923232 -10.41940818 13.49019598 0.033679871 -12.76622881 17.87845313 0.186689808 -7.622096994 28.2218596 0.195953226 -10.7319121 28.06807445 0.152912278 -6.013321284 25.9480696 0.191029912 -9.088291217 19.86071512 0.024288523 -9.057362149 17.03345393 0.265362288 -9.368127315 14.99188432 0.349845321 -10.63975591 20.56886956 0.219959558 -11.26188447 18.89200302 0.029612907 -10.55600826 15.27678751 0.121233361 -15.07000532 23.70860693 0.309468246 -12.91321606 14.5564103 0.109169848 -8.474242929 15.62737307 0.275158098 -9.395400461 19.72858807 0.175302989 -11.18977211 19.2386178 0.046080476 -7.2827071 19.26555877 0.2153048 -9.713202944 31.12595425 0.230240155 -9.64504816 13.53788608 0.048752158 -10.77831055 17.21491348 0.181130233 -10.20887803 23.3696628 0.390804169 -10.8288255 21.02347543 0.071765282 -10.49494135 20.25265204 0.331206749 -12.70045823 10.66120814 0.107321873 -9.07892855 17.69825365 0.302989725 -7.543313227 22.9291694 0.096693077 -9.547160303 20.58389522 0.308296496 -8.318972516 25.03616972 0.37497418 -8.419492205 19.6037966 0.0489681 -7.674252467 13.46088108 0.245007345 -10.26090093 14.31816397 0.085735131 -13.45705298 22.29471356 0.073926624 -9.026570495 13.98484255 0.588719884 -11.40611706 12.75862709 0.258219473 -10.07330807 27.02612531 0.236855249 -9.869468722 25.42221723 0.269701786 -13.56848067 31.25428788 0.269877457 -10.58765676 13.40112142 0.12957821 -12.57218563 11.19467794 0.250133158 -11.11495516 27.01773473 0.249573752 -9.954039301 24.85641923 0.06430969 -8.609894606 16.16748879 0.26938216 -10.46481112 17.95232833 0.075475701 -5.548023497 20.24753837 0.07412197 -8.285763185 13.19995618 0.053714514 -9.479054408 12.215861 0.062169102 -13.23001983 23.39242921 0.246204843 -5.901458136 10.63921295 0.079175961 -8.816878533 14.7239349 0.155844337 -11.05737183 12.32084681 0.396433948 -11.10629203 33.481625 0.295025363 -7.266815859 19.38514008 0.028900411 -8.446020394 17.63094295 0.104578616 -10.03026601 22.10644524 0.138663383 -10.57704974 23.59980066 0.281953227 -10.73843682 14.36967764 0.133884882 -11.19220145 19.86411374 0.131359759 -11.62170356 26.13255675 0.350535405 -10.01793657 15.82300953 0.280674119 -8.298818936 9.708755997 0.202530864 -11.81901525 31.7640736 0.521041779 -9.401032938 17.17044549 0.083236859 -10.52250345 14.15891887 0.04009414 -9.338058886 22.49595182 0.082138285 -12.25212813 21.98269483 0.142036231 -10.17388263 17.99059451 0.071601516 -8.76218177 16.78703224 0.287132858 -11.6598737 26.64705717 0.327586364 -9.155529408 19.82825575 0.150686902 -9.968969383 22.99296657 0.060220964 -7.655152652 30.2831911 0.405783973 -10.18376247 11.79626312 0.223298806 -11.35637753 21.85799534 0.307888773 -10.39731899 13.65249797 0.224341233 -13.31938111 13.80877813 0.205192075 -8.926102838 18.91157346 0.14378036 -7.005837759 16.31736995 0.055558825 -9.081980412 18.47846581 0.219027799 -10.71204645 19.21294682 0.10446653 -7.360602894 29.33163038 0.087074561 -7.950837721 11.70100793 0.364682181 -10.42704233 18.22496485 0.200988637 -10.71931815 16.42623663 0.07443473 -8.259911844 14.42153699 0.024911801 -10.05812774 27.10557874 0.166555336 -10.36418342 19.81868756 0.167019358 -9.98585285 11.95825532 0.131059733 -10.46761441 27.73239411 0.144426388 -11.0134982 22.07800948 0.061774408 -9.169772816 24.31550308 0.241132543 -10.16764387 25.46475799 0.274299958 -10.66716818 16.23506322 0.111168347 -8.224365023 10.6508611 0.020534352 -6.233670683 26.3234358 0.046026278 -10.41920667 22.9592077 0.17138467 Each column represents a sample from a different population. For each column, identify a probability distribution that is consistent with that sample. You must include the values for all necessary parameters for the distribution you propose (eg. , , , , a, b, v, etc. as appropriate).Explanation / Answer
NAME THE THREE COLUMNS AS A,B,C
IN EXCEL
data-->data analysis-->descriptive statistics
selec t all the data range.
select sumary statistics
You will get the below output
For Column A
mean=-10.01
stdd ev=1.79
skewness=0.000
median=-10.12
mean=median for column
Column A is normal distribution with mean=-10.01 and variance=3.21
Now,Column B
mean=19.52
median=19.25
mean>median
postively skewed distribution with mean=19.52 and stddeviation=5.60
skewness=0.369
Finally,For column C
mean=0.18
median=0.16
mean>median
positively skewed
skewness=0.809
A Mean -10.00979925 Standard Error 0.179092231 Median -10.17882255 Mode #N/A Standard Deviation 1.790922311 Sample Variance 3.207402725 Kurtosis 0.330442595 Skewness 0.005304604 Range 9.521981823 Minimum -15.07000532 Maximum -5.548023497 Sum -1000.979925 Count 100