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

Ask an Expert

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

Write your message here..

Related Questions

Correlation coefficient for X and Y, Calculate Correlation coefficient for ... Calculate Correlation coefficient for X and Y, Statistics Homework • Variable X x • Variable Y y • Calculate: • z-scores for all values in the variables • correlation coefficien

Margin of error, The poll interviewed 1500 persons rather than 1060, for 95... The poll interviewed 1500 persons rather than 1060, for 95% confidence.

Description of sample at baseline, Description of Sample at Baseline 1... Description of Sample at Baseline 1. Describe the sample characteristics and baseline values, comparing the two groups'characteristics. With any analysis, the first step

Definition of capital lease as a financial arrangement, Definition of capit... Definition of capital lease in term of financial arrangement whereby a lessee pays rental for asset. Capital lease is a financial arrangement underlying a agreement where a lesse

Classification of cost., what i6 the relevance of cost classification? what i6 the relevance of cost classification?

Psy 1110 Ohio University, do you give the answers with the way you figured ... do you give the answers with the way you figured the problem out?..

Accounting standards in europe, Accounting Standards in  Europe  countr... Accounting Standards in  Europe  countries:   Europe has seen the maximum progress in having developed its accounting standards. In 2000, a document was published by the Europe

Regression analysis, Regression line drawn as Y=C+1075x, when x was 2, and ... Regression line drawn as Y=C+1075x, when x was 2, and y was 239. Given that y intercept was 11. Calculate the residual

Define block grant, Define block grant A federal grant that consolidates, ... Define block grant A federal grant that consolidates, for a wide reason or any type of purpose, funds previously awarded for a wide variety of activities.

Central tendency, explain the graphical method of measure of central tenden... explain the graphical method of measure of central tendency.