Question

# The following data was collected to explore how the average number of hours a student studies...

The following data was collected to explore how the average number of hours a student studies per night and the student's GPA affect their ACT score. The dependent variable is the ACT score, the first independent variable (x1) is the number of hours spent studying, and the second independent variable (x2) is the student's GPA.

 Study hours GPA ACT score 0 2 17 1 2 19 5 2 28 5 3 29 6 4 31

Find the p-value for the regression equation that fits the given data.

How do i find p value on a ti-84 calc? i dont have excel.

 Regression Statistics Multiple R 0.9991 R Square 0.9982 Adjusted R Square 0.9963 Standard Error 0.3851 Observations 5 ANOVA df SS MS F Significance F Regression 2 160.50 80.25 541.13 0.0018 Residual 2 0.30 0.15 Total 4 160.80 Coefficients Standard Error t Stat P-value Intercept 16.08 0.62 25.81 0.0015 Study hours 2.25 0.10 22.40 0.0020 GPA 0.42 0.30 1.37 0.3040

The p-value for the regression equation is 0.0018

In excel, I have used the Regression function in the Data Analysis option of the Data tab.

#### Earn Coins

Coins can be redeemed for fabulous gifts.