ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Analysis using Microsoft Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/77141-data-analysis-using-microsoft-excel-2003-a.html)

Paa Nii

Data Analysis using Microsoft Excel 2003
 
I wish to find out how to handle multiple response questions (dichotomy or
category) using the above software.

--
Wish U the best of everything and Good Luck
Hope to hear from you soonest

Mike Middleton

Data Analysis using Microsoft Excel 2003
 
Paa Nii -

I wish to find out how to handle multiple response questions (dichotomy or
category) using the above software. <


Arrange data in a list, and use a Pivot Table.

Or, use the COUNTIF worksheet function.

Or, for numerical data, use the array-entered FREQUENCY worksheet function.

Or, for numerical data, use the Histogram tool of the Analysis ToolPak.

Or, post a more specific question.

- Mike
www.mikemiddleton.com




All times are GMT +1. The time now is 09:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com