Examlex

Solved

Instruction 12  Regression statistics \text { Regression statistics }  ANOVA \text { ANOVA }

question 4

Short Answer

Instruction 12.30
The managing partner of an advertising agency believes that his company's sales are related to the industry sales. He uses Microsoft Excel's Data Analysis tool to analyse the last four years of quarterly data with the following results:
 Regression statistics \text { Regression statistics }
 Multiple R 0.802 R Square 0.643 Adjusted R  Square 0.618 Standard Error  SYX 0.9224 Observations 16\begin{array}{|l|l|}\hline \text { Multiple R } & 0.802 \\\hline \text { R Square } & 0.643 \\\hline \begin{array}{l}\text { Adjusted R } \\\text { Square }\end{array} & 0.618 \\\hline \begin{array}{l}\text { Standard Error } \\\text { SYX }\end{array} & 0.9224 \\\hline \text { Observations } & 16 \\\hline\end{array}

 ANOVA \text { ANOVA }
 df  SS  MS  F  Sig.F  Regression 121.49721.49725.270.000 Error 1411.9120.851 Total 1533.409\begin{array}{|l|l|l|l|l|l|}\hline & \text { df } & \text { SS } & \text { MS } & \text { F } & \text { Sig.F } \\\hline \text { Regression } & 1 & 21.497 & 21.497 & 25.27 & 0.000 \\\hline \text { Error } & 14 & 11.912 & 0.851 & & \\\hline \text { Total } & 15 & 33.409 & & & \\\hline\end{array}

 Predictor  Coef  StdError  t Stat  p-value  Intercept 3.9621.4402.750.016 Industry 0.0404510.0080485.030.000\begin{array}{|l|l|l|l|l|}\hline\text { Predictor } & \text { Coef } & \text { StdError } & \text { t Stat } & \text { p-value } \\\hline \text { Intercept } & 3.962 & 1.440 & 2.75 & 0.016 \\\hline \text { Industry } & 0.040451 & 0.008048 & 5.03 & 0.000\\\hline\end{array}


 Durbin-Watson 1.59 Statistic \begin{array}{|l|l|}\hline\text { Durbin-Watson } & 1.59 \\\text { Statistic } &\\\hline\end{array}


-Referring to Instruction 12.30,the value of the quantity that the least squares regression line minimises is____________.


Definitions:

Competition

The rivalry among businesses or individuals for dominance or a greater share of the market or attention, often leading to innovation and better choices for consumers.

Monopolist

An individual or entity that holds a dominant position or exclusive control over a market or supply of a particular commodity or service.

Market Size

The total volume of sales or potential sales of a product or service within a particular market.

Tying Arrangement

A seller’s act of conditioning the sale of a product or service on the buyer’s agreement to purchase another product or service from the seller.

Related Questions