Answer:
A) The linearity conditions are satisfied.
b) Yes there is positive linear association because attendance per game increases then pitcher age also increases.
c) The pitcher age increases by 1 year the average attendance tend to increase by about 5511 fans.
Explanation:
a)
We have to find scatter plot
First enter all data in excel
Select all data ----------> Click on Insert --------> Scatter ------->Click on first graph
We get( check the first attached for the excel computation)
Conditions.
A) The linearity conditions are satisfied.
b) Yes there is positive linear association because attendance per game increases then pitcher age also increases.
c) y : Dependent variable = attendance per game
x : independent variable = pitchers age
We can solve this question using excel.
First enter data into excel.
Click on Data -------> Data Analysis --------> Regression ------->
Input
Input Y Range : select y values
Input X Range :select values of x.
Output Range : select any empty cell
---------> ok
We get ( check the first attached for the excel computation)
The regression equation is
Attendance = - 124506 +5511 x age
Test statistic for slope is 6.797
P-value for test statistic is 0.0000191
The pitcher age increases by 1 year the average attendance tend to increase by about 5511 fans.