Need a hand? All the help you want just a few clicks away
Hi,I'm in the process of calculating a goodness of fit test and my expected frequency data is in decimal format (as it varies)... The dialog box in XLSTAT is prompting me to enter the data as an "expected proportion" instead of an expected frequency. XLSTAT error-ed out my goodness of fit test and displayed the following message:"The values in the selection should be in the [0, 1] interval"I need urgent assistance here, as I do not know how to enter the data my "expected data/ proportion" in the format that XLSTAT is asking for.My email address is email@example.com and phone number is 678-353-1548.Thanks,Sarah
You should transform your expected frequency data into proportions prior to using the feature with the expected proportion option.
This can be done simply by dividing each expected frequency by the sum of expected frequencies:
expected proportion of x1 = (expected frequency of x1) / (sum of the expected frequencies).
Hope this helps!
XLSTAT first steps and statistical learning resources
The place where you will master all of XLSTAT features
Any feature or option you’d like us to develop?
For those of you who prefer video help