Microsoft Office Tutorials and References
In Depth Information
Answers
ANSWERS
1. You may want
to select
the entire range A1:B1001 by pressing the
CRTL
* keys, and apply Create from Selection with Excel 2010 and
Excel 2007 under the Formula ribbon or
Insert
þ
Shift
þ
.
Name
.
Create with Excel 2003 or Mac Excel 2011.
2.
Column 1
Mean
303.694
Standard Error
7.598075751
Median
240
Mode
112
Standard Deviation
240.2722521
Sample Variance
57730.75512
Kurtosis
2.973972391
Skewness
1.469255633
Range
1545
Minimum
9
Maximum
1554
Sum
303694
Count
1000
Largest(1)
1554
Smallest(1)
9
Con
dence Level (95.0%)
14.91001873
3.
 
Search JabSto ::




Custom Search