Excel help

Reply #8

Raven62 — Fri, 22 Sep 2017 22:16:23 GMT

Actual Values:

347 829

467 52

Expected Values:

564.758 611.242

249.243 269.757

Chi-Squared Values:

83.9623 77.577

190.25 175.781

Chi-Square = 527.57

Degrees of Freedom = 1

p = 0

https://www.mathsisfun.com/data/chi-square-calculator.html

Reply #7

Raven62 — Fri, 22 Sep 2017 22:13:07 GMT

Actual Values:

209 280

225 248

Expected Values:

220.609 268.391

213.391 259.609

Chi-Squared Values:

0.61091 0.502149

0.631575 0.519135

Chi-Square = 2.26377

Degrees of Freedom = 1

p = 0.132431

Reply #6

lakerben — Fri, 22 Sep 2017 21:57:13 GMT

I'm working on other stuff also.

Reply #5

lakerben — Wed, 30 Aug 2017 15:15:42 GMT

Reply #4

CountingMan — Tue, 29 Aug 2017 23:34:38 GMT

If I remember correctly, you can also calculate exponentials as follows in excel:

=sum(518^2) which is 518 X 518; The ^ means exponential

Reply #3

lakerben — Sat, 12 Aug 2017 02:17:56 GMT

Thanks jade I know you are busy.

I'm working on some new things and watching football.

Reply #2

JADELottery — Fri, 11 Aug 2017 17:53:57 GMT

Looks like you started another topic with the same name.

Haven't used a function like that in quite that way.

Excel has a Χ functions built in: =CHIDIST(), =CHIINV() and =CHITEST

Reply #1

lakerben — Fri, 11 Aug 2017 16:16:32 GMT

No replies

Excel help

lakerben — Mon, 07 Aug 2017 18:49:15 GMT

I tried a chi-square calculator on the interenet.

347. 829

467. 052

It gave me something as i remember close to 572.57

Can someone program this