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

Bonded warehouse is a storage area under Customs authority that is imported dutiable goods on which duty is unpaid and these are stored. Once the duty & other charges are paid the

Short-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

I have a regression analysis assignment using minicab, but I am not sue how to do with my current data set?

What is the difference between parametric and non-parametric stats tests? Different kinds or levels of data need to be analysed using different kinds of stats tests. The basic dist

discuss the steps in preparing product cost allocation.

The company acquired 50000 8% preferencd shares (with a par value of R4 each) in cross limited on 30 june 2006 for R180000.


During October, Alcorn Company had 81,250 of cash receipts and 83,688.00 of cash disbursements. The October 31 cash balance was 14,060. Determine how much cash the company had at