# data[].attributes.body
https://padlet.com/chrisyang/EN2W6

# data[].attributes.body
This example teaches you how to add error bars to a chart in Excel.

# data[].attributes.body
Example: The average temperatures of 5 Welsh towns in four seasons in 2015 are given below:
(1) Transfer the data into Excel.
(2) Plot the temperature of four seasons for each town in bar graph.
(3) Use Line Chart to plot (2) again.
(4) Calculate the year average temperature for each town, and round to one decimal place. Use bar graph to plot the year average temperatures.
(5) Calculate the town average temperature of each season rounding to one decimal place.
(6) Use the town average temperature of each season to represent Welsh climate in 2015, plot the Welsh climate in 2015 using Line Chart, using error bars to reflect temperature coverage in the four seasons.

# data[].attributes.headline
4. Example Answer 2: Temperature of 4 Seasons (bar)

# data[].attributes.subject
4. Example Answer 2: Temperature of 4 Seasons (bar)

# data[].attributes.headline
5. Example Answer 3: Temperature of 4 Seasons (line)

# data[].attributes.subject
5. Example Answer 3: Temperature of 4 Seasons (line)

# data[].attributes.headline
6. Example Answer 4: Year Average Temperature

# data[].attributes.subject
6. Example Answer 4: Year Average Temperature

# data[].attributes.body
You can use the Analysis Toolpak add-in to generate descriptive statistics. For example, you may have the scores of 14 participants for a test.

To load Analysis Toolpak,

1. Click the File tab, click Options, and then click the Add-Ins category.

2. In the Manage box, select Excel Add-ins and then click Go.

3. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK.

# data[].attributes.headline
10. Descriptive Statistics Result for Group G

# data[].attributes.subject
10. Descriptive Statistics Result for Group G

# data[].attributes.body
Download the below spreadsheet from this Padlet, which is the peer marking of the EN0017 Group Discussion on Rules of Algebra in Week 1.
(1) Calculate the average and standard deviation for each group.
(2) Use Excel function to find maximum and minimum marks for each group, construct positive and negative errors for each group.
(3) Use bar graph to plot the average mark for each group with error bars.
(4) Add your interpretations to the data and the plotting.
(5) Upload your result in one Excel file to the Group column on Padlet.

Your Demonstrator will:
(1)   Help entering raw data into Excel with proper labelling

(2)   Help calculate average value and display results in new cells

(3)   Help other basic operations in Excel

(4)   Remind each student to save both graphs in ONE Excel file and post the file onto Padlet under the group column (https://padlet.com/chrisyang/2017Group).

(5)   Complete the self- and demonstrator-evaluation form by the end of the lab.

# data[].attributes.attachment_link.title
Week 1 Group Presentation EN0017 Mark List (No graph or calcuation)