Question
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 rings. The rings should have a mean diameter of 2cm. A sample of 20 such rings were taken out of 1000 such rings. The sample diameter of these rings was 2.01 cm with a standard deviation of 0.01 cm. Can the company say with 95% confidence that the rings should be accepted. Make suitable assumption and justify your answer.
Answer :
Word Count : 266
(i) Calculation of Standard Error In the spreadsheet, to calculate the Standard Error (SE), use the formula: $$ \text{Standard Error (SE)} = \frac{\sigma}{\sqrt{n}} $$ Where: * σ = Population standard deviation = 25 * n = Sample size = 50 In the spreadsheet (e.g., Excel or Google Sheets): * In one cell (say, A1), enter: `=25/SQRT(50)` * This will give the value of standard error ≈ _____ _____ _________ __________ __________ _________ ________ ____ _______ __________ _______.
________ ______ __________ ______ _________ _______ _______ ________ ___ __________ __________ __________.
______ _______ __________ __________ _________ ______ ___ ______ __________ ______ ________ _______.
______ _______ _________ _____ ______ _________ ________.
______ _______ _____ ____ ____.
____ ________ _________ ____ ____ ______.
______ ________ _______ _______ _______.
_____ ___ _______ _______ ____ _________ ____ _____ __________.
_________ _________ ____ ______ ______ __________ __________ __________ ______.
_________ ______ __________ ________ _______.
___ ___ ____ _____ ______.
____ ____ ___ ____ __________ _______ ________.
________ _________ __________ ____ ___.
________ _____ _______ ________ ________ _____ _____ _________ ________ ____ _____.
______ __________ _____ ________ ________ ____ ______ ______ ____ ___.
_______ __________ ___ ___ _____.
________ ________ ____ ______ _________ _____ _____ _________ _______ _______ __________.
__________ ________ _____ __________ _________ ____ __________ ____.
_____ ___ ____ ___ __________ ____ ______ _____ _________ _______.
_________ _____ __________ __________ __________ _______ ______ ___ _____ ______ __________ _______.
______ ________ _______ _______ ______ _________.
_____ _________ _________ _______ ____.
______ ______ ________ _____ _________ _________ ____ ________ _____.
_______ ________ ____ __________ ___ _______ _______ _______ __________ ______.
___ ___ ___ ______ __________.
Get Full Answer on WhatsApp
(i) Calculation of Standard Error In the spreadsheet, to calculate the Standard Error (SE), use the formula: $$ \text{Standard Error (SE)} = \frac{\sigma}{\sqrt{n}} $$ Where: * σ = Population standard deviation = 25 * n = Sample size = 50 In the spreadsheet (e.g., Excel or Google Sheets): * In one cell (say, A1), enter: `=25/SQRT(50)` * This will give the value of standard error ≈ _____ _____ _________ __________ __________ _________ ________ ____ _______ __________ _______.
________ ______ __________ ______ _________ _______ _______ ________ ___ __________ __________ __________.
______ _______ __________ __________ _________ ______ ___ ______ __________ ______ ________ _______.
______ _______ _________ _____ ______ _________ ________.
______ _______ _____ ____ ____.
____ ________ _________ ____ ____ ______.
______ ________ _______ _______ _______.
_____ ___ _______ _______ ____ _________ ____ _____ __________.
_________ _________ ____ ______ ______ __________ __________ __________ ______.
_________ ______ __________ ________ _______.
___ ___ ____ _____ ______.
____ ____ ___ ____ __________ _______ ________.
________ _________ __________ ____ ___.
________ _____ _______ ________ ________ _____ _____ _________ ________ ____ _____.
______ __________ _____ ________ ________ ____ ______ ______ ____ ___.
_______ __________ ___ ___ _____.
________ ________ ____ ______ _________ _____ _____ _________ _______ _______ __________.
__________ ________ _____ __________ _________ ____ __________ ____.
_____ ___ ____ ___ __________ ____ ______ _____ _________ _______.
_________ _____ __________ __________ __________ _______ ______ ___ _____ ______ __________ _______.
______ ________ _______ _______ ______ _________.
_____ _________ _________ _______ ____.
______ ______ ________ _____ _________ _________ ____ ________ _____.
_______ ________ ____ __________ ___ _______ _______ _______ __________ ______.
___ ___ ___ ______ __________.
Get Full Answer on WhatsApp
IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★