Data file: Datafile_Question 1.xlsx The file above contains…

Data file: Datafile_Question 1.xlsx The file above contains a random sample of 200 service times during the busiest hour of the day at a particular fast-food restaurant. Calculate a 95% confidence interval for the proportion of service times longer than 90 seconds. What are the values of lower limit (LL) and upper limit (UL)? Round your answer to 3 decimal places.   

You have been assigned to determine whether more people pref…

You have been assigned to determine whether more people prefer Coke or Pepsi. Assume that roughly half the population (i.e., 0.5) prefers Coke and half prefers Pepsi. How large a sample do you need to take to ensure that you can estimate, with 95% confidence, the proportion of people preferring Coke within 2% of the actual value? Round your answer to whole number. Use the attached Excel spreadsheet to calculate the answer for this question: Blank spreadsheet for your use.xlsx