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
mr.sunil join as a new business partner and borrowed rs. 850000 from ansul investment co. and depoisted the money into a uti bank account on 1-4-2006.

Introduce the aim of this section of the report including an explanation of the data to be analysed. • Use Excel to produce a box and whisker plot for the two sets of booking data

Mode Mode, M is the value that has the largest number of occurrence or frequency in a data set, for instance, given the following data:  11 15 16 12 15 19 17 15 we can se

Three major Accounts and their Rules There are three major Records which are a) Personal Accounts b) Real Accounts c) Moderate Accounts Rule for Personal Account: Ch

Limitations of mean

Question: (i) A soft drink machine is regulated so that it fills an average of 300 cL per cup. If the amount of drink in each cup is normally distributed with standard deviati

A retail store has recently hired you as a consultant to advise on economic conditions. One important indicator that the retail store is concerned about is the unemployment rate.

The initial research proposal will consist of the following SIX (6) items: 1. Identify a business research topic 2. Define the research questions for the identified problem or opp

The results of a study using focused comparison techniques showed that two independent variables distinguished between successful and unsuccessful negotiations with the US on secur

Derive the profit function P (p) and the supply function (or correspondence) y (p)for the following three Single-output technologies, whose production functions f (z) are: