Please help me figure out how to do this precisely in Excel. Thank you

If you use the Queuing Computations spreadsheet to perform calculations, please attach a printout of the Table of Results from the spreadsheet. Your inputs and outputs should be clearly visible on the table. In the table, label the experiments to correspond to the problem number that the analysis applies to. Please label the answers to each question clearly, ideally summarized on one sheet of paper. If rounding is necessary, round any decimal numbers to 3 decimal places. 1. (10 points) There is only one copying machine in the student lounge of the business school. Students arrive at the rate of =45 per hour (according to a Poisson distribution). Copying takes an average of 30 seconds, or =120 per hour (according to a negative exponential distribution). Compute the following: (a) The percentage of time that the machine is used. (b) The average length of the queue. (c) The average number of students in the system. (d) The average time spent waiting in the queue (in seconds). (c) The average time in the system (in seconds). 2. (10 points) Angie Kuno has been collecting data at the TU student grill. She has found that, between 5:00 p.m. and 7:00 p.m., students arrive at the grill at a rate of 25 per hour (Poisson distributed) and service time takes an average of 2 minutes (negative exponential distribution). There is only 1 server, who can work on only 1 order at a time. (a) What is the average number of students in line? (b) What is the average time a student is in the grill area? (c) Suppose that a second server can be added to team up with the first (and, in effect, act as a single fast server). This would reduce the average service time to 90 seconds. How would this affect the average time a student is in the grill area? (d) Suppose a second server is added and the 2 servers act independently, with each taking an average of 2 minutes. What would be the average time a student is in the system? 3. (5 points) During the evening hours, an average of 42 customers can be found in Shirin's Caf. About 80 customers arrive each hour. Using Little's Law, howlong (in minutes) does each customer stay at the caf? A computer processes jobs on a first-come, first served basis in a time-sharing environment. The jobs have Poisson arrival rates average 0.6 jobs per minute. The objective in processing these jobs is that they spend no more than 5 minutes, on average, in the system. Assuming exponential service times, how fast does the computer have to process jobs (in minutes), on average, to meet this objective? (5 points) Susan Anderson's Car Wash takes a constant time of 2 minutes in its automated car wash cycle. Autos arrive following a Poisson distribution at the rate of 24 per hour. Susan wants to know: (a) The average waiting time in line (in minutes). (b) The average length of the line. 6. (12 points) Create a set of six pictures (from the Internet or some other source) that fall into some kind of category (for example, female celebrities, cities in Missouri, flags from different countries, etc.). Size the photos such that their sizes are approximately equal. Incorporate the pictures into an Excel sheet. Specifically, create a drop-down list in cell D3 from which the user can select one of the six pictures (using an appropriate description for each picture). Once a picture description is selected, have Excel display the appropriate picture in cell F4. (Make sure that F4 is large enough to fully contain the picture