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.
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
Similar orders to Problem Solving - Data Analysis (Quantitative Communication) Making Data-Driven Decisions
Anova on Excel using Hypothesis testing procedure
turning on developer mode on excel and then using excel add-ins data analysis to solve the hypothesis testing. Use the 5-step hypothesis testing procedure. The assignment must be done by the data analysis package.Type in correct answer where there is a "?"...
Statistics Practice Exam - Hypothesis Testing, Interval Estimation, Point Estimation
This is a practice exam with no solutions - I would like to get the solutions to study from. If concentration inequalities/minimax lower bounds are not familiar, those questions can be omitted. Looking for it to be done as fast as possible....
INTERVAL ESTIMATION TASK PROBLEMS LARGE SAMPLES
An auditor wants to estimate how many accounting errors There is a population of financial reports. Select a sample of 500 Report and find an average of 65 errors with a standard deviation of 5 errors. With this information: a) Construct an estimatio...
Apply statistical techniques to address research problems Perform regression analysis to address an authentic problem
Competencies In this project, you will demonstrate your mastery of the following competencies: Apply statistical techniques to address research problems Perform regression analysis to address an authentic problem Overview The purpose of this project...
operation risk - joint probability distribution for two department losses
This exercise has as goal to show how correlations affect the distributions of the total losses that a firm may incur. Consider a company with two divisions. In each one of the two divisions, the probability of one operational risk event happening in one...
Using a cumulative binomial table to find a sample size
The probability that a patient will experience an adverse event is 0.10 (10%). We want to size the study so that we have a sufficient number of patients to be sure (in this case, with 90% probability) to see at least one adverse event. What is the minimum ...
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.