Calculate the mean and the standard deviation, Basic Statistics

1.  Create formulas to calculate the normalized (i.e., percentage scores) for each of the quizzes and exams.  The yellow fields depict where these interim calculations are required.  There is a little arithmetic required to do accomplish this but nothing that should be beyond your capabilities.  Use the I.M. Perfect data to check your formula.  When done correctly, 100% should show across the row in the yellow and blue fields.

2.  Then using the weighting factors provided calculate the final grades for the students, again on a 100 point (i.e., percentage scale).

Note with respect to the above tasks, you are expected to make appropriate use of absolute and relative references.  You will not that you have accomplished this when you can copy your formula down the various columns and achieve the correct answer (without having to modify your formulas).

3.  For a little function practice, then calculate the mean and the standard deviation for each of the quizzes, exams and assignments.  These will go in the blue fields at the bottom of each column.

Posted Date: 2/22/2013 4:52:33 AM | Location : United States







Related Discussions:- Calculate the mean and the standard deviation, Assignment Help, Ask Question on Calculate the mean and the standard deviation, Get Answer, Expert's Help, Calculate the mean and the standard deviation Discussions

Write discussion on Calculate the mean and the standard deviation
Your posts are moderated
Related Questions
Semiannual coupon = 10%*$100/2 = $5 Since it is one-year semiannual bond, it pays two coupons, one at six months from now and the other at maturity when the bank account will be

#questKody Corporation uses a job-order costing system with a plantwide overhead rate based on machine-hours. At the beginning of the year, the company made the following estimates


difference of them for covering the following: 1.purpose of reporting 2.FORMAT OF INCOME STATEMENT

each student will be assigned a homework problem which requires data collection using an information system. Two scores are given: 1- adequacy of data collection and relevancy ( M2

How has quantitative analysis changed the current scenario in the management world today?


Your friend Jose is trying to decide whether to buy or lease his next vehicle. He has gathered information about each option but is not sure how to compare the alternatives. Purcha


The 70-m microwave transmission tower