Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello. Could you please show me how this is done on Excel step by step? Thank you so much clpccd.instructure.com 1 (23032) Fall 2020 Topic:

Hello. Could you please show me how this is done on Excel step by step? Thank you so much

image text in transcribed
clpccd.instructure.com 1 (23032) Fall 2020 Topic: Discussion - Ch. 7 - Calculate This! Project-based Course Overview have access to: Discussion - Ch. 7 - Calculate This! At 2 Hi Class, Time to practice sampling and sampling distribution. Packaging: A variety of packing solutions exist for products that must be kept within a specific temperature range. Cold chain distribution is particularly useful in the food and pharmaceutical industries. A packaging company strives to maintain a constant temperature for its packages. It is believed that the temperature for its packages follows and normal distribution with a mean of 5 degrees Celsius and a standard deviation of 0.3 degrees Celsius. Inspectors take weekly samples for 5 weeks of eight randomly selected boxes and report the temperature in degrees Celsius. The data is given below: Week 1 Week 2 Week 3 Week 4 Week 5 3.98 5.52 5.79 3.98 5.14 4.99 5.52 6.42 5.79 6.25 5.15 4.98 4.88 5.77 4.89 5.23 4.28 4.02 4.3 5.99 4.77 5.12 4.76 5.41 6.35 5.21 5.08 5.08 4.55 5.11 5.51 5.86 4.58 6.02 6.02 4.95 4.95 5.44 5.95 4.28 1. Construct an x chart. Plot the five weekly sample means on the x chart. 2. Are any points outside the control limits? Does it appear that the process is in control? Explain. Due Friday: Complete the following two questions. Show all your work. You can use Excel to create the charts. Due Sunday: Review and you can respond to your group member's posts, respond to one of your peer's posts Rubric . Complete posts by each due date, original post by Friday and respond to one peer's post by each Sunday. All required posts, one original and at least two responses are required to earn credit. All calculations are shown step by step and any explanations as needed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Applications For The Management, Life And Social Sciences

Authors: Ronald J. Harshbarger, James J. Reynolds

12th Edition

978-1337625340

More Books

Students also viewed these Mathematics questions