Scenario Frank has only had a brief introduction to statistics when he was in high school 12 years ago, and that did not cover inferential statistics. He is not confident in his ability to answer some of the problems posed in the course. As Frank's tutor, you need to provide Frank with guidance and instruction on a worksheet he has partially filled out. Your job is to help him understand and comprehend the material. You should not simply be providing him with an answer as this will not help when it comes time to take the test. Instead, you will be providing a step-by-step breakdown of the problems including an explanation on why you did each step and using proper terminology. What to Submit To complete this assignment, you must first download the word document, and then complete it by including the following items on the worksheet: Incorrect Answers Correct any wrong answers. You must also explain the error performed in the problem in your own words. Partially Finished Work Complete any partially completed work. Make sure to provide step-by-step instructions including explanations. Blank Questions Show how to complete any blank questions by providing step-by-step instructions including explanations. Your step-by-step breakdown of the problems, including explanations, should be present within the word document provided. You must also include an Excel workbook which shows all your calculations performed.

Assignment: Note: This Assignment consists of two parts. You will complete and submit Part 1 this week, and you will complete and submit Part 2 next week.Companies often develop and test hypotheses about their products. For example, car manufacturers will test their cars to determine fuel efficiency and miles per gallon. To ensure that products are safe and that they perform as advertised, regulatory and consumer protection groups also test companies’ claims.For this Assignment, you are working at a firm that conducts independent testing for heavy industry. Recently, an automobile manufacturer has been in the news for complaints about the highway gas mileage of their latest model minivan. You receive a contract from a consumer action group to test and write a report on the company’s claim that its minivans get 28 miles per gallon on the highway. The car company agrees to allow you to select randomly 35 low-mileage fleet minivans to test their highway mileage. Your test results gave you the following data: 29.7 24.5 27.1 29.8 29.2 27.0 27.8 24.1 29.3 25.9 26.2 24.5 32.8 26.8 27.8 24.0 23.6 29.2 26.5 27.7 27.1 23.7 24.1 27.2 25.9 26.7 27.8 27.3 27.6 22.8 25.3 26.6 26.4 27.1 26.1To prepare for this Assignment:Refer to the scenario above and the data that was provided by the car company (please see above)Submit Part 1 of your report according to the following prompts.Part 1: Sample Mean, Standard Deviation, and Confidence IntervalComplete the following and include your results and responses in your report:Include a brief introduction that provides a context for the assignment you have been given by your firm.Calculate a 95% confidence interval around your sample mean. (75 words, or 1 paragraph)Note: Include your calculations. If your calculations are submitted separately, make note of where they can be found.Is the company’s claimed mean inside your confidence interval? (75 words, or 1 paragraph)What does that result indicate about the company’s claim? (75 words, or 1 paragraph)3 prompts: 1 citation for each prompt. APA style, Times new roman 12, double space.