Google sheet:

https://docs.google.com/spreadsheets/d/18AX5nNUPSnK95EeZgYGhHP1THvvLA13p/edit?usp=sharing&ouid=113257864853398549491&rtpof=true&sd=true

Excel Project #2 This is a multi-part assignment using various functions in Microsoft Excel. You should start the project as soon as it becomes available. You can find all ofthe procedures for performing the tasks required for this assignment in the Excel Notes folder in Canvas. Do not hesitate to contact me if you have any questions. For each exercise, you must: 0 Copy and paste the output (not the original input data) to the included template 0 Organize the output in the order of the questions (e.g., Ex #1, Ex #2, etc) 0 Submit the final Word file with the output to Canvas in the appropriate Excel Project folder Exercise #1 A small company surveyed 200 of its customers to get their opinion regarding the customer service for their online sales department. Customers were asked to rate their online customer service experience from 1 to 5, with 1 = very dissatisfied to 5 = very satisfied. Use the data from the Excel file Customer Service.xlsx and do the following: a) Create a probability distribution for the ratings b) Create a probability histogram for the ratings Exercise #2 A manufacturer of metal pistons finds that on average, 12% of the pistons are rejected because they are either oversized or undersized (e.g., rejects). Suppose that a batch of 10 pistons is selected and the number of rejected pistons is recorded. a) Assuming that the batch of 10 pistons may have X = 0, 1, 2, , 10 rejects, create a probability distribution for the number of rejected pistons in a batch of 10. b) Create a probability histogram for the distribution of rejected pistons in a batch of 10. c) Find the probability that a batch of 10 pistons will contain exactly 2 rejects. d) Find the probability that a batch of 10 pistons will contain no more than 2 rejects. e) Find the probability that a batch of 10 pistons will contain at least 2 rejects