Your data analysis solution
Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

How to calc goodness of fit in XLSTAT when "Expected Data" is in decimal format

By Sarah Amuka | Dec 12, 2016 08:48PM CET

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 sarahamuka@gmail.com and phone number is 678-353-1548.

Thanks,

Sarah

Up

0

Down

By Jean Paul | Dec 13, 2016 03:46PM CET | XLSTAT Agent

Hello,

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!

Jean Paul

Post Your Public Answer

Contact Us

1c26995d494fb3061dd0ae8571ffc0a4@xlstat.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/portal/articles/autocomplete
9283