Statistics How To

Chi Square P Value Excel: Easy Steps, Video

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.
chi square p value Excel

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.

Comments are now closed for this post. Need help or want to post a correction? Please post a comment on our Facebook page and I'll do my best to help!
Chi Square P Value Excel: Easy Steps, Video was last modified: October 15th, 2017 by Stephanie Glen

11 thoughts on “Chi Square P Value Excel: Easy Steps, Video

  1. bashir a yusuf

    For more than 5mouths I have been searching where or who will teach me how to use excell to solve my research hypothesis till this night by coming in contact with your stuffs. Thanks a lot really appreciated your work. Good night and next time.

  2. Gary Adams

    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!

  3. Andale Post author

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

  4. Abdi

    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.

  5. Shadia attia

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

  6. Andale Post author

    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).

  7. Henry

    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

  8. Andale Post author

    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.