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

Explain the financial accounting., Explain the Financial Accounting. Und...

Explain the Financial Accounting. Under the Financial Accounting System the producing of economic purchase are done in the Cash and Publication, in other Bookkeeping as Sales, P

reading and display data-affine relation, We start reading and display the...

We start reading and display the data: library (UsingR) data(galileo) g2=galileo$init.h-500 gl=galileo$h.d par(bg='cornsilk') plot(gl,g2,pch=20,col="red",cex=2,yl

Time series , what is the importance of time series

what is the importance of time series

GENERAL ENTRY PROBLEM, could you please tell meaning of credit and debit no...

could you please tell meaning of credit and debit notes in terms of intercompany transactions.

Confidence Intervals, In each of the following cases, compute 95 percent, 9...

In each of the following cases, compute 95 percent, 98 percent, and 99 percent confidence intervals for the population proportion p. p=.1, n=30, p = .1, n = 100, p = .5, n = 50, p

Budgets and budgetary control, Budgets and budgetary control A fund is...

Budgets and budgetary control A fund is an operating plan for a business, ready in progress. Funds may be set in money conditions, egg a revenue funds of £500,000, or it can

Estimate the population mean flying time for the pilots, The mean number of...

The mean number of hours of flying time for pilots at Continental Airlines is 49 hours per month (The Wall Street Journal, February 25, 2003). Assume that this mean was based on ac

Determine the level of consumption, Suppose an individual has a lifetime ea...

Suppose an individual has a lifetime earnings profile and expects to live for 4 Periods:             Earnings in Period 1:   $30             Earnings in Period 2:   $60

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