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
#what is the importance of measures of central tendency to Human resource management

Questions In one hybridization experiment 8070 offspring seeds were obtained, and 23.54% of them had green flowers.  The others had white flowers.  Perform a hypothesis test

Write a sample Results section, discussing your data screening activity.


What does a bookkeeper do? An accountant is responsible for handling the documents for a business's dealings. Ultimately the dealings will be registered in records within the bu

Identify the unit of analysis in the following hypothetical research design: A research team wants to compare the school spirit at college campuses across the country to see if pri

The whole point of organizing data using SPSS software is so that we can manipulate the data to answer our descriptive and inferential questions.  This next section will walk you t

Give certain creative assignment for freshers of accounting


Question 2 Pankratov Lakes is a new recreational real estate development that consist of 500 Lake front and lake view lots. As a special incentive to the first 100 buyers of lake v