Solved

The Manager of a Fast Food Restaurant Wants to Determine

Question 126

Essay

The manager of a fast food restaurant wants to determine how sales in a given week are related to the number of discount vouchers (#) printed in the local newspaper during the week. The number of vouchers and sales ($000s) from 10 randomly selected weeks is given below with Excel regression output.  Number of  vouchers  Sales  Number ofvouchers  Sales 412.8 Mean 7 Mean 14.8715.4 Standard Error 1.5055 Standard Error 0.8155513.9 Median 5.5 Median 14.65311.2 Mode 5 Mode 13.91918.7 Standard Deviation 4.7610 Standard Deviation 2.57901017.9 Sample Variance 22.6667 Sample Variance 6.6511816.8 Kurtosis 4.7702 Kurtosis 1.1563615.9 Skewness 2.0386 Skewness 0.0535311.5 Rarge 16 Range 7.5513.9 Minimum 3 Minimum 11.2 Maximum 19 Maximum 187 Sum 70 Sum 148 Count 10 Count 10\begin{array}{|c|l|l|r|r|l|r|}\hline \begin{array}{c}\text { Number of } \\\text { vouchers }\end{array} & \text { Sales } &{\text { Number ofvouchers }} & &&{\text { Sales }} & \\\\\hline 4 & 12.8 & \text { Mean } & 7 &&\text { Mean } & 14.8 \\\hline 7 & 15.4 & \text { Standard Error } & 1.5055 &&\text { Standard Error } & 0.8155 \\\hline 5 & 13.9 & \text { Median } & 5.5 &&\text { Median } & 14.65 \\\hline 3 & 11.2 & \text { Mode } & 5 &&\text { Mode } & 13.9 \\\hline 19 & 18.7 & \text { Standard Deviation } & 4.7610 &&\text { Standard Deviation } & 2.5790 \\\hline 10 & 17.9 & \text { Sample Variance } & 22.6667 &&\text { Sample Variance } & 6.6511 \\\hline 8 & 16.8 & \text { Kurtosis } & 4.7702 &&\text { Kurtosis } & -1.1563 \\\hline 6 & 15.9 & \text { Skewness } & 2.0386 &&\text { Skewness } & 0.0535 \\\hline 3 & 11.5 & \text { Rarge } & 16 &&\text { Range } & 7.5 \\\hline 5 & 13.9 & \text { Minimum } & 3 &&\text { Minimum } & 11.2 \\\hline &&\text { Maximum } & 19 &&\text { Maximum } & 187 \\\hline &&\text { Sum } & 70 &&\text { Sum } & 148 \\\hline &&\text { Count } & 10 &&\text { Count } & 10 \\\hline\end{array}  SUMMARY OUTPUT  RegressionStatistics  Multiple R 0.8524 RSquare 0.7267 Adjusted R Square 0.6925 Standard Error 1.4301 Observations 10 ANOvA dfSS MS F significance F Regression 143.498243.498221.26820.0017 Residual 816.36182.0452 Total 959.8600 Coefficients  Standard Error  t Stat  P-value  Lower 95% Upper 95%  Intercept 11.56760.834113.65790.00009.644113.4912 Number of vouchers 0.46180.10014.61170.00170.23090.6927\begin{array}{|l|c|c|c|c|c|c|}\hline \text { SUMMARY OUTPUT } & & \\\hline & & \\\hline \text { RegressionStatistics } & & \\\hline \text { Multiple R } & 0.8524 & \\\hline \text { RSquare } & 0.7267 & \\\hline \text { Adjusted R Square } & 0.6925 & \\\hline \text { Standard Error } & 1.4301 & \\\hline \text { Observations } & 10 & \\\hline & & \\\hline \text { ANOvA } & & & & & & \\\hline & d f & S S & \text { MS } & F & \text { significance } F & \\\hline \text { Regression } & 1 & 43.4982 & 43.4982 & 21.2682 & 0.0017 & \\\hline \text { Residual } & 8 & 16.3618 & 2.0452 & & & \\\hline \text { Total } & 9 & 59.8600 & & & & \\\hline & & \\\hline & \text { Coefficients } & \text { Standard Error } & \text { t Stat } & \text { P-value } & \text { Lower } 95 \% & \text { Upper 95\% } \\\hline \text { Intercept } & 11.5676 & 0.8341 & 13.6579 & 0.0000 & 9.6441 & 13.4912 \\\hline \text { Number of vouchers } & 0.4618 & 0.1001 & 4.6117 & 0.0017 & 0.2309 & 0.6927 \\\hline\end{array} Determine the standard error of the estimate and describe what this statistic sells you about the regression line.

Correct Answer:

verifed

Verified

se = 1.4301 and the mean of sal...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents