Alterna · учебный материал

Data analysis workshop

Issues, summaries and a practical scenario in the electronic table.

Что в этом материале

Содержание и основные понятия

01
Issues and actions
The test tests the language of the analysis; the workshop below requires that the question be formulated and the action taken in the table.
Loading option...
02
Practical mini-laboratory
The story.
There is a date, area, type of task, minutes and status in the table "Marchruths of Volunteers".
Answer me.
Find the sum of minutes for the tasks performed and the average time for the one type selected.
Show me.
Build a diagram of the distribution of the three types of tasks, add a title and signatures.
Check it out.
Check the two records manually and explain the lines that came into play.
Open Alterna Office: tables
FILE
Analysis kit
The book has a pass, release, and 36 observations. Check the quality, group the areas, build a point or line diagram, and form a output restriction.
download XLSX
03
From calculation to analytical note
Evidence
Attach the reference question, formula or settings of the composite table, the range and manual verification of the two lines. The number without the means of obtaining it cannot be independently verified.
Interpretation
Formulate one conclusion in the language of the task and then name the restriction: pass, short period, small sample or unknown factor.
Table.
The headings are clear, the units are specified, the reference values are not closed.
Truck.
The formulas operate after the input value has been changed and do not include the heading in the range.
Figure.
The type corresponds to the question, the axles and the categories are signed, the scale does not distort the comparison.
Conclusion.
Separates the observed fact from the possible explanation and does not state the causality of one link.

Structural map of textbooks