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

Recruitment process process map, What are the steps in a recruitment proces...

What are the steps in a recruitment process and who are responsible for each step?

Regression, Sales from a leading motor dealership were monitored over the p...

Sales from a leading motor dealership were monitored over the past four years. The sales figures are presented in the accompanying table. Year Quarter 1 Quarter 2 Quarter 3 Quarter

Statistics question, 1. A sample from 16 different farms across Quebec show...

1. A sample from 16 different farms across Quebec shows that the hay production in bales per acre is normally distributed N(100,50). a. (2p )What is the probability that a random

Calculate the predicted mean temperature, The following are actual data sho...

The following are actual data showing the latitude of a sample of major cities in the northern hemisphere and their mean high annual temperature. latitude(X)    mean high temp(Y

Histogram , The following figure shows a histogram of the annual maxima of ...

The following figure shows a histogram of the annual maxima of daily rainfall levels (in millimetres) recorded at Maiquetia international airport, Venezuela, for the years 1952 to

Dist4ibution, I want support about statistical distributions

I want support about statistical distributions

TIME SERIES, Graphical representation of freehand and semi average method

Graphical representation of freehand and semi average method

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

why are revenues an important number in financial statements?

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