Question

USING EXCEL TO THINK LIKE AN ENGINEER. Text book

Please use excel to answer the question.

Please do not attempt if you are new to excel, an example has been provided. You guys have gotten my last 4 answers wrong.

-Assume that your company has received an order for 100,000 assemblies each consisting of two subassemblies. The two subassemblies end-to-end to create an assembly that is to be 3,000 mm in length with a lower specification limit of 2,995 mm upper and specification limit of 3,003 mm.

-Your company has two machines to make these subassemblies.

-Machine A makes Subassembly A, measures of machine A found that subassemblies produced had a mean length of 1,000 mm with a standard deviation of 3 mm.

-Machine B makes Subassembly B. Measurements on machine B have found it makes parts with a mean of 2,002 mm and a standard deviation of 2 mm. The order is for 100,000 assemblies.

Answer the following.

A). Given the current situation, if 100,000 assemblies are manufactured, how many will not meet the specification?

B) What changes would you recommend to the system to reduce the number of out-of-specification parts to less than 2,000?

An example has been provided with figures 1-14 shown.

I have already done the problem and would like to check my work, so please do it correctly, and use excel.

Thank you.

USE EXCEL

ooo T-Mobile F 5:26 PM riolearn.org Approaching the objectives Up to this point, all models you have constructed are those considered to be deterministic. A deterministic model is one where, given an independent variable guaranteed output is always certain. Ohm's Law (E li is an example. In a perfect world, multiplying current by resistance, with the ability to measure without erro would result in the same voltage every time However, the world is filled with error and random outcomes. Measuring devices sometimes produce errors, machines have variability because their gears may not line up perfectly, the individuals that operate the machines will never do exactly the same thing twice, etc. Hence, the output is variable and random. Such processes are said to be stochastic Many different types of stochastic processes are possible, depending on the type of distribution used to describe the behavior. The flip of a coin where the outcome is either heads or tails is considered a binomial distribution. The arrival of individuals to a queue follows the Poisson distribution. any distributions can be used to derive a stochastic model. One key distribution i called the normal distribution, which you learned about in Lesson 14. This distribution is important because so many processes follow the normal distribution including manufacturing processes. Below is an example of a stochastic model using a normal distribution. It is a classic example of a quality control problem as it determines what portion of the output from a machine will meet the specification. Follow along in Excel and work the model as you read the lesson textbook readings. Assume a client has ordered 10,000 pieces of bar stock that is to be 500 mm long ith tolerance of 3 mm. These parts are made on a band saw, and the length of the first 100 parts has been measured. It is discovered that the machine is makin the parts with an average length of 498 mm and a standard deviation of 3 mm. If nothing is done with the setup, how many parts will fail to meet the specification? To model this scenario, you will need to perform the following tasks in an Excel worksheet: Enter the problem statement. Define the cells that wi contain mean and standard deviation. With these cells, you ask the question: "How will the number of out-of-specification parts change as you modify the mean and standard deviation?" Develop a vector of random measurements Create a worksheet section that generates histogram parameters Generate a dynamic histogram that will change as you modify machine characteristics Dynamically graph the results Review Figure 1. You will notice cells entered for your name, clas and the problem statement in the upper right corner. Cells B8 and B9 contain the mean and the standard deviation. You will adjust these model parameters as you analyze the process A formula has been entered in Cell L1 to generate a random variable. You can see the Excel formula in the formula bar of the Excel worksheet The formula is this format

Answer 1

#include
#include
#include
#include
#include
#include
#include
#include
#include
#include
#include

using namespace std;

// world Constants and Variables
int PORT = 55555, node, s_sockfd , s_clilen, s_n;
struct message;
struct tokenone = empty token, two = token with information
int valid;
message msg;
int checksum;
int turn;
};
struct sockaddr_in s_serv_addr, s_cli_addr;

// perform Definitions
void getToken(char* token);
void sendToken(char* token);
bool messageExists();
void createServerSocket();
void error(string msg);

int main(int argc, char** argv) North American nation. Erase it and alter token sort to one
                   token[2] = -1;
                   token [3] = -1;
                   token[4] = -1;
                   token[0] = 1;
               } else if(token[3] == node) North American nation. Display it
                   cout << "--------------\n";
                   cout << "From: " << token[2] << endl;
                   //cout << token.msg.message << endl;
               }
           } else if(token[0] == 1) doesn't contain a message
               if(messageExists()) there's a message to send. Load message into token and alter sort

                   // Open file ./message.tok
                   // browse initial line because the receiver
                   // remainder of file is message
                     
                   token[0] = 2;
               }
           } else may be a sort we tend to don't understand
               // don't be concerned concerning this token, simply forward it
           }
           sleep(2);
           // Send token on it's merry manner
           sendToken(token);
       }

come (EXIT_SUCCESS);
}

void getToken(char* token) produce a server socket on PORT
   * Listen on socket till message is received
   * If message is of sort token load it into token
   * shut socket
   * come crammed token
   */
listen(s_sockfd,5);
s_clilen = sizeof(s_cli_addr);
newsockfd = accept(s_sockfd,
(struct sockaddr *) &s_cli_addr,
(socklen_t*) &s_clilen);
if (newsockfd < 0)
error("ERROR on accept");
bzero(token,256);
S/N = read(newsockfd,token,255);
if (s_n < 0) error("ERROR reading from socket");

   cout << "I've got the token\n";
}

void createServerSocket() information processing = "192.168.0.";
  
   // begin Socket Vars
   int sockfd, n;
struct sockaddr_in serv_addr;
struct hostent *server;
   // finish Socket Vars
      
   // realize consequent node to send to
   to = node + 1;
   std::ostringstream sin;
   sin << to;
   std::string val = sin.str();
   ip.append(val);
  
   /*
   * produce socket affiliation to next node
   * Send token
   * shut socket
   */
sockfd = socket(AF_INET, SOCK_STREAM, 0);
if (sockfd < 0)
error("ERROR gap socket");

   try information processing << " causation to 192.168.0.1\n\n";
       server = gethostbyname("192.168.0.1");
   if (server == NULL) sop = false;
   come ret;
}

void error(string msg)