Using Excel
Use Microsoft Excel to process your data. Yes google sheets is becoming increasingly sophisticated but is not as powerful in the presentation of data. The latest version of Office also now seems to be much more intuitive. On this page you will find a collection of YouTube tutorials which demonstrate how to produce a variety of graphs.
For the Independent Investigation, you need to demonstrate their ability to choose the correct data manipulation tools and to display data graphically that shows statistical analysis.
For the Independent Investigation, you need to demonstrate their ability to choose the correct data manipulation tools and to display data graphically that shows statistical analysis.
The Ultimate MS Excel crash Course for Beginners
Adding Error Bars to a Bar Chart
Error bars should show the standard deviation of each category of data so you need to add an error bar to each category and not just by clicking add error bars. Standard deviation shows you how much variation there is in the data. The shorter the error bar, the more accurate the data. The less overlap between the error bars on each bar, the more reliably you are able to say there is a difference between the categories.
Please remember excel in different versions and for Mac or PC can function slightly differently! This gives you a general guide.