Home / Questions / Project Description In this project you will use excel to perform statistical analysis of ...
Project Description:
In this 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 named exploring_e08_grader_h1.xlsx , and then save the file as exploring_e08_grader_h1_LastFirst , replacing LastFirst with your name.

0.000 
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.000 
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.000 
4 
Enter a function in cell J5 to calculate the average salary of all support staff (H5) in the survey. 
6.000 
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.000 
6 
Enter a function in cell I12 to calculate the number of Directors in the survey that have a job satisfaction level of 4 or higher. 
6.000 
7 
Enter a function in cell I13 to calculate the average salary of Directors in the survey that have a job satisfaction level of 4 or higher. 
6.000 
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.000 
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.000 
10 
Use the fill handle to copy the function down column F. Be sure to include the appropriate absolute or mixed cell references before copying the functions. 
5.000 
11 
Enter a function in cell I20 to calculate the minimum Quartile value in the list of salaries. 
6.000 
12 
Use the fill handle to complete the remaining quartile values in cell range I21:I24. Be sure to include the appropriate absolute or mixed cell references before copying the functions. 
5.000 
13 
Enter a function in cell H27 to calculate the correlation of column D and E. 
12.000 
14 
Format the result as Number Format with two decimal positions. 
5.000 
15 
If necessary, display the Analysis ToolPak. Run a Data Analysis with descriptive statistics. Complete the input criteria using the salary data in the range D4:D53. Set the Output functions to display on a new worksheet. Set the output as Summary statistics. 
12.000 
16 
Name the newly created worksheet Descriptive Statistics . 
3.000 
17 
Run a Data Analysis histogram. Use the salaries in the range D4:D53 as the input range. Use the quartiles in the range I20:I24 as the bin range. Output the data in cell H29. Include a chart with the output.

10.000 
18 
Move the Employee Satisfaction worksheet to display first in the workbook. Ensure that the worksheets are correctly named and placed in the following order in the workbook: Employee Satisfaction; Descriptive Statistics. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
Jul 27 2020 Read more Less More
Explain why innovation is critical for the success of any global companies. Then develop five different ways to enhance a global company’s innovation capacity and share y...
May 26 2020Consider an economy with two labor markets—one for manufacturing workers and one for service workers. Suppose initially that neither is unionized. a. If manufacturing wor...
Apr 30 2020On January 9 a company pays $6,000 for salaries, of which $1,100 was reported as Salaries Payable on December 31. Give the entry to record the payment
Apr 17 2020Infer how lubricating a machine affects the output force exerted by the machine.
Nov 26 2019Which of the following is NOT a dimension of job satisfaction?a) satisfaction with job fulfillmentb) satisfaction with securityc) satisfaction with payd) satisfaction wit...
Dec 25 2019Nov. 20 Sold two items of merchandise to Cheryl Jahn, who paid the $390 (total) sales price in cash. The goods cost Bear’s $290. 25 Sold 20 items of merchandise to Vasko...
Sep 01 2020Use Itˆo’s Lemma to evaluate dS−1. For the following four problems, use Itˆo’s Lemma to determine the process followed by the specified equation, assuming that S(t) follo...
Jun 06 2020What is the basic premise underlying the highlow method of analyzing semivariable costs?
May 22 2020List the basic steps in static GAP analysis. What is the objective of each?
Nov 26 2019Suppose the price elasticity of cigarette demand is –0.40. If we increased the price of cigarettes by 50%, what would we expect to happen to the quantity purchased? To to...
May 15 2020Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.