Question

Results for: KCereals.mtw Regression Analysis: Rating versus Shelf position Method Categorical predictor coding (1, 0) Analysis...

Results for: KCereals.mtw



Regression Analysis: Rating versus Shelf position

Method

Categorical predictor coding (1, 0)


Analysis of Variance

Source DF Adj SS Adj MS F-Value P-Value
Regression 2 1511 755.6 5.50 0.013
Shelf position 2 1511 755.6 5.50 0.013
Error 20 2748 137.4
Total 22 4259


Model Summary

S R-sq R-sq(adj) R-sq(pred)
11.7222 35.48% 29.03% 21.34%


Coefficients

Term Coef SE Coef T-Value P-Value VIF
Constant 32.85 4.43 7.41 0.000
Shelf position
bottom 7.40 7.35 1.01 0.326 1.30
top 18.15 5.58 3.26 0.004 1.30


Regression Equation

Rating = 32.85 + 7.40 Shelf position_bottom + 0.0 Shelf position_middle
+ 18.15 Shelf position_top


Fits and Diagnostics for Unusual Observations

Std
Obs Rating Fit Resid Resid
13 93.70 51.00 42.71 3.81 R

R Large residual


————— 4/25/2019 8:34:40 PM ————————————————————

Welcome to Minitab, press F1 for help.
Retrieving project from file: ‘\\Client\C$\Users\jajoa\Downloads\Exam 2
part 2.mpj’

Results for: KCereals.mtw

Regression Analysis: Rating versus Shelf position

Method

Categorical predictor coding (1, 0)


Analysis of Variance

Source DF Adj SS Adj MS F-Value P-Value
Regression 2 1511 755.6 5.50 0.013
Shelf position 2 1511 755.6 5.50 0.013
Error 20 2748 137.4
Total 22 4259


Model Summary

S R-sq R-sq(adj) R-sq(pred)
11.7222 35.48% 29.03% 21.34%

How do I do the model utility test for this data?

Does it involve the null and alternative hypothesis or the F-test? If so, how do I perform it?

Homework Answers

Answer #1

Here we want to test in regression that regression model is worth or not.

In F-test we are trying to do the testing that as a whole the regression is working or not.

So in F-test the hypothesis is

H0 : all coefficient of regression is zero

Vs

H1 : at least one coefficient is not zero.

And this test results will come from ANOVA table as

