Question

Generate 100 random numbers using the RAND function and create a frequency distribution and a histogram with bins of width 0.1. Apply the chi-square goodness of fit test (see Chapter 5) to test the hypothesis that the data are uniformly distributed.

This question is from Business Analytics 3rd Edition by James R Evans and from Chapter 12 and question 1

The question is from following book and from Chapter 12 question 1

1. Textbook: James Evans, Business Analytics, 3nd edition, 2019, Pearson Education, Pearson. ISBN: 13:978-0-13-523167-8

Answer 1

Random no.
0.605731376
0.207037568
0.907773064
0.185552538
0.030121769
0.50880459
0.396496475
0.179845576
0.73812067
0.095736564
0.153660695
0.403271584
0.436475723
0.333994568
0.120365001
0.413922544
0.80712302
0.610248115
0.340128788
0.970366527
0.406720176
0.256691183
0.309121982
0.606036561
0.06900235
0.970030824
0.843958861
0.650929289
0.964751122
0.255958739
0.873287149
0.48158208
0.976500748
0.930295724
0.05957213
0.281075472
0.54380932
0.207892087
0.657124546
0.089846492
0.635670034
0.41093173
0.512527848
0.428937651
0.005890072
0.827204199
0.614368114
0.276589251
0.388164922
0.750450148
0.097506638
0.679830317
0.786523026
0.233344523
0.109073153
0.781762139
0.518082217
0.584795679
0.441816462
0.546433912
0.163884396
0.142246773
0.341349528
0.962065493
0.084047975
0.351268044
0.393566698
0.003967406
0.653798029
0.682454909
0.898129215
0.138737144
0.876339
0.417584765
0.634907071
0.650410474
0.528916288
0.836634419
0.428907132
0.570207831
0.498641926
0.835596789
0.420484024
0.49140904
0.463454085
0.508041627
0.446699423
0.049592578
0.575518052
0.720236824
0.440565203
0.350749229
0.302560503
0.211859493
0.253639332
0.127475814
0.08395642
0.253456221
0.809350871
0.905301065

Class boundary	Observed Frequency                      O	Expected frequency E=0.1*100	(O-E)^2/E
0-0.1	11	10	0.1
0.1-0.2	9	10	0.1
0.2-0.3	10	10	0
0.3-0.4	10	10	0
0.4-0.5	16	10	3.6
0.5-0.6	10	10	0
0.6-0.7	12	10	0.4
0.7-0.8	5	10	2.5
0.8-0.9	9	10	0.1
0.9-1.0	8	10	0.4
Total	100		7.2