STA641 Assignment 1 Solution Spring 2022 Download

Assignment#1 

STA641 (SPRING 2022) 

Some Key Points About Assignment 1

1. Download Your First Assignment from VULMS > STA641 > Assignment

2. The Assignment File is in MS Excel. Open the file in MS Excel.

3. There are three sheets with the name “Assignment 1 Data” and “How to solve” and "Key Points"

4. The question statement, Instruction and What is required by you is mentioned in “How to solve”. Read it carefully. 

5. After understanding the question, Go to the sheet with the name “Assignment 1 Data” and apply the appropriate function/formula to get the required answer. 

6. After completing, save this file in your system.

7. Now go to the Assignment page of your VULMS and SUBMIT / UPLOAD this assignment. 

Instructions:

Note: You can add/edit data only in GREEN area.

No manual calculations are allowed. Use proper funtion.

Question # 1: 

Find the Five number Summary of given data.

Question # 2: 

Find the total count  (number of observations)

Question # 3: 

Find the value of Mean, Median and Mode.

Now you are required to do this on "Assignment 1 Data" sheet

> In cell H4, find the minimum value

> In cell H5, find the first quartile 

> In cell H6, find the second quartile

> In cell H7, find the third Quartile

> In cell H8, find the Highest value

> In cell H10, count the number of values in the data

> In cell H12, find the value of Mode

> In cell H13, find the value of Mean

> In cell H14, find the value of Median

3.  

Download Question File and Solution

Download File Now 

 

Want more info, please press the below button

`

Want more info, please press the below button

`