Excel for Statistics > Chi Square P Value Excel

Watch the video on how to calculate a chi square p value Excel. Or, read the step-by-step article below.

P-values are used in hypothesis testing to help you figure out if your results are significant or not. A significant result is one where you reject the null hypothesis. In hypothesis testing, you’re really asking two questions:

- What do the results tell me about a population?
- What is the strength of those results?

A p-value is a number between 0 and 1, but it’s easier to think about them as percentages (i.e. a p-value of 0.05 is 5%). Small p-values (generally under 5%) usually lead you to reject the null hypothesis.

## Calculate the chi square p value Excel: Steps

Step 1: **Calculate your expected value.** The expected value in chi-square is found by dividing your counts (the number of responses or data items) by the number of categories. There are twelve categories (zodiac signs) in the question, so:

29 + 24 + 22 + 19 + 21 + 18 + 19 + 20 + 23 + 18 + 20 + 23 = 256

256 / 12= 21.333

Step 2: **Type your data into columns in Excel. ** For this sample question, type your zodiac signs into column B, the observed values in column C (the observed values are the counts in the question) and your expected value (from Step 1) in column D.

Step 3: **Click a blank cell anywhere on the worksheet** and then click the “Insert Function” button on the toolbar.

Step 4: **Type “Chi” in the Search for a Function box **and then click “Go.”

Step 5: **Select “CHITEST” from the list** and then click “OK.”

Step 6: **Type a range into the “Actual Range” box for your observed values**. For this sample problem, the observed values are in cells C3 to C14, so type “C3:C14.”

Step 7: **Type a range into the “Expected Range” box for your expected values**. For this sample problem, the observed values are in cells D3 to D14, so type “D3:D14.”

Step 8: **Click “OK”** to calculate the p-value in Excel, which for this sample problem is .9265.

*That’s how to find a chi square p value Excel!*

If you prefer an online interactive environment to learn R and statistics, this *free R Tutorial by Datacamp* is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try *this Statistics with R track*.

*Facebook page*and I'll do my best to help!

Hi there,

So, going by this example, the CHITEST function is the same as AVERAGE? Where is the .9265 value displayed? I keep getting errors (502 and 522) even after enabling Iteration, but I’m using LibreOffice Calc. I’ll test this example in Excel tonight. Thanks!

Expected value is a kind of average, but CHITEST is something completely different. Try this in Excel tonight and hopefully it will become clearer :)

I have been struggling how to do statistics in excel for quiet some time and many assignments locked before I could finish because I had to d them manually but now it is easy for me to do in excel with short time. Thank you very much and I really appreciated your help.

Thank u very much,really helpful

I followed the same steps but got a value of 2.3672E-106, which I do not unsersatnd

Hi, Shadia, without sitting at your computer and watching what you’re doing, I have no idea :/. Perhaps check each cell to make sure there isn’t a hidden formula (and check your inputs too).

Can anybody explain why chisq.test gives results depending on the way the data is arranged, eg, single columns or matrix. I can attach the example taken from Excel Help and this gives anomalous results unless I am missing something.

Actual (58 11 10 35 25 23) Expected (45.35 17.56 16.09 47.65 18.44 16.91) in two adjacent columns or as two 3×2 arrays as cited in Excel Help

It should give the same results. Without seeing how you’re entering it though, I don’t know what you might be doing wrong. Check your inputs carefully.

it is useful for my practical exam.thank you

Great!