Statistics

 

Summary - What should we know?

1. The meaning and method of Average, Mode, Median
2. The meaning and method of counting the Weighted Average
3. The meaning and formula for Correlation
4. The ways of recording and analysing the raw data
5. Choosing a suitable graphical representation of the survey results

Analysing research data

Task 1 

1. Download an example spreadsheet from capsa - go to folder PCSkills, file PcSkillsZakladyStatistiky.xls

2. Use the sum, average, mode and median formulas to get the first results. THINK about the type of data you are using and consider you want to learn - use the predefined questions and hypotheses.

3. In some surveys it is very important to mutually relate various findings -  to prove or disprove a correlation between two facts/answers. Identify the possibilities and explore the correlation within the data.

4. Prepare a graphical presentation showing the results. Decide which types of graphs are the most suitable.


___________________________________________________

Task 2 - Supporting activities

1. Downolad the excel file KorelacePriklad.xls form capsa. Use the formula explained in this link: Korelace v excelu - příklad to find out the correlations among the given sets of data.

2. Downolad the excel file Verejny... .xls form capsa and explore the formula used for counting individual teaching loads: =DSUMA(I7:J116;"Úvazek";L1:L2). How does it work, what does it summarise?

3. Study the articles linked below. You should understand, and be able to explain and apply at least the descriptive statistics. Ask the tutor for help if necessary.


Tips:
Pie graphs are used only when describing the split of a limited sum of recipients or other data.
Example: Identifying the use of potatoes in the kitchen:  50% get boiled, 25% are mashed, the rest is used to make soups.

Focus on the examples - try to understand the information in the data before dealing with the methods.
Consider real-life examples,  or use the real data to experiment with descriptive statistics.

___________________________________________________

Help:
Vážený průměr
Weighted Average in Excel
Excel Help - Weighted Average
Excel Help - Descriptive Statistics


Descriptive statistics - Distribution, Central Tendency (Average, Mode, Median), Dispersion, Standard Deviation
Correlation example

Úvod do popisné statistky
Popisná statistika
Co je korelace?
Čtyřpolní a kontingenční tabulka
Měření závislosti, korelace a regrese