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
review the financial disclosures for two publicly traded companies. Identify recently promulgated (or proposed) accounting pronouncements that have an impact on the companies. In a

Capital grants Grants that are restricted for the acquisition: structure: renewal of capital assets associated with an accurate program, Refer to GRANTS & OPERATING GRANTS

What is the basis for factory overhead absorption

Expertsmind.com  brings you unique solution in  physics An audio amplifier setup will have a power amplifier and usually a preamplifier.  The preamplifier takes the wea

Clearing account An account used to build up entire charges, credits so that they can be disseminated later amongst the accounts to which they are allocable, so that the net diffe

A LARGE SHIPPPING COMPANY RECORDED THE NUMBERS OF TONS SHIPPED WEEKLY ACROSS THE PACIFIC FOR 50 WEEKS. ARRANGE DATA IN A LESS THAN CUMULATIVE DISTRIBUTION USING SEVEN CLASSES OF E

1) Define and explain the following: i) Ordering cost ii) Safety stock iii) Re-order point 2) Profit Volume Chart. 3) Discuss the various techniques of financial statement analysis

Geometric mean of index number of laspeyres and paasches = 229.5468 , while sum of their index number=480 find out laspeyre''s and paasche''s indices.

1. Mention the characteristics of Statistics. Explain any two applications of Statistics.

Definition of brokerage is termed as a fee paid to a broker for services. BROKERAGE is a fee which is paid to the broker for his/her services to act as an intermediary between the