+
Exploring Series Vol. 2, Chapter 8, H1 Statistical Functions

Exploring Series Vol. 2, Chapter 8, H1 Statistical Functions

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/exploring-series-vol-2-chapter-8-h1-statistical-functions/

Statistical Functions
 
Project Description:
In the following project, you will use excel to perform statistical analysis of a cross section sample of an employee satisfaction survey.
 
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

Download and open the file namedexploring_e08_grader_h1, and then save the file asexploring_e08_grader_h1_LastFirst, replacing “LastFirst”with your name.

0

2

Enter a conditional function in cell I5 to calculate average satisfaction for support staff (H5). Format the results with Number format and two decimal positions.

6

3

Use the fill handle in cell I5 to copy the function down through the range I6:I9. Be sure to use the appropriate mixed or absolute referencing before copying the functions.

3

4

Enter a function in cell J5 to calculate the average salary of all support staff (H5) in the survey.

6

5

Use the fill handle in cell J5 to copy the function down through the range J6:J9. Be sure to use the appropriate mixed or absolute referencing before copying the functions.

3

6

Enter a function in cell I12 to calculate the number of Directors in the survey that have a job satisfaction level of 4or higher.

6

7

Enter a function in cell I13 to calculate the average salary of Directors in the survey that have a job satisfaction level of 4or higher.

6

8

Adapt the process used in the previous two steps to calculate the total number and average salary of managers that have a job satisfaction of 4 or higher in cells I16 and I17.

6

9

Enter a function in cell F4 that calculates the rank of the salary in cell D4 against the range of salaries in the data set.

6


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial