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
Ask questio How many women must be randomly selected to estimate the mean weight of women in one age group? We want 90% confidence that the sample mean is within 3.7 lbs of the po

1. Generate a large dataset ( at least 1000 observations) µ with a known mean, µ between 20 and 40 and variance s = 9 using rnorm(). identify it as D. Use the functions mean() and

A. If CD players are able to use the LDD strategy better than pure chance then explain what happens to the signal reliability ration as a CD player detects more cautiously B. As

assume that your group is incorporating a business organization. you are required to present a detailed structure, business environment and organizational structure of the entity.

If in a hall there are 18 persons then how many handshakes are possible?

Design an activity based cost system requires that: a) the job bid process redesigned b) resource costs be linked to the activities performed c)the cost of activities be linked to

Absorption distributions Probability distributions which represent the number of 'individuals' (such as particles) which fail to cross the speci?ed area containing the hazards o

office supplies on hand at year-end amounted to $100

In a suburban community, 30% of the households use Brand A toothpaste, 27% use Brand B, 25% use Brand C, and 18% use Brand D. In the four groups of households, the proportions of r

a). Show that if a random variable has a uniform density with the parameters a and ß, the probability that it will take on a value less than a+p(ß-a) is equal to p b). Prove that t