This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
en:lesson5 [2019/11/07 16:43] golikov [Magnetometer calibration. Raw data acquisition] |
en:lesson5 [2019/11/13 11:45] golikov |
||
---|---|---|---|
Line 220: | Line 220: | ||
Press **Insert** and choose Pie chart. | Press **Insert** and choose Pie chart. | ||
- | {{::05image011.png?nolink&200|}} | + | {{:en:image_excel.png?500|}} |
- | {{::05image012.png?nolink&200|}} | + | {{:en:excel_2_.png?200|}} |
Right-click to color circle and choose white for filling and black for outline. | Right-click to color circle and choose white for filling and black for outline. | ||
- | {{::05image014.png?nolink&200|}} | + | {{:en:excel_3_.png?300|}} |
- | {{::05image015.png?nolink&200|}} | + | {{:en:excel_4_.png?300|}} |
Now it is seen (even with the naked eye only) that magnetometer is not perfect: the sectors of a circle are not preciously 30. Some are narrow, others are wide. | Now it is seen (even with the naked eye only) that magnetometer is not perfect: the sectors of a circle are not preciously 30. Some are narrow, others are wide. | ||
Line 237: | Line 237: | ||
Press **Insert** and choose Radar chart. | Press **Insert** and choose Radar chart. | ||
- | {{::05image017.png?nolink&200|}} | + | {{:en:excel_5_.png?200|}} |
{{::05image018.png?nolink&200|}} | {{::05image018.png?nolink&200|}} | ||
Line 248: | Line 248: | ||
Choose any cell; enter the equal mark, the function name, the left bracket. | Choose any cell; enter the equal mark, the function name, the left bracket. | ||
- | {{::05image019.png?nolink&200|}} | + | {{:en:excel_6_.png?200|}} |
Choose with mouse the range of calculated remainder values upon which we plotted the diagrams, enter the right bracket. The function will be = AVERAGE(C2:C13). | Choose with mouse the range of calculated remainder values upon which we plotted the diagrams, enter the right bracket. The function will be = AVERAGE(C2:C13). | ||
Line 260: | Line 260: | ||
{{::05image020.png?nolink&200|}} | {{::05image020.png?nolink&200|}} | ||
+ | |||
Choose with mouse the range of calculated remainder values upon which we plotted the diagrams, enter the right bracket. | Choose with mouse the range of calculated remainder values upon which we plotted the diagrams, enter the right bracket. | ||
Line 268: | Line 269: | ||
Then calculate the percentage ration of the average and standard deviation. | Then calculate the percentage ration of the average and standard deviation. | ||
+ | |||
{{::05image021.png?nolink&200|}} | {{::05image021.png?nolink&200|}} |