Excel phyc

Extra Credit – MSExcel – Part 2

· You are asked to prepare a MS-excel file, to be emailed to me ([email protected]) in an attachment by Wednesday 04/15.

· The file should be called PS103_Part2_xxx where xxx stands for your last name. Also, because we have a few people with the same last name, please write your full first and last name in the email you send me.

· The file should have two columns, where up to 20 values can be entered. Those two columns should be labeled as 'Independent' and Dependent'.

· A third column, labeled as 'Errors' should also include up to 20 values entered by the user.

· The program should graph on an x-y graph the values from the Independent (on the x-axis) and the Dependent (on the y-axis) columns.

· The values from the Error column should appear as vertical error bars on each point.

· Graph Style.

(i) The axes should report the labels: 'Dependent' and 'Independent'

(ii) No grid, no title and no Legend should appear on the graph.

(iii) The data should be plotted as full marks, not connected by lines.

· A linear Trendline should be added to the graph. The equation for the trendline should be shown on the graph.

· The program should look like in the figure below.

Independent	Dependent	Error
0	0	0
1	1	0.5
2	2	0.5
3	3.1	0.5
4	4.2	0.5
5	5.3	0.5
6	5.9	0.5
7	6.8	1
8	8	1
9	9	1
10	10.2	1
11	10.8	1
12	12	1
13	13.2	2
14	14.2	2
15	14.9	2
16	15.7	3
17	17	3
18	18	4
19	19.2	4