Perform the following tasks using a spreadsheet (you must either enter necessary formula that are required to calculate the value or you may use spreadsheet function for the same):

(i) Calculate the standard error, given a population of 250, sample size 50 and
population standard deviation of 25.
(ii) Assume that a company manufactures Discs. The Discs should have a mean diameter
of 2cm. A sample of 20 such Discs were taken out of 1000 such Discs The sample
diameter of these Discs was 2.01 cm with a standard deviation of 0.01 cm. Can the  company say with 95% confidence that the Discs should be accepted. Make suitable assumption and justify your answer.

(i) To calculate the standard error, given a population size of 250, a sample size of 50, and a population standard deviation of 25, you can use the following formula:

Standard Error = Population Standard Deviation / Square Root of Sample Size

In this case, the population standard deviation is 25, and the sample size is 50. Using the formula, the calculation would be as follows:

Standard Error = 25 / √50

To calculate the square root of 50, you can use the SQRT() function in the spreadsheet package. __________ _______ ________ _______ ____ _________ __________ _________ __________ __________ _______ ________.
__________ ______ _________ ___ _____ ____ ___ __________ ____ ________ _____.
______ __________ ___ ________ _______ ____ _____.
________ _______ __________ __________ _______ ____.
_______ ___ _______ ___ ______ ____ _________.
____ _____ ______ _________ ______.
______ ______ ___ ____ _____ ______ ____ ____ ________ __________ _________ __________.
_____ _________ ______ _________ _______.
________ __________ ___ ______ ____ _______ _______.
________ ___ ___ ________ _______ ___ _________ _______ _______ ____.
_____ ________ _______ ______ _________ ______ ________ _________ ______ ___.
________ _____ _________ __________ _________.
________ _______ __________ ___ _________ _____ ______ __________ _________ __________ _________ ______.
________ _________ ________ ________ __________ _____ ________ ___ ______ ___.
______ _________ _________ ____ ____ _______ ___ _______ _______.
______ ______ _____ _________ ______ __________ ____ ______ _________.
_____ ___ ___ __________ ________ ____ __________.
______ __________ _______ ___ ________ _________ _____ ____ _________ ___.
_____ ___ _____ _________ ______ _____ _________ _______ ______ ____ __________.
___ _________ ________ _____ ____.
_______ ___ ____ ____ _____ ________ ______ ___ ____ ____.
__________ __________ ________ ____ ________ ______ ____ ____ __________ _______ _______ _________.
___ _____ __________ ____ ______ _______.
___ ______ _________ _____ ___ _________ ____ _____ __________ __________ ________ ___.
___ ___ ________ ______ ___ __________ ______ _________.
___ ___ __________ _________ _____ ___ _____ _____ ____.
___ ___ ___ ______ ___ __________ _________.
____ _____ __________ __________ ____ ______ ______ ________ __________.
_______ ______ ______ ____ ________ _________ _______.
________ _______ __________ ________ ____ _________ ________.
________ __________ _____ ________ _________ ____ ___.
_________ ___ ___ __________ _____ _______ ______ _____ ______ _____ ___ ________.
___ ____ _____ __________ ________.
____ ______ ____ _________ _______ ______.
________ __________ _________ _________ _______.
______ ___ _____ __________ __________ _________ _______ _____ _________ ________ ________.
____ _____ ___ ______ __________ ____ __________ ___ _____ ________.
________ ___ ___ ______ __________ ______ __________ ______ ________ _________ _____.
_____ ___ _______ __________ ___ ___ __________ _______ ____ ______ ___.
_______ _____ ____ ______ ____.
_______ _______ _________ _____ _____ _____ _________.
______ _____ _________ _________ _______.
_____ __________ ______ ____ ____ ________.
_____ ____ ______ _________ ________ _______ ______ ________ _______ ___ ________ _____.
__________ _________ ___ ________ _________ _________ ______ __________.
__________ ________ ________ _________ ________.
____ _______ __________ _______ ________.
____ ____ _______ _____ _____ ________ ________ _______ _____ _______ __________.
_________ ________ ______ ____ _________ _________ _____ ______ __________ ____.
___ ______ _____ _____ ____ ______ _______ _____ ___ ______ _______.
__________ _________ _____ ________ _______.
______ ____ _________ ___ _________.
___ ____ _________ __________ ________ ____ ______ ________ _____ _________ ___ _____.
________ ____ __________ _______ ________ ___ _______.
Get Full Answer on WhatsApp