“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

You are a senior engineer in a company for making motor parts. While doing research, you realize that 5% the parts coming off an assembly line are defective, 78% are moderately okay and the rest 17 out of 100 are perfect. If the sampling was binomially distributed, while determining distribution of defective parts what is the chance of getting 40% parts being defective. Show all calculations in Excel. Thanks for the help.

Solved by K. F. in 15 mins

I need help splitting excel workbook in to 3 parts

Solved by V. B. in 18 mins

10 percent of the products manufactured are defective. Assuming a binomial probability distribution, calculate the probability of exactly 4% parts being defective. Determine the distribution of defective parts.

Solved by A. J. in 25 mins

I have 3 columns in excel. The first column is service type and it has a background table (data validation) with Parts replacement & Preventative maintenance in it. The next column is parts replacement and the third column is preventative maintenance. (each of those columns also has a background list). How can I make it so that when parts replacement is picked in the service type column there are no choices in the preventative maintenance column, but there are choices in the parts replacement column. (and vice versa ie. when preventative maintenance is chosen there are no options in the parts replacement column)

Solved by E. H. in 16 mins

I'm trying to adding text of multiple cells and trim the irrelevant parts.

Solved by D. Q. in 15 mins