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
Long Term Credit Decision In no more than one typed page, provide a statement of your decision to lend or not lend to this company based on your interpretation of the company'

what are the statistics hypotheses for bartlett''s test for exponential distribution?

In a mathematics examination the average grade was 82 and the standard deviation was 5. all students with grade from 88 to 94 received grade of B. if the grade are approximately no

meanings of statistics by different authors and importance of statistics in the field of Education

Explain the effects of the transactions on Accounting Equation under a Financial Accounting System. Ans. Under the Double Entry System each of the financial transaction bring the

You are working for the management of ESK Jewellery as a marketing consultant. The main business of ESK Jewellery is the retailing of diamond jewellery. They opened their first sho

An individual has $ 100 initially. He repeatedly plays a game of chance in which he earns $ 100 with probability 0.8 or loses $ 100 with probability 0.2. The stops playing at the f

Median The median describes the value of the middle term in data. The data set must be ranked first in increasing order before the middle value is identified. The median separa