Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
image text in transcribed
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

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

Path To College Mathematics (Subscription)

Authors: Elayn Martin Gay

1st Edition

0134654560, 9780134654560

More Books

Students also viewed these Mathematics questions