Not sure of my analysis. Can you assist me?

In this discussion, you will apply the statistical concepts and techniques covered in this week's reading about multiple regression. You willnotbe completing work in Jupyter Notebook this week. Instead, you will be interpreting output from your Python scripts for the Module Six discussion. If you didnotcomplete the Module Six discussion, please complete that before working on this assignment.

Last week's discussion involved development of a multiple regression model that used miles per gallon as a response variable. Weight and horsepower were predictor variables. You performed an overall F-test to evaluate the significance of your model. This week, you will evaluate the significance of individual predictors. You will use output of Python script from Module Six to perform individual t-tests for each predictor variable. Specifically, you will look at Step 5 of the Python script to answer all questions in the discussion this week.

In your own initial post, address the following items:

1. Is at least one of the two variables (weight and horsepower) significant in the model? Run the overall F-test and provide your interpretation at 5% level of significance. See Step 5 in the Python script. Include the following in your analysis:
2. Define the null and alternative hypothesis in mathematical terms and in words.
3. Report the level of significance.
4. Include the test statistic and the P-value. (Hint: F-Statistic and Prob (F-Statistic) in the output).
5. Provide your conclusion and interpretation of the test. Should the null hypothesis be rejected? Why or why not?

Here is a copy of my HTML output:

Step 5: Multiple regression model to predict miles per gallon using weight and horsepower

This block of code produces a multiple regression model with "miles per gallon" as the response variable, and "weight" and "horsepower" as predictor variables. Theolsmethod in statsmodels.formula.api submodule returns all statistics for this multiple regression model.

Click the block of code below and hit theRunbutton above.

In[6]:

from statsmodels.formula.api import ols # create the multiple regression model with mpg as the response variable; weight and horsepower as predictor variables. model = ols('mpg ~ wt+hp', data=cars_df).fit() print(model.summary()) OLS Regression Results ============================================================================== Dep. Variable: mpg R-squared: 0.828 Model: OLS Adj. R-squared: 0.815 Method: Least Squares F-statistic: 64.96 Date: Tue, 03 Aug 2021 Prob (F-statistic): 4.81e-11 Time: 17:20:37 Log-Likelihood: -70.523 No. Observations: 30 AIC: 147.0 Df Residuals: 27 BIC: 151.3 Df Model: 2 Covariance Type: nonrobust ============================================================================== coef std err t P>|t| [0.025 0.975] ------------------------------------------------------------------------------ Intercept 37.3294 1.667 22.388 0.000 33.908 40.751 wt -3.9362 0.666 -5.912 0.000 -5.302 -2.570 hp -0.0309 0.010 -3.243 0.003 -0.051 -0.011 ============================================================================== Omnibus: 4.329 Durbin-Watson: 1.358 Prob(Omnibus): 0.115 Jarque-Bera (JB): 3.271 Skew: 0.806 Prob(JB): 0.195 Kurtosis: 3.141 Cond. No. 579. ============================================================================== Warnings: [1] Standard Errors assume that the covariance matrix of the errors is correctly specified. 

1. What is the slope coefficient for the weight variable? Is this coefficient significant at 5% level of significance (alpha=0.05)? (Hint: Check the P-value,, for weight in Python output. Recall that this is the individual t-test for the beta parameter.) See Step 5 in the Python script.
2. What is the slope coefficient for the horsepower variable? Is this coefficient significant at 5% level of significance (alpha=0.05)? (Hint: Check the P-value,, for horsepower in Python output. Recall that this is the individual t-test for the beta parameter.) See Step 5 in the Python script.
3. What is the purpose of performing individual t-tests after carrying out the overall F-test? What are the differences in the interpretation of the two tests?
4. What is the coefficient of determination of your multiple regression model from Module Six? Provide appropriate interpretation of this statistic.