Description
Question 1.
1. The vice-president of administration at your company wonders whether employees are taking adequate amounts of vacation time. Employee burnout is a concern. Research suggests that an employee taking less than 1.4 weeks of vacation annually is very likely to experience burnout. You are asked to analyze the employee vacation data and conduct a hypothesis test with the following results:
t = 2.93
p = 0.0084
What factors should the vice-president consider in determining the presence of employee burnout?
Do employees take more than 1.4 weeks of vacation?
What reasons should the vice-president provide to the president to justify the recommendation on employee burnout?
Based on the data, is the presence of employee burnout an issue that may negatively impact the company
Question 2:
Data set 2 spreadsheet presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks. The company’s operations manager believes that the number of defects produced by the process is less than seven defective flash drives per week. Use this online calculator (or any statistical package that you are comfortable with) to construct a hypothesis test to verify the operations manager’s claim. Your hypothesis test should include null and alternative hypotheses, a t test statistic value, a p value, a decision, and a conclusion. Submit a Word file that includes the hypothesis test.
Submit your assignment here. Make sure you’ve included all the required elements by reviewing the guidelines and rubric.
Unformatted Attachment Preview
Week
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
#Flashdrives
6
7
6
5
7
5
6
6
8
9
9
7
5
6
8
8
9
7
6
8
5
7
6
8
10
9
7
8
7
6
Number of Defective Flashdrives for 30 Weeks
Flashdrives for 30 Weeks
QSO 510 Data Set Homework Guidelines and Rubric
Listen
Two data sets are used during this course for three homework assignments:
Dictionary
Module Two, Descriptive Statistics: Data set 1 presents a sample of annual salaries for recently hired plant operators at a chemical manufacturing company. Use Excel’s ToolPak (or any
Translate
statistical package that you are comfortable with) to compute descriptive statistics for the data. Submit your statistical output from Excel, which
should include values for the mean,
median, mode, sample variance, and sample standard deviation.
Module Four, Correlation and Regression: Data set 2 presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks. Use
Excel’s Analysis ToolPak (or any statistical package that you are comfortable with) to compute the regression equation for predicting the number of defective flash drives over time (in
weeks), the correlation coefficient r, and the coefficient of determination R2. Submit your statistical output from Excel, which should include values for the slope, y-intercept, regression
equation, r, and R2.
Module Six, Hypothesis Testing: Data set 2 presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks. The
company’s operations manager believes that the number of defects produced by the process is less than seven defective flash drives per week. Use this online calculator (or any
statistical package that you are comfortable with) to construct a hypothesis test to verify the operations manager’s claim. Your hypothesis test should include null and alternative
hypotheses, a t test statistic value, a p-value, a decision, and a conclusion. Submit a Word file that includes the hypothesis test.
Specifically, the following critical elements must be addressed:
I. Methodology
II. Analysis
What to Submit
For the Modules Two and Four assignments, submit both a 1-page Word document and an Excel spreadsheet. For the Module 6 assignment, submit only a 1-page Word document.
Data Set Homework Rubric
Criteria
Exemplary (100%)
Methodology
Meets “Proficient” criteria, and
articulation is comprehensive
and astute methodology
Proficient (90%)
Needs Improvement (70%)
Clearly and accurately
articulates methodology
Articulation of methodology is
unclear and/or inaccurate
Not Evident (0%)
Does not articulate
methodology
Value
40
Criteria
Exemplary (100%)
Proficient (90%)
Needs Improvement (70%)
Not Evident (0%)
Value
Analysis
Meets “Proficient” and the
quality of the statistical
analysis is above minimum
quality standards for
competent
Represents competency with
respect to the statistical
analysis
Statistical analysis is evident,
but does not meet standards
Statistical analysis is not
evident
50
Articulation of Response
Submission is free of errors
related to citations, grammar,
spelling, syntax, and
organization and is presented
Submission has no major errors
related to citations, grammar,
spelling, syntax, or organization
Submission has major errors
related to citations, grammar,
spelling, syntax, or organization
that negatively impact
Submission has critical errors
related to citations, grammar,
spelling, syntax, or organization
that prevent understanding of
10
readability and articulation of
main ideas
ideas
in a professional and easy to
read format
Total:
100%
QSO 510 Scenario Analysis Guidelines and Rubric
Knowledge of statistics is important foundational knowledge for analyzing data. Equally important is what you can do with that information. An overarching goal of this course is to consider
how statistics informs decision making, or data-based decision making. Throughout this course, you will be asked to make decisions and then to consider the impact of those choices. Whether
in stock trading, in car sales, or on the production floor, the decisions you make as a business professional should be directly influenced by the data available to you. Careful analysis is the key to
data-based decision making.
Each module task below provides a scenario and a list of questions for you to answer using data-based decision making.
Module Two: Stock Options
Module Four: Cars Sold
Module Five: Computer Chips
Module Six: Vacation Time
Module Eight: Promotion
Module Ten: Printing Equipment
Specifically, the following critical elements must be addressed:
I. Main Elements
II. Integration and Application
III. Analysis
IV. Critical Thinking
What to Submit
Your analysis of the scenario must be submitted as a 1- to 2-page Microsoft Word document with double spacing and 12-point Times New Roman font.
Scenario Analysis Rubric
Criteria
Exemplary (100%)
Proficient (90%)
Needs Improvement (70%)
Not Evident (0%)
Value
Main Elements
Thoroughly addresses each of
the main elements found in the
individual prompts and guiding
questions for each scenario
Adequately addresses all of the
main elements found in the
individual prompts and guiding
questions for each scenario
Addresses most but not all of
the main elements found in the
individual prompts and guiding
questions for scenario
Addresses less than half of the
main elements found in the
individual prompts or guiding
questions for each scenario
20
Criteria
Exemplary (100%)
Not Evident (0%)
Value
Integration and Application
All of the course concepts are
correctly applied
Most of the course concepts
are correctly applied
Some of the course concepts
are correctly applied
Does not correctly apply any of
the course concepts
20
Analysis
Meets “Proficient” and the
quality of the statistical
analysis is above minimum
quality standards for
competent
Represents competency with
respect to the statistical
analysis
Statistical analysis is evident,
but does not meet standards
Statistical analysis is not
evident
40
Critical Thinking
Draws insightful conclusions
that are thoroughly defended
with peer-reviewed evidence
and examples
Draws informed conclusions
that are justified with evidence
based on peer-reviewed
research
Draws logical conclusions, but
does not defend with evidence
based on peer-reviewed
research
Does not draw logical
conclusions
10
Articulation of Response
Submission is free of errors
related to citations, grammar,
spelling, syntax, and
Submission has no major errors
related to citations, grammar,
spelling, syntax, or organization
Submission has major errors
related to citations, grammar,
spelling, syntax, or organization
Submission has critical errors
related to citations, grammar,
spelling, syntax, or organization
10
that negatively impact
readability and articulation of
main ideas
that prevent understanding of
ideas
organization and is presented
in a professional and easy to
read format
Proficient (90%)
Needs Improvement (70%)
Total:
100%
Purchase answer to see full
attachment
