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

six subjects were exposed to 4 treatments and the following data were recorded

A boat is heading across a river at a velocity of 25 mph. The river is flowing downstream at 10 mph. What is the actual velocity of the boat?

A gambling machines works in the following way. The player inserts a penny into 1 of 5 slots which are colored Blue, Red, Orange, Yellow & Green corresponding to 5 colored light bu

I want as much information about moderate negative correlation.

The "recoverytime" files record the time (in days) for male blue-collar workers to recover from a common wrist fracture. Each man was given a questionnaire to complete to determine

Plase give me the answers of this sets of questions.

How important a role do you think IT will play in the conversion process from GAAP to IFRS? Manager 1: Earlier, we never expected the new rules to have such an impact on the

What is cash flow net of tax? I view income net of tax as the money spent without the earnings tax savings when the quantity is insurance deductible on the corporation’s earnin

1. (TCO 8) Planning for capital investments is an important function of management. You are responsible for considering purchasing a new exhibit. It would cost $136,000 and have