| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Analyze Data
I am trying to anayze the data from a survey that was handed out to 20 people
and was ranked 1 - 5. Number 1 as being the least need for improvement and 5 being the most need for improvement. How do I come up with a chart that will analyze this data? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Analyze Data
Use COUNTIF to count the number of 1s, 2s etc
You need a chart for this? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "tokentrinkit" wrote in message ... I am trying to anayze the data from a survey that was handed out to 20 people and was ranked 1 - 5. Number 1 as being the least need for improvement and 5 being the most need for improvement. How do I come up with a chart that will analyze this data? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Analyze Data
How do I average the range?
"Bernard Liengme" wrote: Use COUNTIF to count the number of 1s, 2s etc You need a chart for this? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "tokentrinkit" wrote in message ... I am trying to anayze the data from a survey that was handed out to 20 people and was ranked 1 - 5. Number 1 as being the least need for improvement and 5 being the most need for improvement. How do I come up with a chart that will analyze this data? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Analyze Data
=AVERAGE(range)
-- Brevity is the soul of wit. "tokentrinkit" wrote: How do I average the range? "Bernard Liengme" wrote: Use COUNTIF to count the number of 1s, 2s etc You need a chart for this? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "tokentrinkit" wrote in message ... I am trying to anayze the data from a survey that was handed out to 20 people and was ranked 1 - 5. Number 1 as being the least need for improvement and 5 being the most need for improvement. How do I come up with a chart that will analyze this data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| How do I statistically analyze data across multipe worksheets? | New Users to Excel | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Linear Mode
