Question
a. Generate a model for y as a function of x b. Is this model useful?...
a. Generate a model for y as a function of x
b. Is this model useful? Justify your conclusion based on
i) R2 adjusted,
ii) Hypothesis test for model coefficient,
iii) overall model adequacy test and
iv) regression assumptions
c. If needed, modify model as appropriate and generate the new model.
Highlighted the parts that I need most. Please be detailed with explanation and use Excel. Thank you.
| x | y |
| 5 | 6 |
| 6 | 9 |
| 7 | 11 |
| 8 | 13 |
| 9 | 14 |
| 10 | 15 |
| 11 | 15 |
| 12 | 13 |
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
Consider the data in the worksheet below. X Y 5 6 6 9 7 11 8...
Consider the data in the worksheet below.
X
Y
5
6
6
9
7
11
8
13
9
14
10
15
11
15
12
13
a. Generate a model for y as a function of x.
b. Is this model useful? Justify your conclusion based on:
i. R2 Adjusted
ii. Hypothesis test for model coefficient
iii. overall model adequacy test
iv. regression assumptions.
c. If needed, modify model as appropriate and generate a new
model.
Please be as detailed in...
Use the following table to answer the following questions X Y 5 34 6
Use the following table to answer the following questions
X Y
5 34
6 37
8 41
9 46
10 50
13 53
15 47
17 55
i)Make a scatterplot
ii) Find r to the nearest hundredth
iii) Using scatterplot determine the relationship between X and
Y
iv) Find r 2 and interpret its meaning.
v) Determine the regression equation y’ =
The accompanying table, MultiLinear Regression 5, provides data for tar, nicotine, and carbon monoxide (CO) contents...
The accompanying table, MultiLinear Regression 5, provides data
for tar, nicotine, and carbon monoxide (CO) contents in a certain
brand of cigarette. All measurements are in milligrams (mg). Part
a) Run the Multilinear Regression Analysis in Excel with both
predictor variables. What is the adjusted R2 value to the nearest
hundredth of a percent (i.e. 45.67%)? Adjusted R2 =
Nicotine (Y)
Tar (X1)
CO (X2)
0.4
5
3
0.9
9
11
0.7
12
18
0.8
13
18
1
16
18...
Consider the data set: x y 1 -2.8948 2 5.806411 3 11.0518 4 5.486057 5 8.625354...
Consider the data set:
x
y
1
-2.8948
2
5.806411
3
11.0518
4
5.486057
5
8.625354
6
12.95243
7
18.10561
8
21.45488
9
33.39081
10
36.66942
11
38.03181
12
43.02581
13
44.28387
14
50.17743
1.Using Excel or another tool calculate linear regression
analysis of the set. What is the slope>
2.Using the result from previous question, report R2
. Use two decimals.
3.Predict the value of y when x = 28. Use one decimal.
Consider the following Linear Programming model: Maximize x+2.5y Subject to x+3y<=12 x+2y<=11 x-2y<=9 x-y>=0 x+5y<=15 x>=0...
Consider the following Linear Programming model:
Maximize x+2.5y
Subject to
x+3y<=12
x+2y<=11
x-2y<=9
x-y>=0
x+5y<=15
x>=0
y>=0
(a) Draw the feasible region for the model, but DO NOT draw the
objective function. Without graphing the objective function, find
the optimal solution(s) and the optimal value. Justify your method
and why the solution(s) you obtain is (are) optimal. (4 points)
(b) Add the constraint “x+5y>=15” to the Linear Programming
model. Is the optimal solution the same as the one in (a)?...
For the data given below, forecast period 17 using following methods and suggest the best forecasting...
For the data given below, forecast period 17 using following
methods and suggest the best forecasting model
1. Simple Moving Average (Three Period)
2. Weighted Average (50% on t-1, 30% on t-2, 20% on t-3)
3. Exponential Smoothing (α=.1), F1= y intercept from
regression)
4. Exponential Smoothing (α=.3), F1= y intercept from
regression)
5. Exponential Smoothing with trend (α=.3) and (δ=.3), F1= y
intercept from regression)**
5. Exponential Smoothing with trend (α=.1) and (δ=.3), F1= y
intercept from regression)**
6....
By looking at the given x, y data pairs, determine if either ratio estimation, regression estimation,...
By
looking at the given x, y data pairs, determine if either ratio
estimation, regression estimation, difference estimation, or all of
them can be used in estimating the y variable population total.
Remember to look at the requirements for using each of these
techniques and justify your answers based on these
requirements.
Sample
x
y
1
12
60
2
16
87
3
18
91
4
10
50
5
17
94
6
11
62
7
14
67
8
13
64
9...
1) Generate a data set with three variables (X, Y and Z). X and Y have...
1) Generate a data set with three variables (X, Y and Z). X and
Y have 10 observations for each (N=10), and Z has 13 observations
(N=13). Each observation should have two digits (such as “83” or
“8.3”).
2) Draw a stem-and-leaf display for variable Z only and draw a
box plot display for variable Z after specifying the 5 numbers
(UEX, LEX, FU, FL, MD).
3) Calculate the mean and standard deviation for variable X
4) Calculate the mean...
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...
The following samples of observations were randomly selected. x: 5 3 6 3 4 4 6...
The following samples of observations were randomly
selected.
x:
5
3
6
3
4
4
6
8
y:
13
15
7
12
13
11
9
5
Determine the regression equation.
Determine the value of y when x is 7.
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 5 minutes ago
asked 28 minutes ago
asked 28 minutes ago
asked 39 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago