Question: Solve these problems on the attached Excel File and submit your completed Excel file on Blackboard. Problem 1 The table below shows the actual temperature

Solve these problems on the attached Excel File and submit your completed Excel file on Blackboard. Problem 1 The table below shows the actual temperature (in degrees Fahrenheit) of 6 cups of coffee bought from a gourmet coffee shop on 10 consecutive days. Federal health regulations require that coffee temperatures be between certain limits. Assuming the standard deviation for the temperature population is 9, use statistical process control (SPC) method to find the control limits for the average temperature of each sample and verify if the process is under control. Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 Cup 1 160 165 169 155 159 163 155 172 174 171 Cup 2 173 156 162 164 165 166 167 163 165 162 Cup 3 171 167 168 168 169 167 162 166 169 169 Cup 4 159 155 162 165 163 168 167 164 Cup 5 164 159 173 159 169 164 166 172 180 179 Cup 6 171 173 159 174 173 169 168 172 172 165 157 168 Recently the following data were collected: Day 11 Day 12 Day 13 Day 14 Cup 1 158 160 145 155 Cup 2 150 170 153 150 Cup 3 157 157 168 154 Cup 4 159 163 170 152 Cup 5 164 172 160 150 Cup 6 155 155 150 165 Using SPC method, find out whether the process is still under control. Problem 2 Solve the previous problem assuming that we do not know the standard deviation of the temperature population Day 10 Measure of Performance: Average temperature Day 1 Day 2 Day 3 Cup 1 160 165 169 Cup 2 173 156 162 Cup 3 171 167 168 Cup 4 159 165 157 Cup 5 164 159 173 Cup 6 171 168 173 X_bar Day 4 155 164 168 155 159 159 Day 5 159 165 169 162 169 174 Day 6 163 166 167 165 164 173 Day 7 155 167 162 163 166 169 Day 8 172 163 166 168 172 168 Day 9 174 165 169 167 180 172 171 162 169 164 179 172 Sigma= 9 Sample Size (n) - Number of Samples (m) X_bar_bar UCL -X_bar_bar+3(sigma/sqrt(n)) LCL =X_bar_bar-3(sigma/sqrt(n)) Is the process under control? What are recommended actions? Future samples: Day 11 Cup 1 158 Cup 2 150 Cup 3 Cup 4 159 Cup 5 164 Cup 6 155 X_bar 157 Day 12 160 170 157 163 172 155 Day 13 145 153 168 170 160 150 Day 14 155 150 154 152 150 165 Is the process still under control? What are recommended actions

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Differential Analysis Problems Attached Files: 7 Differential Analysis Problems.xIsx (9) (40.262 KB) Instructions: 1. The attached Excel file contains a series of Differential Analysis problems,...

Specific instructions to be followed carefully: Requirements (to be completed sequentially): All work should be done in Excel. The attached Excel file has three tabs. A. Start with the joumal papers...

MGMT 3115 EXAM 1 Cal State East Bay By completing and submitting the answer to the exam, the student fully understands the university's policy on academic dishonesty and agree to abide by this...

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

The data for this assignment is provided in the attached Excel file labeled "Weather data Plains." This data is from the weather station at the Experiment Station in Plain, Sumter County, Georgia....

Activity Based Costing (ABC) Background Information: Nick's Woodworking Inc. began operations in 2023 as a manufacturer of picnic tables with attached benches. During its first decade of operations,...

Java Fundamentals Lab 2 Java Fundamentals Lab Obiectives Write arithmetic expressions to accomplish a task Use casting to convert between primitive types Use a value-retuning library method and a...

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

Explain the significance of ROC with a diagram.

Waterfield Company has three decentralized segments. Its executive managers are looking for a way to measure the performance of each segment. Which of the following metrics might be used for this...

16 The formula to convert a temperature in degrees Centigrade (C) to degrees Fahrenheit (F) is F=Cx1.8+32 a Work out F when b i C=-15 Read what Marcus says. C=-20 Is Marcus correct? Explain your...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...