Uncategorized

Course Outcomes Organize data for analysis

Posted by

Comments Off

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.

Institutional Outcome

Quantitative and Scientific Reasoning – Follow established methods of inquiry and mathematical reasoning to form conclusions and make decisions.

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 weekly resource 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

Deadline

Deliverable items for the Portfolio Project will be required at different points during the course. Details for each submission are included below in the Deliverable Descriptions.

Deliverable Descriptions

Week 3: Part I

Due by the end of Week 3 at 11:59 pm, ET.

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.

Use the data from Table 1 below to answer Questions 1 – 7 below.

Table 1: Employee Data on 15 Sales Representatives at Company ABC

You send the survey to all 20 employees and 15 responds. Identify the population.
What level of measurement is the variable: Employee ID?
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?

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.

Ethnicity	Frequency
White
African American
Hispanic

Using the Ethnicity frequency table (from part A), create a pie chart 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.

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)?

Using the Age variable (Column E), create a histogram using the following frequency distribution.

Frequency Distribution
30-39
40-49
50-59
60-69

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.

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 Week 3 at 11:59 PM ET.

Week 5: Part II

Due by the end of Week 5 at 11:59 pm, ET.

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.

You want to randomly select two employee surveys to review.

If you randomly select two employee surveys with replacement, what is probability of selecting 2 males? Make sure to show your calculations for full credit.
If you randomly select two employee surveys without replacement, what is the probability of selecting 2 males? Make sure to show your calculations for full credit.

What is the probability of randomly selecting an employee survey that is female and hispanic? Make sure to show your calculations for full credit.

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.

In 2-3 sentences, explain what this z score tells us.

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.

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.

Submit your work for Part II in Blackboard by the end of Week 5 at 11:59 PM ET.

Week 6: Part III

Due by the end of Week 6 at 11:59 pm, ET.

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 ABC are 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 Table 1 above. Use a significance level of 0.05.

Write out the null and alternative hypothesis for this t-test.
The data for the Hypothesis Test can be found in Table 2 below. Enter the data into Excel.

Table 2: Employee Satisfaction Scores by Gender

Female	Male
3.4	3.5
4.8	4
3	4.5
4.1	4.6
4	4.1
4.1	3.7
3.7	3.7
	5

Use a significance level of 0.05. Run a 2-Sample Independent t-test using the data from Table 2. Paste the Excel output below.
Using your output in part C, what are the average employee satisfaction scores for male and female employees at Company ABC?

Gender	Average Employee Satisfaction
Males
Females

What is the p-value of the T-test?
What decision do you make regarding the null hypothesis?
How would you answer Managements question: Are female sales representatives at Company ABC as equally satisfied working at the company as male representatives? Explain in 2-3 sentences.

Submit your work for Part III in Blackboard by the end of Week 6 at 11:59 PM ET.

Week 7: Final Submission to ePortfolio

Due by the end of Week 7 at 11:59 pm, ET.

Corrections: This week you will incorporate instructor feedback and make any additional corrections to your Word document before submitting to your ePortfolio. Upload your Portfolio Project to the Institutional Outcome in your ePortfolio listed below. Use the following naming convention: MATH309 – Portfolio Project: NAME

Quantitative and Scientific Reasoning – Follow established methods of inquiry and mathematical reasoning to form conclusions and make decisions.

For directions on how to upload your project to your ePortfolio, please see Student Resources in Blackboard on the navigation pane.

For specific grading information, please refer to the Portfolio Project Grading Rubric below.

Week 7.5: Reflection

Due by the end of Week 7.5 at 11:59 pm, ET.

For the final piece of your Portfolio Project, you will reflect upon the course and how it directly relates to your future workplace. This reflection will be delivered as a Word document and should be 250-500 words in length.

Discuss if your findings confirm or refute your hypothesis.
Summarize the effect of these findings on your goal statement.
Describe related answers this data provides to your research question.
Explain how your findings inform the statement of problem you provide at the beginning.
Synthesize, analyze, and evaluate your findings in the context of the literature review you performed.

Upload and submit your final reflection to Blackboard. For specific grading information, please refer to the Portfolio Project Reflection Grading Rubric below.

CLICK ORDER NOW BELOW AND OUR WRITERS WILL WRITE AN ANSWER TO THIS ASSIGNMENT OR ANY OTHER ASSIGNMENT, DISCUSSION, ESSAY, HOMEWORK OR QUESTION YOU MAY HAVE. OUR PAPERS ARE PLAGIARISM FREE.*."