How do I solve this Lab?
The table produced does not give you the confidence interval, however it does give you the sample mean and the margin of error. The margin of error is the last row called Confidence Level. To find the confidence interval subtract and add the margin of error to the mean in two separate cells to the right of the table. Round your answers to two decimal places. Highlight these two numbers in blue. I will be selecting each cell to check on the formulas so do not just type in the answer from a calculator. b) Type in an interpretation of your interval using context and units from the question. c) Find the 99% confidence interval for the average number of vacation days. Repeat what you did in part a, but change the confidence level for mean to 99%. Round your answers to two decimal places. Highlight the two cells in green with the lower and upper boundaries. I will be selecting each cell to check on the formulas so do not just type in the answer from a calculator. d) Which confidence interval is smaller (narrower) on the number line? e) Which interval is more likely to contain the population mean, explain your answer? Formatting: Put problems in the same order as in the directions and label the problem numbers. Format all column widths so that you can clearly read answers. Merge and wrap text for long sentence answers. Select your name in cell Al on the first sheet then save the file so that the workbook opens at the top of the page. Label the tabs if you use more than one tab on the Excel workbook. Move page breaks so that they do not cut any tables in half.STAT243 Spring 2020 Lab 4 Due June 3rd The following assignment is to be done in Microsoft Excel. 1. Open up the Excel le called \"STAT 243 Excel Lab4 Data\". Type your name in cell A1. 2. Use Excel to nd the following condence intervals for the mean number of paid vacation days for PSU employees. a) Find the 95% condence interval for the mean number of vacation days. The data is in the Excel le in the column labeled Vacation Days. Select the tab labeled Data, then select Data Analysis. If your data analysis button is not installed, go back to the directions for installation before you continue with the rest of this lab. In the Data Analysis Tool, select Descriptive Statistics, then 0K. Data Analysis ? X \"mm" Move: Single Factor Move: Two-Factor with Replication Camel Move: Two-Factor Without Replication Correlation Covariance H" Exponential Smoothing F-Test Two-Sample for variances Fourier Analysis Histo - ram Click into the box next to Input Range. Use your mouse and highlight the data including the label. Check the box that says \"Labels in first row.\" If you did not select the label for you input range then don't check the label box. Click the circle next to Output Range. Click into the box to the right of output range. Use your mouse and select a cell where you want the top left corner of your table to show. Check the boxes next to Summary Statistics and Condence Level for Mean. Change your condence level to t the question. Select OK. Descriptive Statistics ? X Input jnput Range: | $335326 III an: I Grouped lly: columns ' 0 3\"\" Help Labels in first row Output options om Range: | \"353 0 New Worksheet my: I I 0 New workbook iul'mry statislics Confidence Level for Moon: [95 I 96 D ion urgest: III on Smallest
