QMB6357 Unit 2 HW
Employment Status Number of Affiliations Satisfaction Advisement Spending on Textbooks un 0 2 550 pt 0 2 400 pt 0 5 450 pt 0 5 360 pt 1 1 500 pt 2 5 650 un 0 4 500 pt 0 1 500 pt 0 4 350 pt 0 6 300 pt 1 4 200 un 0 5 550 pt 3 5 425 pt 0 4 600 pt 0 3 600 pt 0 5 400 un 1 4 250 pt 2 4 350 un 0 2 400 un 0 4 400 pt 2 5 500 pt 0 3 600 pt 0 3 400 pt 1 3 500 pt 3 6 1000 pt 2 4 300 pt 0 2 450 pt 0 5 550 un 1 5 600 pt 0 4 400 pt 0 3 700 ft 0 5 500 pt 1 6 350 pt 1 1 450 un 0 7 600 pt 0 5 400 pt 0 3 450 pt 0 3 800 un 0 3 400 un 1 4 375 pt 0 3 400 pt 0 5 500 pt 1 4 350 pt 0 5 525 un 2 4 400 pt 1 3 450 pt 0 3 500 pt 0 4 400 pt 1 3 450 pt 0 2 500
Fifty undergraduate students answered a survey. The results are shown here.
Q-2a: What is the average expected salary of these undergraduates upon graduation? (Round to two decimals)
Q-2b: What is the median amount spent on textbooks? (Round to two decimals) Q-2c: What is the mode with respect to the number of affiliations to clubs and other organizations of these undergraduates? Q-2d: What is the standard deviation of these students' GPAs? (Round to two decimals) Q-2e: Using coefficients of variation, tell me which has more variation, the age of the students in this sample or the amounts that they spent on textbooks.
ANSWERS
Q-2a) The average expected salary, or the mean salary, of undergraduates upon graduation can be found by using the function =AVERAGE(range of salaries)
47.3
The formula is the equivalent of adding all of the salaries and dividing it by the total number of students surveyed.
The average expected salary of undergraduates upon graduation is 47.3, or, if salary is expressed in thousands, then the average expected salary of undergraduates is $47,300.
Q-2b) The median amount spent on textbooks, or, the middle number when all amounts are listed in numerical order, can be found by using the function =MEDIAN(range of
Fifty undergraduate students answered a survey. The results are shown here.
Q-2a: What is the average expected salary of these undergraduates upon graduation? (Round to two decimals)
Q-2b: What is the median amount spent on textbooks? (Round to two decimals) Q-2c: What is the mode with respect to the number of affiliations to clubs and other organizations of these undergraduates? Q-2d: What is the standard deviation of these students' GPAs? (Round to two decimals) Q-2e: Using coefficients of variation, tell me which has more variation, the age of the students in this sample or the amounts that they spent on textbooks.
ANSWERS
Q-2a) The average expected salary, or the mean salary, of undergraduates upon graduation can be found by using the function =AVERAGE(range of salaries)
47.3
The formula is the equivalent of adding all of the salaries and dividing it by the total number of students surveyed.
The average expected salary of undergraduates upon graduation is 47.3, or, if salary is expressed in thousands, then the average expected salary of undergraduates is $47,300.
Q-2b) The median amount spent on textbooks, or, the middle number when all amounts are listed in numerical order, can be found by using the function =MEDIAN(range of