logging in or signing up drop two lowest formula CWarner Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINTLite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 5 Category: Education License: All Rights Reserved Like it (0) Dislike it (0) Added: December 11, 2009 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... Premium member Presentation Transcript =(SUM(B2:F2)-SMALL(B2:F2,2)-SMALL(B2:F2,1))/(5-2) : =(SUM(B2:F2)-SMALL(B2:F2,2)-SMALL(B2:F2,1))/(5-2) Enter an = sign to begin making a formula Create the SUM function and include the entire row of grades in the array Subtract the two lowest grades by creating two SMALL functions. Include the entire row of grades in the array, but then enter a comma and include a 2 in the first function and a 1 in the second. This will subtract the second lowest grade and then subtract the lowest grade. Divide the entire formula by the remaining grades: the total number of grades less the number dropped You must Parenthesize the Entire Formula You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.
drop two lowest formula CWarner Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINTLite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 5 Category: Education License: All Rights Reserved Like it (0) Dislike it (0) Added: December 11, 2009 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... Premium member Presentation Transcript =(SUM(B2:F2)-SMALL(B2:F2,2)-SMALL(B2:F2,1))/(5-2) : =(SUM(B2:F2)-SMALL(B2:F2,2)-SMALL(B2:F2,1))/(5-2) Enter an = sign to begin making a formula Create the SUM function and include the entire row of grades in the array Subtract the two lowest grades by creating two SMALL functions. Include the entire row of grades in the array, but then enter a comma and include a 2 in the first function and a 1 in the second. This will subtract the second lowest grade and then subtract the lowest grade. Divide the entire formula by the remaining grades: the total number of grades less the number dropped You must Parenthesize the Entire Formula