Week 9 Assignment: Making Data-Driven Decisions Due: Week 9 Points: 150What you need to complete this assignment: The completed Week 9 Assignment Template. Download th

Week 9 Assignment: Making Data-Driven Decisions
Due: Week 9
Points: 150What you need to complete this assignment:

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:

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 TemplateSkill(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.

Submission Instructions: When you are ready to submit your completed Week 9 Assignment Template, click the Week 9 Assignment submission link, then click on Brows

Calculator

Sample Number Ounces in Bag Minimum 19.02
1 20.56 Maximum 20.79
2 19.37 Q 1 19.66
3 20.01 Q 2 19.925
4 19.99 Q 3 20.1725
5 19.65
6 19.94
7 19.47
8 20.19
9 19.72
10 19.51
11 19.52
12 19.99
13 20.28
14 19.02 Student should Use t-test
15 20.79 Mean 19.92
16 19.47 Median 19.9250
17 20.67 Standard Deviation 0.402598
18 19.69 n= 30
19 20.12 df= 29
20 20.29 Confidence Level= 0.95
21 19.92 t= 2.045
22 19.79 E= 0.150333
23 19.72 Confidence Interval Lower Limit 19.76767
24 19.92 Confidence Interval Upper Limit 20.0683
25 20.39 Null Hypothesis µ=20
26 19.49 Alternative Hypothesis µ<20
27 19.92 What type of Test Statistic did you use and why? t-test; population standard deviation not given
28 19.93
29 19.98
30 20.23
Conclusion: Is the claim supported? Why or why not? Fail to reject the null so there is not enough evidence to reject the hypothesis; we cannot support this claim.
If student uses z-test; provide feedback and grade for content.
Hypothesis Test
Null Hyp: m = 20 ← In cell C18, select the correct equality/inequality, enter null value in D18
= Alt Hyp: m < 20 ← In cell C19, select the correct inequality, enter same null value in D19
≥
≤ significance level = 0.05 ← Enter the level of significance of the test.
≠ test statistic = -1.11558
< critical value = -1.69913
> p-value = 0.13688
Since 0.1368797045 > 0.05 we fail to reject the null: m = 20

,

Week 9 Assignment: Snack Company Case Study (MGT)

Due Week 9 and worth 150 points

Imagine you are a manager at a major potato chip/snack company. Customers have begun to complain that the bags of the leading flavor of potato chip produced in your company contain less than the advertised twenty (20) ounces of product by weight. Your supervisor wants to solve the problem at hand and has asked you to investigate.

You have your employees pull thirty (30) bags off the line at random from all the shifts at the production plant. You ask your employees to measure the weight of chips there is in each bag. The results of your sample and your calculations are shown in the Excel file provided in the assignment instructions in Blackboard.

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 weight of chips in the bags.

1. Copy the sample mean, median, and standard deviation for weight of chips in the bags.

1. Copy the 95% Confidence Interval for the weight of chips in the bags.

1. Conduct a hypothesis test to verify if the claim that the bags contain less than twenty (20) ounces 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 there are less than twenty (20) ounces in a bag of chips, speculate on three (3) possible causes. Next, suggest the strategies to avoid the deficit in the future.

Or

4. If you conclude that the claim of less than twenty (20) ounces of chips per bag is not supported or justified, provide a detailed explanation to your boss about the situation. Include your speculation on the reason(s) behind the claim, and recommend one (1) strategy geared toward mitigating this issue in the future.

© 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 2

image1.png

,

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

image1.png

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018