Question
Explain the procedure for computation of mean and standard deviation using Microsoft Excel.
Answer :
Word Count : 231
___ __________ ________ ______ ______ __________ __________ _________ _________ _________ ____.
_________ ______ _________ ___ ______ _________.
_________ ___ ________ _______ ____ ___ ______ __________ __________.
__________ _________ __________ ______ _______ _____ _______ ___ __________.
______ _________ _____ ___ __________.
_________ _______ ________ _____ _________ __________ __________ _______ _______.
____ ________ __________ ______ ________ ______ _______ _________ _______ _______ ______ ____.
______ ______ _______ ____ _____.
_______ ________ ___ __________ ______ ____ ___ ______.
___ ___ ______ _______ ___ ____ __________.
_____ ____ ___ __________ _____ ________ _______ __________ __________.
__________ _____ ____ ________ ____.
____ ______ _______ _______ __________.
_________ ___ _______ ________ ____ ______ _________ _____ ___ _____.
_____ ____ _____ _______ ________ __________ _______.
_________ __________ _______ _____ _________.
_________ ______ ___ _______ __________ ________ __________ ___ _____ ______ _______ ____.
_____ ______ _____ _________ ______ ________ __________ __________ __________ ______ ________.
_________ __________ ______ ________ ___ _______ ____ ___ ___ __________ __________ ____.
_________ ____.
Skip in 10
To compute the mean and standard deviation using Microsoft Excel, follow these steps:
1. Enter the Data: Start by entering your data values in a single column or row in Excel. For example, you might input your data in cells A1 to A10.
2. Calculate the Mean: To compute the mean (average), use the AVERAGE function in Excel. Click on an empty cell where you want to display the mean value, and
_________ ______ _________ ___ ______ _________.
_________ ___ ________ _______ ____ ___ ______ __________ __________.
__________ _________ __________ ______ _______ _____ _______ ___ __________.
______ _________ _____ ___ __________.
_________ _______ ________ _____ _________ __________ __________ _______ _______.
____ ________ __________ ______ ________ ______ _______ _________ _______ _______ ______ ____.
______ ______ _______ ____ _____.
_______ ________ ___ __________ ______ ____ ___ ______.
___ ___ ______ _______ ___ ____ __________.
_____ ____ ___ __________ _____ ________ _______ __________ __________.
__________ _____ ____ ________ ____.
____ ______ _______ _______ __________.
_________ ___ _______ ________ ____ ______ _________ _____ ___ _____.
_____ ____ _____ _______ ________ __________ _______.
_________ __________ _______ _____ _________.
_________ ______ ___ _______ __________ ________ __________ ___ _____ ______ _______ ____.
_____ ______ _____ _________ ______ ________ __________ __________ __________ ______ ________.
_________ __________ ______ ________ ___ _______ ____ ___ ___ __________ __________ ____.
_________ ____.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.