answersLogoWhite

0


Best Answer

For each category, you should have an observed value and an expected value.

Calculate (O-E)2 / E for each cell.

Add the values across the categories.

That is your chi-square test statistic.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you calculate a chi square using excel 2007?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the use of MS excel 2007?

you may calculate


How Excel 2007 Converted to Excel 2003?

You can open a 2007 Excel spreadsheet with Excel 2003 if you save the file in Excel 2007 using "Save As" and select the 2003 compatibility mode.


How do you interrogate data in Excel 2007?

You can interrogate data in Excel 2007 by using the filter and sort options in Excel. This re-organizes the data in a way that makes it easy to analyze and evaluate the data.


How many columns in 2003 and 2007?

In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.


What is the name of the spreadsheet package you are using?

It is called Microsoft office excel 2007


What is the file extension for an Microsoft Excel file using spread sheet?

the normal extension for Excel is xls if pre 2007 otherwise xlsx


Can you use Excel 2010 as Excel 2007?

The differences between them are not extensive so you can work in Excel 2010 easily if you are familiar with Excel 2007. You can save your files so that Excel 2007 will recognise them.


What is the extension for Excel?

.xls for the lower version If you are using the Microsoft Office 2007, it's .xlsx


What is a file extension for Microsoft Excel?

For a standard Excel document, prior to Excel 2007, it is xls and xlsx is used in 2007. There are other kinds of files created by Excel, like templates which can be xlt or macros which can be xlm and xla for Add-ins, and there are other extenions. For 2007, you add x to the end of them.


Can the condition of a cell only be true using excel 2007?

No. The condition of a cell can be either true or false.


Do you need the basics in Excel 2003 to learn Excel 2007?

Not necessarily. Having a good understanding of Excel 2003 will help in using Excel 2007. The main difference is the look, but the fundamentals are the same as it is still a spreadsheet, so it has to be able to do things that spreadsheets do, like with the formulas and functions. As those things are much the same, then you could use Excel 2007 without having ever used Excel 2003. Users of Excel 2003 would find Excel 2007 a little strange at first because of how different it looks, although they would quickly get used to it. Someone who has never used Excel 2003 won't have that problem.


When was sumifs introduced to Excel 2008 or 2007?

The SUMIFS function was introduced in Excel 2007.