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
1. ABC produces a single product. Material A is added at the start of production and Material B at the end. Conversion is uniform throughout. Inspection before Material B is added.

1. Use the portal method to determine the approximate vertical reactions. Circles represent pinned connections. 2. A steel 2" x 3" rectangular bar is 9' long (E = 29,000ksi

The square of the sample correlation coefficient is typically denoted r2 and called the coefficient of determination. It estimates the fraction of the variance in Y that is explain

How to calculate manually Cronbach alpha

solved example with data of bi variate frequency distribution

Cluster Sampling and Area Sampling: Cluster sampling involves grouping the population and then selecting the group or the cluster rather than individual elements for inclusion in t

Budgetary accounts Accounts used to go through the adopted budget into the all-purpose ledger as part of the administration control method of formal budgetary addition.

what is the importance of time series

In marketing research field surveys are commonly used to collect primary data from the respondents. 1. Through Personal Interviews: The investigator follows a rigid proced

A, Suppose a CD player player tries to detect whether its partner is C player instead of a DD player by looking for external signals that are at least as typical for DD players tha