669 Downloads

MS Excel Advanced - Statistical Functions

MS Excel Advanced - Statistical Functions
Product Rating
4.0
1 Rating
File Type

PDF (Acrobat) Document File

Be sure that you have an application to open this file type before downloading and/or purchasing.

167 KB|0 pages
Share
Product Description
Excel offers whole range statistical functions should have previously used functions MAX MIN AVERAGE We now going look at some other commonly used functions For example • MODE MEDIAN mode median set data • COUNT COUNTBLANK COUNTIF Count cells that fulfill given criteria • LARGE SMALL Find 7th largest or 4th smallest value etc • STDEV Standard deviation set data • RANK value occupying certain rank list • QUARTILE number one quarter way through set etc • PERCENTILE number 90% way through set etc spreadsheet below uses number statistical functions analyze set data present columns B C Task 1 - Data Ignoring blank cells write out data order starting with smallest table like one shown below Rank 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Data Mode Minimum 2nd smallest 25th Percentile Median 65th Percentile 75th Percentile 3rd largest Maximum Note - way Excel calculates its quartiles percentiles fairly complicated It will not be covered here Task 2 - Using Functions Recreate spreadsheet shown above Make sure that all statistical values created using formulae that refer data range B3C13 Statistical Functions 2007 Excel Advanced 10
Total Pages
0 pages
Answer Key
N/A
Teaching Duration
N/A
Report this Resource
Loading...
FREE
Digital Download
avatar

ORB Education

232 Followers
Follow
More products from ORB Education
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign Up