Sign In
Not register? Register Now!
Pages:
3 pages/β‰ˆ825 words
Sources:
No Sources
Style:
Other
Subject:
Mathematics & Economics
Type:
Coursework
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 15.55
Topic:

Making Data Driven Decisions

Coursework Instructions:

eek 9 Assignment: Making Data-Driven Decisions
Due: Week 9
Points: 150
Skill(s) Being Assessed: Problem Solving - Data Analysis (Quantitative Communication)
Criteria for Success: In this assignment, you will:
Construct an accurate box-and-whisker plot for the provided dataset.
Accurately calculate the mean, median, and standard deviation for the provided data set.
Construct an accurate 95% Confidence Interval for the provided data set.
Conduct a hypothesis test to verify if the claim in the provided scenario is supported.
Clearly state the logic of your test, the calculations, and the conclusion of your test.
Accurately evaluate the results of the Hypothesis Test and communicate the suggested solution(s) based on those results.
What to Submit / Deliverables: The assignment includes a case study and Excel data set that you will use to complete the Week 9 Assignment Template [DOCX].
What is the value of doing this assignment? This assignment gives you the opportunity to apply the statistical concepts and methods you have learned throughout the course to a current real-world problem. You will continue to practice your problem-solving skill through analysis of data—examining how others use descriptive statistics, and creating your own mathematical visuals in order to analyze and draw conclusions based on this data.
You will also practice taking initiative in putting together a report on the problem identified and sharing your findings with your supervisor in the workplace. The activity will allow you to go through the process of making informed decisions based on data in your chosen field. This will additionally help you practice communicating effectively—a skill you can use in your personal and professional lives every day.
As you work to complete this assignment, you will continue to practice results-driven strategies. You will have the opportunity to engage in a statistical process while working toward a specific goal, use measurement to report results, and consider the quality and integrity of data and the ways it can be used to effectively communicate solutions.
Your goal for this assignment is to: Apply the statistical concepts and methods you have learned to a current real-world problem by using your problem-solving, initiative, and results-driven skills to complete a case study that incorporates the data analysis, conclusions, and solutions you have reached.
What you need to complete this assignment:
The completed Week 9 Assignment Template. Download the Week 9 Assignment Template [DOCX]
A Case Study and Data Set
Steps to complete:
STEP 1: Select the case study and data set that pertains to your program by clicking the appropriate links:
Accounting/Finance (ACC/FIN)
Week 9 Case Study - ACC/FIN [DOCX]
Week 9 Data Set - ACC/FIN [XLSX]
Criminal Justice (CRJ)
Week 9 Case Study - CRJ [DOCX]
Week 9 Data Set - CRJ [XLSX]
Human Resource (HR)
Week 9 Case Study - HR [DOCX]
Week 9 Data Set - HR [XLSX]
Health Services (HSA)
Week 9 Case Study - HSA [DOCX]
Week 9 Data Set - HSA [XLSX]
Information Technology/Information Systems (IT/IS)
Week 9 Case Study - IT/IS [DOCX]
Week 9 Data Set - IT/IS [XLSX]
Management (MGT)
Week 9 Case Study - MGT [DOCX]
Week 9 Data Set - MGT [XLSX]
Marketing (MKT)
Week 9 Case Study - MKT [DOCX]
Week 9 Data Set - MKT [XLSX]
STEP 2: Using the data from your case study and data set, complete the Week 9 Assignment Template [DOCX].
STEP 3: Submit your assignment:
The Week 9 Assignment Template
Note: This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.
Grading information for this assignment can be found in the Course Guide.

Coursework Sample Content Preview:
Week 9 Assignment Template
Making Data Driven Decisions (150 Points)
Name: 
Title of Presentation: 
 Write a two to three (2–3) page report in which you:
 
Construct a box-and-whisker plot for the provided data set. Calculate each of the values needed to construct a box-and-whisker plot and enter your calculations below.
Minimum

Maximum

Quarter 2
(Median of data set)

Quarter 1
(Median of first half of the data set)

Quarter 3
(Median of second half of the data set

84,246

147345

99456

93249

106235

Create the box-and-whisker plot in Excel and include a screen shot of the box-and-whisker plot below.
Calculate the sample mean, median, and standard deviation of the provided data set in Excel and enter your calculations below.
Mean

Median

Standard Deviation

103,261.9667

99,456

15,225.8505

Construct a 95% Confidence Interval in Excel for the provided data set and enter your calculations below.
Lower Limit

Upper Limit

97,476.54

108947.4

Conduct a hypothesis test to verify if the claim is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test.
Null Hypothesis (H0)

The null hypothesis states that the average daily revenues generated by the company is equal to 100,000 (Ho: U=100,000)

Alternative Hypothesis (H1)

The alternative hypothesis states that the average daily revenue generated by the company was higher than US$ 100,000, (HA: U>100,000)

What type of Test Statistic did you use and why?

T-statistic is commonly used to facilitate comparison of the hypothetical mean with the actual mean.

Value of Test Statistic

1.1734

P-value

0.125085

Critical Value

0.05

Conclusion: Is the claim supported? Why or why not?

The claim is not supported as the generated p-value is higher than the critical value. IN order for the researcher to accept the alternative hypothesis, the t score should have a p value that is lower that the set criti...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:

πŸ‘€ Other Visitors are Viewing These Other Coursework Samples: