Do My Homework
/
Homework Help Answers
/
Statistics Homework Help
/ Problem Solving - Data Analysis (Quantitative Communication) Making Data-Driven Decisions
Problem Solving - Data Analysis (Quantitative Communication) Making Data-Driven Decisions
Need help with this question or any other Statistics assignment help task?
This assignment is for MAT210.
There are 3 parts to this assignment please complete all three parts.
Week 9 Assignment: Making Data-Driven Decisions
Due: Week 9
Points: 150
What you need to complete this assignment:
The completed Week 9 Assignment Template. Download the Week 9 Assignment Template [DOCX].
A Case Study and Calculation Worksheet.
Steps to complete: In Week 9, complete and submit your assignment in Blackboard using the following steps:
STEP 1: Select the Case Study and Calculation Worksheet set that pertains to your program by clicking the appropriate links:
Accounting/Finance (ACC/FIN)
Week 9 Case Study - ACC/FIN [DOCX]
Week 9 Calculation Worksheet - ACC/FIN [XLSX]
Criminal Justice (CRJ)
Week 9 Case Study - CRJ [DOCX]
Week 9 Calculation Worksheet - CRJ [XLSX]
Human Resources (HR)
Week 9 Case Study - HR [DOCX]
Week 9 Calculation Worksheet - HR [XLSX]
Health Services (HSA)
Week 9 Case Study - HSA [DOCX]
Week 9 Calculation Worksheet - HSA [XLSX]
Information Technology/Information Systems (IT/IS)
Week 9 Case Study - IT/IS [DOCX]
Week 9 Calculation Worksheet - IT/IS [XLSX]
Management (MGT)
Week 9 Case Study - MGT [DOCX]
Week 9 Calculation Worksheet - MGT [XLSX]
Marketing (MKT)
Week 9 Case Study - MKT [DOCX]
Week 9 Calculation Worksheet - MKT [XLSX]
STEP 2: Using the data from your Case Study and Calculation Worksheet, complete the Week 9 Assignment Template [DOCX] .
STEP 3: Submit your assignment: The Week 9 Assignment Template
Skill(s) Being Assessed: Problem Solving - Data Analysis (Quantitative Communication)
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 the 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.
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.
The specific course learning outcome associated with this assignment is:
Recommend solutions based on the analysis of data using graphs, charts, or other visual means to different audiences.
Grading information for this assignment can be found in the Course Guide.
Additional Instructions:
MAT210 - Week 9 Assignment Template
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:
1. Construct a box-and-whisker plot for the provided data set. Copy each of the values needed to construct a box-and-whisker plot from the Excel worksheet provided and enter those numbers below.
Minimum
Maximum
Quartile 1
(Median of first half of the data set)
Quartile 2
(Median of data set)
Quartile 3
(Median of second half of the data set
Create the box-and-whisker plot in Excel and include a screen shot of the box-and-whisker plot below.
1. Copy the sample mean, median, and standard deviation from the provided Excel Worksheet and enter those below.
Mean
Median
Standard Deviation
1. Copy the 95% Confidence Interval from the Excel Worksheet provided and enter that below.
Lower Limit
Upper Limit
1. Use the results from the hypothesis test in the Excel worksheet provided to fill in the table below. Clearly state the logic of your test, the calculations, and the conclusion of your test.
Null Hypothesis (
Alternative Hypothesis (
What type of Test Statistic did you use and why?
Value of Test Statistic
P-value
Critical Value
Conclusion: Is the claim supported? Why or why not?
1. Evaluate the results of the hypothesis test and communicate the suggested solutions based on those results. (This section should be 1–2 pages). Provide the following discussion based on the conclusion of your test:
4. Provide a detailed explanation to your supervisor of how the results address the concern.
4. What is your suggested solution based on the results?
4. What decisions should be made based on the results? What should the next steps be?
© 2022 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.
Page 1 of 1
Week 9 Assignment: Case Study (ACC/FIN)
Due Week 9 and worth 150 points
Imagine you work in the finance department of a large company. Revenues seem to have increased for the company and the budget must be planned for the upcoming year. Your supervisor believes the new business plan has resulted in daily revenue that is greater than $100,000. Your supervisor wants to determine if they are correct and has asked you to investigate. If you can prove the daily revenue is greater than $100,000, your company can adjust the budget and begin implementing the next phase of the business plan.
You collect data from the past six months and then randomly sample 30 days of revenue. The results of your sample are shown in the Excel file below.
Write a two to three (2–3) page report using the provided template in which you:
1. Construct a box-and-whisker plot for the daily revenue.
1. Calculate the sample mean, median, and standard deviation for the daily revenue.
1. Construct a 95% Confidence Interval for the daily revenue.
1. Conduct a hypothesis test to verify if the claim that the daily revenue is greater than $100,000 is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test.
1. Provide the following discussion based on the conclusion of your test:
4. If you conclude that the daily revenue is greater than $100,000, provide three (3) possible arguments for adjusting the budget.
Or
4. If you conclude that the claim of the daily revenue is not supported or justified, provide a detailed explanation to your supervisor about why the budget should not be adjusted. Include your speculation on the reason(s) behind the claim.
© 2022 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.
Page 2 of 2
Calculator
Sample Number Daily Revenue Minimum 84246.00
1 $111,234 Maximum 147345.00
2 $132,456 Q 1 93249
3 $99,345 Q 2 99456
4 $127,294 Q 3 109485.5
5 $109,238
6 $147,345
7 $109,568
8 $104,345
9 $101,342
10 $93,492
11 $123,456
12 $85,899
13 $102,634
14 $93,339 Student should Use t-test
15 $90,233 Mean 103261.97
16 $84,246 Median 99456.0000
17 $119,346 Standard Deviation 15225.850746
18 $105,234 n= 30
19 $123,245 df= 29
20 $90,456 Confidence Level= 0.95
21 $99,845 t= 2.045
22 $89,323 E= 5685.426106
23 $94,232 Confidence Interval Lower Limit 97576.54056
24 $99,456 Confidence Interval Upper Limit 108947.3928
25 $93,294 Null Hypothesis µ=20
26 $99,456 Alternative Hypothesis µ p-value = 1.00000
Since 1 > 0.05 we fail to reject the null: m = 20
There are no answers to this question.
Login to buy an answer or post yours. You can also vote on other
others
Get Help With a similar task to - Problem Solving - Data Analysis (Quantitative Communication) Making Data-Driven Decisions
Related Questions
Similar orders to
Problem Solving - Data Analysis (Quantitative Communication) Making Data-Driven Decisions
Tutlance Experts offer help in a wide range of topics. Here are some
of our top services:
- Online writing help
- Online homework help
- Personal statement help
- Essay writing help
- Research paper help
- Term paper help
- Do my homework
- Online assignment help
- Online class help
- Dissertation help
- Thesis help
- Proofreading and editing help
- Lab report writing help
- Case study writing help
- White paper writing help
- Letter writing help
- Resume writing help
Post your project now for free and watch professional experts outbid each other in just a few minutes.