Name is required.

Email address is required.

Invalid email address

Answer is required.

Exceeding max length of 5KB

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

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

XLSTAT AgentHello,

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

Up

Down

XLSTAT AgentHello,

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