I need help please ?!!!!
2 answers:
You might be interested in
Answer:
There is no significant interaction between the number of sales calls and the miles driven.
Step-by-step explanation:
The variables are defined as follows:
Dependent (Y) = amount earned in commissions last month
Independent (X₁) = number of miles driven last month
Independent (X₂) = number of sales calls made last month
In this case we need to test whether there is a significant interaction between the number of sales calls and the miles driven.
The hypothesis can be defined as follows:
<em>H</em>₀: There is no significant interaction.
<em>Hₐ</em>: There is a significant interaction.
Assume that the significance level of the test is, <em>α</em> = 0.05.
Use the Data Analysis tool in Excel to form the regression equation.
For the regression equation, we need to compute the values of (X₁ × X₂).
Steps:
- Go to Data - Data Analysis - Regression. A dialog box will open.
- Select the <em>Y</em> values in the "Input Y range" and values of X₁, X₂ and X₁ × X₂ in the "Input X range".
- Click OK.
The output of the regression analysis is attached below.
The regression equation is:
Consider the third table in the regression output.
The test statistic corresponding to the interaction term is:
<em>t</em> = -1.85
The <em>p</em>-value for the test of the interaction term is:
<em>p</em>-value = 0.078.
The <em>p</em>-value of the test is more than the significance value.
The null hypothesis will not be rejected.
Thus, concluding that there is no significant interaction between the number of sales calls and the miles driven.
