I am uploading all the documentation that will show what is needed. A patient is classified as having gestational diabetes if their average glucose level is above 140 milligrams per deciliter (mg/dl) one hour after a sugary drink is ingested. Rebecca's doctor is concerned that she may suffer from gestational diabetes. There is variation both in the actual glucose level and in the blood test that measures the level. Rebecca's measured glucose level one hour after ingesting the sugary drink varies according to the Normal distribution with μ=140+# mg/dl and σ=#+1 mg/dl, where # is the last digit of your GCU student ID number. Using the Central Limit Theorem, determine the probability of Rebecca being diagnosed with gestational diabetes if her glucose level is measured:Once?n=#+2 times, where # is the last digit of your student ID?n=#+4 times, where # is the last digit of your student ID?Comment on the relationship between the probabilities observed in (a), (b), and (c). Explain, using concepts from lecture why this occurs and what it means in context.Insert screenshot and figure for part (a)Insert screenshot and figure for part (b)Insert screenshot and figure for part (c)Comment on the relationship among the probabilities in parts (a),(b), and (c).Suppose next that we have even less knowledge of our patient, and we are only given the accuracy of the blood test and prevalence of the disease in our population. We are told that the blood test is 9# percent reliable, this means that the test will yield an accurate positive result in 9#% of the cases where the disease is actually present. Gestational diabetes affects #+1 percent of the population in our patient’s age group, and that our test has a false positive rate of #+4 percent. Use your knowledge of Bayes’ Theorem and Conditional Probabilities to compute the following quantities based on the information given only in part 2:If 100,000 people take the blood test, how many people would you expect to test positive and actually have gestational diabetes?What is the probability of having the disease given that you test positive?If 100,000 people take the blood test, how many people would you expect to test negative despite actually having gestational diabetes?What is the probability of having the disease given that you tested negative?Comment on what you observe in the above computations. How does the prevalence of the disease affect whether the test can be trusted?Answer part (a) here. Answer part (b) here. Answer part (c) here. Answer part (d) here. Comment on how prevalence of the disease affects your ability to trust the test. Discuss what factors would lead you to trust the blood test, or not trust the blood test.As we have seen in class, hypothesis testing, and confidence intervals are the most common inferential tools used in statistics. Imagine that you have been tasked with designing an experiment to determine reliably if a patient should be diagnosed with diabetes based on their blood test results. Create a short outline of your experiment, including all the following:A detailed discussion of your experimental design. Detailed experimental design should include the type of experiment, how you chose your sample size, what data is being collected, and how you would collect that data.How is randomization used in your sampling or assignment strategy? Remember to discuss how you would randomize for sampling and assignment, what type of randomization are you using? The type of inferential test utilized in your experiment. Include type of test used, number of tails, and a justification for this choice.A formal statement of the null and alternative hypothesis for your test. Make sure to include correct statistical notation for the formal null and alternative, do not just state this in words. A confidence interval for estimating the parameter in your test. State and discuss your chosen confidence level, why this is appropriate, and interpret the lower and upper limits. An interpretation of your p-value and confidence interval, including what they mean in the context of your experimental design. Answer each part below. State your significance level, interpret your p-value, and make a decision on the null.For each part, insert your sketch of the required area under the normal curve. In addition, include a screenshot of your Excel computation to find this area. Fill in the conditional probability table here, then answer the questions in each part below.

I have a statistics end of the semester project. I have attached the rubric, instructions, and the data used to create the project. I expect this to be done and completed to its entirety in one week.

To prepare for this Assignment:Review the Learning Resources and the media programs related to ttests.For additional support, review the Skill Builder: Research Design and Statistical Design and the Skill Builder: Hypothesis Testing for Independent Samples t-test, which you can find by navigating back to your Blackboard Course Home Page. From there, locate the Skill Builder link in the left navigation pane.Also, review the t test scenarios found in this week’s Learning Resources and consider the three different approaches of t tests:Independent sample t testPaired sample t testOne sample t testBased on each of the three research scenarios provided, open the High School Longitudinal Study dataset or the Afrobarometer dataset from this week’s Learning Resources using SPSS software, then choose and run the appropriate t test.Once you perform your t test analyses, review Chapter 11 of the Wagner text to understand how to copy and paste your output into your Word document.For this Assignment:Write a 2 to 3-paragraph analysis of your t test results for each research scenario and include the SPSS syntax and output. Do not forget to evaluate if the t test assumptions are met, justify the selection of type of t test, and report the effect size. Based on your results, provide an explanation of what the implications of social change might be.Use proper APA format, citations, and referencing for your analysis, research questions, and output.Submit Assignment: Testing Hypothesis for a Mean.