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 this study.Sales(In_Thousands)71.6362.3763.274.4836.8370.3543.4843.5747.549.6349.7851.5958.2260.1461.5867.2370.0675.9277.485.4687.5589.2360.9571.5864.92a. 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 lower limit (in $1000) of 98% confidence interval for average sales is________ The upper limit (in $1000) of 98% confidence interval for average sales is________Based on your lower and upper limits of a 98% confidence interval for average sales, is it plausible that the average sales (in $1000) for all such stores be 65 in Week 1 of December? Yes or No because___65 is between lower and upper values.___65 is NOT between lower and upper values.___65 is a value in the given data.____65 is NOT a value in the given data.__x__None of these. 123456789101213ASales(In_Thousands) D1617181920212223242526272829Ready71.6362.3763.274.4836.8370.3543.4843.5747.549.6349.7851.5958.2260.1461.5867.2370.0675.9277.485.4687.5589.2360.9571.5864.92BSales+Accessibility: Investigate0000010000001000010000000000Type here to searchCFrequencySales in $100001 00 1 10 in5OPNWA01009080706050403010[36.83, 47.31]DHistogram(47.31, 57.79)EBoxplot(57.79,68.27)Sales in $1000100(68.27,78.75)6F(EZ 68 52 84)MeanStandard ErrorMedianModeStandard DeviationSample VarianceKurtosisSkewnessRangeMinimumMaximumGLower limitUpper limitSales(In_Thousands)SumCountConfidence Level(98.0%)t-Test: Paired Two Sample for MeansMeanVarianceObservationsPearson CorrelationHypothesized Mean DifferenceH63.7862.817921515#N/A63.214.08960758198.5170417-0.595149066-0.0171976952.436.8389.231594.65Sales(In Thousands)#DIV/0!257.022709799 Margin of error63.786198.51704172553ID0025E+ 70.0675.9277.485.4687.5589.2360.9571.5864.92SalesAccessibility: Investigate1000000000Sales in $1000Type here to search8888888889°100Et6Lower limitUpper limitt-Test: Paired Two Sample for MeansMeanVarianceObservationsPearson CorrelationHypothesized Mean Differencedft StatP(T<=t) one-tailt Critical one-tailP(T<=t) two-tailIt Critical two-tailSales(In_Thousands)63.786198.5170417#DIV/0!25533.8276438650.0004067751.710882080.000813552.063898562D0025

The provided data is inserted in Excel as follows:

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 this study. Sales(In_Thousands) 71.63 62.37 63.2 74.48 36.83 70.35 43.48 43.57 47.5 49.63 49.78 51.59 58.22 60.14 61.58 67.23 70.06 75.92 77.4 85.46 87.55 89.23 60.95 71.58 64.92 a. 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 lower limit (in $1000) of 98% confidence interval for average sales is The upper limit (in $1000) of 98% confidence interval for average sales is Based on your lower and upper limits of a 98% confidence interval for average sales, is it plausible that the average sales (in $1000) for all such stores be 65 in Week 1 of December? Yes or No because _65 is between lower and upper values. _65 is NOT between lower and upper values. _65 is a value in the given data. 65 is NOT a value in the given data. xNone of these.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

100%

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 this study.

Sales(In_Thousands)
71.63
62.37
63.2
74.48
36.83
70.35
43.48
43.57
47.5
49.63
49.78
51.59
58.22
60.14
61.58
67.23
70.06
75.92
77.4
85.46
87.55
89.23
60.95
71.58
64.92

a. 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 lower limit (in $1000) of 98% confidence interval for average sales is________

The upper limit (in $1000) of 98% confidence interval for average sales is________

Based on your lower and upper limits of a 98% confidence interval for average sales, is it plausible that the average sales (in $1000) for all such stores be 65 in Week 1 of December? Yes or No

because

___65 is between lower and upper values.

___65 is NOT between lower and upper values.

___65 is a value in the given data.

____65 is NOT a value in the given data.

__x__None of these.