The following data represent the Sales (in $1000) data gathered from a marketing efficacy study in Week 1 of December 2019 at a fast-food chain. Each row is an individual store that was randomly selected for ths study. Click this button to reveal the data. Click again to collapse it. SalesInThousands (Y) 68.93 59.77 60.4 72.98 34.03 68.85 40.68 42.47 45.9 46.73 47.98 50.49 56.72 58.14 59.68 64.73 67.16 73.42 75.6 84.36 86.55 87.13 59.05 70.18 63.12 Click Download CSV to download csv file of data or copy/paste the data into Excel. When you paste, use Paste Special and then select Unicode Text. After downloading the file, you must save it as an Excel Workbook. Otherwise, your tables and graphs will not be saved properly. As you work in Excel be sure to save all your work and clearly label your results. • If you have a Mac computer, then please watch How to Add the Data Analysis ToolPak in Excel on Mac 2018. • If you have a windows operating system, please watch How to Add the Data Analysis ToolPak in Excel 2016 for Windows. a. Use Excel to create a histogram and boxplot of the Sales in Thousands variable. Based on the graphs you created in Excel and the given information, select all that are true in this study. There is a random sample of data. There is NO random sample of data. The sample is large enough. It is given that the population has a Normal distribution. The histogram and boxplot shows it is safe to assume sample is selected from a population with a Normal distribution. The boxplot shows the sample has no outliers. None of these. Therefore, do we satisfy all the requirements or assumptions to confirm that our results from the one-sample t confidence interval are valid in this study? No • Yes b. Use Excel to create a descriptive statistics table of Sales (In_Thousand) variable along with the margin of error to compute a 98% confidence interval for average sales. Using the result, fill in the blanks of the following statements rounded properly to 2 decimal places. The average (in $1000) sales is The margin of error (in $1000) for 98% confidence interval is The 98% confidence interval for average sales (in $1000) is (54.70 68.90 c. Based on your 98% confidence interval for average sales (in $1000), is it plausible that the average sales (in $1000) for all such stores be 63 in Week 1 of December? Yes because 63 is NOT between lower and upper values. 63 is a value in the given data. 63 is NOT a value in the given data. • 63 is between lower and upper values. None of these.