I am working on a project and have answered the first two sections of the problem, but am stuck when it comes to c - f. I also want to be able to put the calculations in Excel

1.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.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.

I chose to assess the effectiveness of a patient's diagnosis using a blood test. I asked my daughter to choose a number that I could use as my standard deviation, the number she choice was 5. I asked my husband to choose my sample size and he chose 27. My margin of error when calculated was 1.89 when I had a confidence level of 95%.

b.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?

Randomization is important when you are testing a particular data amount and based on the information one will be able to determine the reliability of that information. I decided to use both my daughter and husband who did not have any information on what kind of testing I was doing and gave them a range and asked them to pick a number from that range. If someone is doing a test to see what the validity of a specific test is, you what the information to be random so that there is not a bias one way or another. This will help to ensure accuracy.

c.The type of inferential test utilized in your experiment. Include type of test used, number of tails, and a justification for this choice.

d.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.

e.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.

f.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.