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
hi i just want to knw my husband done b.com n doing job as a accountant in private firm can u suggest me it is better for my husband to do m.ba or either some professional course

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

One way to use contiguous allocation of the disk and not suffer from holes is to compact the disk every time a file is removed. Since all files are contiguous, copying a file requi

What is the properties of a simple random sample when 50 females are numbered 1 through 50, and males are numbered 51 through 100?

Basis of accounting This represents the technique and time of when income and costs or costs are acknowledged in the records and revealed in the fiscal reports. Talk about ACCRUAL

Progect Guid: PROJECT 1: SIMPLE DATA ANALYSIS & COMPARISON REPORT GUIDELINES This document contains general guidelines for the preparation of the Project Report I. Please note,


Assumed Means Deviations in F2 Test : When actual means of X and Y variables are in fractions the calculations can be simplified by taking the deviations from assumed means. When d


Impact of government regulation on managerial Decision making Impact of government regulation on managerial Decision making how methods of control can influence market prices.