Homework Helper
$17/per page/
INSTRUCTIONSÂ
Please help to complete the exercises in Word (or some other compatible word processor) and submit.
|
Xi |
13 |
19 |
18 |
23 |
21 |
26 |
15 |
|
yi |
37 |
54 |
46 |
65 |
51 |
66 |
38 |
a.    Develop a scatter diagram for these data.
b.    Develop the estimated regression equation for these data.
c.    Use the estimated regression equation to predict the value of y given x = 17.
Please note that you can either use the formula (12.6) and (12.6), a statistical package such as StatTools, or the Regression program within Excel’s Data Analysis Add-in to calculate the estimated regression.
2.    The following output was obtained from a regression analysis of the dependent variable Sales and an independent variable Advertising. (10 points)
|
ANOVA |
 |  |  |
| Â |
df |
SS |
MS |
|
Regression |
1 |
13489.58 |
13489.58 |
|
Residual |
15 |
45620.74 |
3041.38 |
|
Total |
16 |
59110.32 |
 |
| Â | Â | Â | Â |
| Â |
Coefficients |
Standard Error |
 |
|
Intercept |
254.1 |
54.2 |
 |
|
Advertising |
0.14 |
0.066 |
 |
a.    Use the p-value approach to perform an F test for the significance of the linear relationship between Advertising and Sales at the 0.05 level of significance.
b.    Calculate the coefficient of determination.
c.    What percentage of the variability of Sales can be explained by its linear relationship with Advertising? What is the sample correlation coefficient?
d.    What is the estimated regression equation?
e.    Use the critical value approach to perform a t test for the significance of the linear relationship between Advertising and Sales at the 0.05 level of significance.
3.    The data in BUSI1013-Regression A.XLSX is collected for building a regression model to estimate value of residential homes in a mid-size Canadian city. Use this data to perform a simple regression analysis between Value and Size. (12 points)
a.    Develop a scatter diagram using Value as the dependent variable y and size as the independent.
b.    Develop the estimated regression equation.
c.    Use the estimated regression equation to predict the value of an 1800 square-foot home.
d.    Use the critical-value approach to perform an F test for the significance of the linear relationship between Value and Size at the 0.05 level of significance.
e.    What percentage of the Value of residential homes variability can be explained by its linear relationship with Size?
f.     Use the p-value approach to perform a t test for the significance of the linear relationship between Value and Size at the 0.05 level of significance.
4.    The estimated regression equation for a model involving two independent variables and 15 observations is:
yhat = 30.13 - 0.58X1Â + 2.54X2Â
Other statistics produced for analysis include: SSR = 7120.3, SST = 7835.5, Sb1Â = 0.08, Sb2Â = 0.352. (16 points)
a.    Interpret b1 and b2 in this estimated regression equation
b.    Predict y when X1 = 50 and X2 = 120.
c.    Compute R and Ra.
d.    Comment about the goodness of fit of the model.
e.    Compute MSR and MSE.
f.     Compute F and use it to test whether the overall model is significant using a p-value (α = 0.05).
g.    Perform a t test for the significance of β1. Use a level of significance of 0.05.
h.    Perform a t test for the significance of β2. Use a level of significance of 0.05.
5.    Use data in BUSI1013-Regression A.XLSX to complete the following. You will need to use a statistical package such as StatTools or the Regression program within Excel’s Data Analysis Add-in to generate the estimated regression equation and the ANOVA etc. (12 points)
a.    What is the estimated regression equation using Value as the dependent variable, and Size and Number of Bedrooms as the independent variable?
b.    Comment about the goodness of fit of the model using the coefficient of determination.
c.    Conduct an F test to see whether the overall model is significant. Use α = 0.01.
d.    Perform a t test for the significance of the Size variable. Use α = 0.05.
e.    Perform a t test for the significance of the Number of Bedrooms variable. Use α = 0.05.
f.     Estimate the value of a three-bedroom home that has 1800 square feet of space.
Â
 Please help with the attached statistics study guide reply in word format only
| 400.0 | 1206 | 2.0 |
| 708.0 | 2393 | 4.0 |
| 661.0 | 2382 | 4.0 |
| 570.0 | 2149 | 4.0 |
| 463.0 | 1451 | 3.0 |
| 485.0 | 1525 | 3.0 |
| 494.0 | 1589 | 3.0 |
| 565.0 | 1919 | 4.0 |
| 487.0 | 1413 | 3.0 |
| 500.0 | 1416 | 4.0 |
| 498.0 | 1530 | 3.0 |
| 633.0 | 2348 | 5.0 |
| 579.0 | 1890 | 3.0 |
| 449.0 | 1308 | 3.0 |
| 672.0 | 2294 | 5.0 |
| 657.0 | 2334 | 5.0 |
| 519.0 | 1590 | 2.0 |
| 487.0 | 1764 | 3.0 |
| 640.0 | 2151 | 3.0 |
| 640.0 | 2523 | 4.0 |
| 465.0 | 1413 | 3.0 |
| 509.0 | 1499 | 3.0 |
| 498.0 | 1557 | 3.0 |
| 585.0 | 1775 | 3.0 |
| 676.0 | 2216 | 3.0 |
| 569.0 | 1924 | 3.0 |
| 701.0 | 2500 | 5.0 |
| 561.0 | 2118 | 4.0 |
| 675.0 | 2340 | 4.0 |
| 691.0 | 2437 | 4.0 |
| 559.0 | 1948 | 5.0 |
| 399.0 | 1288 | 2.0 |
| 589.0 | 1897 | 3.0 |
| 506.0 | 1453 | 4.0 |
| 503.0 | 1682 | 3.0 |
| 422.0 | 1307 | 3.0 |
| 628.0 | 2329 | 4.0 |
| 700.0 | 2365 | 4.0 |
| 516.0 | 1420 | 4.0 |
| 575.0 | 1862 | 4.0 |
| 668.0 | 2389 | 4.0 |
| 588.0 | 2145 | 5.0 |
| 577.0 | 1924 | 4.0 |
| 673.0 | 2374 | 4.0 |
| 504.0 | 1787 | 3.0 |
| 629.0 | 2236 | 4.0 |
| 443.0 | 1259 | 2.0 |
| 608.0 | 2246 | 4.0 |
| 728.0 | 2510 | 4.0 |
| 639.0 | 2155 | 4.0 |
| 651.0 | 2397 | 4.0 |
| 622.0 | 2126 | 4.0 |
| 562.0 | 1678 | 4.0 |
| 682.0 | 2465 | 4.0 |
| 553.0 | 2058 | 4.0 |
| 578.0 | 2205 | 4.0 |
| 465.0 | 1574 | 3.0 |
| 719.0 | 2512 | 5.0 |
| 611.0 | 2239 | 3.0 |