Excel Skills Demonstration
1 Compute the Average of the following numbers 1 567 3874 2081 74 -88
2 Name the following numbers as a range "Test1" 84 88 188 881 38 60 12 -38 659
3 Place the Square Root of each of these numbers below it. Use the SQRT() function
12 89 36 89 10 38 72 690 200,9
4 Insert a line Graph in the indicated location
X Axis (horizontal) Jan Feb Mar Apr Jun Jul Aug Sept Oct Nov Dec
Y Axis (Vertical) 600 650 675 790 821 888 901 1028 1150 1200 1333
5 Create and display the Data Analysis Descriptive Statistics for the following numbers:
What is the difference in the Standard Deviation of the two columns?
Col 1 Col 2
78 750
79 788
82 901
86 1600
88 1700
89 1800
90 1900
94 2560
98 2800
103 2900
111 3000
128 3050
139 3051
160 3052
190 3053
6 In the Answer cell, calculate the value "True" if column 1 has a higher standard deviation, and "False" if column 2 has higher standard deviation. Use the IF function.