Calculate the mean and the standard deviation, Basic Statistics

Assignment Help:

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.


Related Discussions:- Calculate the mean and the standard deviation

Bad debt reserve, Explain definition of bad debt reserve and provision in t...

Explain definition of bad debt reserve and provision in terms of accounts receivable likely to be uncollected. Bad debt reserve provision Bad debt reserve provision is a amount

#title. .decision tree, Assume that you have a client that is a paper manuf...

Assume that you have a client that is a paper manufacturer and they have expressed concern that the government will pass a new regulation banning the use of chlorine-based technolo

Card custodian, Card custodian An person who is assigned responsibility of...

Card custodian An person who is assigned responsibility of purchase card security & issuance of cards to authorized users,

How can do entry, mr.sunil join as a new business partner and borrowed rs. ...

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.

Esk jewellery, You are working for the management of ESK Jewellery as a mar...

You are working for the management of ESK Jewellery as a marketing consultant. The main business of ESK Jewellery is the retailing of diamond jewellery. They opened their first sho

Time series, discuss the nature and causes of the components of an economic...

discuss the nature and causes of the components of an economic time series?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd