Pop-Up Coffee Vendors Have Been Popular in the City of Adelaide

question 26

Essay

Pop-up coffee vendors have been popular in the city of Adelaide in 2013. A vendor is interested in knowing how temperature (in degrees Celsius) and number of different pastries and biscuits offered to customers impacts daily hot coffee sales revenue (in $00's).
A random sample of 6 days was taken, with the daily hot coffee sales revenue and the corresponding temperature and number of different pastries and biscuits offered on that day, noted.
Excel output for a multiple linear regression is given below: $$\begin{array} { | c | c | r | } \hline \text { Coffee sales revenue } & \text { Temperature } & \text { Pastries/biscuits } \\\hline 6.5 & 25 & 7 \\\hline 10 & 17 & 13 \\\hline 5.5 & 30 & 5 \\\hline 4.5 & 35 & 6 \\\hline 3.5 & 40 & 3 \\\hline 28 & 9 & 15 \\\hline\end{array}$$ $\begin{array}{|l|r|l|l|l|l|l|}\hline \text { SUMMARY OUTPUT } & & & & & & \\\hline \text { Regression Statistios } & & & & & & \\\hline \text { Multiple R } & 0.87 & & & & & \\\hline \text { R Square } & 0.75 & & & & & \\\hline \text { Adjusted R Square } & 0.59 & & & & & \\\hline \text { Standard Error } & 5.95 & & & & & \\\hline \text { Observations } & 6.00 & & & & & \\\hline \\\hline \text { ANOVA } & & & & & \\\hline & {d f} & SS & M S & F & \text { Significance } F \\\hline \text { Regression } & 2.00 & 322.14 & 161.07 & 4.55 & 0.12 \\\hline \text { Residual } & 3.00 & 106.20 & 35.40 & & \\\hline \text { Total } & 5.00 & 428.33 & & & \\\hline \\\hline & \text { Coeffients } & \text { Standard Error } & \text { tStat } & \text { P-value } & {\text { Lower } 95 \%} & {\text { Upper } 95 \%} \\\hline \text { Intercept } & 18.68 & 37.88 & 0.49 & 0.66 & -101.88 & 139.24 \\\hline \text { Temperature } & -0.50 & 0.83 & -0.60 & 0.59 & -3.15 & 2.15 \\\hline \text { Pastries/biscuits } & 0.49 & 2.02 & 0.24 & 0.82 & -5.94 & 6.92 \\\hline\end{array}$ Test the significance of the overall regression model, at α of 5%.

---

Definitions:

Quick Parts

Features in Microsoft Office that allow users to create, store, and reuse pieces of content, including text, graphics, and formatting.

Building Blocks

Fundamental components or elements used as the foundation to build, create, or assemble more complex structures, systems, or pieces of work.

Recycled

The process of converting waste materials into new materials and objects, aiming to reduce consumption of fresh raw materials and energy usage.

Domain

An area of knowledge or activity characterized by a set of defined terms and concepts; also refers to an internet address that identifies a specific web presence.