Question Attached - Rules Belowperform certain calculations discussed in the assigned reading in order to derive an answer for each problem.use Microsoft Excel to complete each problem and submit a single Excel spreadsheet that contains a separate worksheet (i.e., separate tab) for each problem.to show all calculations or other work performed to derive your answer(s) for each problem.have your spreadsheet be fully functional (i.e., configured to allow the reader to not only see all numerical values, but also be able to see the underlying formula associated with each calculated value).to label your work in each worksheet to clearly identify the nature of each piece of data or calculated value.No credit will be granted for problems that are not completed using Excel, for which your Excel worksheet is not fully functional, or for which you have not shown all of the calculations or other work performed to derive your answer(s). You may refer to the course textbooks, supplemental reading materials, online information, and your own notes in conjunction with completing the homework assignments. Once you have completed the necessary calculations to solve each problem and answer the associated questions, select the hyperlink provided to submit your Excel spreadsheet for grading.

Assignment Details You are a Business Analyst working for the ABC Ball Bearing company. An hour ago, you sent an order of 74 boxes of your A1 ball bearings to a customer on your delivery truck. You have just found out that your truck is going to go over a bridge that has a weight limit of 11,500 lbs. You need to determine if your truck will safely make it over the bridge. If you determine that the truck cannot make it over the bridge, you will need to call the driver and have him/her turn back. The plant manager has told you that an empty delivery truck with the driver weights about 8500 lbs. You have 30 boxes of the A1 ball bearings in your plant. You immediately had them weighed. The weights of the boxes are: 40.1 41.1 39.5 40.1 39.1 41.2 37.6 39.1 41.6 40.8 43.2 38.9 38.1 43.5 36.9 39.1 40.5 41.2 37.6 44.0 38.0 39.8 42.1 38.6 41.3 43.7 36.9 43.6 38.1 40.2 Calculate the Mean and the Standard Deviation of this sample. Using the normal distribution curve, calculate the probability the truck’s total weight is under 11,500 lbs. What is your decision? Will you allow the truck to continue or will you call the driver and tell him/her to turn back? Show all of your calculations. Discuss several types of sampling: e. convenience sampling, random sampling, stratified sampling, systematic sampling or cluster sampling. Discuss which type of sampling is used in this scenario. Discuss what sampling bias is. Do you believe that using the 30 boxes in your warehouse caused sampling bias? What does the central limit theorem state and why is it important to solving this problem. Is the thirty boxes of ball bearings enough to predict the probability of safely going over the bridge? Use the template provided to complete a 5-page report (excluding the cover page). NOTE: Please delete all instructions and examples before submitting your work. Use this template to complete your assignment.

1. (HW 1) -2.1,2.2, 2.3, 2.4 (50 Questions))2. (HW 2)-2.5, 2.6, 2.7 (40 Questions)3. Exam 1 4. Homework (HW 3) 3.1, 3.2, 3.3 (40 Questions)5. (HW 4):3.4, 3.5, 3.6 (35 Questions)6. Exam 27. Homework (HW 5):4.1,4.2,4.3,4.4,4.5 (75 Questions)8. Exam 39. (HW 6): 5.1,5.2,6.3,6.5,8.1,8.2,8.3 (52 Questions)