We can note the p-value corresponding regression of ANOVA table is 0.013<0.05 hence reject H0 we can comment that the regression is working significantly.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The following is a partial computer output of a multiple regression analysis of a data set...
The following is a partial computer output of a multiple regression analysis of a data set containing 20 sets of observations on the dependent variable The regression equation is SALEPRIC = 1470 + 0.814 LANDVAL = 0.820 IMPROVAL + 13.5 AREA Predictor Coef SE Coef T P Constant 1470 5746 0.26 0.801 LANDVAL 0.8145 0.5122 1.59 0.131 IMPROVAL 0.8204 0.2112 3.88 0.0001 AREA 13.529 6.586 2.05 0.057 S = 79190.48 R-Sq = 89.7% R-Sq(adj) = 87.8% Analysis of Variance Source...
Use the multiple regression output shown to answer the following questions. The regression equation is Y=9.40+0.332X⁢1+0.067X⁢2-0.251X⁢3...
Use the multiple regression output shown to answer the following questions. The regression equation is Y=9.40+0.332X⁢1+0.067X⁢2-0.251X⁢3 Predictor Coef SE Coef T P Constant 9.395 6.858 1.37 0.184 X⁢1 0.3316 0.8962 0.37 0.716 X⁢2 0.0666 -0.0520 -1.28 0.214 X⁢3 -0.2508 -0.1036 2.42 0.025 S=4.84768 R-Sq=15.0% R-Sq(adj)=2.8% Analysis of Variance Source DF SS MS F P Regression 3 86.8 28.93 1.23 0.322 Residual Error 21 493.5 23.5 Total 24 580.3 a) Which variable might we try eliminating first to possibly improve this...
The regression equation is Sales = 0.20 + 2.60 Adbudget Predictor Coef SE Coef T P...
The regression equation is Sales = 0.20 + 2.60 Adbudget Predictor Coef SE Coef T P Constant 0.200 2.132 0.09 0.931 Adbudget 2.6000 0.6429 4.04 0.027 S = 2.03306 R-Sq = 84.5% R-Sq(adj) = 79.3% Analysis of Variance Source     DF SS MS   F P Regression 1 67.600 67.600 16.35 0.027 Residual Error 3 12.400 4.133 Total 4 80.000 a) What is the slope of the regression equation? b) Null and alternative hypothesis c) Is the slope significantly different than...
Examine the Minitab output shown here for a multiple regression analysis. How many predictors were there...
Examine the Minitab output shown here for a multiple regression analysis. How many predictors were there in this model? Comment on the overall significance of the regression model. Discuss the t ratios of the variables and their significance. The regression equation is y = 4.091 - 5.111x1+ 2.662x2 + 1.557x3 + 1.141x4 +1.655x5 - 1.248x6 + 0.436x7 + 0.959x8 + 1.289x9 Predictor Coef Stdev T p   Constant 4.096 1.2884 3.24 .006 x1 -5.111 1.8700 2.73 .011 x2 2.662 2.0796 1.28...
A manager in an advanced manufacturing facility is interested in studying job performance rating and uses...
A manager in an advanced manufacturing facility is interested in studying job performance rating and uses a sample of 30 workers to estimate a model ; where = a job performance rating score between 0 and 100 = work experience in years d = (code = 1) if advanced manufacturing certified and (code = 0) if not certified The regression results are shown below. Analysis of Variance Source          DF      SS      MS     F      P Regression       2  3919.3  1959.6  6.85  0.010 Residual Error  12  3434.0   286.2 Total           14  7353.3 S = 16.9166   R-Sq = 53.3%   R-Sq(adj) = 45.5% Predictor            Coef  SE...
Study the following Minitab output from a regression analysis to predict y from x. a. What...
Study the following Minitab output from a regression analysis to predict y from x. a. What is the equation of the regression model? b. What is the meaning of the coefficient of x? c. What is the result of the test of the slope of the regression model? Let α = .10.Why is the t ratio negative? d. Comment on r2 and the standard error of the estimate. e. Comment on the relationship of the F value to the t...
Multiple linear regression results: Dependent Variable: Cost Independent Variable(s): Summated Rating Cost = -43.111788 + 1.468875...
Multiple linear regression results: Dependent Variable: Cost Independent Variable(s): Summated Rating Cost = -43.111788 + 1.468875 Summated Rating Parameter estimates: Parameter Estimate Std. Err. Alternative DF T-Stat P-value Intercept -43.111788 10.56402 ≠ 0 98 -4.0810021 <0.0001 Summated Rating 1.468875 0.17012937 ≠ 0 98 8.633871 <0.0001 Analysis of variance table for multiple regression model: Source DF SS MS F-stat P-value Model 1 8126.7714 8126.7714 74.543729 <0.0001 Error 98 10683.979 109.02019 Total 99 18810.75 Summary of fit: Root MSE: 10.441273 R-squared: 0.432...
12.4 Study the following Minitab output from a regression analysis to predict y from x. a....
12.4 Study the following Minitab output from a regression analysis to predict y from x. a. What is the equation of the regression model? b. What is the meaning of the coefficient of x? c. What is the result of the test of the slope of the regression model? Let α = .10.Why is the t ratio negative? d. Comment on r2 and the standard error of the estimate. e. Comment on the relationship of the F value to the...
Regression Analysis with a Minitab output Assume that your company owns multiple retail outlets in cities...
Regression Analysis with a Minitab output Assume that your company owns multiple retail outlets in cities across the United States. You conduct a study to determine if daily sales levels (in hundreds of dollars) can be predicted by the number of competitors that are located within a one-mile radius of each location and city population (in thousands of people). Therefore, the dependent variable is SALES and the two independent variables are NUMBER OF COMPETITORS and CITY POPULATION. Your research team...
need step by step for MINITAB please Problem 1. Consider the GASTURBINE data set and corresponding...
need step by step for MINITAB please Problem 1. Consider the GASTURBINE data set and corresponding output from Minitab. Use the complete data set in your analysis. The first 10 observations are given for illustrative purposes. Complete parts a) through g) below. ENGINE SHAFTS RPM CPRATIO INLET-TEMP EXH-TEMP AIRFLOW POWER HEATRATE Traditional 1 27245 9.2 1134 602 7 1630 14622 Traditional 1 14000 12.2 950 446 15 2726 13196 Traditional 1 17384 14.8 1149 537 20 5247 11948 Traditional 1...