What trend do you see takes place to the confidence interval as the confidence level rises? Explain mathematically why that takes place.

This is a 2 part project. I also attached details as word doc. Week 6 Assignment: Course Project Part I Required ResourcesRead/review the following resources for this activity:•Textbook: Chapter 8•LessonScenario/SummaryYou will complete a Course Project in this course that will span two weeks. The final project is due the Sunday of Week 7. The project is broken into two parts. You will complete Part I in Week 6 and Part II in Week 7. In Week 6, Confidence Intervals will be explored and in Week 7 Hypothesis testing will be explored.A confidence interval is a defined range of values such that there is a specified probability that the value of a parameter lies within the interval.In Part I of this project, you will pick a topic, complete research and provide a write-up that includes calculations. Round all values to two decimal places when appropriate.Deliverables1.Choose a Topic where you can gather at least 50 pieces of data. Examples of Topicsa.The Golden Gate Warriors Points Per Game in 2016 (use the points scored in the first 50 games).b.High School Graduation Rates by State (use the graduation rates for all 50 states)c.Average Tuition Rates in the US (You have to find the tuition rates of 50 college/universities).d.The prices of a hotel room per night in a major city (You have to find the price of the same night of hotels in one city).e.Weights of 50 babies at birth.2.Write at least a 1-Page ReportOpen a Word Documenta.Introduction–Provide a description of your topic and cite where you found your data.b.Sample Data—Include a 5×10 table including your 50 values in your report. You must provide ALL of your sample data.c.Problem Computations—For the topic you chose, you must answer the following:•Determine the mean and standard deviation of your sample.•Find the 80%, 95%, and 99% confidence intervals.•Make sure to list the margin of error for the 80%, 95%, and 99% confidence interval.•Create your own confidence interval (you cannot use 80%, 95%, and 99%) and make sure to show your work. Make sure to list the margin of error.d.Problem Analysis—Write a half-page reflection.•What trend do you see takes place to the confidence interval as the confidence level rises? Explain mathematically why that takes place.•Provide a sentence for each confidence interval created in part c) which explains what the confidence interval means in context of topic of your project.•Explain how Part I of the project has helped you understand confidence intervals better?•How did this project help you understand statistics better?Required SoftwareMicrosoft Office: Word and ExcelWeek 7 Assignment: Course Project Part II Required ResourcesRead/review the following resources for this activity:•Textbook: Chapter 9•LessonScenario/SummaryThis week you will submit the second part of the course project. You completed Part I in Week 6 and will complete Part II this week. Hypothesis Testing is the use of statistics to determine the probability that a given claim is true.In Part II of this project, you will choose a data set, review claims and perform hypothesis testing and make a decision. You will then complete a write-up that includes the calculations.The government logs the number of documented births, deaths, marriages and divorces; however, it is possible to have undocumented cases. In part II of this project, you are going to test claims about total births, deaths, marriages and divorces.Deliverables1.Choose a Data Set. a.Go to https://www.cdc.gov/nchs/products/nvsr.htm (Links to an external site.) b.In the search bar type: Births, Marriages, Divorces, and Deathsc.Pick a DataSet and download the PDF document and make note of the volume, number, and date. For example you could use the National Vital Statistics Reports,d.Pick the same month/year combination for each data set. For example, choosing September of 2009.2.Preliminary Calculationsa.Create a summary table for 1. Live Births, 2. Deaths, 3. Marriages, and 4. Divorces highlighting the mean, median, sample standard deviation, minimum and maximum values for each the data sets. You will have FOUR tables using the list of values of each state, the District of Columbia and Puerto Rico (You will have 52 numbers for each data set).Summary Table for _________Mean Median Standard Deviation Minimum Maximum3.Hypothesis Testing With the information that you gather from the summary tables, test the following (you can use excel when appropriate):a.Determine if there is sufficient evidence to conclude the average amount of births is over 5000 in the United States and territories at the 0.05 level of significance.b.Determine if there is sufficient evidence to conclude the average amount of deaths is equal to 6000 in the United States and territories at the 0.10 level of significance.c.Determine if there is sufficient evidence to conclude the average amount of marriages is greater or equal to 2500 in the United States and territories at the .05 level of significance.d.Determine if there is sufficient evidence to conclude the average amount of divorces is less than or equal to 4000 in the United States and territories at the 0.10 level of significance.For each of the tests above, in your report, be sure to—1.Clearly state a null and alternative hypothesis2.Give the value of the test statistic3.Report the P-Value4.Clearly state your conclusion (Reject the Null or Fail to Reject the Null)5.Explain what your conclusion means in context of the data.Lastly, propose and conduct your own test of hypothesis about the Birth, Death, Marriage and Divorce data that you have been analyzing. Make sure to follow the five steps above.Required SoftwareMicrosoft Office: Word and Excel