Q1. An investigator wants to estimate caffeine consumption in high schoolstudents, how many students

Q1. An investigator wants to estimate caffeine consumption in high schoolstudents, how many students would be required to ensure that a 95%confidence intervals estimate for the mean caffeine intake (measured in mg)is within 15 mg of the true mean? Assume that the standard deviation incaffeine intake is 68mg.What is the effect on the probability of a Type II error when theprobability of a Type I error is decreased?o Describe type I and type II errors of a mammography in termsof the diagnosis.o Add this text to the spreadsheet you created for the abovepractice problems.Assignment are to be completed using Microsoft Excel and should besubmitted as a spreadsheet.Q2. Consider the study proposed in the first problem (Q1) how manystudents would be required to estimate the proportion of students whoconsume coffee? Suppose we want the estimate to be within 5% of the trueproportion with 95% confidence.Excel please