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

Continuous probability distributions, Continuous probability distributions:...

Continuous probability distributions: Procurement and working capital analysis – Normally distributed random variables and their transformation Procedures The data is measure

Histogram, difference between histogram and historigram

difference between histogram and historigram

Binomial probability distribution, if the probability of getting caught cop...

if the probability of getting caught copying someone else s exam is 0.2 find the probability of not getting caught in 3 attempts assume independence

Estimate the variables-statistically significant, The dataset also contains...

The dataset also contains a variable y , which is the dependent variable of interest, as well as x1 , x2 , x3 , x4 , x5 , and x6 , all explanatory variables that are potentially

Revenues , why are revenues an important number in financial statements?

why are revenues an important number in financial statements?

Testing the hypothesis type 1 and type 2 error, ...if a transit employee pr...

...if a transit employee provides a strand of hair for drug testing, state the null and alternative hypothesis in verbal terms, then identify what would constitute a type 1 and typ

Assignment, Discuss about the scalling techniques

Discuss about the scalling techniques

Find the value, Find the value of E (i+). Show your calculation. i=7 i=3

Find the value of E (i+). Show your calculation. i=7 i=3

Homework help, example of descriptive statistics in word form

example of descriptive statistics in word form

Explain the term “trial balance” and its needs, Explain the term “Trial Bal...

Explain the term “Trial Balance” and its needs for an organization. Ans. A Trial Balance is a statement of summarization of the all the involved ledgers accounts at the end of th

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