Reference no: EM133775110
Statistics
Course Outcomes
• Organize data for analysis in the form of graphs, tables, and frequency distributions.
• Calculate statistical data for measures of central tendency and dispersion.
• Investigate dispersion through normal distributions using range, mean, standard deviation and z scores,
• Collect, organize, and interpret data to perform regression analysis.
• Measure location, variation, probabilities, distributions, and expectations.
• Formulate a hypothesis, test a hypothesis, and interpret the results.
• Draw conclusions and/or make decisions through the application and analysis of mathematical
models using Microsoft Excel.
Directions
You must submit a single Microsoft Word document (Copy your Excel work into Word) and upload your work into the Portfolio Project folder by the due date. You will also submit your Excel document into the Portfolio Project folder showing your work for each problem. You are welcome to use the videos and resources from your Blackboard Modulelyresource lectures. A list of all the videos is given at the end of this document.
Requirements and Formatting
Your Portfolio Project must be formatted as follows:
• APA formatting
• Title Page
• Times New Roman or Arial 12-point font
• 1-inch margins
• Page numbers in top right corner
You are a manager for Company ABC and decide to compile data and analyze your employees' level of satisifaction. You create a survey to ask each employee to rate their level of satisfaction working at Company ABC.
Table 1 shows data of 15 people employees that responded to your survey. Each of the employees have the same job title: Sales Representative. The data set includes variables regarding an employee ID, gender, ethnicity, region, pay rate, employee satisfaction rating. Each employee was asked to rate their level of satisfaction working at Company ABC. A composite score from 0 (lowest) to 5 (highest) is shown as the data variable employee satisfaction.
1. You send the survey to all 20 employees and 15 responds. Identify the population.
2. What level of measurement is the variable: Employee ID?
3. Input the data from Table 1 into Excel. Calculate the descriptive statistics on the Pay Rate column (Column D) of the table. (See video links on the last page of this document if needed)
• Paste your Excel descriptive statistics output for the pay rate variable below.
• What is the mean pay rate of the sales representatives?
• What is the standard deviation of pay rate?
4. From the data from Table 1, we can look at the Ethnicity variable.
• Use the data from Table 1 to complete the frequency table of ethnicity (Column C) for the 15 participants.You can use the =countif (C2:C21, "White") function in Excel.
• Using the Ethnicity frequency table (from part A), create a piechart for Ethnicity of employees. Make sure to include a title and each slice is clearly labeled. Paste your Pie Chart below. (See video links on the last page of this document if needed)
• Using the Ethnicity frequency table (from part A), create a bar graph for Ethnicity of employees. Make sure to include a title your graph and label each axis.
• Do you think the pie chart, or the bar graph displays the differences in the data more clearly for the Ethnicity variable? Explain your reasoning in 2 or 3 sentences.
5. Calculate the descriptive statistics for Employee Satisfaction (Column F) to answer the following questions.
• Paste your Excel descriptive statistics output for the employee satisfaction variable below.
• What is the mean employee satisfaction?
• What is the minimum employee satisfaction rating?
• What is the Employee ID of the employee with the lowest satisfaction rating (refer to Table 1)?
6. Using the Age variable (Column E), create a histogram using the following frequency distribution.
• Create a histogram of the Age data for the Sale Representatives. Paste your graph below.
• In 2-3 sentences, describe the shape of the histogram in part A. Would this be considered a symmetric or skewed? If skewed, describe the skewness.
7. Continue to focus on Age variable (Column E).
• Calculate the 5-number summary for Age (Column E). Paste the summary below. (See video links on the last page of this document if needed)
• Create a Box plot (Box & Whisker) of Age. Paste your graph below.
Submit your work for Part I in Blackboard by the end of Module 3 at 11:59 PM ET.
Module 5:Part II
• See Tracking Calendar.
8. If you conduct a survey and there is a 75% chance of selecting someone who will complete the survey, what is the probability of selecting someone who will not complete the survey?Make sure to show your calculations for full credit.
Use the data from Table 1 above to answer Questions 9- 14.
9. You want to randomly select two employee surveys to review.
• If you randomly select two employee surveyswith replacement, what is probability of selecting 2 males? Make sure to show your calculations for full credit.
• If you randomly select two employee surveyswithout replacement, what is the probability of selecting 2 males? Make sure to show your calculations for full credit.
10. What is the probability of randomly selecting an employee survey that is female and hispanic? Make sure to show your calculations for full credit.
11. You create a distribution of payrate of our employees. The mean pay rate is 48. The standard deviation is 7.
• What is the z-score for a pay rate of 34?Make sure to show your calculations for full credit.
12. In 2-3 sentences, explain what this z score tells us.
13. You want to determine which factors are associated with Payrate.
• Create a scatterplot of Payrate and Employee Satisfaction in Excel. Paste your graph below. Make sure your graph has a proper title and axes labels.
• Find the correlation coefficient of Payrate and Employee Satisfaction. Paste your correlation coefficient below. Interpret the direction and strength of the correlation coefficient in 2-3 sentences.
• Create a scatterplot of Payrate and Age in Excel. Paste your graph below. Make sure your graph has a proper title and axes labels.
• Find the correlation coefficient of Payrate and Age. Paste your correlation coefficient below. Interpret the direction and strength of the correlation coefficient in 2-3 sentences.
• Using your answers from part B and part D, is employee satisfaction or age more strongly correlated with Payrate? Explain in 2-3 sentences.
14. Complete a regression analysis using Age (x variable) to predict Payrate (y variable).
• Paste your regression analysis output from Excel below.
• Using the output in part a, write out the linear equation to predict payrate based on your data set.
• Use your regression equation in part B to estimate the payrate of a 45-year-old and a 55-year-old employee.Make sure to show your calculations for full credit.
Use the data from Table 1 above to answer Questions 15- 17.
A coworker claims the mean satisfaction rating of ABC employees is 3.2 (on a scale from 1 to 5, where 5 is extremely satisfied). You have reason to believe the mean satisfaction rating of ABC employees,μ, is different from this value and you plan to conduct a statistical test.
What is the null hypothesis, H0, that should be used for the test?
What is the alternative hypothesis, H1, that should be used for the test?
Is this a one-tailed or two-tailed test? Explain in at least 2 sentences.
If you decide not to reject the null hypothesis, what type of error might you be making?
Suppose the true mean satisfaction rating of ABC employees is 3.2. Describe a Type I error in 2-3 sentences.
To conduct a hypothesis test of the claim that the population mean satisfaction rating of ABC employees is different from 3.2, you choose a random sample of 13 surveys. The sample has a mean satisfaction rating of 3.3 and a standard deviation of 0.6. If the sample is from a normally distributed population with an unknown standard deviation, choose an appropriate test statistic for your hypothesis test on the population mean. Then calculate that statistic. Round your answers to two decimal places.Make sure to show your calculations for full credit.
The CEO wants to know if the female sales representatives at Company ABCare equally satisfied working at the company as the male representatives. They ask you to determine if there is an average difference in employee satisfaction by gender. Perform a t-test to determine how to answer this question using data from