Question: Solve the following questions in excel with functions excel file included https://easyupload.io/qrvsaw excel only Q AutoSave OFF Demonstration Home Insert Draw Page Layout Formulas Data
Solve the following questions in excel with functions excel file included https://easyupload.io/qrvsaw excel only

Q AutoSave OFF Demonstration Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments LE Share ab v Conditional Formatting v Insert Calibri (Body) v 11 A A General O Format as Table Ex Delete v $ ~ % " Sort & Find & Analyze Paste BIUV 2 7 V >T V Cell Styles v Format v Filter Select Data 023 X V fx E F G H K L M N P Q R S T U V W X A B The daily sales of Burger Baby restaurants follow the normal distribution with a standard deviation of $4000. a. A sample is taken of 50 restaurants and the average sales were $40,000/day. What is the 99% confidence interval for the average restaurant sales? Answer DO VON UI A W NH 10 11 b What is the probability that the average sales are really $36,000 or less per day? Answer 12 Assume the actual population average is $40,000 per day 13 14 15 16 17 18 19 20 21 22 23 2 A sample of the sales at 50 Haute Dog restaurants is taken and the sample mean is $30,000 per day 24 with a sample standard deviation of $2000. The population standard deviation is not known. 25 26 a What is the 90% confidence interval for the daily sales at all restaurants. Answer 27 28 29 30 31 What is the probability that the average sales are really $32,000 or more per day? Answer 32 b 33 Assume that the population average is $30,000 per day and the std. Deviation is $2k. 34 35 36 37 CoverSheet Basics Discrete Normal Confidence Hypothesis Testing + + Ex Accessibility: Investigate 100% Ready
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
