Use Excel [Solve any 2 question] Note: If you feel that solving the two questions will make you feel tired and effort -
Posted: Fri May 20, 2022 11:48 am
Use Excel [Solve any 2 question]
Note: If you feel that solving the two questions will make you feel tired and effort - then solve a question and just take it. Not a problem
I don't want a previous solution in answers because the question data is different
1. For the following random numbers 0.488 0.226 0.221 0.043 0.055 0.743 0.081 0.685 0.364 0.012 0.372 0.543 0.483 0.050 0.628 0.966 0.750 0.697 0.764 0.040 0.404 0.549 0.203 0.990 0.155 0.079 0.789 0.462 0.795 0.190 Perform chi-square test in Excel, test the following hypothesis taking a =0.05: Ho: R - U[0,1] Ho: R-/U[0,1] 2. Perform Kolmogorov - Smirnov test in Excel to test the hypothesis for the following random number: 0.136 0.513 0.844 0.681 0.154 0.239 0.888 0.090 0.631 0.245 0.394 0.531 0.715 0.276 0.880 Determine whether the Hypothesis of uniformity can be rejected, given a=0.05 and critical value of Da=0.338.
- Use Excel Solve Any 2 Question Note If You Feel That Solving The Two Questions Will Make You Feel Tired And Effort 1 (28.85 KiB) Viewed 31 times
I don't want a previous solution in answers because the question data is different
1. For the following random numbers 0.488 0.226 0.221 0.043 0.055 0.743 0.081 0.685 0.364 0.012 0.372 0.543 0.483 0.050 0.628 0.966 0.750 0.697 0.764 0.040 0.404 0.549 0.203 0.990 0.155 0.079 0.789 0.462 0.795 0.190 Perform chi-square test in Excel, test the following hypothesis taking a =0.05: Ho: R - U[0,1] Ho: R-/U[0,1] 2. Perform Kolmogorov - Smirnov test in Excel to test the hypothesis for the following random number: 0.136 0.513 0.844 0.681 0.154 0.239 0.888 0.090 0.631 0.245 0.394 0.531 0.715 0.276 0.880 Determine whether the Hypothesis of uniformity can be rejected, given a=0.05 and critical value of Da=0.338.