CompetencyDemonstrate the use of the normal distribution, the standard normal distribution, and the central limit theorem for calculating areas under the normal curve and exploring these concepts in real life applications.ScenarioFrank 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 SubmitTo complete this assignment, you must first complete the attached word document, and then complete it by including the following items on the worksheet:Incorrect AnswersCorrect any wrong answers. You must also explain the error performed in the problem in your own words.Partially Finished WorkComplete any partially completed work. Make sure to provide step-by-step instructions including explanations.Blank QuestionsShow 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.

Using the attached data ("Car Weight and MPG.sav"), compute and interpret the relationship between:Car Weight (“Weight”) and miles per gallon consumed (“CityMPG”)For this regression analysis, state the following:A clear research question appropriate for a linear regression: (e.g., Is X a significant predictor of Y?")Null and research hypotheses that align clearly and neatly with your RQ.Description of the variables used.Your dependent and independent variables. (Clearly explain your rationale as to why which is which.)State the sample size, along with the mean, standard deviation, and range (min & max) for each variable, in a paragraph format. (Do not just include a table, and not talk about it.)State the rationale for applying regression analysis in this investigation using appropriate readings and resources in Module 5. (Please cite specific references.)Findings in an APA format. (This includes the wording of the finding and the tables/figures included.)Use the following link to provide the template: https://www.slideshare.net/plummer48/reporting-a-single-linear-regression-in-apaAlso add a clear interpretation of the R-square value in your finding. See last page: https://www.sheffield.ac.uk/polopoly_fs/1.531434!/file/MASH_simple_linear_regression_SPSS.pdfNote: Even if the p-value in the SPSS output shows ".000," write it out as "p < .001."Write out your regression equation, and state the predicted miles per gallon for cars that weighs 3,000 and 4,000 pounds. (Clearly show the calculations and steps involved.)Include the SPSS output in your appendix.Car Weight and MPG.sav